Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by marcfl

  1. marcfl

    Combo Boxes and subforms...

    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...
  2. marcfl

    Searching records in Queries

    *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
  3. marcfl

    Searching records in Queries

    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
  4. marcfl

    Searching records in Queries

    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...
  5. marcfl

    Changing the Control Source of a subform

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

    Changing the Control Source of a subform

    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
  7. marcfl

    Changing the Control Source of a subform

    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.
  8. marcfl

    Changing the Control Source of a subform

    it's that simple?!
  9. marcfl

    Changing the Control Source of a subform

    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...
  10. marcfl

    Changing the Control Source of a subform

    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.
  11. marcfl

    The ideal way to have a pricelist for separate clients.

    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.
  12. marcfl

    The ideal way to have a pricelist for separate clients.

    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...
  13. marcfl

    The ideal way to have a pricelist for separate clients.

    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...
  14. marcfl

    Code to increase a field value by 1

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

    Code to increase a field value by 1

    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) =...
See more

Part and Inventory Search

Back
Top