Recent content by mrbebop

I changed the "Date" field to "theDate" as suggested. I am not sure if that helped or not, but I think the idea behind it was sound. I found some other code that was similar to what I wanted to do. I changed the table names and field names to match what I had, and IT WORKED. I am posting the...

That is not working either. Any other ideas? Thanks, Robert

I have looked and tried a lot of things that I have seen in this forum, but I am not able to make this work. I have a query that I am trying to sort a table field, "Date" by month. The field has a "General" time/date format in the table. This is the last code I tried, but as you can see I am not...

Thanks That worked great. You guys really know your stuff!

Is there a way to put criteria in a query that will choose the last 5 records that have been entered into a table. I want to make a query that will allow me to average the last 5 records from a table. The field that has the data is updated frequently.

scheduled task I checked the server computer and the problem with that is there is no option as to where to save the backup.:(

Frontend The frontend is what I am copying to the viewing folder. There are a lot of reports in the front end already. There are a couple of people that like to view a lot of different data and then sort it the way they like it and stuff. I just like to keep them out of the working database. :)

24/7 The database users are inputting data 24/7. Most of the viewers come in at 08:00. The IT group are usually more of a pain than the problem, so I make the copy myself and C&R when it is necessary. I will look into the scheduler you suggested which I assume is on the server computer. I must...

No sir. On the contrary, at one time I was compacting and repairing every morning. I wouldn't care if I still had to C&R every morning, but having to call around and get everyone out of the database and and then go back and call again to see who minimised it instead of actually closing it is...

The database I am referring to is a split database on a LAN. I have a little knowledge of Access, but not much. Currently I am making a copy of the database file (database.mdb) to a different folder every morning for viewers to look at the plant data. It appears to be helping the balloning of...

Wait! How do you import an entire split database? Sounds easy when you say it but I bet it isn't that simple. Thanks

Thanks! When you are in trouble and don't have the answer any ideas are much welcome! I will try each idea.

Nothing All I get is a blank help screen???

No doubt You no doubt know much more than me and I can understand your answer, but the error has not been there in the past and nothing was done to the database over the weekend except to put in data. The database was successfully compacted and repaired this past Friday. Thanks for looking at...

I tried to compact and repair my database but near the end of the process the following box appeared. I have never seen this before. The database did not compact. What does the statement mean and any ideas as what I should do? Thanks everyone for your help.:)