Hi Duane,
Thank you.
Your recommendation works!
The reason for using a query is that I can re-use the code every time I need to execute an action query that has a Memo parameter.
The following is the SQL view of the query:
PARAMETERS [prmMem] LongText;
INSERT INTO tblLog ( Message )
SELECT...
Hello,
I have a table with a MEMO field.
I want to add records into the table by executing a parameterized action (append) query via VBA.
Does anybody know how to run a parameterized action (append) query with MEMO parameter via VBA?
Thank you.
sudakov.
Hello,
I have a table with a MEMO field.
I want to add records into the table by executing a parameterized action (append) query via VBA.
Does anybody know how to run a parameterized action (append) query with MEMO parameter via VBA?
Thank you.
sudakov.
Hi Duane and Laimeid.
Thank you both.
Sorry for the late response.
Duane,
I am trying to figure out whether your suggestion can be applied.
The Detail section (Record Source) can have from 1 up to 400 records.
Unfortunatelly, there are many cases when the report has one page only (record count...
Hello everyone,
I have a report with approximatelly 100 records in Detail section (4 pages).
The requirement is to display 15 bottom controls on the Front page and hide 10 of them on the other pages showing only 5 bottom controls.
As my aprroach, I put all 15 controls on the Page Footer...
Hi Mintjulep,
You are correct - no need to write any code at all.
You can use Windows explorer, however you have to confirm a PDF-file name everytime.
In my case, I have hundreds of files, so I have to spend the whole day just clicking to confirm each file conversion.
Thanks.
Sudakov.
Hi Ken,
it is a valuable code.
Thank you.
Answering your questions:
1) I am using Word 2003.
2) As of now, my work environment doesn't allow me to download.
However, I have Adobe Acrobat 9 Standart edition installed.
Can Adobe Acrobat API be used?
Thanks.
Sudakov.
Genomon,
I see what you mean and correct me if I am wrong - you suggest to execute VBA code from MS WORD 2007.
However, MS Office 2007 is not available in my work environment yet.
Thank you.
Duane,
the reason I asked my question in Access forum is that I plan to incorporate the code into a MS Access application.
However, I have followed your advise and re-posted it in forum707: VBA Visual Basic for Application (Microsoft).
Genomon,
sorry I forgot to mention I use MS Access 2003...
Hello,
I have multiple (hundreds) MS Word files in a folder.
I would like to write VBA code to convert them into respective PDF files.
Does anybody know if this is possible?
Has anyone done it before?
Thanks.
Sudakov.
Hello,
I have multiple (hundreds) MS Word files in a folder.
I would like to write VBA code to convert them into respective PDF files.
Does anybody know if this is possible?
Has anyone done it before?
Thanks.
Sudakov.
Hi SkipVought,
sorry for that.
For example, the Main form has 8 records. When a user positions (using Standard Navigation Buttons) on the last record on the Main form, the sub-form has one record where the values are as follows:
FIELD1 = 50,000.00 (Currency);
FIELD2 = 1 (Long Integer);
FIELD3 =...
Hi SkipVought,
Values could be different.
The expression in the calculated control "TXB_AGGREGATE" actually is:
=Sum((nz([FIELD1],0)*nz([FIELD2],0)-nz([FIELD3],0))*nz([FIELD4],0))
WHERE the types are:
FIELD1 - Currency;
FIELD2 - Long Integer;
FIELD3 - Currency;
FIELD4 - Double.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.