Not your question?
Ask your question
View similar questions
Add your answer here.Check out some similar questions!
Runtime error 3075?
[ 0 Answers ]
Hi. I have an SQL code using in VBA Access. There is still some syntax error and cannot see it. I would really appreciate, if anyone has any idea. Thanks. Here is is. Set rst = Application.CurrentDb.OpenRecordset("SELECT DISTINCT da_MF_DATA_complete.*, com. As comment FROM da_MF_DATA_complete " _...
Why am I getting a runtime 3075 missing operator error in the following statement
[ 0 Answers ]
strSQLA = "SELECT * FROM tblAgreements WHERE tblAgreements. = LIKE " & "*" & !!. & "*"*" ;" This code is inserted in as VBA in Microsoft access 2010, basically look in the table agreements within ID, for the user's input, say 550 entered in text box. Can you assist?
Updating records and getting Runtime Error 3075
[ 3 Answers ]
Hello there! For the access program I am going to do, there is already an existing data. I had imported it from Excel. Now, I have created a URN field from the look up table and wanted to update it to the main table which comprises the existing data. I've used the following code but I keep on...
Run-Time Error.
[ 13 Answers ]
Hi, I am using Access 2000. I have a form that shows all the projects being held inside my database. I have made drop down boxes in the form with VBA to filter the projects. I am getting an error when I try to filter the projects: Run Time Error '3079': The specified field 'FiscalYear'...
Run Time Error'3075': Syntax Error(Missing Operator) in query expression
[ 6 Answers ]
I am running a database using MS Access 2000 along with Visual Basic. Inside the database I am running a specific tracking summary form that takes information from a populated main table. Inside the tracking summary form I have three combo boxes; Status, Fiscal Year and Province, with their... View more questions Search
|