Compacting the Database

[mtagliaferri]

Hi have a big database where I have different duplicated forms according to the query it runs.
I would like to clean up the database and move one step up.
The DB attached is a simplified version of what I have. What I am trying to achieve is to have one main form and one subform only which loads and displays the relevant query the user chooses from the switchboard.
Any ideas?
Thanks

 

[CJ_London]

once the user has selected a query, you can use vba to set the subform sourceobject to the name of your query - this will display datasheet only

e.g.

assuming the rowsource to your combobox is a list of the queries as named

 private sub cboSelectQuery()
  
     subformcontrolname.sourceobject=cboSelectQuery
  
 end sub

 

[mtagliaferri]

Thanks CJ London, could you be more precise as I am a beginner, how do I achieve this from the switchboard?

 

[CJ_London]

I've done it for you - see frmAllQueries in the attached

 

[khurram7x]

Solve my issue too, thanks.

 

[mtagliaferri]

Thanks CJ London for taking the time to do this for me, now I am feeling even more stupid as I downloaded the file thinking it was an Access file but is a php extension....can you give me a hint on this php file?:banghead:

 

[CJ_London]

its a zip file - from the thread, don't download directly, just open it and drag the db to your computer.

For some reason some browsers are treating all attachments (at least on this forum) as php files

 

[mtagliaferri]

Thanks CJ London, that's exactly what I am trying to achieve.
I will try to extrapolate de code to apply it to my DB...hopefully no dramas!!!
Thanks again

 

[mtagliaferri]

Hi CJ London,
I managed to replicate the sample you gave me on my DB, I am wondering if I can make some cosmetic changes for the user, example have some Buttons on the form that launch the query rather than a list window, and also my current sfrm has some doubleclick codes to open the specific record, however I have e feeling that with this solution as there is no specific sbform I will loose this option

 

[CJ_London]

not quite sure what you are saying, but buttons do not have a controlsource so you would need to create a separate button for each query