Search results

Thanks!!! It works perfectly now.....thanks a million! :D

Code Problem Error message: 2465 Microsoft Acess can't find the field 'l' referred to in you expression Here's the code.....what's wrong with it? Private Sub Contact_main__Click() On Error GoTo Err_Contact_Main_Click Me.[TextBox_Primary Contact].SetFocus DoCmd.RunCommand acCmdFind...

I created a Find Record Button on a form using the wizard. I would like to change the vb code so that the button searches for the same type of record each time. For example - I want to search in the "Primary Contact" field every time I push the button, without having to place the cursor in...

thanks thank you much.......everything is cool now!

Hey All, I have a problem with every other page in my report being blank. How do I fix it? As always, your help is greatly appreciated :D

Is there a way to tie two separate databases together. Here's the scenario: I work for an organization that houses 4 different programs. Each program has it's own database. Is there a way to have one database that is automatically updated when information is placed into the other 4 or should I...

Nevermind I figured it out!

Good Morning All, I have a report based on a query. Upon opening the report a box appears and asks the user to "Enter Landlord Name". I would like the name entered in this box to be automatically placed in the report footer in the following format: Total Donations by "Landlord Name" As...

thanks! It worked! Thanks

Let me clarify the question OK, so I wasn't very clear and that's my fault Let's say there are 50 families stored on my database and I want to track the activities of the "Williams". I want the report to ask the user to "Enter Family Name" when the report is opened. After the user enters a...

I want to create a report that filters by "Name". Can you help me with the event procedure that asks the user to "Enter Name" when the user tries to open the report. I think I'm close but I just can't get over the proverbial "hump". All help is greatly appreciated! txdon32

Big Help First of all, thank you for your input and I do see what you have done. Here's another question: Creating a search in those formats would still require me to assign differnet ID numbers to similar products located in different places ie. ID Item Location...

I have created an invetory database for the organization I work for. One of the fields is called "Location". I want to query the "Location" field to see the equipment located in each area. Simple enough, right? Here's the problem: some of the items are located in multiple places and it is...

I have 4 forms created in my database. I would like my main form to automatically update when information is placed in the other forms (no, they are not subforms). Is there a way to make this happen? Keep in mind, I am a self taught novice, so be gentle. txdon32

It's Posted Now OK, so I really didn't understand how to solve the problem, even with all of your help. So I've posted a small portion of the database and hopefully this will help. Tinker with it as much as you want to, just let me know how you did it. Or you can just give me advice. I'll take...

it didn't work for me I tried that code and got an error that said "Invalid outside procedure" and it highlights the name of the report. Any sugguestions for corrections?

Sorry...the file is too big to send. If you have any idea what I'm talking about, your assistance would be appreciated anyway. txdon32

OK, here's the database...... Be gentle.....Keep in mind, I'm a self-taught rookie. If you look at the bottom of very last page of each report, you will notice a number labeled "Total Value". I would like to place the "Total Value" of each individual report onto 1 single report. It...

I am very much an Access rookie and I am having a problem that I just can't solve. I have three reports, each with a total in the report footer. I would like to place all of the totals on 1 report. I checked out a posting that had the same problem and the suggestion was to refer to all of...