Search results

hi guys, I found 2 procedures that I combined, first one lists all accdb files on a certain network drive, second one lists all the tables in that DB and some info I need (rows, field count, index count). It worked find on the first network drive, detecting over 80 db's and listing over a...

hello, I have a form with behind it a dataset (a linked table from another ACCESS DB). On the form I have a button with an input box for a search function, which show the searched record (based on a value CTR_ID from the table. however this button crashes (90% of the time). I have found where...

Hello, We're in the process of migrating our systems from access to another environment. One of the first steps is to move our main tables that became too big to handle in access to an SQL environment, as a temp solution in transition to the new environment. Performing simple queries on the...

hi everyone, we have encountered a serious problem with one of our most important DB's. as soon as we try to open anything like the developer, decompile, save as, compact and repair, link to the db from another db,... we get this error msg - The database cannot be opened because the VBA...

Hi all, I a trying to list all fields from ALL tables in a certain DB. I am using the tableinfo function. However, because the output of the immediate window is limited to 200 lines, I can only see the last 200 fields. Is there a way to export this in another way than the debug.print...

hi all, I would like to find a solution for the following problem: on a form I have a command button to load a subform, based on a certain table. the table is an imported table, with saved import procedure. when clicking the button I want access to check the date of creation of the table and...