Search results for query: *

I'm having a heck of a time with error trapping. Here's my situation and what I've done: I have a numeric field. If the user enters a character in the field I try to trap it in the on exist event of the field as follows: Private Sub SortPriority_Exit(Cancel As Integer) On Error GoTo...

I'm having a heck of a time with error trapping. Here's my situation and what I've done: I have a numeric field. If the user enters a character in the field I try to trap it in the on exist event of the field as follows: Private Sub SortPriority_Exit(Cancel As Integer) On Error GoTo...

I'm having a heck of a time with error trapping. Here's my situation and what I've done: I have a numeric field. If the user enters a character in the field I try to trap it in the on exist event of the field as follows: Private Sub SortPriority_Exit(Cancel As Integer) On Error GoTo...

I have a form that allows a user to select a customer record they want to see the details for. They click on the record and then I have a pop up form that positions the customer table at the customer record they have requested. I'm having trouble getting to the specific record. I want the...

I would like to Open a Form to automatically go to open a new record so the user won't have to know to press the * at the record selector. I have a form (FORM1) where they either select a specific record to edit or they select add a new record. When they pick the add a new record function I...

Hi all! I have a data entry form where the user is adding names, addresses and some other info. If a user adds a last name and first name that already exists I send a message noting that it's a possible duplicate and ask if they want to continue. If they answer no then what I would like to do...

I've encountered a strange form/subform synchronization problem. Everything works great as I'm paging forward through my records as long as my mainform records have children records. Once I get to a record that has no children in the subform then I'm out of sync and I can't get back in sync...

I have a main form that has data about a parent. The associated subform has telephone number data related to that parent (home, business, fax etc.) The form is used to display and update already existing parents and telephones and also to add new parents and telephone numbers. There are three...

I am working with a user testing new releases and am new to packaging Access applications. My application is split into a back-end database where the table definitions and the data reside and the Access application where all of the forms, reports, etc. reside. When I package the application if...

I have a combo box with a list of telephone numbers. I am using the telephone mask as my input mask. I have AutoExpand set to yes. As soon as I enter the first number the rest of the field is filled in and my cursor is set to the end of the field. (So, for example, when I enter a 7 the first...

I have an unbound control on a continuous form. When I make an entry on one line in this unbound control on the continuous form, the other copies of this unbound control also reflect this one entry. Is there any way around that?

I have used the Packaging Wizard to create a package. I've included Access Runtime. The packaging process appears to work okay. I install the package on another machine where I do not have Access. The install seems to work fine. When I open the package I get the following error messages...

Here is my situation: I have a form with a subform (subform1 - a single form) with a subform embedded in it (subform2). Subform2 is a continuous form that contains informational data only that cannot be edited. Subforms2 can have an infinite number of records (but mostly likely 2) and you...

I have a data entry form for a table with a required field on each record. The required field is the last field in the data entry stream. When the user tabs through the field or enters I trap the error in the ON ERROR event of the form. I display a message noting the field is required and...

I am trying to generate mailing labels for our school PTO. I want to generate one mailing label per family to go to the classroom of the oldest child at the school or even the first child in the list for the family. I have two tables: Family Table that contains a family id and other info...