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!

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

Search results for query: *

  1. PoppaSmurf

    DoCmd.RunSQL problem

    SELECT Max([AssetNo])+1 AS NextNumber FROM tblAssetNo" This will give you the next number PoppaSmurf allanmurphy47@gmail.com
  2. PoppaSmurf

    I can't get the Nz function to work for me

    Your question has been answered on another forum. PoppaSmurf allanmurphy47@gmail.com
  3. PoppaSmurf

    Calendar

    Suppose your calendar is called cal_1. On the Load Event of your form put the following cal_1=date() When you open the form the default date of the calendar is the current date. PoppaSmurf
  4. PoppaSmurf

    Using Access2000 database with VISTA and Access 2003

    Thank you, to all who offered advice. I found the problem, it was due to a LAN upgrade going from Windows 2000 and Access 2000 to VISTA and Access 2003. The database had a front end and a back end that work with the correct linking, BUT in the new configuration the name of the directory where...
  5. PoppaSmurf

    Access 2000 & Vista Compatiblity?

    I have posted a similar question at http://www.tek-tips.com/viewthread.cfm?qid=1395263&page=1 PoppaSmurf
  6. PoppaSmurf

    Using Access2000 database with VISTA and Access 2003

    Thank you. There was no message displayed as per your reply. I contacted the user to determine exactly what happens when they open the database. I was told "the login screen is displayed, they enter their user and password and it appears to hang" the only way to close the database was to click...
  7. PoppaSmurf

    Using Access2000 database with VISTA and Access 2003

    I was asked to help solve this problem and I am seeking some guidance. Prior to the company upgrading from Windows XP and Access 2000 to VISTA and Access 2003, they were able to open a database, that is Access 2000 format, to display a login screen, after entering a valid User Id and Password...
  8. PoppaSmurf

    Number format changes on it's own

    I would do the following as a safeguard. Create a table with the fields and correct format etc. Run a query to delete the existing data in the above table. Then run an append query to add the new data to the above table. PoppaSmurf
  9. PoppaSmurf

    Emailing a snapshot file, waits for me to click send....why

    Place a comma between the two addreses e.g. "one@aol.com,two@.aol.com", PoppaSmurf

Part and Inventory Search

Back
Top