Search results for query: *

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

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

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

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

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

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

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

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

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