Search results for query: *

Yes, and I don't see what the problem is. I actually have spent a great deal of time trying to figure out what is wrong, but haven't been successful.

I have noticed that I now have a very strange problem with my junction table. Sarting with no records after implementing the code and running it I know have a junction table with over 100,000 records. There has to be something in the loop that is causing this. Do you see anything that would be...

Thanks, I will check the control sources. I also found that part of the problem was one of the six tabs on the form. When I deleted it, 6 of the 7 prompts for values disappeared.

I have a form that when I open it, a series of boxes pop up asking me to 'Enter Paramter Value'. The values that it asks for are: tblPayment.Payor tblProperty.PersonID tblproperty.AddressID tblProperty.OrganizationID tblProperty.PermitID tblPermit.StatusOfPermit The code for the form is...

Missinglinq, Thanks for the help. I will look at this. PS I am afraid to ask where you work if you have to stay up 72 hours.

I have a listbox that gets its values from a lookup table, tluPersonType. The list box is on a page for entering information on a person and is used to allow users to select the category(ies) for the person (e.g., salesman, manager, etc.) After a record has been successfully entered I can view...

I have a form that allows a user to enter information on a person. One of the pieces of information that is collected is the phone number of the person. It does this with 4 different text boxes: txtHome txtWork txtMobile txtFax The problem is that when there is no record for a person the...

Thanks!

I have a form that is related to two tables: tluPermitType PermitTypeID - PK PermitType tblPermit PermitID - PK JobID PropertyID PermitTypeID - FK Abstract Description For some reason typing in data in the form I receive the error: Can't find a record in tluPermitType w/key matching...

Thank you so much! That fixed it. This problem has been frustrating me for such a long time. It is such a relief to have it fixed!

Thanks for the help. However, when I click on the Subform and go to Border Style, my only available options are: None Thin Size Dialog There is no option for flat. Any idea on what I am doing wrong?

I have a main form with 4 different subforms on it. 3 of the 4 subforms blend perfectly with the main form where there is no trace of them being subforms in Form View and they can only be seen as subforms in Design View. However, one Subform in Form view does not blend. I have carefully...

Thanks again for your excellent help. Ok, I have it like this in the code: Private Sub Check0_AfterUpdate() If checked INSERT INTO tjxPersonPersonType VALUES (PersonTypeID,PersonID) Then EndIf End Sub Does that look about right? If I can figure out how to do one, I can get the delete...

Thanks for the help, I really appreciate it. So, I built the junction table and now have an unbound subform that has check boxes with all my person types. The only part I can't figure out is the after update event of each check box to append or remove the record. Do you have any idea how to...

Thank you for your reply. So, if I made a junction table this might be the way to solve it? tluPersonType PersonTypeID PersonType tblPerson PersonID PersonTypeID txj PersonPersonTypeID ? Can you give me any guidance on how to set this up properly? Thanks again for your help.

I have a form where information on a person is entered (e.g., first name, lastname, dob, etc.) I want to categorize the people by the type of person that they are on this form (e.g., employee, contractor, agent, salesman, etc.) There are around a dozen categories of people coming from a...

Thanks I will look at this.

The record source that you suggest, SELECT N.PersonID, N.PhoneNumberID, T.PhoneNumberTypeID, T.PhoneNumberType, N.PhoneNumber FROM tblPhoneNumber AS INNER JOIN tluPhoneNumberType AS T ON N.PhoneNumberTypeID = T.PhoneNumberTypeID ,I have a few questions about. What does the N and T mean...

Thank you for the help - I looked at the information, but I don't think it is quite what I need. It might be, but I don't think so. However, I want four different textboxes and not a single textbox. Basically, I want to set it up where the form looks like this: Home Number: Work Number...

I have a form with a subform on it. The form, frmPeople, has a subform for phone numbers. I want to set it up where the following phone numbers can be captured from textboxes without a combobox. txtHome txtWork txtMobile txtFax The database has three tables that may be relevent: tblPeople...