Search results

will give it a go. Thanks :)

Hi How can i export my file using the macro (transferspreadsheet function) but export the file with the current date. so if the filename is gonna be fhm.xls, i'd like it to be fhm09-01-2006.xls.

Hi I'm trying to import a sheet from a excel spreadsheet. this is my "code" The problem is that when i hit the run button, it imports blank sheets or more likely is not importing at all :confused: :( On Error GoTo ErrorTrap Dim dlgOpen2 As FileDialog Dim countrystring2 As String...

thanks, it did help. :D

hi i've created a unbound text box and for my default value i've put the path of a spreadsheet i wanna import. How would i get my macro to select fromt the form as apposed to the default path i put in manually.

yup, not running on close. i renamed the macro, and ran it. when i clicked on my button, it said that it can't find the macro (coz i changed the name), so i closed the form and the macro ran!!! added a close form button. when i close the form with the button, the macro runs! :(

Okay another Quick question. When i open access, i get my forum popup with my button that runs the macro. i click on the button and presto! all done, which is fine BUT - > when i try to close the form, the macro runs again! which i don't want. Any ideas on how i stop that from happening?

sweeet :D thanks again for your help. Have a virtutal beer on me

yeah i think i've got it now. Thanks Col basically this is what i've done. Created a Macro that 1.) Deletes the contence from my Table 1 2.) Deletes the contence from my Table 2 3.) Imports the new Table 1 (same file name, same location) 4.) Imports the new Table 2 (same as above) 5.) Runs...

thanks, this was really useful to me aswelll :D

no idea, just trying to find a way to import but don't know how so was trying to create a cmd select button so when it is was clicked it would promt u with a open box so that i could select the table/file to import?

thanks i've created the macro to run all six queries in succession. Also created a form with a button to run the macro. was trying to create another button to upload the tables but kind of stuck now :/

thanks again. Well i've got as far as Setting the form up. Creadted a cmdselect button to open the new files BUT when i open up the db, the macro wants to run straight away without giving me the option to select my file 1st.

yeah sorry, i mean't 6 queries in one macro. Thanks again. Am i correct in saying that when i create that form and add the OnClick button, i can also add a button to import the 2 source files that i'll use as tables for my queries?

Thx Col works well. Next Question - Can i add say 5 more macros to the end of this and will they all run? Also, how would i set this up so that when i open the db, i just click 1 button to run the macro (which will run my 6 queries)

Hi i've managed to create a macro that opens a query into design view but can't seem to figure out how to get the macro to run the query :(

much clearer now Thanks again :D

Could i be a pain and ask for a brief explanation of it?

I have 6 Queries that i would like to Automate to run with a click of a button or 2 or 3. The db needs 2 tables to run which i'll need to import. Can anyone help me out. Tell me where i can begin or where i can find out more about this. Thanks in advance Rayan

yeah i saw that. Guess i should of mentioned how little i know about Access :( Thanks again