473,287 Members | 1,865 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,287 software developers and data experts.

text box values not passing to query

171 100+
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
8 2758
nico5038
3,080 Expert 2GB
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
iheartvba
171 100+
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
iheartvba
171 100+
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
3,080 Expert 2GB
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
iheartvba
171 100+
@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
3,080 Expert 2GB
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
iheartvba
171 100+
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
3,080 Expert 2GB
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

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

Similar topics

1
by: Mike Wimpe | last post by:
Without creating a form, how do i pass a value to another script? I would like to pass: group = "Oranges" to another script or at least just 'group' and initialize it in the first script. ...
3
by: MX1 | last post by:
I'm ready to pull the hair out of my head. I have a query with a couple of parameters that I want to get from combo boxes on a form. One parameter is a date with a dynamically calculated year and...
4
by: Greg Iocco | last post by:
Simple problem, but I've checked the newsgroups and couldn't find an answer. On the main swithboard is a command button to open a report. The report I built is based off a query, and the query...
11
by: Zorro | last post by:
Hello guys, <SELECT name = "f_hello"> <OPTION value = 'H'>Hello</OPTION>" <OPTION value = 'G'>Good-Bye</OPTION>" </SELECT> In the case above, I can easily retrieve the f_hello variable ...
1
by: Garry Jones | last post by:
I want to simplify the following code. I have 4 variables which are to be read in up to ten times. When read in these are to be written to an SQL database. The value of $ct tells me when to stop...
1
by: Sigmazen | last post by:
Hi I am looking in to utilising the new functionality of DPSIs on zOS UDB (DB2 v8), but I have a question regarding the following scenario. - The first table is an Account table whose columns...
3
by: Sharon | last post by:
hello all, I was successfull in passing one value from first webpage to second webpage, but not sure how to pass three textbox values from the first page to the second page. Below is the code i...
0
by: Melanie | last post by:
Hi - my problem is as follows: I'm writing an ASP.Net 2.0 app with C#. From the app, I call a stored procedure that updates some data in the app's database (SQL Server 2000). This stored procedure...
6
by: jej1216 | last post by:
I am trying to put together a PHP search page in which the user can select none, one, two, or three fields to search, and then the results php will build the SQL with dynamic where caluses to reflect...
0
by: Aftab Ahmad | last post by:
Hello Experts! I have written a code in MS Access for a cmd called "WhatsApp Message" to open WhatsApp using that very code but the problem is that it gives a popup message everytime I clicked on...
0
by: Aftab Ahmad | last post by:
So, I have written a code for a cmd called "Send WhatsApp Message" to open and send WhatsApp messaage. The code is given below. Dim IE As Object Set IE =...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: marcoviolo | last post by:
Dear all, I would like to implement on my worksheet an vlookup dynamic , that consider a change of pivot excel via win32com, from an external excel (without open it) and save the new file into a...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.