Search results for query: *

I have tried a few things to close out my ticket program but, I am not able to do it. I keep getting a ODBC error when I try to change a field's value. I have created a query on a database and then created the form, which pulls the information from the query. The error I encounter is...

I have a Access 97/2000 linked database to a SQL 2000 server. I am running a switchboard menu and starting my form in add mode. I open my form and decide not to type any data in and click the close button. The SQL server still records an entry as a null for all fields. Any ideas? Thank...

I am running access 97 and 2000 database with a link to a SQL 2000 server. I have noticed extra entries on the SQL Server even when I don't enter any data. I am opening a form in add mode through the switchboard. But, when I decide not to enter any data in, and click on my button, which...

Thank you for the info it seems to work. I also tried another command called refresh and that also seems to work.

Hello, I have been experiencing a problem with data from a Auto number field not showing up on the MS Access 97 /2000 client form. The data is incrementing fine on the SQL server but, it just does not appear on the linked form when I ADD a new record. Does anyone have a good direction I...

I have recently converted my Access 97 /2000 database to SQL 2000 server. I was relying on the Autonumber feature in the software, but now I am unable to use that field type with SQL 2000 Server. I need a way to do a ticket number system for my helpdesk software with SQL 2000 server. Any Ideas ?