My database was working properly until yesterday. A new error is throwing while opening a form
Run-time error '-2147352567 (800200009)' :
This Recordset is not updateable
I'm not able to update the data in linked table using this form. however I'm able to change the data directly going into...
Hi Issskint,
I installed IDAutomation Data Matrix Font Encoder and imported the .bas file into Modules. Then in report I created a text box and changed the control source as "=EncDM([Table_name].[Field_name])". Then I changed the font into "IDAutomation2D XLS". But It is not generating a QR.
I'm trying to insert today's date into a table using SQL. But run-time error 3067 is popping out
strSQL = "INSERT INTO tblECO (Release_date)" & vbCrLf & " VALUES (Now()) WHERE ECO_number = (" & E & ")"
db.Execute strSQL, dbFailOnError
In the above code Release_date is date/time(short date)...
Hi,
I've got syntax error in date expression in an SQL command
Dim db As Database
Dim rs As Recordset
Dim temp3, As Date
Dim temp1 As Long
Set db = CurrentDb()
Set rs = db.OpenRecordset("tblSale_order")
temp1 = Me.MID
temp3 = Me.txtexpecteddeliverydate
strSQL = "UPDATE [tblSale_order] SET...
Error in Dcount criteria
I need to count number of records in a table (tblData_save) with with date field given in criteria. Date field is taken from a form (frmTransaction_input). The code is as follows
temp1 = DCount("*", "tblData_save", "[Enter_date] = #" &...
I want update one field in my recordset using UPDATE and WHERE command in SQL. But the following error is showing
strSQL = "UPDATE [tblLogin] SET [Login_password] = '"&Me.txtnewpassword&"' WHERE tblLogin.Login_id = '"&Me.txtLoginid&"'"
db.Execute strSQL, dbFailOnError
It is showing error...