Recent content by tol514

I wasn't trained in VB for ACCESS. I don't even know how to start. (?) Tom Walsh, HRIS Analyst Capital Health System ADP HR&Payroll wi RSmith

conditions were OK. I located a macro called TransferSpreadsheet. I think that's going to work. Thanks for all your help on this! Tom Tom Walsh, HRIS Analyst Capital Health System ADP HR&Payroll wi RSmith

Thanks!! I'll verify these conditions. Tom Tom Walsh, HRIS Analyst Capital Health System ADP HR&Payroll wi RSmith

The field is defined on the Table as DATA TYPE Date/Time with a FORMAT of Short Date. After an import/refresh from an xls, it's back to the default of TEXT.I've tried changing the date fields during the import, but that didn't work. I tried to preserve the mm/dd/yyyy during the inital SQL...

I import the xls to the table with the design in place. one of the specs in the design is date/time mm/dd/yyyy for all date fields. the import over-writes the date fields with TEXT. Then, I have to redo the date field back to Date/Time. Sorry if this is cloudy, but I can't attach a screen shot...

Yes, After I import the xls, I manually open the table design in ACCESS. I locate the date field, change it from TEXT to Date/Time, then go to the GENERAL TAB (bottom of Desgin Screen) and click on SHORT DATE. Is that what you're asking? Tom Tom Walsh, HRIS Analyst Capital Health System ADP...

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...

Thank, Michael - the DataPart Function did it!! I like your use of those splendid words, too! Tom Tom Walsh, HRIS Analyst Capital Health System ADP HR&Payroll wi RSmith

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...

I had this same problem. I tried all the links possible, with the nulls, too. The only work-around I could do was move the PS_EMPLOYEES file (or whatever connecting table you need) and the TELEPHONE Table to Xls and do a VLOOKUP. Tom Walsh, HRIS Analyst Capital Health System ADP HR&Payroll wi...

That's a great idea, Roger. Thank you! Tom Tom Walsh, HRIS Analyst Capital Health System ADP HR&Payroll wi RSmith

Charles, this documentation is VERY helpful! Thanks so much!! In fact, thanks, in general, for your help in many of these threads. Tom Tom Walsh, HRIS Analyst Capital Health System ADP HR&Payroll wi RSmith

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...