Search results

I am having problems with the following code. The error is a 3464 data type mismatch error. I have had a look at the table that the procedure writes the data to and it all looks OK. Code below: Private Sub AuftragAbgleichen() Dim qdf As DAO.QueryDef Dim sqlStr As String, sAuftragAlphanum As...

OK, I tried lagbolt's solution and I ended up with the following: Private Sub AuftragAbgleichen() Dim qdf As DAO.QueryDef Dim sqlStr As String, sAuftragAlphanum As String Dim ortId As Long ortId = Nz(cmb_Orte.Value) Set qdf = CurrentDb.CreateQueryDef("", _...

I tried using CurrentDb.Execute sqlStr, dbFailOnError and then I got an error saying "Invalid use of Null". I think the problem could be something to do with the type of data as CJ London pointed out - especially the last item which is a tickbox. I will try a few things and see if it helps. Kirby

The VBA code for an access form has a problem with the syntax - Error number 3144. When I go to debug, the line highlights is CurrentDb.Execute (sqlStr). Can someone please tell me where the problem is. Private Sub AuftragAbgleichen() Dim sqlStr As String, sAuftragAlphanum As String Dim...

Hi all, I've been working with Access for about 18 months so I still have a lot to learn. A lot of what I do is related to a CAD program called IDAT that uses Access for its reporting. Kirby