Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
How to Pass a user input file name to an import macro
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...- andyswen
- Thread
- Replies: 7
- Forum: Microsoft: Access Forms
-
I need to find a record in a subform for edit
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...- andyswen
- Thread
- Replies: 4
- Forum: Microsoft: Access Forms
-
How to use a substring of one field as a key to records in a 2nd table
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...- andyswen
- Thread
- Replies: 6
- Forum: Microsoft: Access Modules (VBA Coding)
