Recent content by joshs1100

How do you create the odbc connection to the target MS SQL database from the AS400?

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!

Thanks! Was just what I needed. I had to add the reference for the DAO Library, and added rs.MoveNext to get it to move to the next record in the recordset on the loop. Dim db As DAO.database Dim rs As DAO.Recordset Dim strtabname As String Dim strrecipients As String strtabname =...

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!

I think I may have posted this in the wrong forum. I'm using an access table to store the addresses, and using a command button on the form to send the email using outlook.

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!

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

Try your where condition like this: "[Cycle]= " & [Forms]![Trtmnts_Admnstrd]![Cycle] & " And [Patient Number]= " & [Forms]![Trtmnts_Admnstrd]![Patient Number] The where condition needs to be a string expression, so you have to enclose your text in "text here&quot...

If you lock and disable it, it will revert back to the standard field format, and will not be a tab stop. That's what I usually on calculated fields.

I haven't used xp, but in 97 and 2000, I just went to View - Toolbars - Customize. Create a new Menu bar, then just drag and drop stuff from the default menu bar to the new one. Then I reset the default menu bar.

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

I think I have found an answer to the problem here that seems to be working for me. In the before update event, if any of my required fields are null, I first do a docmd.cancelevent to cancel the odbc error that pops up (not sure if you would have this if you don't use odbc linked tables, I get...

If they are not a dbowner, make sure that dbo use only is turned off.

In the On Key Down Event, put this code. If KeyCode = 40 Then Me.comboboxname.Dropdown Replace comboboxname with the name of your combo box.

Am I the only one that is affected by this, or is there no way to change the function?