Recent content by Jim0845

I felt I had submitted this issue in the wrong forum so I resubmitted it under IBM: DB2. There is some additional dialogue there, but the solution was to change the commit mode setting under "Advanced server options" in my ODBC driver setup. Once I did that everything worked as expected...

I wanted a different DSN configuration than the one I normally use so I could put tighter restrictions on it, so I duplicated it and then added the restrictions. The original setting for commit mode was "Read uncommitted (*CHG)", which is fine because I am able to apply the commit options as...

I had to change the commit mode setting under "Advanced server options" in my ODBC driver setup. Once I did that everything works as expected. Thanks for your suggestions.

As to the pass-through query, no. I am newly returned to Access, and was never an expert in it. I am using a link to the table on the AS400 and can query it with no problem. I will see what a pass-through query can do for me. The 3rd party software I am using is something called Advanced...

I have a simple DB2 table on an AS400. I have created a linked table in Access and have no problem retrieving any of the data I want. However, when I try to update or append the DB2 table, I get "ODBC--insert on a linked table 'LIBRARYNAME_TABLENAME' failed. When I click on the help button I...

I have a simple DB2 table on an AS400. I have created a linked table in Access and have no problem retrieving any of the data I want. However, when I try to update or append the DB2 table, I get "ODBC--insert on a linked table 'LIBRARYNAME_TABLENAME' failed. When I click on the help button I...

Disregard this one. I finally actually looked and I DID NOT have service pack 1 installed. Some time ago I had to uninstall several programs including my Office97 installation. When I reinstalled I was apparently in too big of a hurry to do the service packs and then forgot about it. Once I...

Thanks for the suggestion Remou. That is a more practical workaround than what I was considering and because of some other issues, that may be what I wind up doing. dhookum, I finally understand how to use the Wingding font to do what I need, although I used Webdings and...

I have a report that has checkboxes. When I preview the report in Access and send it directly to the printer, they are there, along with the checkmarks in the boxes if there are any. When I save or send the report as an rtf file the checkboxes or checkmarks are not there. I saw one posting...

How do I make Access97 recognize the option of creating snapshot (.snp) files? According to the Microsoft website "If you have installed Microsoft Access Service Release 1 or Microsoft Office 97 Service Release 1, you automatically have the ability to save Microsoft Access reports as snapshot...

Thanks for pointing me to the article Remou. After reading it though, I am wondering if I really want to leave Access97 behind. As the users for this particular project don't do anything else with Access I am thinking it may be easier to deal with the dual Office installations. However, for...

Thanks Joe. I guess I need to go ahead and make the move though.

Thanks again Remou. I added a line to turn off the messages and it does exactly what I need. And I will dig into 2003.

Thanks Remou. I will this a shot.

Is it possible to execute more than one action in an event procedure? On exit of a subform control on the main form, I use an event procedure to do a refresh on a different subform on the same main form. (Forms!PPI_Main_Form!Calc_PPE_Stats_subform.Form.Requery) I also want to run an update...