4 posts tagged with access by dy.
Displaying 1 through 4 of 4.
My MS Access files are password protected. I don't know/remember what the password is. I need help on password recovery. [more inside]
posted by dy
on Jun 14, 2007 -
6 answers
How do I make multiple Listbox selection in Access Form work? [more inside]
posted by dy
on Feb 13, 2007 -
1 answer
I'm writing an query in MS Access to get column 1 = product ID, column 2 = product Description. However, the description field has addtional spec data that I don't need. I want to remove anything after the first word, meaning remove after the first blank space.
Example:
Prod ID Prod Desc
10-362-3 Packing DT
12-345-5 Seal XT L-23
Desired result:
10-362-3 Packing
12-345-5 Seal
I tried to use FIND or SEARCH functions to identify the position of the first blank space and to truncate everything after that. However, Access does not recoganize either FIND or SEARCH. Does anyone have any idea how to accomplish this? Thanks.
posted by dy
on Sep 20, 2006 -
4 answers
I'm using Microsoft Access 2003, SP2. Does it come with triggers and procedures? I searched Help, and it says trigger is only available to Access project. What's Access project? Help please.
posted by dy
on May 17, 2006 -
6 answers