Search results

This is probably simple, but then, so am I. Need to compare 2 fields in a query, and return the larger of the 2 values in a 3rd field. As in: Field A=10 Field B=6 I need Field C to = 10. Field A=5 Field B=6 I need Field C to = 6. Any suggestions? Thanks, BeckieO

EternalMyrtle, you nailed it for me. Turns out the control name had a typo, so ...strength turned into ...strenght. Thanks for pointing me in the right direction, I don't think I'd have ever found it. And also, thanks for the other tips. I certainly learned a couple of things today.

I have a data entry form for test results. The tests have some common fields, but also some unique fields. I'm trying to have the unique fields visible/invisible, based on the type of test selected in the Test field. I have the following code in the AfterUpdate event of the TEST field. Private...

I'm trying to avoid having a bunch of incomplete or bogus records created. Also trying to slow them down before they change an existing record. The forms all open to a new record and without this code, anything they put in any of the fields will cause a new record to save. Can't require all...

I found some code on here that requires user verification before creating new records in a form. I placed this in the BeforeUpdate event. Private Sub Form_BeforeUpdate(Cancel As Integer) If Not (Me.NewRecord) Then If MsgBox("Would You Like To Save The Changes To This Record?", vbQuestion +...

Problem solved--issue was the Master/Child tie. As usual, it's the simple things that hang me up. Thanks anyway.

The tables I mentioned are just 2 of many. For example: Product Number (Primary Table--A unique product that we will be testing. Nothing happens without a record in this table) Sample (Secondary Table--we will take multiple pieces of a product and run different tests on it.) Equipment...

I'm building a new db for tracking tests/results, using Access 2007.:) On this issue, I'm working with 2 tables, Sample and Equipment. On a form to enter sample info, I have a combo box to select a piece of equipment. When the equipment is selected, I need to have a sub-form populate with...

Cool Beans!! Thanks so much.

In a report, I have a textbox to show the number of employees in the report. I use this formula : =Count([last name]) Sometimes the same person has multiple entries, so the count is wrong. How can I show only the number of different employees and ignore the duplicate names? Thanks

Well, poooooo. Sorry to take up your time. While I was reading my previous response, I realized that the Event Procedure was inserted by the wizard so, Delete the Event Procedure from ON CLICK and replace with a macro to close form. Works like a charm. Thanks again, BeckieO

I'm thinking it's because my form is unbound. The same button on bound forms works just fine.

I open the form. Doesn't seem to matter whether or not I put the cursor in one of the date fields. If I try to close it with the button, I get the error. I've also tried to remove the If Me. Dirty...code. That just stops the button from working.

pr2-eugin, I put the button on the form, using the command button wizard, the way I've done countless times before. I've found that when using the "X" to close, some folks are prone to hit the wrong "X" and accidently close the whole database, instead of the form, so I try to put a Close button...

Morning, all. In a single user db, I've created an unbound form with Start and End date fields and several buttons to open reports. My intention was to let my co-worker open the form, enter the Start and End dates once, then open several different reports, all using the same date range...

Thanks so much--I'll get right on it and let you know how it goes.

I've done some searching and came close, but can't figure out how to query this. Large db with multiple tables, but simplified: WrkdHrs table, holds individuals weekly hrs, etc with "PeriodEnd" date field. Raise table, holds pay rate for individuals, with "Effective" date field. I need to pull...

Just upgraded my system to Office 2007, as part of an ongoing upgrade for everybody. Until everyone has been upgraded, we'll have some using A2007 and some sill with A2003. Have a db (A2000 format) that I can't open using A2007. I get "An error occurred while loading Form_Transactions_Form. Do...

Thanks so much, Uncle Gizmo. I've spent so much brain power on getting the 7 different criteria (along with possible null values) to work, that I just couldn't see how to solve this. Your response got me back looking at how the form/sub form/query were actually setup. While I was working with...

Hey, all. I've done a load of searching and with the help of a slew of posts on this forum and others, was able to construct a flexible search form to run a query with up to 7 criteria selected from individual combo boxes. The query is run from a button on the main form. Criteria in the query...