Search results

Hi all, i wonder if someone could help me, i have a table based form that is used to enter data and one of the text fields is sourced from the field in the table updated via an update query. i do my testing via a button, but i always get the Compile error 'Argument not optional' when i try to...

Hi All, anyone knows why the ODBC directory string "@'server name':'path' is not working when macro is attempted. The manual import/link works fine through the ODBC driver, but macro throws the message:'Could not find installable ISAM' (Error 3170)and help says that there is a missing .dll file...

Hi everybody, ni have got the form with the selected text boxes displaying info from a table. One of those text boxes is a record id. Also, I have a button that i am trying to make do this: open word document with the name relating to the recird id displayed in the text box, ie if the textbox...

Hi All and Merry Christmas, I have a this subform that is based on the query;One filter is sourced on the combo box on the main form and it refreshes the subform after change. The other filter is on the column in the query that has two values, Y and N. I am trying to set the criteria through...

Hi Everybody, I am trying to create a text box on the form that would show subtotal of the specific column on the subform above it. The subform is based on the query that runs each time a combo box is changed and it refreshes the subform. I have tried sourcing the text box as Sum([Query...

Hi could someone tell me what does this do by the way this question is also posted in the Excel section since it is from the spreadsheet) Dim data2(500, 20) count2 = 0 Sheets("volume").Select For w = 6 To 500 If Cells(w, 4) = "" Then GoTo 30 count2 = count2 + 1 data2(count2, 1) = Cells(w, 4)...

Hi everybody, does anyone know how to translate or adjust the Excel filter command Contains (="=*VALUE*") into Access so that is acceptable as the criteria field? thanx in advance