Search results

Very clever you are. There really were a lot of changes in the code as well as criteria formating on the queries. My database is Access97 however I do have a laptop that has both Access97 and Access2000 on it. I am trying to convert (copy/paste etc) the information into my main database...

Wow! As I check the properties and the event notes, it is quite a bit different than my own. It works really slick. I'm going to take some time tomorrow to understand each of the changes that you made. I see that it will automatically pick the 1st date and the last date recorded specific to...

Thanks for your reply. There are some improvements, but it is still not correct. I am sure it is not for lack of what you have told me but simply my ignorance with Visual Basic etc. Each project I learn just that much more. I have worked hard to get to this point and thought perhaps I would...

I am finally getting back to finalizing my project and realize it is not working quite right, plus my user has an additional request. Currently, the users clicks the Report Name on the switchboard where the "on open" event opens a criteria form. The dropdown box with employee names appears and...

my report is based on a query and your response was just enough to get me on track and get the result that I wanted. Thanks very much!;)

I have a program that Tracks the projects received within a department, who works on them, the time used and the costs associated. I now have a request from that area to adjust a report that will show a designated employees results. Normally, I would set the query/report criteria to ask for...

Sue, The result is absolutely perfect!! I have been stressing over this thing for at least 4 days, trying everything I knew. What I did not realize, was that I could set up a combo box on my report as you did. I will keep your "point to remember" handy for future projects. I am not sure I...

OK Sue, Did what you said and I was able to get it in a zip file. Again, please note the output on my report based on the combo boxes (I don't know how to fix that) and of course the totals problem. If there is an answer to this, I know that I will have learned some valuable information as a...

Acually you are on the right track, but using either of your suggestions gives me error messages regarding the use of (( or commas. My DB is too big to send out in a zip, but I am sending you a copy of my form, as well as the report output as it is right now. As you look at the form/report...

On report, formated Check Boxes That only show a yes, are shown below and work just fine. Have 2 text boxs on form for Dollars and Dollars2. The user will pick q check box for Prof or Fac and show a $ amount in “Dollars”. They will then pick a check box from Prof2 or Fac2 and show a $ amount...

Not sure where my problem lies so will tell you what I have done and what my result should be. Have primary CustomerTbl, ServiceTbl, ReasonTbl, and LocationTbl, with the 3 latter tables related to customer table. Have a form allowing for 2 entries of facts if necessary; Customer name, Contract...