Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. sudakov

    How to set Trusted Location via VBA?

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

    How to run a parameterized action (append) query with MEMO parameter via VBA?

    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...
  3. sudakov

    How to run a parameterized action (append) query with MEMO parameter via VBA?

    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.
  4. sudakov

    How to run a parameterized action query with MEMO parameter via VBA?

    Hi Skip, thank you. I will use the appropriate forum. sudakov.
  5. sudakov

    How to run a parameterized action query with MEMO parameter via VBA?

    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.
  6. sudakov

    How to create a drill-down report in MS Access 2010?

    Hello, Does anybody know how to create a drill-down report in MS Access 2010? Thank you. Sudakov.
  7. sudakov

    How to display some controls on Front page and hide them on others?

    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...
  8. sudakov

    How to display some controls on Front page and hide them on others?

    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...
  9. sudakov

    How to convert MS Word files into PDF via VBA?

    Hi Mintjulep, thanks for your reply. Sudakov.
  10. sudakov

    How to convert MS Word files into PDF via VBA?

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

    How to convert MS Word files into PDF via VBA?

    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.
  12. sudakov

    How to convert MS Word files into PDF via VBA?

    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.
  13. sudakov

    How to convert MS Word files into PDF via VBA?

    Hi mintjulep, do you have any suggestion how to do it? Thank you. Sudakov.
  14. sudakov

    How to convert MS Word files into PDF via VBA?

    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.
  15. sudakov

    How to convert MS Word files into PDF via VBA?

    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...
  16. sudakov

    How to convert MS Word files into PDF via VBA?

    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.
  17. sudakov

    How to convert MS Word files into PDF via VBA?

    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.
  18. sudakov

    Calculated field (SUM) in a sub-form gives #ERROR occasionally

    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 =...
  19. sudakov

    Calculated field (SUM) in a sub-form gives #ERROR occasionally

    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.

Part and Inventory Search

Back
Top