By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,705 Members | 1,845 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,705 IT Pros & Developers. It's quick & easy.

text box values not passing to query

100+
P: 171
Hi this is a query made using access query builder:

Expand|Select|Wrap|Line Numbers
  1. SELECT tblBank.BankID, Now() AS TimeRecd, Val(Right(nz([SerialID],0),3)) AS ConsID, "AutoCASH" AS RecUser, tblBank.Dt, Forms!frmRecCASHRunningBal!tbGroup AS GroupID
  2. FROM tblBank
  3. WHERE (((tblBank.Dt)>([Forms]![frmRecCASHRunningBal]![tbBankMinDate]-1) And (tblBank.Dt)<([Forms]![frmRecCASHRunningBal]![tbBankRecDate]+1)));
  4.  
1.tblBank has a record in the Dt field which equals = 02/07/08
2. tbBankMinDate -1 = 01/07/08
3. tbBankRecDate + 1 = 03/07/08
4. Both tbBankMinDate and tbBankRecDate are formated to be date
5. A very similar query is running properly where the date is filtered exaclty the same way only using different text boxes.
6. The above query was working fine a few days ago.


Thanks in advance
Dec 26 '08 #1
Share this Question
Share on Google+
8 Replies


nico5038
Expert 2.5K+
P: 3,072
Are you sure that the frmRecCASHRunningBal hasn't been renamed, or that the query is executed from another form ?

Nic;o)
Dec 26 '08 #2

100+
P: 171
Hi Nico,
1.There has been no renaming of any forms or text boxes
2. There is no problem with the execution of the query only with the date filters being passed to the query via the text boxes on the form.
3. The text boxes definatley have the correct data in them
Dec 27 '08 #3

100+
P: 171
uuuhmm. Hmmm. mmm. It's working now. I haven't changed anything. Ok. I think it was computer gremlins or something :S
Dec 27 '08 #4

nico5038
Expert 2.5K+
P: 3,072
Or your database is getting "corrupt".
Best to make regular backups and execute a Compact&Repair once in a while.

Nic;o)
Dec 27 '08 #5

100+
P: 171
@nico5038
Q1. Why does A database get corrupt?
Q2. What can one do apart from Compact & Repair to stop a database from getting corrupt?
Q3. Is The Front End or Back End of an Access Database more likley to get corrupt?


Thanks Nico, Much Appreciated
Dec 27 '08 #6

nico5038
Expert 2.5K+
P: 3,072
This FAQ might answer all (and even more) questions you might have on corruption. Just check the text and links:
Corrupt Microsoft Access MDBs FAQ

You can create a corrupt database by deleting a form and creating a new one with the same name in the same session, but that's not the only cause....

Nic;o)
Dec 27 '08 #7

100+
P: 171
Wow! No Wonder programmers get paid so much. There's a lot that can go wrong in any step during developing, implementing or during use of a software. This Guide seems very helpfull I'm sure I will be reading it thoroughly.

Thanks Nico
Dec 29 '08 #8

nico5038
Expert 2.5K+
P: 3,072
Glad I could help. When you create regularly backups (I normally do before starting a main change) you would be on he safe side.

Success !

Nic;o)
Dec 29 '08 #9

Post your reply

Sign in to post your reply or Sign up for a free account.