If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#21
|
|||
|
|||
Help with Query!
that is a very tough one. hahaha
ROTFL.... |
#22
|
|||
|
|||
Help with Query!
Arthur its working good but now I have a drop down list that shows me all my
horses in active Mode so now when they leave qryOrderByHorseName and go into tblInvoice_ItMdt I lose them off this dropdown list untill they appear again in qryOrderByHorseName. Its a Combo box using the same Query, How can I get around this....I am very much appreciated for you help on this........regards Bob wrote in message oups.com... that is a very tough one. hahaha ROTFL.... |
#23
|
|||
|
|||
Help with Query!
This is the code in My ComboBox drop down list maybe something added to it:
To show Horses that are in tblInvoice_ItMdt as well SELECT tblHorseInfo.HorseID, funGetHorse(0,tblHorseInfo.HorseID,false) AS Name, [StableReturnDate] FROM tblHorseInfo WHERE Status LIKE 'Active*' AND tblHorseInfo.HorseID NOT IN (SELECT HorseID FROM TblInvoice_ItMdt) ORDER BY funGetHorse(0,tblHorseInfo.HorseID,true), funGetHorse(0,tblHorseInfo.HorseID,false); Thanks Bob |
#24
|
|||
|
|||
Help with Query!
you can use requery but you have to do it in VBA,
like this. Me.Combo0.Requery |
#25
|
|||
|
|||
Help with Query!
YEAH I did it , I made a new Query Name using your code an assigned it to
that List Box , Brilliant Thanx |
#26
|
|||
|
|||
Help with Query!
good job
Bye my friend, its already late in the evening here. I have to go home. Arthur |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Toolbars, Drop-Down Menus | Rick | New Users | 1 | September 21st, 2005 11:17 AM |
SQL query showing diff between actual and budget | Bon | Running & Setting Up Queries | 3 | August 25th, 2005 12:07 PM |
Nested in-line Query | laura | Running & Setting Up Queries | 0 | February 11th, 2005 12:17 AM |
Big number gives error! | Sara Mellen | Running & Setting Up Queries | 8 | October 11th, 2004 02:48 AM |
Too Few Parameters error Mail Merge Access Parameter Query | Tony_VBACoder | Mailmerge | 3 | September 14th, 2004 12:15 PM |