Search results for query: *

Just to give an update. We had already tried the Trust Center, and it did not resolve the problem. She is going to termporarily disable the User Access Control to see if that helps. I'll post the results as soon as I hear from her. Thank you for the suggestions.

I have an access program that I and others have been using for about two years. It has been run on Windows XP and Windows Server 2003 without any problems. One of the people that uses the program upgraded to Windows 7, and the program no longer will run. The program opens with a form. The user...

I am having a problem that is about to make me crazy!!!! We are using Crystal 10. I took an Aged Receivables report that shows the detail and changed some things. First, I did not want to see certain customers. So, I used the Select Expert to omit them. No problem. Next, I changed the...

Thank you Remou. This works great. It was not filtering the data when it got back to frmCustomerLookup, but I added a call to the filter sub. That took care of the problem. Thank you again!!!

This is the code that I have: Private Sub cboPartNumber_NotInList(NewData As String, Response As Integer) Dim Result Dim Msg As String Dim CR As String CR = Chr$(13) If NewData = "" Then Exit Sub Msg = "'" & NewData & "' is not a part in the database." & CR & CR Msg = Msg...

Thank you. That took care of the problem. I should have realized that I needed to create a button and disable the x since the form is later closed by the lookup form. One more problem if you don't mind. After frmXRef is closed (using the button) the cboPartNumber shows the value that was...

Remou, I tried the code you provided. I am getting the following error after closing frmXref: I click on debug and is highlited. Do you have any suggestions?

I have frmCustomerLookup with 2 combo boxes and a subform. One combo box allows the user to select a customer. The other combo box allows the user to select a part number. The subform then shows all invoice lines where the selected customer has bought the selected part. This all works fine...

Thanks. I used Duane's code and it worked great.

I have qryPointsByDivision. It shows: DivisionNum_fk, EntryNum_fk, SumofPoints I need EntryNum_fk, and SumofPoints for the 2 highest SumofPoints for each DivisionNum_fk. I put: In (Select Top 2 [SumofPoints] From qryPointsByDivision Order By [SumofPoints] Desc) in the criteria for...

Remou, Thank you. I used , and that worked perfectly.

AceMan, I was going on the theory that the user would click on the drop down menu and look for the horse in frmEntry. If the horse was not in the list, the user would click on the New button which would take them to frmHorse. Therefore, when the user clicked on the New button, there would be...

I have frmEntry with combo box Horse. I have a command button AddHorse that opens another form. When the horse is added in the other form and the close button is used, the user is back in frmEntry. However, I want the horse the user just added to be defaulted in the combo box. As it is, the...

Thanks MajP. I already had all the classes assigned to the horseshow. I was trying to create a form that would allow the user to assign ShowClassNum_fk in tblShowClassEntry. I need to create it based on the entry because the user will not have a list of classes with the entries in it...

Okay I have created the following tables: tblHorse [tab]HorseNum_pk [tab]HorseName tblPeople [tab]PeopleNum_pk [tab]PeopleName tblShow [tab]ShowNum_pk [tab]ShowName tblPlacement [tab]PlacementNum_pk [tab]PlacementNumerical [tab]PlacementName tblClasses [tab]ClassNum_pk [tab]ClassNumber...

MajP Thank you for all the thought and time you have put into this. I really like the last structure. I was able to follow the logic from the first time I looked at it. I am going to start making changes. Thanks again

Okay, I think I understand what you are saying. Currently, I have: tblEntry EntryNum_pk ShowNum_pk AssignedNum (This is the number that the entry will wear. The same rider may wear the same number at multiple shows. Or one rider may wear a number at one show and another may wear that number...

I thought this might help: This is the result of the query showing the entry detail.

I'm sorry I meant to include what I had put in the Results table: tblResults ResultsNum_pk ShowNumber_fk from tblShow ClassNumber_fk from tblClasses EntryNum_fk from tblEntryDetail (shows the classes that an individual entry has entered) PlacingNum_fk from tblPlacing I think we may have a...

maxhugen - You are correct. There could be multiple horses owned by the same person and/or ridden by the same rider. I am back asking for advice. I have created the Results table. I also went ahead and entered some test data directly into the tables. I also created 2 queries. One groups...