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: *

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

    Writing a record from the AS400 to a MS SQL 2000 table

    Is it possible to write a record to a table on a MS SQL 2000 server from the AS400 using ODBC, or some other means of connection? Thanks!
  2. joshs1100

    Sending email from outlook, how to get list of "to" addr's from table

    When using DoCmd.SendObject, how can I take a table with a list of email addresses, and use it in the expression to complete the "to" parameter with a semicolon separated list? Thanks!
  3. joshs1100

    Sending email from outlook, how to get list of "to" addr's from table

    When using DoCmd.SendObject, how can I take a table with a list of email addresses, and use it in the expression to complete the "to" parameter with a semicolon separated list? Thanks!
  4. joshs1100

    Index Tuning wizard, Profiler Event ID 998 Error

    I am trying to run the Index Tuning wizard, and it fails with "The server returned an error attempting to optimize a query" In the application log, it shows: Event Type: Error Event Source: SQLServerProfiler Event Category: Internal Error Event ID: 998 Date: 3/9/2004 Time: 9:44:26 AM User...
  5. joshs1100

    How can I make vba wait until a report is spooled to continue?

    I am trying to print 4 reports off of one command button. Each report can vary in the number of pages it contains. The 4 reports need to print in order. The problem I run into is, it starts spooling each report one after the other, and which ever report spools first, prints first. So if a long...
  6. joshs1100

    Format Align difference between Access 97 and 2000

    Is there any way to change the format - align functions in Access 2000 to act as they did in 97. Exampe: on a form you have 2 text boxes that overlap. You select both, and do a format - align - left. In access 97, it will move the left edge of the right box in line with the right edge of the...
  7. joshs1100

    Any way to use this SQL statement without grouping by Type?

    SELECT Table1.Item, CASE (Table2.Type) WHEN 'Variable' THEN SUM(Table1.Cost) END AS V_Cost, CASE (Table2.Type) WHEN 'Fixed' THEN SUM(Table1.Cost) END AS F_Cost FROM Table1 INNER JOIN Table2 ON Table1.TYPE = Table2.Type GROUP BY Table1.Item, Table2.Type
  8. joshs1100

    how can I Let numeric field = null

    I am trying to use code to remove a value entered into a numeric field on a form. When I use "Let Fieldname = Null" I get run-time error '3162'. If I use "Let Fieldname = Empty" it puts a '0' in the field. I want the field to be equal to the same thing it is when you press...
  9. joshs1100

    Custom Menu Bar File->Print Problem

    I am making a custom menu bar in Access 97. When a user does File -> Print, I want it to open the print dialog box, just like the File -> Print on the standard menu bar, but it just immediately prints. Any way I can make it work the same as the standard menu bar? Thanks
  10. joshs1100

    Kick of a DTS package from Access 97

    Anyone know of a way to allow a user kick off a DTS package from Access 97?
  11. joshs1100

    I have linked an as400 database to Sql 7.0, now how do I select data f

    I am trying to get data from an AS400 database (JD Edwards). I have created the linked server, and can see all the tables in enterprise manager under the linked server, but how do I reference them in a sql statement? Thank You

Part and Inventory Search

Back
Top