Search results for query: *

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

Have you got any code in your report. I have had this error message before when I have had a command with the wrong syntax, as for not being able to go in to the report, this sounds like something in your database might have corrupted. The easiest answer is to create a new blank database and...

I have a field which returns 14 vaslues seperated by a comma, (eg 245.67,128.90,126.54,0,0,0,0,0,0,0,0,0,0,0). I need to be able subtract all these values and add them all together, does anyone have any ideas how this can be done. Regards, Gavin,

You would need to look at referencing the Word Object and calling the command through the word object to maximize etc.. the word window, I have done this before, but can't find the code I have used to do this. If you look under the Word VBA Help you should be able to find the solution.

I have just found a solution, for using Replication Id in Auto Number fields. I have used the GUIDToString function to convert the field into something that the code window can handle.

I am trying to reference the AutoNumber Field that I have in one of my tables in Code, but all it returns is a ?, but if I try access the field in a Query I get the right result from the Field. Does anyone know haw to handle an Autonumber - Replication ID Field in Code and return the correct...