Search results

Thanks Steve. I do not understand why the attachment is called attachment.php after downloading.

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?

My intention is indeed to add file to local pc, but I do not know how to address this file in vba to be the background image (transperent) of a a4 report.

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

Thanks sneuberg. I didn't know this.

Also a way and I did that eventually to make progress, but from now more or less similar sheets to maintain. An issue is that when typing positions and/or sizes of controls Access (not always) is not saving this input. E.g. 15.5cm becomes 14.499 or 15.501. The other issue is that when selecting...

Thanks for your swift reply. The one button is printing the report on A4 including margins. The second should print it to a PDF-file, but following needs to be done in VBA: - stretch the width of the report to 21 cm (A4 width) without margins - add image to backgroound which must be stretched...

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

Good to heard that it helped you!

Thanks for that. Apart from the two appent queries I'm also thinking in the directions you gave, but how to build the appent queries including the link between the main and subform.

I want to save the credit invoice as weel.

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

Thanks for all your time Mihail and I try to eplain my question with other words. My form is an invoice (parent) with a subform having the details (child) of this invoice (each record contains an individual priced item). Your example has this relation between frmTest and frmScroll. - I want...

I wasn't clear, but it's difficult for a biker to explain to the engineer what the problem is with his bike. child is e.g. your frmScroll (my invoice details) parent is your frmTest (my invoice) records in detail is a list of works individual priced once the button is pushed I also want to...

after clicking you button I have added: Me.Parent.[TotalExVAT].Requery Me.Parent.[TotalVAT].Requery Me.Parent.[TotalInVAT].Requery to update these three values

You did a lot of work to answer my question. Thanks for that! You introduced a button to requery. I was trying to do the same, but using the on update event. I presume this is a better solution. Two questions: 1. what means the underscore '_' in code Form_frmScroll.GoToNewRecord 2. how did you...

Thanks JHB! It's working now with your help.

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

Increasing the window is not an option. The subform may have 1 record for a invoice and 100 for another. I just want to controll the records that are in view. If the form (parent) is opened the first 6 records (max of subform) are shown and using the scrollbar the next records come in view. The...

It was tested on a Wndows 8 with and without Access 2010 installed. Both resulted in the same error. In the past it was always tested on a machine with previous versions of windows having a version of access and the proper runtime installed. Never this error came up and nothing has been changed...