Search results

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

Hello, I want to create QR code in access report. I tried ID automation, not working. Any ideas/helps are deeply appreciated.

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

I have a table ("Instrument_master") which have a long integer field called Calibration_frequency. I made a data entry form using form wizard for this table. But whatever value I enter in the field Calibration_frequency, it is returning only a specific value (in this case 90) to the table. There...

I've a main form and a sub form. I've a textbox (txtbx) in main form. I want to update value of txtbx with record from subform while I go from one record to next. I found that I've to use "On Current" event. How to code to update txtbx Main form : Form1 Sub form : Form2 I want to update...

Hello, I'm struggling with a syntax error in SQL for updating date in a field Dim db As DAO.Database Dim rs As DAO.Recordset Dim GRN_date As Date Dim temp_date As Variant Set db = CurrentDb() Set rs = db.OpenRecordset("PostedGRNfinal") With rs GRN_date = rs!GRN_date temp_date =...

Hi, I'm new to access. I've been using access for last 45 days. I found this forum very helpful.