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 ?
I'm using a right menu click menu
Since the field is a rich text one I want to limit the users to paste a plain text only, but can't find the correct msoControlButton button ID :(
Is there another option, If there is no special ID for it ?
' Create the PlainText menu.
I want to customize a Hyperlink I already have in the BackStage part of the Ribbon.
I use getLabel/setLabel, getStyle/setStyle.... to change things in VBA
I'm trying to do the same with getTarget/setTarget to alter the target of an Hyperlink, with no success :(
I'm using VBA to download files from my domain (A Sub Domain)
I'm getting an error that there is a problem with the secured channel.
This will happen if I try to Download the file using HTTPS address but will not if I use unsecured HTTP addres
The domain do have SSL, and I have no problem...
I have a problem that Outlook Express cause my Access App to hang :(
Anyone else has this problem ?
Just to clarify - I don't connect to outlook or use outlook in my App in any way.
I do send mail using CDO
Is it possible to replace the ReachText toolbar for a field ?
I want to create my own toolbar adding the Copy, Paste, Cut buttons and removing some of the text formatting existing in the default toolbar.
I also want to disable the right click toolbar for this field
can anyone tell me why this query won't work and will ask for the [EssentialOilsShow] for the ORDER BY clue ?
It will work perfectly If I remove this field from the ORDER BY
It will sort perfectly for any other field [ProductName], [ProductPrice]...
I recently noticed that running the exact same code from a button click is by far slower then running it from a Label click :eek:
I noticed that if run a sort it will load the turning wheel at the end of the run after all data is sorted and set, while running it from a button.
This action alone...
I have this Query
SELECT Materials.MaterialID, Materials.MaterialName, MaterialType_Table.MaterialTypeName
FROM (MaterialType_Table INNER JOIN Materials ON MaterialType_Table.MaterialTypeID = Materials.MaterialTypeID) LEFT JOIN Q1 ON Materials.MaterialID = Q1.MaterialID
WHERE Q1.MaterialID) Is...
How do I add a blank empty field to all records on Continuous Form.
This field will be used to calculate another field, using the AfterUpdate event.
As I read here the only solution is to add the field to the table :(
Is it really?
After giving up with GDrive (Almost) I want try using Google cloud for automatic backups
I'm trying this code but I gen an "AccessDenied", "Anonymous Caller does not have storage objects"
What is wrong with the keys ?
.Open "GET", "https://storage.googleapis.com/MyBucket"...