Search results for query: *

Eric. Here is my coding, as per your suggestion: Private Sub ClearAllFields_Click() On Error GoTo Err_ClearAllFields_Click Dim ctrl As Control For Each ctrl In Me.Controls With ctrl Select Case .ControlType Case acComboBox...

Hey. I've got a form that has a number of fields with lookup menus that I want to limit the user from entering new test into. I can easily do this with the Limit to List option. But I also have a button that clears all the fields. If there is some text in the locked field (that isn't in the...

With a little cut-and-paste of code, I got my Save button to save and clear the fields for a new entry. Thanks for all the help.

Er, I mean... how do a clear the fields after the Save button is clicked. Is there an option in the creation process for clearing the fields?

Ah... I see dgwillia. I only had to change one option in properties, Data/Data Entry - "Yes", and that did the trick. Okay, so that's taken care of - thank you. How, now, do I add a button that allows the user to save the record they've just entered and then subsequently clear the...

Hymn: Your code didn't work for me. I guess I need to know, like dgwillia said above, what code to put in the "On Open" Event Procedure. So dgwillia, if you have some code I'd love to see it. Thanks for the quick responses. jgi.

I've got a Form that links with a Table that already has about 12,000 records in it. I am trying to use the Form simply as a pretty/user-friendly tool to make an addition to the Table and possibly to search for records. The Form itself is in Justified so that it only displays one record. When I...

Jeremy. In the beginning there will be about 2000 choices (different firms) and then the specific cities/offices of the firms (any where from one choice to 20) and some firms have numerous offices in the same city. It should actually be a rather large endeavor. But I'm well on my way. Thanks...

That seems to be working great, actually. Thank you. If I have any questions in the near future, I'll post them.

I've tried asking a few questions about this topic to no answer. I've fought my way through the problem, discovering things for myself (the best way, I suppose) but I am now stuck. Here is my problem. I have three fields in my Form: Firm, City, Address 1. The user chooses a Firm from a lookup...

Oh, and I would love to do this in a Table and not in a Form...

I am trying to create a database that links up a Firm Name, a Firm Office, and Firm Address. When the user chooses a Firm Name (let's say "Law Firm"), the table then formats the next field to the different offices the firm has (let's say "Chicago," "New York," and...

Here's what I'm trying to do... I'm trying to create a table in which one field, 'Company', has a relationship to another table/query that is a database for different companies and their addresses. I would like to set it up so when the user selects a company on the main table from the lookup...