Search results for query: *

A copy would be helpful. You can forward it to andyswen@aol.com Thanks

I need to prompt a user for an input file name and path which I want to then pass to a routine (I have a macro already done) that imports the data into the existing application tables. I can run the macro successfully with a fixed input file name but I need to allow for a variable input file...

Emailed to your signature line address.

That would be great, Thanks! I have a separate table set up currently - main table is wine list with wines in it and the second table is locations with one record for each bin. I do have the subform working correcly where it will display a list of rows with each bin containing the wine from the...

I am pretty new to access, so sorry for the basic question. I have a form with 3 sub forms and need to be able to access a specific record in a subform for edit purposes. The main form holds a product (wine) and the sub form in question is a bin location. I want to add locations as wine is added...

Thanks again for the help. It is working like a champ.

Thank you. That was a great help. I am working on the 1st query and did have to make a couple of changes to get it working for me. I'd like your feedback on why it was not working for me. The initial change was to remove the first Trim(Mid$(A.PrimaryKeyfield to get rid of a syntax error I was...

The tricky issue is the substring varies in location in the primary field. The part I need to strip off has a variable length but uses one of two characters as a delimeter - or : in this case. I just need to strip off the leading characters up to and including the delimeter. The balance of the...