Recent content by orbic1

Thanks - will give it a shot!

Thanks - that works beautifully! Is there any way of making it is by default +2, and if there is no middle name, +1 ? Thanks

Thanks, Wayne 1) I do have a prefix to "name" - forgot! Still, thanks for the heads-up 2) Get an error: Too complex to be evaluated Any ideas? Cheers

Hi, I have a table with the following fileds: ID, Name, DOB, Ref Name is in the Form: Forename (Initial/Middle Name) Surname I have a form that lists all of this data, but I need to sort by Surname. How would I go about it? Thanks

Thanks - I will endeavor to build this into future apps. Is there a way of still using my present way and getting it working on those rogue systems?

Does anyone know the reason why on most machines, the common dialog box opens when called, but not on other systems. I'm calling: MSComDlg.CommonDialog.1 However, when edited, it comes up with an error stating: There is no object in this control. This only occurs on a handful of machines. Is...

Sorry - misread that. Have you managed it yet, or do you still need to know how? If you do, can you provide some more information?

Delimiter Change the table field properties. You will see the different types: text, number etc. You can change text to 255, or if the field data is larger than 255 chars, use memo (unlim chars)

Samia, PM me if you need any support on this project as have developed several NHS patient DB solutions.

Hi Hayley et al, This has been of much use! Could you post your DB with those amendments in it? Thanks - I'm having problems doing the same sort of thing.

yes........ how have you done it?

Thanks I'd like to extend my thanks! That works brilliantly!

Thanks! For the moment I'll use MSDE as to start with, approx only 5 users. Which would you recommend, SQL presumably, for later when 40+ users will need it with view to easiest migration between them? Is it easy to migrate from MSDE to SQL? Once the powers that be spread the DB across all...

Thanks - will give it a shot!

Works brilliantly! Thank you!