Search results

I copied and replaced the table. Now it is working. Don't know how. But, thanks for your support JHB.

Tried both. But not working. :(

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 Arnelgp, Can u brief on that attachment please.

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.

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

Oh!! yes.. Thank you.. Perfectly working..

Thanks. But still the same error. Error is as follows Run-time error '3067': Query input must contain at least one table or query

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

Thanks man. It worked perfectly. Allen's method is really useful .Thanks for the tip

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

Thanks JHB, But it is not working. Still the count is returning 0 value

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] = #" &...

Thank you. It worked. Thank you for the info :)

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'm entering whole numbers only. Format property was blank. I've changed to General number. I will try now.

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

Yep, Marked solved

Ok.. Got it.. Working. Thank you very much to both of you. :)

Oops. I'm sorry. My mistake. But in property sheet of subform I can only find events "On Enter" and "On exit".