Search results for query: *

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

Thanks JB. Actually, in the first version I was comparing against a value in a table. After I got it working I decided to do the comparison against a field on the form. Thanks again to all of you for your help.

When I stopped trying to write the sql myself and typed <=(DateAdd("h",1,[Forms]![PPI_Main_Form].[PR_Time_Beg_Slot])) into the criteria box in the query wizard it worked. I'm still not sure where my sql was wrong, but I will figure that out later. Thanks again for your help.

Guys, thanks for the quick response. PHV, I can use DateAdd("h", 1, "12:00 PM") as an expression in a text box and it returns 1:00 PM, so this is close to what I need. However, the time in the field in question will vary from record to record. When I try to use the function in a query in the...

Can I do time calculations in Access? I know I can in Excel, and I can do date calculations in Access but I can't find anything in Help about time calculations short of writing code. I haven't used Access in over 10 years and never did much with VB. What I want to do specifically is update a...