Search results for query: *

Hi, Ok, this might be a stupid question but erm i have a subform that in it has a combobox which acts as my Product list. The problem is that whenever i select the products i want to use Access re-orders them and i need the products to stay in the order i selected them.. :( How can i prevent it...

*sigh* thanks davejam i didnt check that.... my boss actually made the db and i asked him if he had made the Data Type Number.. he said yes. Nevermind my bad i should have checked that lol

excellent that works but if i wanted to search for 50 boxes in one go or smt that method could be a bit tedious lol

Sigh... ok probably another really easy question to answer thatll make me look stupid, oh well here goes.. :) I have a query which searches through about 427895 records, there's a column called "Box Numbers" and when i enter: Between "321" And "324" In the criteria box the query search...

Thanks MajP ill give it a whirl today and hopefully itll work! This issue is really getting on my nerves now.

ok so far i have: Private Sub Pricelist_AfterUpdate() If Forms!mainform!SubForm.Form!Pricelist = "Air-Edel" Then Me.mainform.RecordSource = "PricelistAir" End Sub and it doesnt work i get: Compile error: Method or data member not found The .mainform is highlighted when i click on ok

no lol i wasnt being sarcastic im not like that, it's just that ive been trying to do this for nearly 2 weeks hehe.

it's that simple?!

ok maybe i didnt explain it properly.. I have a subform on which there is a combobox. In this combo box there are 12 options, each option has its own query. What i want is for each option to load the query that is related to that option (so there are 12 queries aswell). Im not sure how to do it...

Hi, I'm trying to change the control source of a subform by the selection of an option in a combobox. Ive created the qrys that i want to be my control source but I have no idea how to write the code for what i want.. :( Help! Cheers, marcfl.

Cheers for the help fneily I really appreciate it! I'm going to try to make those changes now will probably take me all day if not longer. :) Sorry i didnt reply sooner but I was off sick yesterday so I didnt get the chance.

Well that's not exactly how it works. Below is a link to the relationships of my db.. Bear in mind that this is the first one I've made so no laughing!! http://i379.photobucket.com/albums/oo238/marclf/dbRel.jpg Basically, we have many clients that purchase a varying number of products, some...

Hi Everybody! I've created a database for the company I work for and there's only one more thing left for me to do! (Which you can imagine I'm both happy and sad about.) I suppose the main problem I have is figuring out what the best way is to have a unique pricelist for some clients but not...

nice one AceMan1 worked perfectly! What would i do without you guys!

Private Sub JobLocation_AfterUpdate() Dim CBx As ComboBox, Prefix As String, Cri As String Dim NextNum As Long, DQ As String Set CBx = Me!JobLocation DQ = """" Prefix = Switch(CBx = "Gatwick", "GWO-", _ CBx = "Woking", "WWO-") Cri = "Left([JobNo],4) =...

haha ok yeah didnt work cause it's spelt woking not working :) however the jobno comes out without two 0's like this WWO-12 when it should be WWO-0012.

ok and when i try to use Woking i get an error message saying "Invalid use of Null" with this highlighted: Prefix = Switch(CBx = "Gatwick", "GWO-", _ CBx = "Working", "WWO-") the Gatwick part works fine tho :)

I tried your code AceMan1 and it gives the next record the right JobNo when i save it, but doesnt give the "current" record a JobNo the box just stays blank.

sorry i was away thursday and friday cause i had 2 seizures (ive got epilepsy) well i havent managed to make it work yet... but ill keep tryin today hopefully something will work! ill let you know what happens.

ah.... sorry i did look must have missed it :s Thanks