Set the Selstart and SelLength property of the textbox to zero in the GotFocus event

e.g.

Private Sub txtUserID_GotFocus()

txtUserID.SelStart = 0

txtUserID.SelLength = 0

End Sub

You need to create an expression for the SQLStatementSource property

Set the expression to equal:

"insert into t_RowCount values('+Cast(" + @[User::MyVar] + " as varchar(10))+',getdate())"

My only experience of a problem like this was caused by users opening the csv file in Excel after the extract to edit the data - it was Excel converting...

We have an Access front end to a SQL back end (adp, not linked tables) and each user has their own copy of the front end, which only gets refreshed...

I would never have more than one user per front-end, whether it be with linked tables, or as a project file. You get much better performance with each user...

Microsoft have a tool called JetComp that will fix more problems than the inbuilt option in Access - you can get it here:

http://support.microsoft.com/kb/295334/en-us

This has just worked for me on one of my stored procedures

DoCmd.OutputTo acOutputStoredProcedure , "EXEC usp_SelectClientByNumber '00010'", acFormatXLS, "c:\test.xls"

Looking at the sample data, the column separator should be a space, with the text delimiter set as double quotes - this should then handle any embedded spaces in the...

For a single table it is very easy using the import data wizard:

Start SQL Server Management Studio, connect to the server, browse to Databases and right click on the name...

When you import the file, make sure that the text specifier is set to " (double quote) in the second screen of the Import Text wizard.

If you want to...

I haven't set up the linked server yet - I am so far just trying to create the login, to be used later on to map specific users in the...

If you create your front end system as an Access project (adp) rather than as an Access database (mdb) you have a single connection to the database and all queries...

You can update using linked tables, but each table must have a unique identifier, otherwise Access will give read only access.

If the table does not already have a column that...

The tables will only be linked if the Access database is in MDB/MDE format

If it's in ADP format, you need to go to "Connection" on the File menu - here...

If you create an ado connection object, and call the stored procedure to create the temp table through this object, you can use the connection object while it is still...