Search results
-
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... -
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... -
T
Lookup Fields
Ok...but when I add this combo it is blank for records that already exist? -
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? -
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... -
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. -
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... -
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... -
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 -
T
HTML body in e-mail sent from access
.HTMLBody = "<html><body><font face=calibri>Your Message Here</font></body></html>" -
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... -
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... -
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. -
T
Complicated Filtering
But surely the problem remains... some records have multiple locations and some dont. -
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... -
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... -
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... -
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... -
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...