Solved Splitting DB (1 Viewer)

TipsyWolf

Member
Local time
Today, 09:45
Joined
Mar 20, 2024
Messages
295
hey guys,
i split my db so i have now 2 db
1. tables only
2. forms, queries, reports and links to tables.

then having #2 opened , i go and save as
1719391164220.png


but it says...

1719391084329.png


why ?
 
what i need , is just to make 2 files where users can create \ modify records through forms and me doing some changes offline and then when im in the same network - just swap forms, queries, reports (update).
 
Last edited:
My guess would be that your code won't compile. Try to compile it and see if it shows some faults
 
As Bob said compile your code (devhut.net/how-to-compile-vba-code/) . Code can't compile -> can't create accde!
 
you get that when you try to create the accde file.

Open any code module, click Debug and try to compile the code
 
View attachment 114742

this is not my code. i can't code in vba yet.
You can't just copy code without amending for your actual requirement. What is your texbox control name for the search?

Take time to understand the code, do not just copy and paste, that will get you nowhere. :(
 
Seems like search field txt_search has been deleted, but not its code.

Delete all code in Form_FmasterList=today()(and never again name anything like that!!)
 
Seems like search field txt_search has been deleted, but not its code.
oh.. yeah, its my auxiliary form i made just for report and i deleted search field cause report doesn't need any searches :)
yeah, gonna delete code in this form. thank u very much.
and never again name anything like that!!
thanks for advice. i wont.
so just to understand it, no !@#$%^&*()_+= in naming tables, forms, reports etc ..
 
oh.. yeah, its my auxiliary form i made just for report and i deleted search field cause report doesn't need any searches :)
yeah, gonna delete code in this form. thank u very much.

thanks for advice. i wont.
so just to understand it, no !@#$%^&*()_+= in naming tables, forms, reports etc ..
Again. You need to undertstand the code you are using. :(
The error clearly states that control does not exist, you might have even renamed it?, but as it turns out it was deleted.
 

Users who are viewing this thread

Back
Top Bottom