Search results

In VBA I would like to filter a recordset using the comboboxes on a form. I have three comboboxes. One for the year, one for the quarter and one for VAT. The comboboxes are populated correctly. Afrte selecting a value for the year the recordset is filtered. This also is done when the quarter is...

I have a form with my top 10 clients based on theit turnover. Once this graph is in view I would like to have a button to go to the next 10 clients after each click. It should also detect that it has come to the end of the list. Could you give me directions to make this possible?

In an Access report I'm able to include an images as background. The image file is called 'template.png'. My problem starts when different users get a copy of the database and each individual user adds his/her own design image to the database directory with name 'template.png'. How can I address...

In my application an Access report can be selected and two buttons are than available. One button to print this report to the default printer and one to create a PDF file. Both work, but I'm struggling with white borders (margins). My default printer, like most of the other users of this...

I have a form with a subform. The form shows an invoice and the subform the items to be invoiced. On this form I want to have a button that creates a credit of this full invoice. My question is now how to add the existing invoice and details again to the same invoice table (query) and same...

In the default property of a subform control I want to use a control of the main form without using names of forms, but using me and parent. I used in default property of cboVATDetail: =Me.Parent!cboVAT, but it is not accepted. My aim is to use cboVAT of parent as default in cboVATDetail of...

Form invoice has a subform that can show max 6 records. Once more records are involved I want to show the last 6 including the new empty record. Any suggestion how to do that?

My db is running a couple of years. Recently I moved from Access 2003 to 2010 (both on a Windows XP computer). Both files (.accdb and accde) run as expected, but if these file are moved to a Windows 8 computer with runtime 2010 installed only .accdb runs and .accde generates an error. The error...

I have 2 forms and both have a subform. I want to copy the on into the other. The main form is done, but the subform is a problem for me. The problem is that each record of the first sub is copied into the first record of the second. I'm not able to force it to go to the next. This must be done...

The problem is: When I delete all the records in the table 'Invoice' then the option group of the form does not show up. I have no idea why. As far as I know there is no reason that an empty 'invoice' table should influence the option group. Can on of you help me? I'm using already some time...

To print a report to the screen I'm using following statement: DoCmd.OpenReport strDocName, acPreview, strWhere Where and how can I order the report? I would like to order on more then one column.

In MS Access 2003 I have a form with a listbox and combobox. The listbox gives me records regarding expenses and with the combobox I can select a year. After selecting a year the listbox is filtered and is giving only the records for that year. So far things are doing as expected. Now I want to...

My MS Access 2003 database works, but as soon as it's compiled to mde and started in the MS Access 2003 RUNTIME 2003 it generates error 'OpenReport action was cancelled'. If I reject from the mdb in the on open event the code: Dim PathLogo As String PathLogo = CurrentProject.Path & "\logo.jpg"...

A form in my database has a logo. It is not embedded, but linked to the logo file, which is in the same directory as the database. As soon as I install the database on a different location it comes up with a message that it can not find the logo. Is it possible to add in the linked path a...

I have a database with a front/backend and converted the frontend to mde to install it on a computer with only the runtime of MS Access. I would like to install it on any location of that computer. As soon as I install it on different location as given during the link process it comes up with...

In MS Access 2003 I have a form and subform. The form is a basic invoice and the subform is per record an invoice line (approx 10 lines within the subform window). Each record does calculate the price ex VAT and after adding a record the total invoice price ex and incl VAT is calculated in the...

In my application I build a strSQL of which the strWhere part is built via a form with selection buttons. After execution a search using the strSQL a number of records are filtered and displayed in a listbox. Then via a preview button a report is made and shown. So far everything runs as...

In my Access application I print to a pdf-printer. After this is done Acrobat opens and shows the result. Is it possible to avoid Acrobat to open and showing the document?

After pressing the button to open a query on the main menu I change the colour of the forground of the button to reset the query to the original query (see my last post). Now I would like to hold this foreground colour, but it is lost as soon as I leave this form and go back to it. I tried to...

I need to have a button in the menu to reset the SEARCH-query. With a button I give access to this query to add criteria for the search. Often these criteria are not deleted, but other parts of the database also use this search. Can one of you help me with this problem?