Recent content by gavinjb

that worked brilliantly thanks (for the Control), no it is for Vehicle Operating Centres.

Hi, I am trying to write an function to prompt the user if they want to update it if they make a chnage to the field, and if they cancel no, to go back to the previous value, does anyone know how to do this. The Code I have written so far us as follows, but it still excepts the new value, does...

From what I remember that is an Data Error (can only be trapped through the On Error Event), so you should be able to trap it through the On Error Event. You will need to watch for the DataErr No, if you dont know the number just add an msgbox DataErr. You will need to add an response =...

Sorry, proberly didn't put that very well, my Problem is with writing the statement, I can write the part to create the column,b ut Can't work out how I set the Default Value on this new column in DDL.

Hi, I am trying to write a SQL DDL Statement to add a column to my 'Documents Table' called DateLoaded with the default value of Now(), does anyone know how to do this. Regards, Gavin,

Sorry I just posted the wrong thing, my Pc is playing up.

yes, the ldb file is being created. Gavin,

http://www.tek-tips.com/viewthread.cfm?spid=181&newpid=181&sqid=874309

Yes that would work, but you would be better defining strTo as an array and using strTo(0)=sArray(0) ... strTo(3)=sArray(3) As you willl overwrite the values if not. Gavin,

Thanks for your suggestions I have checked them all and none of these apply. Gavin,

Hi, I have included a sample code that will split an list box into individual items and place them in an array, hope this helps. Gavin, Dim sinput As String Dim sArray As Variant sinput = "val1;val2;val3;val4" sArray = Split(sinput, ";") Debug.Print sArray(0) Debug.Print sArray(1)...

Hi, Recently I have been having problems on partiucular PC's when the user logs into any of my access 2000 databases, no one else then can login, has anyone else had this problem and know how to resolve it, I have looked through all the options but cant find anything that could impact this...

The easiest solution, is to create a blank database, and import all your objects from your corrupt(?) database, and see if this resolves the issue (don't forget if you use linked tables to re-link them rather than importing from the corrupt database).

If you want to run the MailMerge through the switchboard, I would create a function to run the Merge, you would then need to create a macro which calls the runcode option, which can be called from the switchboard.

You could try using grouping and select the Maximum option for your EENDDATE