Search results
-
T
Date syntax error
I am needing to do the following... vr_Month = MonthNumber(txt_MonthName) vr_Date_Selected = DateSerial(Me!txt_Year, vr_Month, Me!Text8) rst.MoveFirst Do Until rst.EOF If rst!f_date = # & vr_Date_Selected & # Then ---Do something --- End If...- time4d
- Thread
- Replies: 2
- Forum: Modules & VBA
-
T
Cannot update. Database or object is read-only
with all 3 tables in the query, you are correct, I cannot change anything. If I remove the tbl_Profile from the query, I can open the form without any problems and also edit data directly from the query itself...- time4d
- Post #3
- Forum: Modules & VBA
-
T
Cannot update. Database or object is read-only
Hello all, I seem to be having problems with rst.edit I am using a query to set my recordset. Inside the Query there are 3 tables: tbl_Profile, tbl_Base, tbl_Template All 3 tables have a Primary Key assigned with auto number. The keys are... tbl_Profile primary f_ProfileID tbl_Base primary...- time4d
- Thread
- Replies: 2
- Forum: Modules & VBA