Search results

I was here looking for help several months back to create a time card database to keep our time records and received excellent help - thank you very much! Have been using the database now for several months but the user would like to know if we could somehow make it more like the the old Excel...

Well you certainly deserve the thanks because you’ve helped us tremendously! I realized that I was thanking you over and over again and didn’t want to come off way over the top but I really meant every thanks I gave you because the solutions you provided were excellent! I am trying to...

VilaRestal, You are the BEST!!! That took care of the problem – the job number is now there when going back to the time card form. Thanks too for the explanation. We’ve found three other problems with the forms. I was able to fix one (operator error on my part by leaving out limit to list)...

VilaRestal, I am again in your debt. I should have at least thought about the possibility that the code was for a button but I was so focused on the fields in the form that it didn't even occur to me. Your solution works like a charm! I played with it a bit trying to put it in myself but...

Galaxiom, I put what you listed where you said to and everything appears to be working. Code pops in and it can be changed if needed. Thanks! VilaRestal, I’m not sure what the first part of your code is doing. Remember, I’m not good at understanding this code stuff and unless I'm told...

Well here I am again. Except for creating needed reports I had the database finished – mostly due to some very excellent solutions here on this forum! Had it opening to switchboards, password protected and the user was doing test runs on entering data. Then she asks if is it possible to put the...

Satisfied? Well beyond satisfied!!! Took me a bit to find the control panel but I did find it and updated it. Do not live Down Under but I hear it's quite beautiful. And I do so love the accents!

VilaRestal/Rain, Thanks for your opinions on that. I will watch and see if I can figure out the differences using tables vs queries. And again, thanks for your help with my command button problems. Now it's back to the database to finish it up and hopefully I won't have to come back with yet...

VilaRestal/Rain, I changed Yes required to No in tblTimeCards, removed the EmployeeID line in the code and switched the subform record source to the tblTimeCardHours and it appears to be working. The duplicate button now copies subform info over and the employee field is empty. Thank you both...

Rain, I've saved the database where VilaRestal added the command button code to version 2002-2003. Not sure what you mean about the two updates though. As you probably can tell I'm not very versed in this stuff. I know Access is powerful and you can do so many things in it - I just don't know...

Maybe this falls into bad design category? When making the database I used several different databases as examples, checking how things worked to figure out how to put this one together. In the time card table I have the employeeID display control set to combo box and the row source is SELECT...

I did get some of the error messages to pop up. I was looking at your code and trying to figure out what was what in there. I didn't understand most of it but I like to check things out because sometimes things click. I like to know why it's working if I can. I took the database in today so the...

VilaRestal, I've got your code copied to my database. So COOL - it all works!!! I even played with trying to get the errors messages in your code to pop up. After all my frustration of trying this and that for days and you just zip it out! I just have one question now. Is it possible, when...

Rain, This was solved by VilaRestal but am attaching database in 2000 and 2003 formats in case someone else wanted to know what I was talking about. Should have thought of that in the first place. Thanks for the offer of help!

VilaRestal you are a GENIUS!!! I messed around with the Allen Browne instructions and a few other variations I found online for several days. No matter what I did I couldn't make it work. You cannot know how much I appreciate your figuring this out for me!!! I checked through the code to...

I’m trying to create a database to keep track of hours worked. Basically it is to track hours worked by work code (B-Day, HOL, Offshore, OT, OT Site, OT Travel, REG, Sick, Site, Standby, Travel, VAC). Time worked now is entered into Excel spreadsheet, printed and written over the next week so...

I was first introduced to Access when I went back to school in 1995 and that's the version I learned on. I was not then and am not now even close to a programmer using it. I just dabbled in it enough to make very simple databases for data entry letting Access do the work for me. We have...