Search results

Is it possible for VBA to search a text file for a string of characters and then edit that string, without opening the file? I have an access database that prints out barcodes. The windows driver for the printer duplicates the block of characters for each label it prints, making the printer...

In a Quote System there is two tables with a one to many relationship. I want to be able to copy a certain quote number and create a new one. In the past I created a recordset and then assigned each fields value to the matching form field. There must be a better way...can you help? thanks

Sometimes using queries gets rid of frustration. Have you tried using make-table, delete and append queries? I have found that sometimes it's just better to use them than to hassle with programming the constant data shifting between tables.

In VBA you use : docmd.openform docmd.close

I was trying this out and found out that the ~~~Call Shell(stPath & "/ADD" & stFile)~~~ was giving me a problem. If you add a space after ADD it will work great! ex. Call Shell(stPath & "/ADD " & stFile) Thanks jatfill, I am now going to have fun making my own mp3 player. [This message has...