Search results

(y)efficiency comes first :)

Thanks MajP! I have tried this solution and it works, I have linked the main invoice query with 2 total Tax queries. However it requires now 3 queries :-) Improvement: I can still start the same main invoice Query from all forms with the openreport command !

Thanks for your replies, finally found why I could not find a solution: A query cannot directly reference a VBA variable. It can, however, call a VBA function that returns the value stored in the VBA variable. solutions: - use vba function - use tempvars

Never heard of tempvars but I am gone learn about them, thanks

Thanks, but it seems that this still needs 2 queries, with other form references, for the same report

I quess my first explanation was not obvious This is my goal: I have a report that prints a selected invoice from 2 different forms. All records of an invoice consist of yes/no box if taxes are obliged under the sum of the invoice (report) amount I want 2 extra totals. -the amount where taxes...

Thanks Plog, the query selects just the selected invoice on the form by means of a report I did use the dsum in the report but then I stil have to use 2 reports because of the different references to 2 different forms in the DSum formula kind regards, Louis

Hi, I would like to use 1 query to print a report from 2 different forms. So normally I use the following query’s: qry_invoice where criteria in design mode is forms!frm_invoices!invoicenr qry_invoice2 where criteria in design mode is forms!frmdlg_reports!invoicenr to use 1 query I tried: dim...

Hi Colin, Found the code by trial and error using a local test database and another "open" internet page. The fact why the code would not work is because, after opening the specific page say: https://intranetsite.nl/link/standaard/626 the URL in the URL-bar (at the top of explorer) was not the...

Hi guys, After setting up a test database and getting data from another "normal" website I get a result but not THE result I like to have. With the code: DoCmd.GoToControl "TITLE" DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70 Dim Header As String Dim objIE As Object...

@arnelgp: error:This property or method is not supported by this object @ ridders: error:Method Document of object Webbrowser2 has failed Many Thanks for trying to help me out guys!! I'm tired, I will go further tomorrow...seem to forget letters in commands (s):confused:

I get the impression that the vba error message is earlier than the explorer is completed loading the page

Hi, Also tried that one but I got the message: Method Document of object Webbrowser2 has failed

Hi, Also tried that but unfortunately the translated message: Method Document of object IWebbrowser2 has failed

Both suggestions respond with (translated): This property or method is not supported by this object at the line: Header = IE.getElementById("89_14_21")(0).innerText or Header = Trim(IE.Document.GetElementsByID("89_14_21")(0).innerText)

Hi, The url is correct because the ie explorer opens perfectly at the right page. But you can not test it because the page is intranet page... At our intranet we have a fixed location where default documents are placed with their unique number. In my access form are the fields: NUM en TITLE...

Hi, I don't have sthat specific one but I have ticked: - VBAfor applications - Microsoft 14.0 Object library - Ole automation - Microsoft Office 14.0 access database engine object - Microsoft HTML object library - Microsoft internet controls - Microsoft xml v 6.0

Hi Ridders, I certainly looked at your solution 293970 but for a beginner it looks too complicated, with all the codelines in the sample database moreover I was stil not up to the line "getelement...." But I have come a few lines further with your advise because now the code returns a failure...

Keep getting error on WHILE-statement: "method Busy failed" Private Sub NR_AfterUpdate() DoCmd.GoToControl "TITLE" Dim Header As String Dim IE As Object Dim URL As String URL = "https://intranetwebsite/pagina/" & NR Set IE = CreateObject("InternetExplorer.Application") With IE .Visible = 0...

Hi Ridders, Fraction of a second will be several days because I am a beginner but thanks for your suggestion. I will look in to it next week. Kind Regards, Louis