Search results for query: *

Hi Skip, Finally got back to this and glad to say it worked like a charm. Just had to add the cancel = True part inside the If statement. Wish I could change the title of this thread in case anyone else is looking for a solution like this. Thanks so much for your help. A star for you! Baggie

Hi Skip, Thanks for your response. I will give this a try and let you know how it goes. As far as the workbook object is concerned I chalk that up to inexperience. Are you saying that I don't need to assign it to anything? I can just use the workbook.open...etc without setting it to wkb1...

I have continued researching and now I have found the workbook doubleclick event. I'm thinking that this may be better. However, now I need to limit the range to just the column with the network file pathways so if they double click on any other area it wont' fire off the event. Anyone have an...

Hi, I have been searching for awhile but cannot find what I am trying to perform. I haven't programmed in VBA in awhile and never in Excel VBA, so I'm not handy with the objects, events etc. in it. I have a spreadsheet with a bunch of summary information (about 500 rows) in it that some auditors...

Hi Charliy, Thanks for your response. First thing I need to do is get the last termination date out of the History table. There can be multiple termination dates for some employees and I need to find the last entry (and it should match the term date in the Employee table). SO, I want to know if...

Hi, I'm relatively new to Crystal Reports. I have an issue I'm hoping someone can advise me on. I did search around on this site to try to find an answer but didn't see one that helped. So, first of all, I am on CR Version 12 SP 2. I work for a hospital HR department. I am trying to find the...

MajP Thanks for your response and the link to the article. I got it resolved by upgrading to Access 2007 and the program works fine now.

Hello all, Just wondering if anyone has experienced anything like this. I have an XP database where I have written some VBA code to create, manipulate and then send out (via Outlook) some Excel spreadsheets. It worked perfectly last month when our company had Excel XP. This month we have been...

Greg, That did it! Thanks so much!

Hello all, I have borrowed some code from thread 705-1367295 which shows how to send an email via Outlook from Access. I am having trouble with one item so far and that is where the program declares this variable: Dim fso As FileSystemObject I get a compile error: User-defined type not...

To all: Thanks for your input regarding my question. Sounds like this job may just be the same Excel sheet, different data. Ha! Ok, bad pun. I still haven't received any description on the job so I think they just think I'm going to take this on faith. Well, I'm starting to circulate my resume...

Hi all, I am working at an organization as an HRIS (Human Resource Information Systems) Analyst for some time now. The company has just asked me to move to the Finance area in about a month and be a "Data Analyst". They haven't supplied any job description yet so I've been out on the net and...

Thanks Skip, I'll give it a try!

Hi, I've looked around on this site and haven't seen this question posed. So, I'm going to pose it. I'd like to impose a scatter chart over a bar chart. Is that possible? Here's a bit of the detail. I have pay range data on a bar chart (actually a stock chart) So say the pay range starts at $5...

FortisDragon Try this: Dim appUserFile As New Excel.Application appUserFile.Workbooks.Open ("C:\YourExcelFilename") appUserFile.Visible = True Set appUserFile = Nothing HTH

PROBLEM SOLVED! It turns out that the CopyFromRecordset method will only work with an ADO recordset even though the help file includes DAO. In case anyone is interested here is a copy of the code that now works for me. The Access Cookbook was my major source of inspiration. I highly recommend...

Rob, Skip I bought a book called "Access Cookbook" chock full of sample code. It has a demonstration of a problem similar to mine here. I have to go to a meeting now for the rest of the day, but I'll start banging away again tomorrow. I'll let you know what happens if you're...

Skip, Thanks for your reply. Unfortunately I'm still getting Error '430' Class does not support Automation or does not support expected interface. I'm still not sure if I'm setting the range object correctly (How can I tell?, it doesn't give an error at that line.) But the error occurs on the...

Dear Forum members: I'm having some trouble with Access to Excel automation. This site has been extremely helpful. I've searched for many a solution on this site and found many answers. Now I need to ask a specific question. I'll be as brief and to the point as possible. Objective: Create a...

Mudstuffin, Much obliged! I look forward to seeing it. My e-mail is steve.haackABC123@target.com Take out the ABC123 and that is my e-mail address. Thanks again!