Recent content by DaDutch

Hello all, I have the following question. I wrote a tool in Excel VBA that collects data from a web table and writes it to an excel sheet. The code uses the option "querytables.add" from excel. Is there such an option in Access that does the same trick? (I would like to switch the whole tool...

sorry sorry I wasn't clear enough. i did find out now how to copy one file but now i want it to copy all the found file (all the files which path's are stored in a table). this is the code i'm using so far. Private Sub Command55_Click() Dim rs1 As Recordset Dim sPath...

Hey there, I have the following problem: I've made a search application that will find PDF files in specified folders. It writes the name of the filepath and some other info in a table called tblfiles and shows the data in a form. On that form i would like to create a button that copies all the...

Thank you very much, I think this is what i'm looking for, i'll give it a go later on today!!! Greetz, Rutger

oops wrong link, this one should be good

maybe this screenshot makes it more clear what i want to achieve.

Hello RV, Thanks for the reply. Yes indeed the buttons i'm talking about are on the details section of the form, i need them to be there because they are used to open files found in a search. Maybe to get around this i could delete the buttons and open the files trough a hyperlink or something...

Hello there, I was wondering if any of you experts out there know a way to help me out here. I was wondering if it is possible to color the text on the last pressed button on a continuous form different from all the others, so people will know which one they pressed last? I've been trying a lot...

Hey there, I'm trying to write a code for importing a certain sheet from all excel workbooks in one folder into an access database. This is the code i came up so far: Sub Command14_Click() DoCmd.SetWarnings False Dim Bytchoice As Byte Dim Pad, Bestand As String Dim Naam() As String Dim...

Hey there, I have a problem, I'm pretty much new to access and VBA. For my girlfriend i'm trying to figure out a problem but i'm not getting it fixed. For a conference she will get back forms in excel from attending people. In the Excel workbooks, on Sheet4, there is data which i would like to...