Search results

I'd rather use a command button for this project.

Hi Guy's In I have a table/form which I need to export on to a Word Doc. so far I have this code which works fine but I need to export 'ContactName', 'ContactTitle' 'Address','postcode' and so on. I've tried this bit of code.

The only code I can get to work is this And when the msgbox comes up regarding 'you must add a contact name' after you OK it the come up with the debug form 'Invalid us of null' I tried your code above and it comes up with loads of errors then crashes. Or am I just missing something....

Thanks for all your help Trevor, this code I wrote seems to work just fine. I just need to work out IfNull bit of programming, I have tried.. But it's not working right??/

Thanks for that Trevor, however even when I use your form click on the button I still get this message.

Now I get this, I've tried to research it

Yeh still getting 'Compile error' Type Mismatch on this line

The company are a bit sensitive about that I'm afraid sorry. It's just I have a table called TblCustomerDetails with standard cells, ContactName, Address, postcode, phone number etc. All I need is to extract that data and insert into the fields, I have tried.... and But its jus not...

Thanks Trevor! This works a treat, however is there away as I'm sure that when the button is clicked it would pick up the recordset? .......as in open up with the details of the customer related to what's on that form page and so on Kind regards (-:

Help please guy's! Can anyone one work out why I'm getting 'Compile error' Type Mismatch on this line "MsgBox "Error: " & Err & " " & Error" I'm trying to set up a command button that adds to Outlook on my form.

What I want to do is run VBA so that I can import an Excel spreadsheet that is a template with the same headings and append to an existing table in Access (just like the import Excel wizard as standard in Access) I've tried this as well but not running due to compile errors. :banghead:

Ok thanks for that I'll give it a try and let you guy's know the outcome.

I have tried this version and I get a 'compile error variable not defined' Because of this line - strFile = Dir(strPath & "*.xls")

Nice one guys! I'll give these methods a try and get back to you with the outcome. Again thanx for your help.

Hi Guys Can anyone point me in the right direction or know sufficient code to append an Excel spread sheet to an Access table VBA. I want a command button to run it and add it to an existing table in my DB. Something like Docmd.Importsreadsheet sort of thing. Thanks for any help.

No. =Environ("Public") & "\Desktop\End Of Month.xlsx"

Nice one! I've sorted it using the 'VBA Environ function' Thanks for your help. (-:

Hi Guys, I have this code below which works fine and sends an Excel spread sheet to the users desktop. However I want to be able to use this code to work for any client and therefore need a universal bit of VBA in the below line of code to work on any PC without having to ask the client for...

Hi CJ Thanks for that, however I am running 2013. Cheers

That looks like what I need AccessBlaster, therefore how would I go about achieving this? I it just a case of using the wizard when creating the dail button? Many thanks