Search results

I have made 3 subreports each of which displays one of 3 different sets of info based on where a record falls in a date category. Different people are assigned to these files. I made a query which creates a list of each of the assigned individuals. That query is the source query for the main...

Ok, I have a form where new clients are entered into the system. We would like to have an automated check that could be run which would check several different fields and compare them to several different existing fields in two different tables to see if the same name shows up. What is the...

I would like to be able to have a button that my firm's legal assistants can click which will automatically popup the folder on the server where the client's documents are stored. What is the easiest way to write this? Thanks.

www.accessfix.com I have a database file that will not compact and repair and it's getting quite large. I'm tempted to try this program, but I was wondering if any of you have had any previous experience with it.

Ok, here's the deal. I'm tired of fixing our gigantic table because of corrupt records in my firm's database. I find that the problem ordinarily comes up when someone opens the same record in two different forms (whether on the same computer or on a different machine) and both attempt to make...

I have a Macro that is doing the "Open Report" action. Each of these reports shares the same date as a criteria (I used [Enter Date]). It prompts the user three times. How can I just prompt the user once (same date for all three reports).

In trying to make a certain job more simple, I need to be able to allow a user to click on a shortcut to a query and then enter several parameters. Two of them will be Start Date and End Date. I understand how to do that portion; however, the users must also be able to type in multiple page...

For some reason, I just can't figure out how to do this. I have a form that has Client info fields. I want to make a box at the top of the form that the user can type in the [ID] of the record and retrieve the record by hitting enter. For example: Click in blank box, type "47545", hit enter...

:confused: I have been messing with this far too long, and I am just having a mental block. I am working on a referral database that would track referrals that I would send to doctors and other lawyers. I currently have 2 tables. 1. Client (ClientID, FirstName, LastName, FromID, To1ID...

I have a report which shows a count calls from each city for 12 months backwards. I would like to create column headings which report the month and year of the cities beneath. For instance, the first column would be for May 04 then April 04 and so on. Can I format Today(m-1) displayed as mmmm...

Two queries I use are part of a monthly report that prints out automatically with a macro. Unfortunately, the query does not save the Page Setup information, and the information will not fit on one page. Is there a way to tell Access to either: Keep/Store the Page Setup info such as Landscape...

I am doing this query at work which tracks referrals sent out of our office. I have 7 queries that first isolate the month(s) of data (six months individually back, and one six-month total). I then have 7 other queries which isolate two fields in order to count the number of referrals to each...

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...

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...

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...

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...

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...

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...