Recent content by rabamas

Greg, That sounds like EXACTLY what I need. I would love to set-up something like that on my database. Could you help me? Let me know how to contact you! Thanks in advance, rabamas

What do you mean, "put this code behind your form..."? I don't understand that statement. Where would I enter this code? Also, how does this associate a Payment Number with an Inquiry? All this seems to do is to update Assigned field of the first available Payment Number to Yes. rabamas

HELP! I have a form that I use to gather information from customers who call to inquire about our service. It writes to a table called "Inquiries", and collects the customer's name, address, contact, etc. I have another table called "PaymentNmbrs", which stores numbers that have been...

awesome. this forum is going to totally open doors for me. i only wish i had found it 3 years ago! looks like i need to explore and learn how to use this "archive" thing. i'll try to look there 1st before i post in the future. rabamas

Thanks everybody. This has all been very helpful. I did not know of the existence of the TransferText method, and I have been practicing with it all day now. Looks like it will solve most of my problem. New Problem: TransferText method wants to know the filename up front, but there are actually...

is this all in VBA? I've never used VBA, but I have a book on it that I've been meaning to read. Is this the language I would use to write all this, including the part that checks to see if a file is present, as well as the part that executes the "transfertext" method? Do you think a quick...

I use Access97 presently for my business' database system. Everyday, I download datafiles from a business partner's FTP site that need to be imported into a table in my mdb file. So, every day, I go through this laborious routine of going to the file menu, choosing import external data...

Hello! I just joined the forum, and I hope I can contribute as much as I can - I'm no pro but maybe I can help total newbies! I'm just stoked to have discovered this place, as I have often wished for such a forum when I have run into programming walls in the past. The only thing I've known to...