Search results

Where to put the code. Do I put that in the expression builder or in a module? Kinda new at this. Thanks for your help.

I have a query that I want to show only records that do not have a value in the DateClosed field. I'm not sure which expression I need to use. Any help is greatly appreciated.

Method Used I typed required in the tag property box and added the code to the before update property field. Then I removed my close button that I had created and added a save (refresh) button. So to leave the form they must click the save (resfresh) button, and then click the close button. If...

Finally got it. Thanks a lot! Thanks for all your help. I finally got it to work.

One step closer to working With the word Required typed into all the tag property fields on my form and the code pasted into the beforeupdate property field, it is now showing the "You must complete all fields" message. The only problem is that when you click OK, it closes the form instead of...

Still Having a Problem I'm probably not getting this right, I pasted the code into the BeforeUpdate event (as shown in attachment) and I am still able to close the form with missing fields. I also typed "Required" in the Tag property on the form fields. Still able to close with missing data...

Thanks for the help Thanks for the suggestions. I'll give them a try.

I have a form that I want to make all fields required so that the user cannot leave that form until all fields are filled out. I have the Required property in the table set to yes, and this works fine if I go to the form from the database window. However, If I go to the form from the main...

Thanks, I'll try that.

I have a database that tracks customer survey responses. All questions are rated on a 1 (worst) to 5 (best) scale. The problem that I have is that my report keeps the neutral (3) responses and uses them to perform it's calculations. For example: If I have 25 returned surveys each having...

Lot #41 Okay, here is the data from table "TipBreakage". Lot# DateReceived(Broken) Part#/Description(Finish) 016 1/1/2001 41-511 CPR-1, Bulk 015 8/19/2003 41-511 CPR-1, Bulk 015 8/19/2003 41-511 CPR-1, Bulk 015 8/19/2003 41-511 CPR-1, Bulk 015 8/19/2003 41-514 CPR-4D, Bulk 026...

Answer I attached a picture of my relationships. It should be easier for you to understand as well. I tried to make a junction table because that's what this Access Book I have said to do. I think I've got it messed up good. Thanks for all your help.

This is the table data. The relationship is "indeterminate" when joined by "lot#" field. Lot # is in the primary keys for both tables. Only the "QTY Received" field is pulled from tbl2. All others are from tbl1. As you can see it is repeated for each record. This data is actually only three...

Query Information The relationship shows up as "indeterminate". I can't get a one to one or ne to many. All the information is being duplicated. I really have 25 entrees for a specific lot # in tip breakage table, but 50 show up in my query. I only want the "Quantity Received Engraving" field...

I have two tables that I need to join in a query. The join I have now duplicates the info for lot #. The tables are as follows; TipBreakage - Lot#(Primary Key), DateReceived, Part# and Process Information - Lot #, TipBlank#, BulkPart # (Primary Keys), Quantity Received Engraving. All I want...

Disable Mouse Wheel In XP Worked Great Thanks alot!

I keep seeing people saying that in Access XP there is a way to turn off the mouse wheel. How is that done? I see the new option for "On Mouse Wheel", but what code or macro will disable it? Any help would be greatly appreciated.

In my forms I have dropdowns that when you use the mouse wheel to try and scroll down, it changes what record you are viewing. The "Cycle" propoerty worked for the "Tab" key, but what stops the mouse wheel from changing records.