Search results for query: *

Hey all, I have two tables. Customer: CustID CustName CustAddress etc... OwnerID Owner: OwnerID OwnerName OwnerPhone etc... On my main form I am trying to have a drop down box with the different owners to assign to a company. I would like them to search through the names, select one, and...

Never mind. Been wracking my brain for a while now and as soon as I post it I get an idea and it works !!! I created a table of all the custID and prodID's where those two numbers were not included. That gave me a list of all the companies that had other prodID's. Then I did a query on all...

In the table I need to be able to see all the companies with a productID of 121 or 133. Here is the kicker. They can only have those. If they have other ones then they would be excluded from this query. Table looks like this: CustID ProdID 143 121 143 156 143 452 144...

That seems to give me the results i needed. Thanks for the extra brainpower fred :)

Thanks for your efforts fred. The unmatched query was the first thing i tried. However it only allows you to select one matching field in the two tables. I need to find the records where the two fields are not in the tables. EX: table1 CompID ElementID 26035 01454 26035 01467...

Thanks that was the first thing i tried. However the unmatched query only allows you to select one matching field in the two tables. I need to find the records where the two fields are not in the tables. EX: table1 CompID ElementID 26035 01454 26035 01467 26035 01455 26071...

i accidentally posted this in the "Other Topics" forum. Sorry for the double posting. I have two fields in table1 called CompID and ElementID. I have the same to fields in another table (table2). How can I find out which records in table1 are not in table2. Both the compID and...

I have two fields in table1 called CompID and ElementID. I have the same to fields in another table (table2). How can I find out which records in table1 are not in table2. Both the compID and ElementID are the Primary Keys in each table. Sounds simple enough but for some stupid reason I...

Private Sub Command0_Click() MsgBox fDayofWeek(Text1.Value) End Sub Function fDayofWeek(myDate As Date) Select Case Format(myDate, "ddd") Case "Sun" fDayofWeek = "Sunday" Case "Mon" fDayofWeek = "Monday" Case...

Try "IsNull(fieldName.Value)"

I am using Access2k. Would like to disable the ALT+Enter (brings up the property sheet) combination during runtime. I tried using the AutoKeys macro to do this however it does not allow that combination. I looked through all the Access Options to see if i can disable it that way but I could...