Search results for query: *

Remou, many thanks. You totally just made my week!!

Hiya, I am creating a rental form for a colleague. They want pull-down boxes for Month, Date, and Year for the delivery and collection of an item. Then they want the form to automatically calculate the number of days an item was on hire. 1.How do I combine the data from the month, date, and...

Also, I need it to recognize the year. I created another query to do the month function but it will not distinguish between July 04 and July 05--which is a big problem. Any ideas?

I'm confused! How exactly do I apply the Month function to this query??

I want to create a table or query where, based on the calendar month, a set fuel price will be called up. I created the table with the monthly prices as just one entry per month--which defaults to the 1st of the month. When I run the autolookup query, the fuel prices are generated, but *only*...

Tony you are brilliant! It might not have been too difficult, but I couldn't find anything about it in any help references. Cheers!

I have a report that calculates charges based on the amount of time a piece of equipment was on hire. This works by subtracting an on-hire time from an off-hire time to get an interval. Of course, a bug comes up whenever a job is still on-hire, i.e. no off-hire time is entered in the database...

yes, and I am hiding my head in shame because I figured it out. Long story short, when I remedied a previous problem I changed the data in one field, and then forgot to bring that change over to the calculator. My sincere apologies for being such a total nitwit!!

I looked at the references, and it seems to be o.k. It's a very simple program, and it worked before. Could references un-tick themselves? Because otherwise I am puzzled as to why it was working and now seems to have quit. I also created a new database and imported the necessary tables, queries...

Thanks for your replies! But I still need help... I tried compiling it and it didn't work. I can't try anything on a different computer because at the moment, I have the only computer with Access on it. After I tried the compiling, the form also now does not seem to work in the original DB, or...

Hi, I have created an Access 2000 database for work. It has the usual stuff, and one key form, which is a revenue calculator. I had not compacted my database for 2 weeks. When I did (a couple days ago) the all-important form now comes up with repeated error messages that say, 'run-time error...

I am creating a program for work that essentially calculates various charges and displays them on a form. A couple charges are time-performance based. e.g. As a rental company, we agree to deliver the goods within 3.5 hours. If our delivery time exceeds that, then it qualifies as a late charge...