Search results

Mr. B, in this case, I need to install the MASTER accdb on each user's computer and build the link to the DATA accdb sitting in the network shared folder? This could be time consuming and won't stop my worry. My present setup is both MASTER and DATA are sitting in a network shared folder and...

I have a project with 2 accdb. The MASTER contains forms, reports etc. The DATA accdb contains only tables which is password protected. The tables in the master accdb has links to all tables to the data accdb. This setup allows me to revise program codes, add forms/reports easily by just...

I search the codes in the form, there is no rst.close or set rst=nothing. However, if the form is closed and the database is closed, should the rst closed automatically?

I opened the table mdb, import all queries forms, reports, macro and modules from the program mdb. No problems. The merged mdb has a startup form and is successfully loaded then the menu displays. I ran several options and open the interface displaying the customer data. So far, no problem...

Thanks, vbaInet, I'll try that and post back the results.

I'm helping my friend to migrate an Access 97 to newer version but encounter problem in importing or exporting the table. The current system has 2 mdb, one for tables only, one for forms/reports etc. The 2nd mdb has links to the tables in 1st mdb. To make migrating easier, I copy both tables...

RuralGuy, how do you know the Access deletes the Form_Current event as you cannot view any codes under the accde? Thanks.

boblarson, before reading your reply, I didn't. After that, I added the folder containing the accdb and accde then re-compile the db. Re-run the accde, it still not works. Thanks.

RuralGuy, thanks for your suggestion. Actually, I did import all objects the problematic db into a new fresh empty one but the problem persists. The problem is solved once I remove the sub which contains no codes or remarks at all. Similar problem also happens in earlier version but the...

Guus2005, thanks for your advice. I put the msgbox statement in the accdb. It works to display the form name. I compile the accdb and it does not display the msgbox. I spent a lengthy time to find out what's happening starting some codes that I seldom use before. The codes are: If...

I have a small Access 2007 project which is about 2MB in size. The project has 1 splash screen form, 1 main form with couples sub-forms; several tables, reports and 1 module. On loading of the accdb, the splash screen shows for fraction of second and then the main form displays. Since...

I have similar but a little bit different problem and when I do the search, I find this post. My main form has 4 tabs each of them has a subform. Problem happens on tab #1. The main form displays client's major details and 1 subform displays contact person data from another table which has...

Thanks for all your advices. I'll split the front and rear end as suggested. I'll post back the results.

Thanks, Galaxiom for your advice. I would like to correct my statement for looking for the "compatibility pack"; it should be runtime module such that the Access 2003 machine can run an Access 2007. Is this kind of module available? The reason for opening the mdb from 2 computers is the...

I have a db in Access 2003 format (mdb) and sits in a desktop computer (winXP). I want to access it via the network from my notebook which has Access 2007. There is another user at the desktop computer opening this mdb. When I double clicked the mdb in its shared folder from the notebook, I...