Search results

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

Thanks for your swift reply Spikelp. I thought that I understood your advice, but now I only see one record in the target and that is empty. Code is: Dim rsSource As DAO.Recordset Dim rsTarget As DAO.Recordset Set rsSource = Forms!frmOfferteWijzigen!frmOfferteDetail.Form.RecordsetClone Set...

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.

Clear and with this I will try to solve the issue with two comboboxes. Thanks again Mailman!

Thanks Namliam! It works. Great! I would like to understand it, but I have no idea which quotes are pairs. Can you help with this? If I add a second combo can I join them in a strWhere with an And-function? Thinking of something like: strWhere = "AND(Format([Datum],""yyyy"") = """ &...

It works when strWhere becomes: "qryBTWOverzichtKosten.DatumBTWGevorderd " & "Is Null" or "''" As soon as cboJaar is used strWhere becomes: "Format([Datum];'yyyy') = '" & Me.cboJaar & "'" and is giving an error Maybe I'm mixing up " and '. Not sure when to use what!

Reading again what I wrote I understand it's not very clear. Selecting a year with the combobox the listbox is filtered correctly. Then, by pushing a commandbutton, a report is made and displayed on screen. This report is not correct as soon as the combobox is used to filter the data for one...

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

***** FOUND IT ***** I had to install 'Office File Converter Pack', which I downloaded from Microsoft, and after that it's working perfect. :) I hope you read this message before you start pulling you head out.

I just tried to use a Logo.gif, but same problem. Checked the error message, which says: 'DB does not support the format of the file Logo.jpg or file is too large. Try bmp or gif'. This only happens when I run the DB in RUNTIME!!!!!:eek: :confused: :mad:

I pull my hair out! Pls help!!!!!

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

Thanks for your advices Bob with which I was able to solve it. I now also avoid the remark from MS Access that the frontend is not able to find the backend. First I open an invisible empty form. Check in the frontend where the backend was stored during the linking proces. Then I check if that...

Sorry John, but eventually I found the problem. For testing purposes I had an invisible field with the primairy key of a table on the form, which I forgot to delete.

Looked at it and understand what is happening, but I do not understand how to get this 'calculated' path in the picture's property where now the linked path is stored.

Thanks for your advice. When I double-click on the logo in my form the attached window opens and tried to add CurrentProject.Path & "\Logo.jpg" where now C:\Aalles Administratiesysteem\Logo.jpg is added, but it does not accept it.

The database is an easy invoicing tool with a fe and be. The tool is installed on different individual computers and each fe has its own be. The tool is splitted to make it possible to update the fe.