not sure why, as I calculate it for a specific Product (ProductID)
in any case I have no other option as I must do some calcs based on all data
I don't want to calc Q1 for all records
but my main question is how should my query looks like
O r should I make Q1 outside the record source ?
I have a form that is based on a query
The first query will calculate amount of material in product (AmountOfProduct * PercentOfMaterial)
The second will take the first one and calculate the price and weight. (Query1 * MaterialPrice, Query1 * MaterialWeight)
How can I do that ?
How can I copy a part of long text ?
I know the start and end points
I want to copy it into another place
*** Edit ***
The text I'm looking for is part of field data, not on form
What I'm looking at the end is for any "FontStyle" other then Bold, Underline or Italic.
They all should be...
I'm using CreateObject("MSXML2.ServerXMLHTTP") for long time to automatically download files from my server
recently I can't download getting an error with secured channel
I get the error on .Send
it does not netter if I send the file to get as HTTP or HTTPS
the files are public so no need...
I'm exporting reports to pdf using
DoCmd.OutputTo acOutputReport, strReportName, acFormatPDF, strPDFfile
After exporting the report is sent by email
sometimes the end user get the report with blank sub reports
The report looked OK before exporting and sending :(
Any idea ?