Search results

  1. T

    Subform

    I have a subform that is invisible until I click a button which has the following code : Forms!FrmPassLocation!FrmVenue.Visible = True However, I ALSO want this subform to appear containing just the records that have matching references. I know how to do this if I am just opening a form, but...
  2. T

    Lookup Fields

    Ah...now that's weird. The IDS stored in TblCustomer are different when I use the new Combo box. For example... Bournemouth is now 44 (which is right based on TblLocations) for a test entry made with the new combo but 2 for an entry made yesterday. However, if I look at a copy of the database...
  3. T

    Lookup Fields

    Ok...but when I add this combo it is blank for records that already exist?
  4. T

    Lookup Fields

    Ok...but if I want to display the location it's no longer in the combo because the combo is unbound, so do I need to have the field and the combo on the form?
  5. T

    Lookup Fields

    I think I'm getting it... So.. I have TblLocations & TblCustomers I remove the lookup from TableCustomers What should I do next, do I remove the relationship that exists already between TblLocations & TblCustomers? On the form do I create a new unbound combo and get it to look up data from...
  6. T

    Lookup Fields

    Yeah...got that bit. My issue was then having 1000's of records with numbers in rather than words. So there was a combo box on the table that has Bournemouth (yes, I'm from there too!) which gets changed to 12 whne I convert the combo to a text box.
  7. T

    Lookup Fields

    MANY years ago my first ever job was trainee Access DB developer. Back then I was taught to use lookup fields in tables. Today I know this is baaaad. Is there an easy way to remove look up fileds from tables, fix the forms and update the data? Is there a bset practice for putting this right...
  8. T

    Help, Please !!!!

    Number 4 I'm guessing you want a field to store the date the request was submitted? If that is the case you need a field in your table that has the date added to it when someone submits the form. So click button which submits a form AND enters the date in a field? It's easy, but it uses...
  9. T

    HTML body in e-mail sent from access

    I'm really no expert take a look at this thread.. seems promising! http://www.access-programmers.co.uk/forums/showthread.php?t=229533&highlight=email+template
  10. T

    Complicated Filtering

    All sorted, thank you!
  11. T

    HTML body in e-mail sent from access

    .HTMLBody = "<html><body><font face=calibri>Your Message Here</font></body></html>"
  12. T

    Complicated Filtering

    I've got this working, thanks! Just wondering how I would adjust your code so that I can add another parameter. If Me.NewcastleTick Then strWhere = "[NewCastleTick] = True OR " End If I would like it to ALWAYS have this tacked on as well AND ((Suppllier.Reference)=1)) I'll have a play...
  13. T

    Complicated Filtering

    Ok...I get the theory. My one issue is this Database has kinda grown over time since 2005. I've been asked to make it do something specific and I have just somehow found a way. I'm aware the original table design is poor and the front end actually pulls in tables from 2 backends. It's nasty...
  14. T

    Complicated Filtering

    Well..as it happens I do have the first 2 tables. I've just never come across the idea behind third table and would have no idea how to use it to hold and display the information I want it to.
  15. T

    Complicated Filtering

    But surely the problem remains... some records have multiple locations and some dont.
  16. T

    Complicated Filtering

    I'm not sure how I would have done this differently. I need a way for the user to instantly see what locations a supplier services but equally I need to do things with this data. I can't use the address of the supplier as it often has no bearing on the locations they service. Maybe I'm being...
  17. T

    Complicated Filtering

    The more I look at this the more I think I just need a way to change the where clause using VBA. Current SQL SELECT Suppllier.SupName, Suppllier.Address1, Suppllier.Address2, Suppllier.Address3, Suppllier.Address4, Suppllier.County, Suppllier.Postcode, Suppllier.Tel, Suppllier.Fax...
  18. T

    Complicated Filtering

    I can filter the combo manually to show the information I want for this specific example... all hotels in newcasltle (data set is simplified) where the NewcastleTick box is yes. What I need it the Query to tie in with the relevant tick box on the hotel form. The Query would have all 36 fields...
  19. T

    Complicated Filtering

    SELECT Suppllier.SupName, Suppllier.Address1, Suppllier.Address2, Suppllier.Address3, Suppllier.Address4, Suppllier.County, Suppllier.Postcode, Suppllier.Tel, Suppllier.Fax, Suppllier.Email, Suppllier.Website, Suppllier.NewcastleTick, Suppllier.Reference FROM Suppllier WHERE...
  20. T

    Complicated Filtering

    Sorry... I have a supplier table. There are 1000's of entries in this. We work in 36 locations but a supplier is only relevant to 36 locations and this can be different from their actual address. I had to find a way of showing which locations a supplier is relevant to, hence the tickboxes...
Back
Top Bottom