Search results for query: *

I am using SQL server 7.0 as the database adn Access 97. I need the actual ID to be displayed. What I am doing now is just a requery of one of the controls on the form after the User clicks the Save button. Then the user can record the ID and then click the Exit button to get out. I know...

I had to transfer my Access database to a ODBC linked SQL database. Before this transfer, when the User entered data in the first applicable field on the form using AfterUpdate method, Access automatically displayed the auto number in the ID field. However, in SQL database the form must be...

I had to transfer my access database to a ODBC linked SQL database. Before this transfer, when the User entered data in the first applicable field on the form using AfterUpdate method, Access automatically displayed the auto number in the ID field. However, in SQL database the form must must...

Thanks for your response but I must be doing something wrong because I still cannot get what I need. I need to get the auto number just entered into the SQL database that using an access form to update the database. I need to display the newly entered record for edit/update. Can you help?

I am trying to retrieve the autonumber from a linked SQL table into an Access DB form. What I need is to have the autonumber field data to be displayed as soon as I tab out of another field on the form. I tried the following using AfterUpdate and the Requery as follows: Private Sub...

I am trying to retrieve the autonumber from a linked SQL table into an Access DB form. I tried the following using another field on the form as the focus: Private Sub fieldname_AfterUpdate() Me!fieldname.Value = UCase(Me!fieldname.Value) Forms!Formname.Requery This displays the auto number in...