i am lost. i cannot figure out how to make this work, because the dir= is not static but changes every time the form loads, and so, would appreciate help.
i have an access database 2003 (vb)
and one of the fields in the database contains the filepath for objects that are stored in various places (could be mp3, doc, pdf, xls - etc)on the drive.
i have a form that displays a record, including (among other...
2 results in 0.0040 seconds.
-
katia started a topic need help to get file list onto form - using filepath from field on active formin Visual Basicneed help to get file list onto form - using filepath from field on active form
-
Fred Roach started a topic How to return a number that represents the row after certain criteria is met?in Visual BasicHow to return a number that represents the row after certain criteria is met?
I'm trying to write a macro that will keep track of sales/commissions. I have written a simple macro that will ask the user for data using input boxes, and place that data into an inserted line. The sheet is divided into two areas, one above the other. To sort the first set of sales by invoice number, I wrote a macro to look for data beyond line 3 to the first blank line and sort by column A. However, I do not know how to make it sort the lower data...