Search results for query: *

Thanks Duane. I did try an option group before but didn't understand how it worked on a report. (I've only dealt with them on a form.) I imagine it's similar to using a combo box and being able to select columns. I'll give it a shot.

you're right. I will preview from now on

A list of all jobs performed is maintained in a log report binder that go back decades. (356 pages and counting) The real old jobs are unassigned and coded 99 just so the field isn’t left empty. The newer jobs are coded 1-7 via an option box on the job input form. When a new job comes in, all...

Thanks Duane. Believe it or not I did catch the sql stmt error and the routine works just fine. Much appreciated.

Thanks Duane. I think this will work.

I looked at the above solution but either I’m just not understanding it (Never worked with tdf’s or TableDefs} or it’s not exactly what I’m looking for. Let me explain it this way 1. When I take the Timeclock FE/BE and the Rolodex FE/BE home from work (G drive) put it on my desktop (C drive)...

Thanks Duane. (I set the LnkDataBase on a form) I'll try your solution over the weekend

As an alternative, is it possible to insert an if statement inside the for each statement that states if the table isn't in Timeclock, look in file Rolodex? I'm concerned with the back and forth, forgetting to add any new table name to the table listings.

Wow Duane. I haven't been on a forum for years and you've helped me out a few times back then. So glad to know you're still around. I will create a table with Timeclock and Rolodex table names and relate it to the location table this weekend. Will I have to change the code? I found the code...

I use two access databases. 1 Rolodex (Client Info and related jobs, etc) - 2 is Timeclock (Employee timesheets with hours, rates etc and all necessary info for creating the various forms and reports for distribution). From time to time I have to take the above home to make changes to the...