Search results for query: *

I'm formatting a text field to currency in a report. I'm geting the value of the text field from a function i've made. lets say the value i'm returning is 36.958585 i want to format the value to currency. When the report opens there is no value that appears. When i go in design view and the in...

i'm trying to output an access table to excel using the outputto command.My problem is that i can't output more than 11 000 records or so. I need to output about 50000 and it tells me " Run time error 2306 There are too many rows to output bared on the limitations specified by the output...

I need to get the date and time from the SQL server from our clients. I do not want to work with the clients date and time, I want to work with the server's date and time. I remember there being a function for this. Please let me know what it is. Thanking you in advance, Frank

when i make the connection, exactly like above

i have linked tables in my access database

Yes, I am using Microsoft access to access this sql table.

This is a sample of what i'm trying to do: set db=currentdb() set rstInvoice=db.openrecordset("tblInvoice",,dbseeChanges) *It's very simple the only thing is, is that tblInvoice has an autonumber id.

I am trying to open a recordset on a sql server table threw vba and it keeps telling me that i have to use the dbseechanges option. When i do use the dbseechanges option it still tells me that i have to use the dbseechanges option. Thank you in advance, Frank

I am trying to open a recordset in Access 2000 on an SQL server table that has a unique identifier and i keep getting the same error. It keeps telling me that i have to use the dbSeeChanges option when opening this recordset. Then i use the dbSeeChanges option and it keeps giving me the same...

We are using SQL server 7. The users are updating existing records and adding new records. We have 3 index on our table.The table has about 100 fields

The users are using an Access 97 front end. We were are connecting through ODBC. Some users have read only access and some have change access. The users who are updating records get the timeout error

The users are using an Access 97 front end. We were are connecting through ODBC. Some users have read only access and some have change access. The users who are updating records get the timeout error

The table has about 150 000 records

I am running SQL server on a PC. There are about 20 simultaneous users. I often get timeout when someone is trying to update a record. My server has 512 mb or ram. I don't think its a performance problem with the server but i could be wrong. Does anyone have any suggestions??

Hi, I'm trying to open a recordset on an SQL server table in Access 97. I keep getting "Error 3622. You must use the dbSeeChanges option with OpenRecordset when accessing a SQL Server table that has an IDENTITY COLUMN." I use the dbSeeChanges option and I get the same error. Thanking...

I have a network running WINNT40....one machine is 2000pro. That machine happens to be in the marketing dept. He always saves his work as a .tif on the network, and when I access it to burn from my NT station it isn't recognized. It won't open...nothing. I have to take an external burner and go...

I am running SQL server from a PC. We are using it as a server. I have about 20 users simultaneously using the system. I often get ODBC update fail, when users are making changes to the database. If anyone has any suggestions I'd appreciate it. I already increased the ram to 512 and increased my...