Search results

I have two sets of queries. A client query that lists the client and their skills (a client can have several lines as the skill comes from a child table where the client is in the parent table). I have a job query, that lists employers and the skills that they are looking for (employer = parent...

Can you query on a query in VBA and filter in the VBA for a cleaned up output? If anyone can advise with a VBA-SQL example, appreciated. Thanks.

Hi, I am trying to query on a DateAdd column that I am creating in a query. It is returning data but the dates don't match with the criteria I am trying to pull out of the database. I am getting results on all 'product one' entries. I am running this in a VBA statement to dynamically create...

I am trying to generate a query based on dates input by the users in a text box with an input mask, and users will input dd/mm/yyyy. I am using an access front end on an sql server. The server is read only. I am using VBA and DAO to generate the records and query. I am having a problem with...

I am trying to build an sql statement and put it into a string. I can do this, but at character 1024 the text that follows is put on to a new line, cutting a fieldname in two. I have declared the string but perplexed. Any thoughts? the section on vba: mySQL = mySQL + "LEFT JOIN dbo_Contact ON "...

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

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

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

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

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

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

Access 2003 I would like to use the same form for two different tasks (say... form B). 1) I would like to use a button on a form (form A) to access a second related form (B). I would like to know if there is any VBA that will ensure that the second form only opens the sub record of interest...

Access 2003 --------------------- I am having a problem with opening a form from a sub form. I don't know how to access the subform record selector property on my master form. I have a master form (A) built on a table (table A) . The master form has a sub form(B), built on a table (table B)...

Set-up ------- I have an Access 2003 database - front end and backend. front end sits on dept desktops back end sits on an accessible network with security file/workgroup Problem: --------- Sometimes the network goes down and subsequently the front end on colleagues desktops can no longer...

I have built a database in Access 2003, it has been robust up until now. We noticed that some records were being added and some weren't through a form. I had a look at the ID numbers that Access was automatically assigning (primary keys) and realised that Access was sometimes assigning keys...

I have a rather bizarre SQL issue. I am taking data from two tables and copying it across to a third table, before deleting it. This works perfectly well until I reach the number (a key ID number) 22401 and beyond. I have checked the casts (long) for the recipient table and in the code I have...