Search results

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.

Try something like strSQL = "insert into "&tableName&" select * from "&tableName&" where "&conditions You don't have to specify the fields.

I see that your post answers the question of why it tells me the send using setting is incorrect. And thank you very much. I now how have a little more knowledge under my belt, however, the 24 different companies do not share the same smtp server nor would it be feasible to ask all of them nor...

To be honest I would setup the form based on a table where I would set the fields to required and let access do the work for me. In this case if you try to go on without filling in the data a msgbox will appear and then the focus will be brought back to the frirst control with missing data and...

No problem

You may want to look up the opendatabase method of the workspace object. There info on it and an example in the help files. Thus you would create a database object and a workspace object and set the database object equal to the workspace object.opendatabase(insertfilenamehere) then maniplulate...