Search results

If the check box is null (grey) - the default value, I do not want to include it is the sql statement. If I use the code below I get the error 94 Invalid use of null. How else can I exclude this ststement is the check box is grey. thanks If CheckStaged Then strWHERE = strWHERE & " AND...

I have attached a small part of the database which might help. Please have a look. thanks

I made (with help from this forum archive) a cascading combo box form, it all works fine except when I first select on the first combo_Group1; I get a message box "Enter parameter Value" - Group1, I leave it blank and select Ok and everything works fine, until I reopen the form. Sometimes...

Thank you.

Thanks for the pointers, it seems i left out a changeQueryDef function and once the qryExample was created it worked just fine. thanks again

Thanks for helping; EntriesValid is from the book, not sure what it is testing. I removed it and I got a SQL statement msgbox so the click function and BuildsqlString is working ; when I click Ok I get an error Run-time error 3265: Item not found in this collection. Debug highlights the line...

How do i go about this. I want to check a box is_assigned and have field assigned_date be updated to be a date (which will be set in another period_date field). Thanks

I am trying to learn a little VBA and am stumped again... I am trying to build a SQL statement and query from an input form. I am using a book and I am not understanding or it is not explaining well. In the VBA form module I have 2 functions and then one function in a module called module 1. On...

That did it thanks.

Thanks for answering Debug highlights this line: qdf As QueryDef Tools/references shows that the following items are checked: VB for applications Microsoft Access 9.0 Object library OLE Automation Microsoft ActiveX Data Objects 2.1 Library are any missing? Thanks

When I try and run this function in the Immediate Window I get the Compile Error: User Defined type not defined. What did I miss Thanks Function MakeQueryDef(strSQL As String) As Boolean Dim qdf As QueryDef If strSQL = "" Then Exit Function Set qdf = CurrentDb.CreateQueryDef("qryExample")...

Thanks for responding. I tracked it down to one field by deleting controls.It turned out to be some missing data which created a null value in one field. Very frustrating but what relief when you fix it...

This post explains my problem, but there were no replies. How can I troubleshoot my report to tell me where the data mismatch is. thanks

Thanks both, I have been using Access for sometime and seem to have missed this. All working now.

Attached is a database with one table of 3,304 rows. If I do a Filter by selection or filter by form for "deleted" I get 33 records. However when I do a filter for <> "deleted" I do not get 3,304-210 = 3,271 rows; I get 210 rows. What am I doing wrong. The problem appears to be that the...

that did the trick, thanks

Can anyone help me do this and than tell me how to see the results of the statement so i can see how the result changes when i make changes I want: zone = "08" and circuit <> "Deleted" i am using "zone='" & me.cmbzone & "'" & "AND circuit <>'" & " ' "Deleted" ' " Thanks

Thanks both, I went with the Dlookup. I did not want to put those fields in to all of the queries as well.

I have several reports in a database. I have been adding text fields to show the project name and number; however everytime I use the database for a new project i have to edit all of the reports. So I made a table with standard project details (Project number and name and location etc). In the...

Thats did it Thanks very much. Steve