Search results for query: *

We are getting there! Still an error, but this time: Run-time error '3061': Too few parameters. Expected 1.

Thanks Ken. I have posted the following code; Private Sub Command53_Click() Dim strMessage As String Dim Rs As DAO.Recordset Set Rs = CurrentDb().QueryDef("ClaimDuplicateQry").OpenRecordset If Rs.RecordCount < 1 Then strMessage = "Not Previously Audited" Else strMessage = "Previously...

Sorry, still a bit (actually, very) green on vb! How do I define Dim's? .QueryDef is highlighted.

Thanks for the reply. I have now successfully attached the code, but have been presented with the following: Compile Error: Method or Data member not found I am running the database on Access 97 - might that be the problem?

Thanks for the reply. I have entered the snippet as follows: Private Sub Command53_Click() Dim strMessage As String Set Rs = CurrentDb().QueryDef("ClaimDuplicateQry").OpenRecordset If Rs.RecordCount < 1 Then strMessage = "Not Previously Audited" Else strMessage = "Previously Audited" End...

I have built an audit database using MS Access where users enter various items of data & a record is saved for review later. At the offset, the auditor enters the reference for the file being audited, and presses a "Check History" button. This runs a query against the audit table to check if...

Works a treat, thanks :).

I have written a query that extracts values from a form and returns a value to a table. What I want it to do is where the extracted value is greater than zero, to return a value of 1 to the table, else simply return a value of 0. I have tried using the following field criteria without success...

How would I count the zeroes in a query (bit thick here sorry!)

No. It is an audit database so it is primarily interested in what hasn't been done (the zeros). "Yes" and "n/a" signify either a tasks completion or it's irrelevance to the case in question. This allows me to add the number of questions, per sub catagory, and give a % score. EG: 10...

I want the combo to provide a value to the table, not extract one.

Normal to return the same value to the db, but I kinda wanted the combo to show them as different selections. Guess I may have to chalk it up as a "feature"! Thanks anyway :)

Yep, they are both designed to give the same result.

RowSource is 1;Yes;0;No;1;N/A BoundColumn is 1 ControlSource is blank

Thanks. Unfortunateley, the combo is still misbehaving.

Slight problem. The "yes" & "no" selection works fine, but if you select "n/a" it reverts to "yes". Any way around this?

Both appear to work! Thanks both!

Hello again generous friends! I am building a query that extracts the values from two fields on a form and, dependent of the values, allocates a value to a table field. I have tried using the following as my field in the query: value3:if (value1=0 and value2 =0) then value3=0 else value3=1...

Amazin! Thanks amigo!

Hi all. I am building a form with 150 or so combo driven questions, each offering the user a short range of possible answers (yes/no/not app). I want to apply a numerical value to the answers (yes & na = 1, no=0) so I can score the results later. Is this something I can do in Access or is it...