Search results

Hi, In some cases, Weight and age are optional fields. When i execute the query with null values i'm getting "Syntax error in INSERT INTO statement". How can i resolve this with the query?.

Thanks. Able to insert the record.

Following are the datatypes for the fields present in table CustID = Number Weight = Number AGE = Number

Hi, While I'm trying to run "insert into" query when "save" button is pressed, i'm getting the following error: "No value given for one or more required parameters." Below is the query: stSql = "INSERT INTO [CUSTOMER] (CustID, Weight, AGE) VALUES (txtCustId, txtWeight, comboAge)"...

Hi, I have a already existing form and subform. I would like to create another form which is similar to the existing form with different fields. Please find the attached form which i want to create. Can any one of you please let me know on how to create the subform "Specimens2" in the...

It just worked for me. Thanks a lot.

Regarding query i just wrote a select statement. I tried using DLookup and able to update the values. Following is the code which i kept in Text6_OnClick. When i uncomment the code by removing <'> before And I'm getting type mismatch error which is obvious as the Field2 is of type number in...

This has got a real time scenario, these three fields will be part of a form which contains many fields (which will be saved as a record in different table). So when the user enters the data, he is not comfortable with remembering the field3 data, so i want to make it to populate data...

User doesnot want to enter data in Field3 and should be automatically populated in Field3 by finding the record from the table. I want to accomplish this. Is it possible to do if we bound the form and controls?. Please suggest me on how to do this. Thanks.

Thanks for the reply. I think, I'm not using any lookup field. I'm attaching my code so that you can have a look. In this i need some VBA code for Text6_Click (). Please let me know if i'm not clear.

Well, I have actually 3 fields (field1-> textbox, field2->combobox, field3->textbox), i said 2 fields to keep it simple. Yes, I'm trying to locate a particular record. when field1 and field2 are selected, and clicked on field3 the field3 entry should be automatically in form by looking up the...

Hi, I have an MS access 2007 form which is bound to Access Table. The table contains two fields "first" and "second". The same fields are also present in the form as TextBoxes. When a data is entered in the first textbox say "TestInput" then the corresponding second entry (2) should be...