Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by gavinjb

  1. gavinjb

    BeofreUpdate

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

    BeofreUpdate

    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...
  3. gavinjb

    Optimistic Locking - Bound Form - Access 2000

    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 =...
  4. gavinjb

    ALTER TABLE with Default

    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.
  5. gavinjb

    ALTER TABLE with Default

    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,
  6. gavinjb

    Access Won't allow multiple users to login

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

    Access Won't allow multiple users to login

    yes, the ldb file is being created. Gavin,
  8. gavinjb

    Access Won't allow multiple users to login

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

    working with array

    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,
  10. gavinjb

    Access Won't allow multiple users to login

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

    working with array

    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)...
  12. gavinjb

    Access Won't allow multiple users to login

    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...
  13. gavinjb

    Corrupt Database?

    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).
  14. gavinjb

    linking access to a word mail merge

    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.
  15. gavinjb

    Maximum Date Value

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

Part and Inventory Search

Back
Top