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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Auto-Generate File Name with Field Content...
[code]Thank you for your rapid response's Lisa! + Yes I created the Query -> 3b_WAGE Payroll Summary 207642 + Yes I set the criteria to as for specific dates within a range; ie -> 'Between [Enter Start of Month ~ Example: 11/1/2008] And [Enter End of Month ~ Example: 11/30/2008]' + No, I have...- PPHChris
- Post #5
- Forum: Microsoft: Access Forms
-
Auto-Generate File Name with Field Content...
I am having trouble with auto generating the file name based on a field. Ultimately, I would like to write a script/macro to pull a field and use that field as the filename. Once the parameter's of the query are typed in by the end user, I will append that data to the table in this column (Its...- PPHChris
- Post #3
- Forum: Microsoft: Access Forms
-
Suppress #Error
Hi pjd218, Go to your Properties section of the object and put something in the 'Default Value' -> could be " " or just a *space. If that doesn't work, change it to a default Null Value- PPHChris
- Post #2
- Forum: Microsoft: Access Forms
-
Auto-Generate File Name with Field Content...
Hello all! I have a DB with a query that I need to get the data out to excel while autogenerating the file name with a field. Initially, I wanted a date range if possible... IE. NewGradList_01-01-08_to_11-01-08.xls Previously, I was using a date stamp -> ="NewGradList_" &...- PPHChris
- Thread
- Replies: 5
- Forum: Microsoft: Access Forms
