Recent content by BRP250

I'm buying a 1TB hard drive to use to store media and backups. My question is which is going to be faster internal or external drives? I'm at work so I don't have any detailed specs. The motherboard is about 7 months old a Gigabyte with 2 seagate 160mb Raid 0 sata drives. Checking inside the...

One step at a time. I've cut out some of the manual work. I'm jumping to the 'design new system' stage and trying to get the excel data into a sql db, updating from other sources and creating a crosstab sql view to read and graph/report in excel. I see a lot of little gotchas on the way. This's...

ok here's the story: The user has a spreadsheet (4 actually) that he's been using for years, it has data from 1995. He has every day in column A i.e. in date format and then about 20 columns of readings he's been receiving on hardcopy from other programs for that long. Not every day has readings...

Geoff, I'm using the get external data query engine to access the data. At the moment I have to copy and paste to transpose the data as I do it. If I can get that going satisfactorily I'll work on manipulating the data in the sql DB before it gets to excel. Ideally excel would format etc. when...

Sorry they are text and that is something I have to fix as some of the numbers include text. I've upgraded to 2003. If I use the convert to number option when pasting I've discovered, the numbers are recognised. It would be good if I could format the data columns on import. Thanks, Bruce

Using MS Excel 2k. I have a data link to an sql DB on one sheet and when I copy and paste the data to another sheet to be read by a graph the data is not recognised by the graph. It all looks good, the cells have the correct values. If I type the numbers in the graph works fine. Anybody any...

Damn that's good, why didn't I think of that? I guess I'll just have to settle for 2 buttons, print and print preview.

I'm using access 2000. I call the report from a form to preview. If the report is printed I need to run a query to update some records. Any help would be appreciated... even a NO to put me out of my misery. Bruce

I need to fill parameters etc. so I do need one of the other methods. I'm just testing them now. From what I can see it is different to VB. Thanks again, much appreciated. Bruce

Great thanks, it works. I thought Access would be better than that. Bruce

Hi Can anybody supply vba code to open a crystal report from MSAccess 2000? I've done this in vb6, is it the same? Many thanks, Bruce

Tom Thanks, that gives me avenue to check. Bruce

Tom 1. There's no subreport 2. There is a form that opens the report but at the moment I'm not using it. I have bound the report to a query for report header information. This has controls etc. I open a crosstab query to to get the data to print the information. I'm now experimenting...

Using Access 2000. In my report in the onpage procedure I have written code to print directly to the page i.e. me.currentx = ... me.currenty = ... me.print recordset.field().value 'draw a box around it 'get the next record This is fine to view in print preview looks great but not printing to...

A bit hard to explain, I didn't do to good a job. But I've improvised and repeated the values through code. Still having problems though. Running off the page is to wide for the current landscape paper width (sorry), and the report is bound to a query, the 3 controls are bound to this query...