Search results for query: *

I am attempting to create a select all option in a combo box. I have created a union query with the following code: SELECT "*" AS Task_Code, "(All)" AS Description, "(All)" AS Trade FROM tbl_Taskcode UNION SELECT tbl_Taskcode.Task_code, tbl_Taskcode.Description, tbl_Taskcode.Trade FROM...

I have a query (qry_count_buildingcode). It returns the number of work orders for each building. This query gets its fields from another query. Although 'qry_count_buildingcode' returns two simple columns of data ('Count of work orders' and 'Building Name'), I cannot make Access automatically...

I have a form where the user selects criteria such as 'builidng name'from a combo box. The criteria is used in a query to show work orders for the building selected. I would also like to give the user the option of viewing all buildings at once. Can I include a 'Select All' option in the...

I need to sort my work order report by listing the building with the most number of work orders first. The report is sorted by date next. I made a query to count the number of work orders for each building. Then I told the report to sort by this 'count' and then by date. This works until two...

I have created a form with a command button that has the following code: Private Sub cmdXL_Click() Call CreateExcelChart End Sub There is a module called CreateExcelChart. The module is public and should be run when you click on the command button. The following error message appears...

I have a query that is composed of fields from several tables. Occasionally, a record will not have data for one or two of the fields in the query. If this is the case, the record is not returned when the query is run. It's not that the field for that record is just blank, it doesn't even...

I have successfully used VBA code to print two different reports at one time. Sometimes, however, both reports are not applicable to the field chosen and I end up just printing blank reports. Is there a way to automatically cancel the printing of a report if no records exists for a particular...

I have linked tables in an Omnis database to MS ACCESS. The connection was working for several days. Now I get an error saying: " ODBC-call failed Unable to read disk(bad disk)(#0)" I have reinstalled the driver and tried to link tables in a new MS ACCESS db with no luck.