Search results

Thanks guys, both answers are informative, but you are correct plog, I want to include all results for those fields, even if the vale is null.

I have a form with several combo boxes and date fields that form the parameters for query. I would like to be able to 'select all' records, as well as provide the options from my combo boxes. Is there a way to do this using just the query manager and the form (with the fields linking to the...

Yes, we are getting there, thanks for your follow up. However, the record in table B may not exist yet, and it is only by looking at a list for Table A, that they will decide if a field needs to be added in table B (it will probably create the instance of the record), in relation to the record...

Thanks for the reply. The relationship is really one to one. I cannot update TABLE A, it is from another locked database, I can only reference its contents. So what I would like to do, is take data from TABLE A, represent it as a list on a form, and have some additional related editable fields...

Thank you for the reply. The problem here is that the record has not been created in Table B yet at this stage. The joining record between Table A and Table B does not yet exist. What I would like to try and do is generate a list from table A, and in some way select some of these records and...

I would like to take a list of records in a table (table A), visible on a form, and connect them to a dropdown result and put this in another table (table B), creating new index record if you like in table B. Table A is locked and cannot be modified to add a new field. Is there a way to show a...

Our Access database software is being updated from 2010 to 2013. My understanding is that DAO is no longer supported in 2013. I have some code that runs an SQL query from a form button in 2010 and exports the result as an Excel file, using DAO. I would be grateful if anyone here could provide a...

So it Should...! :)

In Access 2010, I have a form with VBA. Within that VBA I have a modal form. However, when that form is referenced: DoCmd.OpenForm ("frmEmailModal") The form loads and the code it is referenced from continues, without waiting for the form to close. I have checked that the modal property = yes...

I have a form that uses a listbox. I can select multiple items and then update a subform. When I press a button with VBA and use the filter property on the subform for the first time, nothing happens. When I press the button a second time, it does - and it works thereafter with different...

Didn't work. Thanks for the try - any other suggestions?

Hi, I am trying to set up a listbox with an option to select multiple items (I have done this and tested it with debug.print and it seems to work). I am then building a filter statement with VBA. I want to then use a button to add this statement to the filter in a subform with (a datasheet...

I have a query with a number of events. Each event has multiple entries, with two TRUE/FALSE fields of interest. I would like to count each of these two fields and summarise in one query for each of the events. i.e. a list of events with a count of committed to attend and those who actaully...

Amended the original code replacing ISNULL with NZ. The NZ function (never used this before) worked a treat. Thanks!

I have a database form with a combo box. I want to ascertain if data has been entered into this box before closing the form. My code below only works when data has been entered and deleted in the combo field, but not on records where this particualr field has never populated. Any thoughts on...

Perfect. That saves me the effort of the next step in the process of cleaning and preparing the list! Many thanks!

Doesn't seem to work, I should be getting 25823 records, but only getting 25093...

I'm trying to create a query that lists all telephone numbers in one column. I have three telephone fields in one table and would essentially like to take these three fields and Chang and together on one list. I have tried the union command but without success; I'm assuming this command is only...

I simply changed the subform source to query and used the 'order by', which immediately rectified this issue, as you both suggested. I'm not sure why I chose to link to table in this instance, probably convenience at the time - costing more time! Thanks for your help with this. Macky

I have a form (A), with a subform (A1). A1 is based on a table and is ordered by date. I have a button that takes me to a new form (B). I can add a new record to B and close this form. Form B is also based on the same table as A1 and I want form A1 to be refreshed to incorporate the addition...