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!

  • Congratulations wOOdy-Soft 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: *

  • Users: Arnold
  • Content: Threads
  • Order by date
  1. Arnold

    Change BIOS settings from within NT 4.0?

    I have to change the Power/Energy Saver/Energy Saver Mode BIOS setting from either "Minimal" or "Advanced" to "Disable". I need to do this on Compaq Deskpro workstations that are running NT 4.0. I know I can do it manually, but I have too many to have to go to...
  2. Arnold

    Saving Export Specification in Access Project

    I am upsizing my Access 2000 database to an Access 2000 Project and am unable to to bring my export specifications into the project. Also, the project won't allow me to save new import/export specifications. Any ideas?<br>Thanks,<br>Arnold
  3. Arnold

    Formatting a SQL Select string

    I have a SELECT statement in Access 2000 that contains the following:<br>Format([UnitPrice]/[Weight],'$0.0000') AS expr1<br><br>I am looking for an equivalent in SQL Server, but have yet to find it.&nbsp;&nbsp;The SELECT statement is the source for a ListBox in an Access 2000 Project.<br><br>Any...
  4. Arnold

    Formatting a SQL Select string

    I have a SELECT statement in Access 2000 that contains the following:<br>Format([UnitPrice]/[Weight],'$0.0000') AS expr1<br><br>I am looking for an equivalent in SQL Server, but have yet to find it.&nbsp;&nbsp;The SELECT statement is the source for a ListBox in an Access 2000 Project.<br><br>Any...
  5. Arnold

    ODBC-Update on a linked table failed

    I have an Access 97 database that I am upgrading to utilize a SQL Server 7.0 backend and an Access 2000 front end. First, I am upsizing the Access 97 database to Access 2000 and then running the Upsizing Wizard to create the Access 2000 database with linked tables to the SQL Server. When I...
  6. Arnold

    ODBC-Update on a linked table failed

    I have an Access 97 database that I am upgrading to utilize a SQL Server 7.0 backend and an Access 2000 front end. First, I am upsizing the Access 97 database to Access 2000 and then running the Upsizing Wizard to create the Access 2000 database with linked tables to the SQL Server. When I...
  7. Arnold

    Index Errors in Access 97 tables

    I have an Access 97 database that is made up of a front end and a back end, both in Access 97. Just the tables are in the backend. I then link the front end to the backend with linked tables. Next I make an MDE file out of the front end. I have about 10-15 concurrent users at any one time...
  8. Arnold

    Trouble Converting an Access 2000 database to SQL 7.0

    I am trying to convert an Access 2000 database over to SQL 7.0, but I am having some problems. I ran the upsizing wizard to upsize the table structure and link the database tables to the sql 7.0 tables. That worked fine. I then imported all the data into the SQL 7.0 backend. Again no...
  9. Arnold

    Trouble Converting an Access 2000 database to SQL 7.0

    I am trying to convert an Access 2000 database over to SQL 7.0, but I am having some problems. I ran the upsizing wizard to upsize the table structure and link the database tables to the sql 7.0 tables. That worked fine. I then imported all the data into the SQL 7.0 backend. Again no...
  10. Arnold

    ActiveX Component Can't create object

    I have an Access database that works great on one computer, but I get an "ActiveX Component can't create object" error and a "Run-time error '429'" error when I try and run it on a second computer. When I debug the code, the error occurs on "Set dbcurrent = CurrentDb". Am I missing an ActiveX...
  11. Arnold

    Converting from an Access 97 backend to SQL Server

    I am one of the developers for an Access 97 database that is used in a small business. The database we are using has continued to grow, as has the number of users. We currently have about 15 users in the system at any one time. The database is critical to the day-to-day operations of the...
  12. Arnold

    How do you save a previewed report as a File?

    Is it possible to save a previewed report in Access as a file of some sort? My users have a fax program on there computer and they need the ability to fax an Access report from their computer.
  13. Arnold

    How did I get a "Not a valid bookmark" error?

    I have an Access 97 database that is on a LAN with about 15 different users. The database runs without problems when it is run on just one local computer, but when it is run on the network with multiple users all at the same time, I often get a "Not a valid bookmark" error. This usually occurs...
  14. Arnold

    How did I get a "Reserved Error (-1601)"?

    While trying to update a field in my table by using a recordset, I got an error that stated: "Reserved Error (-1601) There is no message for this error" I repaired the database and it fixed the problem, but I am wondering if anyone knows what could have caused the error.
  15. Arnold

    How do I Opening a different database from within the current database

    While in my access database, I want to click on a button that opens another access database. I want the other database to open like it would if I double clicked on it in Windows Explorer. What code do I need to put behind the button?
  16. Arnold

    How do you duplicate a database from Visual basic code?

    While in visual basic code, I want to do the equivalent of copying another database and pasting it with a different name. I don't want to make a replica of it. I do know that I could create a new database with the NewCurrentDatabase Object and then import everything that I want, but I was...
  17. Arnold

    How do you write an UPDATE SQL statement between different databases

    I am trying to write an SQL statement that will update a table in one MS Access 97 database with data from a table in another MS Access 97 database. The tables have the same structure, design, and format. I want to basically do an Update query, but the table being updated is in a separate...

Part and Inventory Search

Back
Top