Search results

It may have to do with the name of the form. I'm piggy backing on someone else's db and they're using a naming convention I don't agree with, but went along with for the sake of consistancy. They named the forms with spaces in between the words. When compiling, the error pops up and the...

Yep. In fact I copied and pasted your code in and then pasted in the names of the form and field.

Thanks for your reponse. I'm getting a "compile error: Expected:=" Any suggestions on what I can change?

This should be simple, but I can't figure this out and my searches don't come up with anything similar. I'd like to place a command button on a form that filters for records in which a field is not null. I know I can go to filter by form and enter Like "*". But the users are nurses with...

Thanks, Shane. placing it on the on_enter of the lookup field locked up my field and I couldn't drop the list down. I placed it on the on_exit of the form B command button (since it defaults to that button when you close the form). Works great now. Thanks again.

Yes, it's a combo box. Let me try the requery. I'm going to try in on the on_enter event of the lookup field. Thanks. [This message has been edited by StephenB (edited 05-30-2002).]

How about "DoCmd.Restore" on the on_open event of the form?

I have form A that has lookup field [Member]. If the member is not on the lookup list, the user will click on a command button that opens form B in which new members are entered. The member is entered and the form is closed focusing once again on form A. My problem: Once form B is closed and...

Thanks, sometimes I feel as thought I work on these dbs so much that I get delirious and start to imagine things. I appreciate the response.

Thanks again, Fizzio, that worked great. It even took care of the black font. Any comment on why the font turned black in the first place? Stephen [This message has been edited by StephenB (edited 05-22-2002).]

I have table [Members] with four field for member's last name, first name, middle initial and ID number. The primary key is [MemID]. I use form A to enter members into the [Members] table. I also have Table [Case] which has field [MemID] looking in the [Members] table to pull members from. I...

Please confirm something that I think I just realized: Am I correct in understanding that I can join two table in a query only and the join not exist anywhere outside the query? It appears to me to be the case, but I'm concerned that I'm missing something of importance. Please comment on if...

Yep, that worked. Thanks Elana. Stephen

The On_Current worked, but placing it on the control source of the unbound age field gave me the "#Name?" error. Thank you both for taking the time to respond. Stephen

I have a form with two fields: [DOB] (for date of birth) and [Age] (which is unbound). I'm using the following to calculate age: [Age] = DateDiff("yyyy", [DOB], Date) + (Date < DateSerial(Year(Date), Month([DOB]), Day([DOB]))) My question is this: What's the best place to place this? If I...

Thank you much, works great. Stephen

Thanks, Pat, (Again). I had tried **many** of the recommendations that they suggested. Nothing was working. Turns out I had a format on the age field. Duh. Glad your here. Stephen

I have a form with field [Comments] and a command button that opens a form with unbound field [EnterComments]. This command button is set to open to the same record on the original form (I chose this setting in the wizard). The second form has command button [close form]in addition to the...

Thank you Pat.

I have the following on a form: Private Sub DOB_Exit(Cancel As Integer) [Age] = ((Date) - [DOB]) End Sub DOB (date of birht) is a field on a table. Age is an unbound field. This correctly returns the age when I enter a DOB that should return 99 years old or less. But when I enter a DOB...