Recent content by puffer317

Hello all, I created my first vb.net program which is a search and display form for an access database. I had the database right in my project folder while I was creating it. Now I would like to Move the database to the server and put a password on it. For the life of me I cannot seem to...

No luck. Thx though.

Hello, I have a spreadsheet which calculates a few simple numbers. I then use the code below to send those numbers to a preformatted word document. If I send $6.00 from the spreadsheet, it shows in word as 6. If I send .00235 from the spreadsheet, it shwos as .0024 in word. How do I keep...

Thanks again Pete, I just had to change the field to number instead of text and it seems to be working well.

Thx for the help. I think you've put me on the right track. I'll have to check back in the morning.

Now it's error 3070 - jet engine does not recognize 'QU0003' as a valid field name or expression.

Very close Thanks for the responses. That's exactly what I'm trying to do Pete, but when I put it in I get runtime error 3251 - "Operation not supported for this type of object." I've tried it with rs.findnext, and rs.seek as well. I get the error on this statement, rs.FindFirst...

I have an excel sheet with 4 pieces of data I would like to send to an access database. The fields in the database are: quoteNumber (which is the primary key) quoteDate quoteCustomer quoteProfile I fill in the spreadsheet then press a command button with the following code: Dim db As...

Thanks, I almost logged off, but you're right. There's always some bad milk somewhere. As long as i've got you here, do you know of a site like this that has more to do with excel/access integration? Or maybe a book?

Sorry. I didn't realize it was from many days ago. I'm new at all this. I've been to a bunch of forums for information recently and keep seeing headings like that so I finally said something back. Too little too late I guess.

The beginning of this thread was about this stuff. Sorry to get worked up, but I've come here a few times for work and have run into bash America day.

Everyone attacks the leader I'm always intrigued by the double standard. When we intervene in one country (Iraq) we're at fault because "we want to take over the world." When we don't intervene in another country (Zimbabwe) we're at fault for what happens there too. Any other country in...

Sweet Sweeeeet. Thx again for the help. Took me a while to figure out how to get the value out of the loop before it got cleared. Works like a charm. strFile = Dir(strPath) Do While strFile <> "" If strFile <> "" Then strSuffix = strFile End...

description Thanks for the response. Sorry I didn't make myself clear. I have a folder with document revisions in it. So it might have 100A, 100B, 100C, and so on. I'm trying to choose the file with the highest letter at the end (100C) because that will be the latest revision. Right now I...

Hello, I have a form with a command button to view a file based on the selected record. The folder has several revved files. For example: 100 100a 200 200a 200b I would like to open the highest suffix. (100a and 200b). If anyone could tell me what function I should be trying to use I'd be...