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 strongm 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: Jim0845
  • Content: Threads
  • Order by date
  1. Jim0845

    Updating DB2 with access

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

    Updating DB2 with Access

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

    Checkboxes don't print on report in 97 Access

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

    Access 97 doesn't give an option for snapshot files

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

    Using event procedures

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

    Time calculations in Access

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

Part and Inventory Search

Back
Top