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...

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