Recent content by stehamp

I have attached the above relationship diagram as I am having a few problems with a table that uses composite keys to link to 2 other tables. The table is called subsmag and contains the fields subid and magid to link to the subscriptions (subid) and magazine (magid) tables. Basically 1...

Can someone help me please? I have a main form (subscriptions) and a subform (subscriptions subform). Upon opening the main form, the subform datasheet automatically goes to a new record allowing new data to be entered. Underneath the subform I have a number of combo boxes which transfer data...

Like many people on here I have found the Cool Search Form attached below very useful. However I would like to have separate fields on my form for name, organisation and postcode searches - but for the subform to still work in the same way. So if I enter a name (or the first letter) in the name...

I have found the following module code which removes alpha characters from an alphanumeric string However I would like to do the opposite - i.e. remove numeric characters leaving only alpha characters. I'm sure this is a simple task but I am quite new to this. thanks