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

Ok, I just replaced the file path with the name of the text box and it works.

http://cuinl.tripod.com/Tips/win5.htm I found that. It launches the window. Now, I want to be able to reference a field and launch the path based on the contents of the field.

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.

I've tried everything else possible to compact and repair. I can't even import everything into a blank database.

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

How do I format the crosstab query to sort by Month AND Year. Using the wizard it gives me options by month and quarter and so on, but I can't seem to make it split them up by Month AND Year. May 04 April 04 March 04 and so on...

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

I would use a report, but I like the column setup with a query. If there is a report that will display this in the same way, I would love to know about it.

Okay, I just figured it out. I used the SendKeys Action in my macro, and after a few tries, I figured out the string to change all margins to .5 and the layout to Landscape. SendKeys %"F""U"{TAB}{BS}.5{TAB}{BS}.5{TAB}{BS}.5{TAB}{BS}.5{TAB}{TAB}{TAB}{TAB}{RIGHT}{TAB}{RIGHT}{TAB}{TAB}{TAB}{TAB}~

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

Okay. I did a search and found my answer. I guess I do have to enter the [Enter Criteria] in every field's criteria, but I had to go into SQL view and change the AND to OR. I'm proud of myself. My first time use SQL! :D I just went back into the Access Query view and saw that I had to put...

I tried that and it didn't work. Maybe I'm doing it wrong, but a made a new query. Added all the fields (biid, umid, bi2id, um2id, resid, pipid) Typed [Type Criteria] in the Criteria box for each field. Ran on an id (i.e. 8657) and I returned no records because I think that would make it find...