Search results for query: *

Hi Just curious... Where does the value 18 come from? Is it a value in the grid? - DCD

Hello, Hopefully this is an easy one. :) I have a process that moves a file. Just need to check to see if the file is open before I move it. Any sugestions? Thanks - D

Hello, Just a basic question, is there anyway to add text to a pdf document using code? I need to add repeating text to specific pages but I don't want to spend the time manually. Thanks DCD

Hello, Is there a way to add or modify relationships with code? Thanks for your help. - DCD

Hello, I'm using Access97 and wondering whats the quickest way to determine if a table exists. I want to delete the table if it exists. Currently, I loop through Tabledefs and I delete the table if found. The more tables I have, the longer this takes... Any Ideas? Thanks DCD

What's the best way to send to more than one recipient? Thanks!

Hello, Is the value being stored in date1 a date? If so, try replacing: Dim date1 As String With: Dim date1 As Date - DCD

Hi, I believe you'll need to use something like: "where blabla = '" & format(Date(),"YYYY-MM-DD HH:NN:SS") & "'" you may need to tweak the date format a little. Good Luck - DCD

Ok found a solution... see: thread223-209794

Sounds like you want to open a recordset... What version of Access are you using?

Hi, Is there an easy way to take a 5000 pg pdf file and convert it to 5000 single page pdf files? I have acrobat 5... Thanks DCD

Hi, I've seen most of the posts regarding attaching and emailing using VBA code, and I've just started working with it and hope someone can answer a couple of questions... 1) I can email one person. I've tried creating a group to send an email to multiple people, but it doesn't appear to have...

Thanks, John This looks like it will be very helpful!!

Hi, Using Access 97 with Acrobat 4, I need to be able to split and merge pdf docs and I need to be able to use find text. Any ideas? Thanks DCD

Maybe, I'm missing something.... Is rs a query? If so you'll need to move to the last record before rs.RecordCount will have a value other than 0.

I figured it out!! Thanks

Hi, Is there anyway in code to check to see if a font is installed and if it's not, then install it? Thanks DCD

Hi, Select File > Get External Data > Link tables

Hi You could try linking to the excel spreadsheet, like it's a table... Not sure if this will increase efficiency Good Luck -DCD

Hi Try test: format([countofmalus]/[count]*100,"#.000") if you want to force 3 decimal places OR test: format([countofmalus]/[count]*100,"#.###") if you don't mind having 1, 2 or 3 decimal places Good Luck -DCD