Recent content by TomUK

E3 to E34, however this data is variable, hence why the following in my code: Range(Selection, Selection.End(xlDown)).Select The data should allways start at E3, but the end cell is unknow.

Please find attached, although the orginal file was an xlsx file, but should not make a difference.

Hi all, I am trying to import variable data from excel into a database and in particular a table. However the data in Excel is in column and the table in rows. I have the following code borrowed from here: http://www.accessmvp.com/KDSnell/EXCEL_Import.htm#WriteFileRst But I am unsure how to...

Thanks, I am not sure what you mean, any chance you can elaborate?

I have searched through the forums regarding this and have tried several of the suggested solutions but I have not had any luck, so I am starting my own thread with the hope that someone will be able to help me. I have an Access 2007 database which data is saved into and using VBA data is...

Thansk guys that worked. All I need to do now is link that code to a button on my form.

I have added DAO but I still get the same error message

Thanks JANR, You will have to excuse my verly limited understanding of VBA. I have looked in tools>Refrence but I cant find any reference to ADO can you give me the exact name I am looking for please?

Thanks for the replys. You will have to excuse my lack of knowlage. The reason I want to see the code is to combine several functions onto one button. However my VBA knowlage is not good enough to write it from scratch hence why I want to see an exisiting code and copy/modify it for my own...

Yes it is a complile error "User-defined type not defined" Error appears on line 4 "Dim rs As ADODB.Recordset" Thanks, Tom

Hi all, I am new to access 2007 and have brought a database through from 2003. I am having trouble getting some code to work which is run from a button on a form. Is there a major change in the code for 2007 to make the following stop working: Private Sub ExcelExport() 'Declare a variable...

That takes me into Macro tools design tab. I want to see the VBA code behind the form/button as what I want to do is not in the standard list of commands in the macro tools

I am having trouble finding the VBA code behind a button placed on a form in Access 2007. I have placed a run query button on a form using the wizard. Using alt F11 I bring up VBA to view the code but I can’t find anything in VBA. I want to modify the code so I can get several commands on one...

I still can seem to make this work, it appears to be the control source in the unbound textbox that is the problem. This is what I have writen in the contolSource: =[Input force at 1.5mm]/[miscalanious values]![Number of bridges] The name of my unbound textbox is Input force at 1.5mm and the...

Thanks for the quick reply. I should have mentioned this before, but I am running 2003 and I cant find the recordsource you mentioned, is this the same as controlsource?