Search results for query: *

How can I import an xls and refresh a table in ACCESS via the macro object? Tom Walsh, HRIS Analyst Capital Health System ADP HR&Payroll wi RSmith

In ACCESS 2003, I am importing xls files into ACCESS. BUT, the date formats are over-written. So, I go in each day, after I update the Tables, and click DESIGN and make the field date/time, then format the field to SHORT DATE on the General Tab. Is there a macro I can build for this in ACCESS...

I have a huge file. One of the fields is FROM DATE, or [DATE]. How can I code a Query expression that would say, for example, IIF [DATE} BETWEEN X AND Y, then label this field 9 - where 9 is the week of the year? Or is there an easier way? I have to create a field, through ACCESS Query,that...

Question: Can I code a SaveReport and use the xls extension PLUS some code to invoke the "Retain Formatting" option? (The retain formatting option is now a check-box on the save screen.) Tom Tom Walsh, HRIS Analyst Capital Health System ADP HR&Payroll wi RSmith

My poor end-users. The only thing I can create, using REPORT VARIABLES, is a parm that asks, for example, to enter a course name. I can't seem to figure-out how to list the courses, and have them click on one of them. Or, better, to use XLAT and present them with English versions of the course...