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 bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by adherennium
-
Filtering a query using a combo box
Thank you for this simple and elegant solution. Very much appreciated.- adherennium
- Post #3
- Forum: Microsoft: Access Other topics
-
Filtering a query using a combo box
Hi, Does anyone know how I can set up a query to filter using a combo box, for example a list of customer names, so that if one name is selected only those records pertaining to that customer are show, BUT if no customer is selected then all customer records are shown? I want to be able to...- adherennium
- Thread
- Replies: 2
- Forum: Microsoft: Access Other topics
-
Update date on table
You don't mention how the code associated with your text box is 'triggered', but I suspect your problem might be that nothing is causing the code to run. You might want to look at putting the code against the first textbox, '[date sent to]', so that when that is updated, the code is run to...- adherennium
- Post #2
- Forum: Microsoft: Access Forms
-
How can you get autonumbering to start from a specific number
Although I realise this might not be practical if a very high starting number were required, but you could always create a load of dummy records until you reach x-1, where x is the starting number that you want, then delete all the dummy records. This could be done manually, but VBA code would...- adherennium
- Post #2
- Forum: Microsoft: Access Modules (VBA Coding)
-
Creating a "Save As" window
If you omit the directory "C:\DIRNAME\FILENAME.xls" from your code, when the code is run, a window is automatically opened to allow selection of a directory.- adherennium
- Post #2
- Forum: Microsoft: Access Modules (VBA Coding)
