Search results

Thanks for the tip, I was just posting that thats what I did and it work perfectly thanks so much for all your help.

got it (more or less) Function OpenFile() Call getFileNameOpen(path) Dim db As Database Dim td As TableDef Dim WS As Workspace Dim i As Integer Dim ListOfNames() i = 0 ReDim ListOfNames(i) Set WS = CreateWorkspace("DBtoReadTables"...

PeterF what worked perfect. thanks so much now how can I add them to a list array. In python I would know how to do it, but in VB code I'm really struggling. The output from the debug.print tb.name is: Composite_Parts Deleted_Items Material_List MSysAccessStorage MSysAccessXML MSysACEs...

I'm trying to get all the names of all the tables for a file from a given path and add them to an array. so I can use the array after for something else :)

This is what I have so far. I'm calling the function on the above question and getting the path but I can't figure out how to set the currentDb() to be the database at that path. Call getFileNameOpen(path) Dim db As Database Dim td As TableDef Database = path...

Hello everyone. I'm trying to find all the table names inside an external access file from a path. I have a code for the user to select a file which return a patch to the file. Them I need to find all the tables names from that file and append them to a list. so I them can input them into a...

sorry. I'm trying to create a button that will create a new backend empty file and save it. I have a empty backend file, which has all the tables but nothing inside the tables. I'm trying to make it that every time the frontend opens it links to that empty backend file. Then on the main form...

Hello everyone. I'm trying to create a button that will open a save window so that user can select where and the name of a new backend file. and create a new backend file from the one in use and link to the new open. anyone has any ideas on how to go about this and can help me out, I'm very...

thanks for everyone replays. I was given this link jstreettech.com (J Street Access Relinker) sorry I'm not allow to post links yet!!! that sucks which has a download with exactly what i needed if anyone has the same problem. you just import it to your database and the code is all done. it...

hi Mihail, super complicated thread. I'm very new to scripting to I didn't got anything :) and that thread is the reverse of what I'm trying to do. link a specific backend file into the frontend file. and eveytime someone opens the frontend file it is linked to a empty backend file.

Thank you for the replay Mr.B I will have to study the compile version to use in runtime, I'm new to access and create an exe was the only solution I found so that users can't change the code or the design. The reason for creating several backend files is that each project will be totally...

Hello everyone. I created a database and I manage to split it into front end and backend. now I'm going to make an EXE of the front end. My question is when I open the front end, I need the database to be empty, and them create a button that will make the user select which project he wants to...