Search results

Aha! I was about to come back and tell you of my failures. I put in your original code, and got an overflow error. I will implement your new code tonight, and see how my poor 1.6GHZ computer handles. It should be quite entertaining. I don't know why, but I get pleasure out of making my...

Great! I think this will work. I began the process, and it seemed to be working, but I had to cut it short. It was taking forever. I have to run this on about 25 files, and each are 2-5 MB large, so I think I'll set them up to run this evening, and through the night. Thanks! I'll let you...

It's funny: I thought, since you all answer my questions so often, I'd "give back to the community" by answering a few questions from others. So, when I clicked on sbayeta's "First Access App. Need Advice" (http://www.access-programmers.co.uk/forums/showthread.php?t=69171), I thought I was...

It's always the stupid one... Sorry for being an airhead, but I cannot get Pat's code to work. It's probably because I have no formal training....It's very much because of that. I attached a sample database, with a single table and the module in question. Can anyone help a babbling buffoon?

An extended response... Even my slimmed-down version exceeds 100KB, the current limit for .zip files. The 1.4MB file is currently located on a geocities site…Sorry everyone, if bandwidth gets in your way. Feel free to email me at: mtairhead@yahoo.com if you need a copy. (It’s just my...

Probably because I don't know how… This is the first VB script I've ever really designed, and it's mostly converted Macros. The entire VB script plays out as follows: (1) Opens a form with two fields: ID and Field1. ID is an auto-number, and Field1 are all various words. There are some 20K...

How do I make a module repeat? Currently, I have a command, which runs the module again. Example: " Call Generate_Reports_Based_on_Form2" This code is actually in the module "Generate Reports Based on Form2" Obviously, this only works from about 7,000 records, and then my computer "Runs out of...

Thanks, I'll set up these queries today and see how it works. Thank you all! This forum is the BEST place in the world. Andrew

I'm having a problem with one of my queries...And I think it's more of a logistics problem than an I-don't-know-what-I'm-talking-about problem. I have a table with around 20,000 records. It's complicated to get into, but the entire table only has one field, and each record only contains one...

I know that this has been discussed so many times within this forum, but I don't seem to like any of the answers given.... I have a report, which contains several hyperlinks to various web pages. (Depending on the record's purpose) When I export the report to HTML, why don't the links work...

I knew it was probably something as simple as that! Thank you, it works!

I set a query to look for data in (Let’s call it) “field1” with the expression =“Cat” That means that the query returns only the records that contain only the word “Cat” within field1. This I know…. I also know that if I change the expression to Like “*Cat*” it will return all records that...

I posted this awhile ago, and just recently tried to fix it using the advice someone gave me…And it still doesn’t work. Perhaps I’m doing something wrong? I have a form (Let's say it's called "Data Entry Form"). I also have a report formatted for that form. (Let's say it's called "Data Entry...

Re It works great – Thanks! I ended up going with the Union Query. It took a little extra work, but at least now I know what people are talking about when they say SQL… I hadn’t used it at all. I cannot combine the tables because it defeats the purpose of the system. What I didn’t report was...

I have 12 Access tables– One for each month of the year. They are named as such. (January, February, etc) In these tables are Accounting Journal Entries, which aren’t very confusing. Just imagine that each table has column labels as follows: Account Number Program Project Class Credit...

I've seen this question before on this forum, but I don't understand the answer.... Can I user the "Where Condition" in the "Open Report" command (Both found when creating a macro in design view...) to have the current record that is currently being viewed on a form to be the only record...

I've searched the database, and found several similar questions, but none seem to be simple enough for me to do... That's a great way to start out, isn't? I have a form (Let's say it's called "Data Entry Form"). I also have a report formatted for that form. (Let's say it's called "Data Entry...