Search results

--------------------- EDIT: Solved! In my table, the Date field was set to text, rather than to date. --------------------- Thanks for the help you two, it's nice to have other brains on this problem. I tried it on a different computer, I tried importing everything into a new shell, and I...

I'm working on an Access 2007 database that has a report in it that asks you for a start and end date which it plugs into a query to get all the records in that date range, and then it shows you the results in a report. Problem is that the query is returning extremely inconsistent results. For...

I followed the decompile steps exactly and had that issue. I ended up importing everything into a new database and the file size was reduced 30% from the already compacted file, and all errors are gone. I guess that was what was necessary. Thanks for the help guys.

Wait... After putting that new version on the server for employees to use, I got a call saying that when they opened it, it told them that it couldn't be opened because it is in a test mode. I tried searching for this and couldn't find anything. I can open it fine.

That decompile process was very quick and solved it immediately. It actually made the file 100kb larger, but if it prevents errors it's totally worth it. Thanks guys!

Ah, glad I'm not the only one! I have working backups and simply deleting the label fixes it, but I wanted to know how to fix it so that I can add the label. Do I have to remake the the form and delete the old one? Oops, just saw your comment Boblarson - I'm going to try those things too now.

I have an Access 2007 database that works perfectly fine. BUT WAIT! It has a main form which opens automatically when the database is opened which I wanted to add an ordinary label to. After adding the label (pictured on the bottom of the form in the attached image), if I restart the database...

That was it! Thanks Steve.

Oh yeah I didn't see that one. I have a half dozen other forms in which I've called it AutoNumber too though. For example: pstrEGateSQL = "SELECT tblEastGateProduction.AutoNumber, tblEastGateProduction.Date, " & _ "tblEastGateProduction.TrucksLoaded, tblEastGateProduction.HoursRan...

When opening a form I get the error: Error 3141 in the frmHaulageProduction Form_Open Subroutine: The SELECT statement includes a reserved word or an argument name that is misspelled or missing, or the punctuation is incorrect. I'm new to VBA, but I've had this before and know that it is...

Thank you pbaldy! I was still getting a syntax error with your code, but then I realized that I was calling my date field Date - which is a reserved word in Access and was making it unhappy when I used it in the code. I just put brackets around Date to let it know that it is a field name. For...

Thanks for the reply pbaldy! This gave me a great start. I looked into append queries and managed to come up with something. On Form_Open I put: Dim AutoFill As Database Set AutoFill = CurrentDb AutoFill.Execute " INSERT INTO tblVehicleHours (VehicleNumber) " _ & " SELECT...

I'm creating a database in Access 2007. Every day, the same 30+ company vehicles are operated and the number of hours they were running needs to be recorded. My form shows the current date at the top, and shows a blank continuous form at the beginning of a new day. There are "Next/Prev Day"...