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!

Register Log in
  • Congratulations Rhinorhino 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 tol514

  1. tol514

    ACCESS 2003

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

    Is there a way out of this?

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

    Is there a way out of this?

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

    Is there a way out of this?

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

    Is there a way out of this?

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

    Is there a way out of this?

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

    ACCESS 2003

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

    Is there a way out of this?

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

    Using BETWEEN in ACCESS Query, how can I label the Week Number?

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

    Using BETWEEN in ACCESS Query, how can I label the Week Number?

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

    Employees dropping off when using Telephone_Nbr table

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

    ReportSmith Macro ADP Hosted EV4

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

    ReportSmith Macro ADP Hosted EV4

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

    ReportSmith Macro ADP Hosted EV4

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

    Report Variables in ReportSmith

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

Part and Inventory Search

Back
Top