Search results

I have created a very simple Access database with a CompaniesTbl, ContactsTbl and CallsTbl. The database is used to record telesales contact with customers. The tables are set up like this: The CompaniesTbl has an AutoNumber Primary Key field called CompanyID. The ContactsTbl has an AutoNumber...

Hello all Further to an earlier post asking how to check if forms were open ... I have a form EditCompanyForm which pops up to let people edit the details of a company. The form can be opened from one of three forms. When the EditCompanyForm is closed I want to update the form that opened...

Hi I know this is stupid but ... I looked in my book and it said it you want to test whether a form is open you can do this ... If FormName.IsLoaded = True Then If I try this it tells me 'IsLoaded' is not a valid property. How do you test if a specific form is open? Cheers

Hi I have a combo box which is populated as the result of a user doing a search. If the search only produces one record the combo box only has one row.. How can I make the combo box select the one row? At the moment the combo box still shows empty and you have to drop it down and there is...

To try to keep a sane user interface I would like to close forms as another form opens. If I put a Command button on FormA that opens FormB and it is set to find a record on FormB ... how can I close FormA when FormB opens. I tried putting DoCmd.Close either before and after the code that...

Hello all I'm new to Access so sorry if this is stupid - I have looked everywhere! I have an unbound combo box on a form that is populated in the onload event of the form by setting the rowsource to a query based on the companyID on the form. The query gets me a list of contacts at that...