Search results

Addition:: I solved my first question by a query that makes the names that appear in the gusts and attendances compo boxes only for the group members.......you can find that in the attached db.... NOW? how can i add "select all" choice to my multiple compo box choices? sometimes all members...

HI honestly i did not have time to try and now I have another point regarding compo box so i am preparing a mock db to share that makes the issue clearer thanks in advance

Hi all it is long time since my last log in nice new ACCESSWORLD view ...i like it:) ----- my question is ....I have two multiple combo boxes the first is for people who we invite for specific meeting (not all attend sometimes) the second is for people who actually attend the meeting later...

Thanks from the bottom of my heart

yes that is the problem and I add () to the function name now it works great many many many many many thanks for your great help :)

:confused::confused::confused: after i created a runcode macro

many many many thanks and how should i run it :rolleyes: another beginner question

QUOTE=theDBguy;1647961]Okay. The next step is to test it. From the Immediate Window, enter the following: BackupAndCompactBEIf you didn't get an error, check the folder where your FE is located to see if you see the backup file there. GREAT :D

yes and i did those changes

I did the first step I copied the code and pasted it in new module and named it backup and did this too "Note: Replace "tblHidden" with the name of one of your linked tables in the BE and replace "\SCR_BE" with the actual name of your BE file." then :) .... what

i got it now many thanks and i will keep trying

OK I will work on that many thanks for your help

Does RunApplication as an AutoExec macro in the FE be a solution??? to open the BE and then the export data autoExce macro runs..... or it does not work!!!!!! :confused::confused::confused:

Many thanks what do you suggest then?? I am :confused:

I simply use this macro to get may goal.....do not use VBA a lot as a beginner

hi :) may you explain more ...i am an access beginner user .....

hi :) I backup my data on the same computer until they manage a space on the server it works great in the FE but it exports the linked tables that means any damage may happen to the shared BE db means no data .... BTW many users use the data base from different computers

many thanks for your reply I will work on that

Hi all ^_^ How can I make an autoExec macro runs in the backend split access db when a user opens a frontend db The macro is for ImportExportData .......I use it as a back up method......so i need the original tables to be copied not the linked ones...... thanks in advance :D