Search results for query: *

Hello. Does anybody know how to set Trusted Location in Trust Center via VBA? Thank you. sudakov.

Hi Duane, Thank you. It works! Sudakov.

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.

Hi Skip, thank you. I will use the appropriate forum. 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.

Hello, Does anybody know how to create a drill-down report in MS Access 2010? 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, thanks for your reply. Sudakov.

Hi genomon, thank you. I let you know if I can figure it out myself how to use Adobe's API. Thanks. Sudakov.

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.

Hi mintjulep, do you have any suggestion how to do it? Thank you. 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.