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 wOOdy-Soft 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 AndrewRice
-
Access annoyingly converts mm/dd/yyyy format to mm/dd/yy
I have an .adp with a SQL Server backend. Date of Birth text box is set with format 'mm/dd/yyyy' and input mask '99/99/0000;0;_'. Now, if a user inputs a birthdate before the Regional Options cutoff - i.e. '4/25/1929' - the value of the text box is '4/25/1919' but if it is after that cutoff -...- AndrewRice
- Thread
- Replies: 1
- Forum: Microsoft: Access Project (ADP)
-
Exporting .adp reports to Excel
I am trying to export some reports in my .adp project to Excel. I have discovered the TransferSpreadsheet method, but this does not allow SQL strings. You can only transfer Tables and Queries (which of course don't exist in .adp). I can't use a View because the datasets are user-defined (they...- AndrewRice
- Thread
- Replies: 1
- Forum: Microsoft: Access Project (ADP)
