Recent content by creamichoc

Hi, Basic bit of help required here, have built a userform with a textbox & need to capture the content for use in a subsequent module called from the same form. I would have thought: Public Sub Command0_Click() Me!textname1 = pathforlater Call CodeABC End Sub and then using pathforlater...

Hi, I'm after a bit of code to allow users to select files (any type) from a conventional brower window. The file path will then be used within further operations (such as import). I've previously seen something clever to do this (path returned to a form text box) but didn't bookmark it! :o...

Ok I see your point but that's just a better way of what I've got. First I think it's important to put in place what I don't have! I.e. not being able to import the data to the table!

Queries include adding a field with a constant (user defines), datajoins to other tables etc. I accept that this may not be the ideal solution, however rather than reengineer the entire db I was hoping to be able to be able to write some VBA to replicate the Import Wizard process (since criteria...

Thanks for the replies guys. Unfortunately, once the data is in the table I perform a number of queries on it (add columns etc) so the incoming table will not resemble the current table. Additionally the append query would need me to specify the table name of the newly imported file which if...

Hi, I've got an Access table that I regularly want updated/replaced using a NEW (i.e. different file name but same path) excel file. So effectively I want to be able to select the new file I want, import it (with fixed criteria i.e 1st row contains headers, no primary key etc) & give it the...