Replies

Hi as per my first email, have already tried in quotations… no worries will keep trying. thanks.

Blitzy,

Could you please post the code for the On-Click Event? :cheers:

HI AS REQUESTED THANKS!

DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel8, Tbl_Data_Gaps, [J:Data AnalysisGap.xls], True

Thanks Ruirib, that makes sense.

Will give it a go.

M

Actually, I think you want to create a link in the Access database to the SQL Server table using ODBC, not the other way around. Your original post indicated you do have that. Rather than recreating the table, I would run a delete query and then an append query to move the data in Access to SQL Server. Or you could simply have the SQL Server table the destination for the process that creates the data to begin with.

Thanks Wendell, problem I have is that I am trying to create a wee automatic cleaning and export function on an on_click event, for which everything is working fine except the final export to SQL. Problem is that I cannot seem to find a way in VBA (I’m not a programmer just probably a slightly more “advanced” user than someone just putting queries together) where I can do that – I’ve found a transfer option which seems to relate to the entire database into SQL but not just one table. So if for example I wanted to punt my newly cleaned table directly into SQL Server how would I do it using a Docmd? I don’t want to append to an existing table in SQL server but to put the Access table straight into the database. For example if my Access Table were called Table1, my ODBC connection called ODBC1 and the SQLServerDatabase called SQLServer1? Thanks for your help.

blitzy

Hi, several hundred thousand records so likely to be slow. I did try to set up a link in SQL to the access table but was booted out because of permissions – have had to park this just now, but may have to come back to it! Thanks for input

Thanks, I got it to work! Cheers for help.

You want to convert it to a Date to insert in a table or just to perform some calculation?

Hi I am going to search for records between dates.

thanks.

Hi John, thanks so much that’s working beautifully now. Can you also help with a similar issue –

I have a table detailing actions – simply an autonumber and listing possible actions people might wish to do with the db (e.g. open table, open form, run query, run report etc.). I want to attach this table to an unbound combo box on a switchboard form to allow people various options. I’ve got the combo box set up but not sure how I get the various actions to perform once the combo box listing is selected. think I need some sort of if statement on the AFter update box but VBAs not my strong point. Can you give me some pointers. It would be like

If Combo2 value = 1, then open form1
If Combo2 value = 2 then run report1 etc.

Thanks for your help!

blitzy

me.combo9.requery will get it to update. But where do you put it?
You could use the Activate event.

Not sure I know what the Activate event is – I was going to put it in the onEnter part of the combo box – would that do the trick??

Hi Reid, yes that seems to be working thanks for your help.

Best.

Blitzy

Hi Ruiri – yes I’ve got the Match y/n filled. Thanks kindly for the help – will give it a try with a backuptable in place.

Blitzy

Hi hans, one of my colleagues has pointed me in the direction of the Access Developer Solutions Database, and I’m finding it helpful…. Think I can probably get what I want from this. Thank you very much for your help in any case.

Regards. Blitz

Hi hans, one of my colleagues has pointed me in the direction of the Access Developer Solutions Database, and I’m finding it helpful…. Think I can probably get what I want from this. Thank you very much for your help in any case.

Regards. Blitz

Thanks folks! I’ll try this lot out.

Regards. Blitz

Thanks folks! I’ll try this lot out.

Regards. Blitz