Search results for query: *

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

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

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

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

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

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

I am using Access 2000 and I have a tabbed form. On one tab I have a subform in datasheet view (The mainform is customers, the subform is invoices) When a user adds a record to the invoice subform I have code in the last control's exit event that performs some calculations on the main form. This...

I want to eliminate spaces in my data. For example, bbb01 should be 01. I wrote this simple routine but it doesn't seem to work as the spaces are not eliminated. ??? Sub ElimSpaces() Dim db As Database Dim rs As Recordset Dim strSQL As String Set db = CurrentDb strSQL = "SELECT DENCOV...