My MS Access files are password protected. I don't know/remember what the password is. I need help on password recovery. [more inside]
How do I make multiple Listbox selection in Access Form work? [more inside]
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.
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.