Search results

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

Thanks for all your time and effort to help me with this problem. I will try to solve it by delaying the 'focus-code'. Once I'm successful I will come back on this thread. Thanks again!

Still I don't get it to work, but I now realise that the names of my form and controll are confusing. The subform is indeed called frmFactuurDetail and the control of the subform on the main form is called frmDetail. Due to the last advice (frmFactuurDetail instead of frmDetail) I modified this...

Sorry, it didn't work. I'm doing something very stupid or I'm giving you wrong information. For that reason I attached a zip-file with the relevant parts of the database and, if you have more time for me, pls have a look at it. after unzipping open form...

Sorry, I cann't scream YESSSSS yet! Due to an error I had to modify the code to: Dim rs As DAO.Recordset Set rs = Forms!frmFactuurWijzigen.frmDetail.Form.RecordsetClone rs.MoveLast Forms!frmFactuurWijzigen.frmDetail.Form.Bookmark = rs.Bookmark Set rs = Nothing Now the first time the focus...

Getting closer now! Following code is now in the on current event of main form. Dim rs As DAO.Recordset Set rs = frmDetail.Form.RecordsetClone rs.MoveLast frmDetail.Form.Bookmark = rs.Bookmark Set rs = Nothing When I enter 'modify invoice' the last and an empty record are displayed in...

I got a runtime error on the second line: Set rs = frmFactuurWijzigen.frmDetail.RecordsetClone main = frmFactuurWijzigen sub = frmDetail

Thanks for your quick response John Big Footy! Although I understand your advice, I wasn't able to solve the problem and added a couple of screenshots to make it visible. A - new invoice (nieuwe factuur) Making a new invoice works as expected. A new line in the subform is entered by moving the...

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

It took me some time to come to a solution of this problem with all your advices. Thanks for that. After the query is built I store it and use it once the report is made. This seems to work perfect!

strSQL which includes the strWhere is in my previous post (today 12:14) Leigh. Is that what you need?

You are right Leigh. My fault, but if I use DoCmd.OpenReport "rptExecutedProject", acPreview, ,strSQL still I get all the data in the report and if I use (the strWhere is also known) DoCmd.OpenReport "rptExecutedProject", acPreview, strWhere then MS Access complains that the string is too long

Thanks for all your advices! I'm getting closer to the problem causing the faulty report, but still not able to solve. I've been adding criteria one by one and every time I checked the content of the strSQL, listbox and report. Underneath you will find the strSQL when the first faulty report was...

I'm working on your advices David. Thanks for that! What do you mean with "You may try looking at In(1,3,4)"?

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

You both are correct. Found it in the settings. Thanks!

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?

Thanks Bob. This indeed gives the reminder that the query has been changed (at least opened) in the previous session after the database is restarted.

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