Recent content by robburton

I'm not sure I understand the relevance of this to my issue, I think this would relate to the ability to send a document/file to someone or somewhere via mail, the issue I have is not knowing how to open and print a specific type of file using vba in access. If I've missed the point completely...

Thanks for your reply, I think I have not explained myself clearly. I have managed to output the files in .snp format, what I now need to be able to do, is to be able to open the .snp file and/or print it using vba. Sounds a bit long winded I know, my reasoning is that to output the access...

I could be missing something really obvious here, but I can't see it!! I have a series of reports that I output from access to file in .snp format, however there are certain times of the day and night when I also need to submit these reports to a printer. The only solution I can think of...

My apologies, got carried away with the triumph!! The dlookup solution was as follows: v_date = DLookup("[fld_name]", "tbl_table_names", "[fld_key] = " & x) I just needed to take the variable I was validating fld_key against outside of the quote marks, if memory serves me correctly, I...

It works!!!:) Thankyou so much for your help. Rob

I've had a bit more of a look at the dlookup and have now managed to get it working, as a result the message box programed in by Uncle Gizmo has bougght back the following, hopefully someone can see where i am going wrong! --------------------------- Microsoft Office Access...

Yes, it's an autonumber field put against each of the tables names in the refrence table. An example would be as follows: fld_key = 1 fld_name = P01W1 The fld_name field refers to a table.

I've checked it, the code you revised was correct, I copied that straight into access.

Thanks Uncle Gizmo, The message is as follows: Runtime error 2001 You cancelled the previous operation. This occurs on the following line: v_date = DLookup("[fld_name]", "tbl_table_names", "[fld_key] = x") Rob

Hi, I've been looking for a while for a means to achieve this but have so far drawn a blank so any help would be much appreciated. I have 1 Access 2K3 database with circa 300 tables in, each of these tables have the same structure, but vary in thier length, and in some cases are just field...