Search results

First of all make sure that there are no spaces in your field names. Secondly you need to look at what fieldlist is returning Why are you using mid(..,3)?

When you say long updates, how long is long?

You are using the msgbox not as intended If MsgBox("Incorrect Password",vbExclamation+VbRetryCancel,"Invalid Password) = vbRetry Then '/Do this Else '/Do That End if

Then on the on click of the first listbox Me.Listbox2 = "" and vice verca

Are each list boxes multi select?

Have you looked in the Sample Databases section or examples?

I knew you would ask that. Go to the VBA section of the checkbox to the OnClick Event() Next click on the extreme left gray vertical strip see image Then when you click on the checkbox press the F8 function key to step through the code to see whats is or is not happening.

DoCmd.RunSQL "Update cost set pallet_cost = " & Me.Text2 & " where order_no = '" & me.Text0 & "'"

Put a breakpoint on your on click event and step though the code.

oApp.Visible = True oApp.Workbooks.Open OpenFile.lpstrFile With oApp .Visible = True Remove the bold lines

Go to each of the controls and bring up their properties Visible False

With .Workbooks(.Workbooks.Count) For i = 1 To .Worksheets.Count WrksheetName = .Worksheets(i).Name DoCmd.TransferSpreadsheet (acImport), acSpreadsheetTypeExcel97, "Testing Tab", OpenFile.lpstrFile, False, "Access" Next i End With replace with DoCmd.TransferSpreadsheet (acImport)...

Is palet cost a number if so take out the single quotes If DCount("*", "cost", "order_no='" & Me.Text0 & "' AND pallet_cost=" & Me.Text2 ) = 0 Then Same applies for Order no

Set the default visible property to False or all the controls when the form opens.

Then select the range and name it then use the named range for the import

Whe you say it is not working, what is not working?

How are you intending to use this query?

Are all the cells on the same worksheet in the same place? Can you post a sample xls with the cells highlighted.

Use the add command button wizard to a form and select new record then use the vba that it generates.

This is probably because there are three worksheets in the workbook. What are you trying to do exactly? why the For Loop?