Search results for query: *

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

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?

I was wondering if anyone knows how I can get a vertical scroll bar on a text field where the data is locked and not enabled? Basically, I'm creating a msgbox with a scoll bar. Any help is greatly appreciated. Thanks, Mike

Good afternoon all, Quick question, should be an easy one but I think I'm a bit brain dead today. I seem to be having some trouble applying criteria to an expression within a query that is using totals. I keep getting prompted for expressions that are defined within the query in other columns...

I'm looking for a conference on any one of a number of subjects. It can be on Access, SQL, VBA, VB, Office, any Office application, anything I can relate to my job. Basically, my boss is sending me as a reward so it doesn't have to be a huge learning experience for me. So because of this, I'm...

I was wondering if anyone has any insight into retrieving properties for Outlook items, specifically item type. I need to be able to identify if the item is a note, post, mail item etc. Any insight or direction is greatly appreciated. Thank you, Mike

Does anyone have any experience with calling functions from a table? I have a table that contains rules for a process. The table contains a sql statement that is tested and also a yes function field and a no function field. If the sql statement returns positive then I want to be able to call...

Here are the facts: I have a piece of code that retrieves a function name from a table based on criteria met. The function name is assigned to a string variable. I need to be able to run the function from the code using the string variable. So far, no luck. I haven't been able to hit it yet...

I have a form that fills a list box with file names from a directory but I need to be able to include the file created date as well. I don't know if my brain is cramping or this is actually difficult but I can't seem to think it through. Below is the code that I'm using to grab the file names...

I'm working with the Acrobat ActiveX control in an Access form for the first time and could use a little help. The control has a default src of null and is not visible on the form. When I double click a file name from a list box, I'm populating the src and making the control visible. The...

Has anyone done any VBA coding for RightFax (by Captaris) in Microsoft Access? RightFax is a faxing application that integrates with Outlook. Although, I am fairly proficient in VBA, I've never worked the RightFax model. I've loaded the api and I'm ready ot go but to be honest, I'm not sure...

I posted this to the Access queries forum but perhaps I should be posing the question to this group. I'm looking write a pass through query in Access 2002 that will contain a parameter supplied by a form. I'm having some difficulty getting this to fire. Does anyone have any experience in...

I'm looking write a pass through query that will contain a parameter supplied by a form. I'm having some difficulty getting this to fire. Does anyone have any experience in doing this? So far, this is what I have: SELECT DISTINCT dbo.clmsttus_hist_lmy_v.clm_num...

I was wondering if anyone had some code that will grab the message body from an Outlook e-mail.