Search results

I'm trying to search for data in several different fields. Currently, I have like 12 queries setup to do this. Is there a way to have 1 query check all 12 fields? The data I'm searching for is the same. I need the record to show up if ANY of the fields contain the information.

I know this has to be easy, but I can't seem to figure it out. I need to be able to count how many records fall under each month historically for several years. I think that's clear, but just in case: March 2004 February 2004 January 2004 and so on... The date is formatted mm/dd/yyyy if...

Bumb to get some info. Thanks in advance. Alan

Automatically Sending A Report (1 record) as E-mail I searched and found this code which seems to work; however, I just need to show one record on the report. Below is the code that I found... Private Sub YourButton_Click() Dim EmailApp, NameSpace, EmailSend As Object...

Thanks a lot!

I need to make the query collect all of records dated one month previous from when the query will be run. For instance, sometime in February of 2004 the query will be run and return all of the records from January of 2004. I think this should be easy, but I can't get the syntax right. Thanks...

Should this issue influence my being able to create an MDE file on the front-end portion of the database? Also, I am already running SR-1, and because of attorney/client privilege issues, I shouldn't post the database. Worst case scenario, what will I have to do with this?

I deleted all the records except for 10 then tried to import the table into a blank database. It immediately gave me an INVALID ARGUMENT error. I get this same error if I try to CUT the record from table. It seems that this record is definitely causing this error. I wouldn't be worried about...

Okay. I downloaded the Jet Database Update. I opened the GIGANTIC 30,000+ record table with the corrupted record, and the corrupted record was all blank. I tried to Compact and Repair, but it did the exact same thing. Starts to Compact with the status bar at the bottom left. It gets through...

One of the users somehow corrupted a record. The record now has a bunch of boxes in place of the information. I tried to delete the record from the table but I get an error "The Search Key was not found in any record." When I tried to Compact & Repair, it would start the process in the bottom...

Is this Insane? (Too many queries within a query) We have a fairly complicated Access Database where I work. We have added new letters to a long merge document. It merges the addresses of insurance companies and doctors and the like. There is a Contacts table with all of this information...

No, there aren't spaces in the name. There is capitalization. MinorFirstName

We use an Access database to merge data into a document. I edited the existing query to add 3 new fields, but when I run the merge, Word says "The merge field is contained in the main document but not in the data source." It then gives me the option to substitute if for another field. What's...

Duh, that was easy! Thanks!

I need to find the HOURLY difference between two dates. One of the dates is automatically generated in the full format including time. The second date uses two fields and is manually entered: Sign Up Date, Sign Up Time. I want to be able to find the HOURLY difference between these two dates...

Thanks for the help! I figured that info regarding this topic would be available through searching, but I was unsure of what to call it.

In one of our forms for the firm, we would like to ask what telephone book they found our firm in. The person taking the information would select the book from a drop-down menu. The second question would be "On what page did you find our firm?" Could a second drop-down menu be formated to only...

Thanks! The "&&" solution worked just fine!

Our firm's name contains an Ampersand. The Ampersand is not appearing on the report. It is replaced by an underscore of some sort. What's going on here?

That worked! Thanks alot!