Search results for query: *

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?

On each of the 7 fields you enter into, put an after update event that requeries the subform that has the total. subformcontrolname.requery

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

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

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

Got it to work. Copied the option from the standard menu.