Recent content by dragofly

Try not specifying the spreadsheet type and just use the default. Also you may want to experiment with leaving off the extension all together and see if the api is smart enough. For the user defined path check out the filedialog object. If the hlp file isn't helpful enough try a google and I...

PRNT = MsgBox("Print "&CStr([Forms]![LabelValues]![NumLabelsGel].Value) &" Labels?", vbQuestion + vbYesNo + vbDefaultButton1, "Question")

Your welcome

What do you mean by falls over. I usually just use the combobox.value function and convert as necessary.

Galaxiom, do you know how to import it in older versions of access.

Interesting work around.

Leave the equals sign out and try.value and/or CInt() to force it to be an int.

Check out the filedialog help. Type in filedialo. Then, put the cursor back in and hit F1. The path returned for filedialog.selecteditems(lbound(filedialog.selecteditems)) would be a string good for your filename variable.

I'm interested what was your solution?

If the only problemis possibly that the table is not updated you could put rs.update before rs.findfirst Or what I would do is link the table (using file import data->link table) then use a query with a where clause simular to your findfirst and thus get your id.

Or you may need to uninstall and reinsttpall access.

What error are you getting? Also is I ever negative?

Open up the test_transfer table in design mode and try setting that field's data type to text if it isn't already.

DoCmd is a member of access.application and a global. But you may be confusing it without referencing it through you're application object. I.e. put a period in front of it and try that. Also I don't have an acCmdCode

Sorry for the late reply dbDamo, but they haven't let me come back to this problem for a while. The mailto works fine with the exception of not allowing for attachments.