Recent content by HowardB

Actually Nigel its worse than you think :) In the VBA code using this syntax LIKE '*" & sNewStub & "*' as you suggested makes the query work within the combobox routine If I translate that syntax approach to my standalone Access query which works but uses LIKE "*" & sNewStub & "*" It...

jd thanks for your help and suggestion of an alternative approach but my gold star goes to nanscombe who took the time to look at the code in detail and nailed the problem. I corrected the SQL spacing and used the single quotes as you suggested and it works like a charm tyvm Nigel :) Oh just...

I'd really not rather talk to you like a 6-year old. The task was explained in the first para of the attached doc that was submitted in the original post to elaborate a little: Attempting to use a combobox to search a 1000’s of records. Rowsource is a union query with a user defined search...

Hi jd, Thx for reply, in response to your questions: 1. Learning vba, but I think I get the gist of how the solution is supposed to work. Even if I wasn't a beginner no point in re-inventing the wheel, code's meant to be re-usable right? 2. Combo columns are 0 based, are you saying that if my...

Hi All, I shamelessly plagiarised another persons code to try to design an unbound combobox whose rowsource can be dynamically set based on a union query in order to search 1000's of names returning each name that contains a user defined string. The search does not start until the user...

OK I will give it a go and get back to you if I have any questions, thx

JDraw thanks for the quick reply. Is the approach you drew an example of a star schema? Would it be a good idea to have a primary key on the Vehicle table that was a composite of the manufacturerID and modelID? Will the record structure arising from such a schema allow me the flexibility...

Hi All, I have a type of problem that I want to understand. I have given an example in the attached excel spread sheet with a few comments at the head of each column. 1. I want to confirm that my best modelling approach for this kind of information is a series of 1 to many relationships...

Hi CJ, Thank you that was helpful I think I have cracked it now, regards HowardB

Hi All, In my scenario Single products night be thinks like 2-inch wheel or 1 inch wheel in a choice of colours, front axle, back axle etc that can be ordered as distinct products A kit is distinct product in its own right consisting of a bundled set of other single product...

Hi All, Just briefly introducing myself. I live in Kent, I work in healthcare and have a science background. I am not a professional programmer but I am reasonably IT savvy have used access on but mainly off for 5 years or so, so still learning:) I am hoping to get some support with a few...