Search results

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!

One spelling mistake correction later and it all works! Thanks!

I'm trying to set up the path for my images to be set in a table "General Settings" I've tried the following code with no success: Me.Text8 = tables![general settings]![img path] & Me.ID & "_1_" & Date$ & ".jpg" but it doesn't work! Any ideas?

Thanks. I'll give it a shot and post here if it works or not!

I'm trying to base reports upon various data to be used for statistical analysis. Presumably these reports need to be based upon queries. I'm about there with what I need to do, but am not sure. Below are a list of queries that I need to find, but I need to find the number of rows / records, not...

Thanks! So if I'm using an Access frontend, MSDE would be the best backend? Are there any other alternatives without forking out for win2k3 + SQL server? Can MSDE or similar be run on a Linux Box? Cheers