Hello everyone,
I know this may seem very simple to most people, but I am completely stuck! When I run this query, I get the Enter Parameter Value pop up box. The box is not supposed to pop up. Here is some background on whats happened....
We have been running on this same exact access database, which is using a Front End and a Backend database as two separate file, for about 15 years now. It was originally on Office XP(2002?). We are actually still using it on an old Windows XP machine which is running Office XP. I have been toying with trying to upgrade this database to 2016 or newer for a couple of years now. So on my home machine, I am running VirtualBox which I have setup a clean fresh Windows 10 and Office 2007, as I am trying to go through all of the versions of office working my way up to catch all the problems.
It has worked fine in 2003, but with 2007, 2016, and 365, the same exact Enter Parameter Value box comes up. I have done the conversion to accdb, it has the same problem wether its the original mdb or not. I have read literally hundreds of forums, and have been through all of the procedures of using the document analyzer, and finding the parameter, have looked through every different view type of the query, and added quotes around the parameter, removed them, checked for spelling, removed and re typed all manually, added FROM clauses in different areas, removed the table name and left just the field name.
I just cannot figure out what would have changed between 2002 and 2007 that would cause this to only now start popping up.
The parameter value it is asking for specifically in the "Enter Parameter Value ? " Box is GeneralLedger.TransDateTime . The GeneralLedger is the table name, which is in another database, located in the same folder, and is linked to this database, which is the user front end. I have checked the linking and its still there. The value put in the box does not matter, and the program functions properly still when I dont enter any information, or if i enter the exact information, with the proper spacing and format. I have checked all of my data that its supposed to be logging, and its all there. So this pop up box, I dont need it. but need it to go away.
It is possible that this is not where the problem is, that is causing the Enter Parameter Value to pop up. But no other query has the GeneralLedger in it.
Any help would be Greatly Appreciated.
Thank you In Advance!!
Code:SELECT count(GeneralLedger.TransDateTime) AS rowcnt, (select min(GeneralLedger.TransDateTime) FROM GeneralLedger WHERE GeneralLedger.TransDateTime>[Forms]![basLoggedOnEmployee]![CheckInDateTime] And GeneralLedger.AddUser = UserName() And GeneralLedger.TransDetails = "Cash Count Start") AS StartDateTime FROM GeneralLedger WHERE GeneralLedger.TransDateTime>[Forms]![basLoggedOnEmployee]![CheckInDateTime] And GeneralLedger.AddUser = UserName() And GeneralLedger.TransDetails = "Cash Count Start";