Search results for query: *

Thanks. Actually, my 5 year old is 25 years old and a first year law student. He is pretty smart........but he doesn't write code. If you were writing this at 7, I'd say you were a pretty bright child yourself. Keep up the good work, and thanks again for the help. Perry

Thanks, Eric. Hmmm, a 3? I was really expecting it to be a 1. I appreciate your feedback. Perry

We get supplier data dumps from our suppliers about twice a month as text files. Some of these dumps can have 50 to 80 fields in them, of which we use approximately 30 in a std. text format file. Rather than have people do the ugly cut-n-paste thing, I'd like to develop something that can read...

Let the jokes begin....seriously, a friend of mine called with this problem. She has run all kinds of anti spyware and has the normal virus protection stuff. Whenever she tries to run anything in her Office Professional series, her pc reboots. Any ideas? By the way, if this is the wrong...

This is about as bad as I thought. Thanks for everyone's input. I blame Bill for this problem......

Is there anyway to keep an Access 200x user from converting a Access 97 database to 200x (either deliberately or inadvertantly)when they open it? I looked in the FAQ but didn't find this. Thanks.

Yeah, I just caught that....how embarassing. Thanks for the help.

I'm having trouble with a TableDef....keeps throwing a runtime error 3265 when I try to add it to the collection. I'm recreating a table substituting more meaningful field names for the convenience of the QA group. Here's the failing code: Set db = CurrentDb Set rst =...

This works great on 2000, but now I need to migrate the db back to 97 and I keep getting the 2585 runtime error. Access 97 help files indicates the following:Syntax Private Sub Report_Page( ) Remarks You can't cancel the Page event. Naturally, time is short..... Any help greatly...

and give the user the option to cancel after they see the report may be 1300 pages long.

Using Access 2000.....never tried this and it seems information is limited. Thanks.

Unless I'm doing it wrong, that copies both the reference (001) and the url link....just a complete copy of the original cell. Thanks anyway.

I have an Excel 2K spreadsheet that has a value in a cell that is a hyperlink to a website...example: a1=001 and the link is to google.com. Can I copy just the url link to b2 without taking the visible value of the cell too, i.e. b2=http://www.google.com? Thanks.

People in my group aren't able to use the above functions. It's gotta be a reference thing. Does anyone know right off hand which references need to be set to make use of those two worksheet functions? Thanks, everyone. PerryG

Yup, I tried the blank db. I can't get in because the MSysDb object from the corrupted database has gone missing. I'm not real sure what that is, but it must be really important. Anyway, thanks again for everyone's help. Perry

I do have a backup from about 3 days prior (on my hard drive). This db was on the network.....the IT dept. might be able to recover the file from network backups, but it requires manager approval and a fee is assesed to our department. There were only a few files lost and all the source data...

Tried it, but it couldn't get in. Any other ideas? Appreciate the input.

I can't open my database....I keep getting the following message: The Microsoft Jet Engine couldn't find the 'MSysDb'.... Any ideas where I can find this or how to salvage my db? Any and all help greatly appreciated.

Thanks! Much clearer now. PerryG

coco86 - Thanks for the input, but for the moment, let's pretend I shouldn't know what you are referring to when you say 'textstream'. I am a little vague on the term and I want to be sure we are talking about the same thing. Can you give me an example how you declare it? I normally make use...