Recent content by Page410

Working with ranges and selections is one of the options that I am looking into. It may end up working in this scenario. I would still be very interested in a clipboard object to work with however.

Combo, It is a home grown in house application written in VBA. The Access application opens and populates data into MS Word templates. It also copies content from one template to another. I'm currently investigating a couple of different options but ideally, I would have a clipboard object...

Issue: Current process uses MS Access, MS Word and the Windows clipboard to create correspondence. Because of the way that the clipboard is used I can only have one of these processes running on a machine at any given time. If I try to run more than one, I run the risk of incorrect data being...

I was wondering if there was any way to identify and/or copy all records related to a record being copied. Let's say I have 5 tables A,B,C,D,E My goal: When I copy record A1 to create record A2 I would like to identify all records in B,C,D,E (if they exist) and create records in those tables...

I'm deducing that you simply want to grab a record at random from your dataset. I Performed a Google search for 'ms access return random data' and found this link in less than 30 seconds. http://support.microsoft.com/?kbid=210468 Check it out and let me know if this is what you are looking for.

Prior to generating a new excel file try to delete the existing one with a Kill command (Kill "C:\My Data\myfile.xls"). Just trap the resulting error when someone has the file open (probably permission denied) and deal with it accordingly.

Have you tried to simply query the MSysObjects table. You should be able to get something from that.

Can you post the code for how you are trying to open the file?

Try changing the the following property of the control. .setShowToolbar (False)

set the src property for the control to the file path of the pdf file.

Here is a snippet that should help. Just make sure you add the Microsoft Scripting Runtime reference. Function LoopThroughFiles() On Error GoTo ErrorHandler Dim sysObject As FileSystemObject Dim sysFolder As folder Dim sysFile As File Set sysObject =...

Using Select Cases may help to 'clean' things up. Also, don't use bangs(!) if you don't have to. Referring to the form properties using the period(.) or the index using parentheses and quotes (ME("ControlName")) is more efficient for Access. Dim curDiscountedPrice As Currency Dim...

For my information, what would the advantage of passing the reference be?

Here's a quick little function that will check if a control exists on a form or subform and return a boolean value. I've used it to check to see if recordset field names are used as form control names, updating the recordset with the form value when I have a match (let me know if anyone is...

The pdf activex control doesn't include an error class. Does anyone know how I can trap these errors. Has anyone out there already written a class module for this?