Search results

Okay, I'm getting closer to this, but don't like what I am finding! I have a form (which I'll call MainForm) which shows some of the details of a company, name, phone, status etc. If you want to edit the full details of the company, you click on the company name (hyperlink) and it opens a new...

Thanks for your replies. I have repaired and compacted the database each time - to no effect. The database is not on a server. It only has one user so is just being used on a local machine. I haven't used Access for years - used to use it quite a bit - never seen anything like this before. I...

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...

Thanks for that.

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...

Thanks very much for your answers. I wonder if you can help me understand something. The function is called IsLoaded You dim oAccessObject as an 'AccessObject' You then write ... If oAccessObject.IsLoaded Then ... which I don't understand. Is 'IsLoaded' a property of an Access object? Cheers

Hi, thanks for your answer. I tried it and got a message that said something like 'Property or method not available' There is definitely only one row in the combo box. Cheers

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...

Thanks very much for your replies.

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...

Brilliant! That did the trick. I read the Access documentation until I was blue in the face and couldn't find that. I assumed I was going to have to loop through the combo box rows etc but couldn't find the syntax. Thanks very much for both answers.

Hi, thanks for your reply. Not sure if it gives me what I want. Often you use a combo box to select which record(s) to display. I want to do the opposite. When a form opens I know which record I want to display - but I want to get an unbound combo box on that form to show which record is...

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...