Search results

Hi all, I have two sub forms on a main form. Subform 1 displays information which comes from a query, filtered using two combo boxes on the same form. The active record on the data sheet has two field values output to hidden text boxes on the form. These text boxes then provide the values...

Hi all, I have a query which uses values in two hidden text boxes, in order to populate a sub form. Unfortunately some times the data in the text box contains brackets within it as follows: '120/60 ZR17 (55W)' When this occurs the query returns no data, even though records with a matching...

Hi all, I am trying to execute a query to update a table with pricing values calculated in a seperate select query. This comes back with an error messahe of "Operations must use an update query". I have checked that the database and linked data files are not in read only folders, but still get...

Hi all, I have a text box on a form which is a calculation based on two other text boxes bound to a query. The code for this text box is as follows: =IIf([Forms]![frmQuote]![Check47]=True,(Sum([Text72]*[Text64]),"0")) When Check47 = True the text box displays #Error, and when Check47 is False...

Hi everyone, I have a form in a database which is bound to a table containing quotes for pallets of books. On one of the form tabs I have two text boxes which are bound to a seperate query which calculates the total Price & Quantity of the quote. Both of these text boxes produce a #Name error...

Hi All, I am exporting data from a query to an excel file using the following code from the Knowledge Base: http://support.microsoft.com/kb/904953 I have the code set up as follows: Public Sub WorkArounds() On Error GoTo Leave Dim strSQL, SQL As String Dim Db As ADODB.Connection...

I have a query which does some calculations. It is limited to 1 decimal place, and this works fine. However, when it returns a recurring number, it is not limited to 1 decimal place. E.G. 7.78156765 rounds up to 7.8 7.33333333 displays as 7.333333334 Is this a bug or is there something else...

Hi i am new to using VBA, so please excuse my ignorance. I am trying to use the following code to select a full or summary report: Private Sub Command25_Click() If Me.Check20 = False Then DoCmd.OpenReport (rptRemainingRubber) Else: If Me.Check20 = True Then DoCmd.OpenReport...

I have a report which calculates the value of the tyre rubber remaining on a vehicle. The report is based on the following query: SELECT qryEfficiencyUnbound.[Vehicle Reg], qryEfficiencyUnbound.Tyre, qryEfficiencyUnbound.Pattern, qryEfficiencyUnbound.OTD, qryEfficiencyUnbound.RTD...

Hi everyone, I have set up a email contacts database for creating email lists. It contains both fleet and tyre dealer customers. I have created a form which (will) allow users to customise the query to give them the appropriate list of contacts. The form has a series of dropdown and tick boxes...

I have a report based on a simple select query (Access 2007). When I run the query, everything is fine and I get the results I expect. However, when I run the report I get the error "you tried to execute a query which does not include the specified expression [tblinspection].[inspectiondate]...

Hi I have a query which pulls vehicle inspection data, and invoice data resulting from any faults found. I have several query fields which should display a value which, at point of data entry, was selected from a combo box pointing at a table. On the input form in the combo box the text field...

Hi I have a report which displays the 2 query parameters used to generate it. The user enters a month number and year number. I have used the following statement: Format([Reports]![MyReport]![Month Number], "mmmm")) When i pull off a report for January 2010 I get the results i expect...

Hi I have a database which has a front end on 6 local machines, and the data tables sat on the server. I have just started getting the error message "database has been placed in a state of admin by...." as i am editing some reports which need to be updated, which live in the local front end on...

Hi I have a query which should total all fuel expenses, by month for the last 12 months. however, when i run the query, it only displays the first cost incurred by a vehicle in each month column, and not a total of all fuel costs. here is the SQL: TRANSFORM...

I'm not actually doing this right now, but i have been wondering if it is possible for future use Can you, through form controls allow users to select AND/OR and other SQL statements to create a dynamic query? For example: A list box allows a user to select AND/OR so the query could find...

Hi I have a database which relies on importing data from .dbf files generated from a DOS system The import has worked fine until today and I am now recieving a type mismatch in expression error. I have not made any changes to the database, and it was working the last time data was imported I...

Hi I have a database which relies on importing data from .dbf files generated from a DOS system The import has worked fine until today and I am now recieving a type mismatch in expression error. I have not made any changes to the database, and it was working the last time data was imported I...

Hi I have 3 queries which produce statements for customers/suppliers and anyone with an overdue balance The customer/supplier statements work fine, and here is the sql: SELECT STATMENT.CUSTOMER AS [Customer Code], STATMENT.LINEDATE AS [Invoice Date], STATMENT.REFERENCE AS [Tyrenet Invoice]...

Hi I have a report which creates overdue payment notices for any accounts with outstanding balances over 60 days old. Every time i run the report it gives me the error code 2467 ("The expression you entered refers to an object that is closed or doesn't exist") When i run debug it shows me the...