Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. AmeriSource

    formatting a text field

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

    trying to output a table to excel

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

    How do i get the time and date from the SQL server

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

    Opening a recordset in VBA on an SQL srv table with Unique Identifier

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

    Can not open a recordset on a table with a unique identifier

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

    SQL Update failed..Timeout

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

    Opening a recordset on an sql server table with Id Column

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

    Windows 2000 TIF problems

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

    SQL Server Timeout

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

Part and Inventory Search

Back
Top