I am having two problems when using insert object. First I am trying to insert a Excel Spreadsheet that has math formulas build in to it. I created a blank...

Hi, I am trying to insert Null value in column(ShipDate) in my table.That column(ShipDate)'s type id date/time and format is short date. I am using "" to...

I need the code to insert a new record in a table that is in the same .mdb database that my form is in, I want a command button that on click will insert a...

I have made a database with subforms in it. You can add items to the subforms on their own forms but when you want to add the items to the boxes on the main...

If I have two tables, and each table has a field called "NAMES" , eg. Name of product . What I want to do is to insert the NAME record from Table1 into Table2...

I have created a database with several fields, now I'm making my forms and I would like to make a form that has all data in one. I've inserted a tab control...

How can I insert a map into a form and be able to zoom in on it? Thanks, Dave

I'm in A2002 and I have created an OLE object field in the table. On the form I have a bound object. When I insert a picture as embedded or linked, it always...

I am trying to insert a line break. I have a button that the user clicks and then the text goes into Outlook. What is happening is that all of the text is...

I make a database of employees and want to link JPG pictures from same location on disk into Bound Object Frame by Insert Object (on right...

Is it possible to insert data that a user enters in a dialog box prompt into a table? I can't seem to do it in the Query in Design View as it is always looking...

This code is giving me a syntax error. I can't find the problem. CurrentDb.Execute "INSERT INTO " & zDepartments & "(, ) VALUES ('" & NewData & "', dirid );"

Hi, This is what I have: 6 forms that have 5 - 6 text boxes or combo boxes on each form. These text boxes and combo boxes are currently Unbound but that...

I need to store the current data displayed in a form window into a different table. I have tried to use SQL insert into statement as below: - Dim SQL As...

Hi all, I hope this doesn't appear twice, I did it a while ago and it never came up! So here goes again! I am trying to use INSERT INTO to insert one record...

Hi, I am trying to insert to values into two different fields (USER ID: and DESK/LAPTOP) in a table (tna feedback). The values come from forms. I've done...

I have the following code: INSERT INTO (, MI, ) SELECT ., .MI, . FROM WHERE . = !! I keep getting the run time error 3061, stating "Too few...

After messing with it, got the following to work: Dim SQL As String If CDRLID = 9 Or CDRLID = 10 Then DoCmd.SetWarnings (0) SQL = "INSERT INTO...

I'm trying to copy a value from a control to a table using INSERT INTO. The problem I'm having is referencing the control properly. I'm running this in the...

I have a form with various text boxes etc. - Click 'Save' button - all Ok - but if e.g. a text box is left empty - then when 'Save' is clicked - error on SQL -...