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 derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: markcharleston
- Order by date
-
Generate new lot number
I need to create a database that will generate a new lot number when a button is pressed. Our lot number format is: 03U01 where 03 represents the current month, U represents the year (2007=U, 2008=V, 2009=W, etc.)and the final two characters are a sequential number, starting at 01 and going...- markcharleston
- Thread
- Replies: 2
- Forum: Microsoft: Access Forms
-
Import fixed width text file
I have been importing and linking to fixed width text files using Access 2002 but am suddenly having problems. I specify the file I want to import, specify fixed width text file and specify that it should be imported to a new table. I then move the lines that separate the columns to line up with...- markcharleston
- Thread
- Replies: 3
- Forum: Microsoft: Access Modules (VBA Coding)
-
Conditional Report Printing
Is there a way to have Access verify that a field in a report's underlying query does not contain any NULL values prior to printing? I'd like to get a message box telling me that [plannercode] contains NULL values if that is the case, so I can refresh the data if necessary prior to printing the...- markcharleston
- Thread
- Replies: 1
- Forum: Microsoft: Access Forms
