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!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by tkcrosbie

  1. tkcrosbie

    ado.net - too many characters in update sql

    I'm using a beta version of the .net framwork as a learning tool (it was free). When I'm using the data grid and ado to add data to an access(97) data base I get a failure indicating invalid characters at the end of the sql statemet. Is this a beta problem or is there a workaround or.... also...
  2. tkcrosbie

    problem with openargs

    I guess we can conclude that there is a problem in either office xp or winxp. The first call which uses open args always contains null on my system. I find it very interesting that access 97 has no problems at all with the same code. Thanks for the definitive awnser on the class. I am much...
  3. tkcrosbie

    problem with openargs

    I quit trying to use openargs and settled on accessing the field in the calling form. Here is the code holdafe = Forms!AFE.AFE_Number holdafe is a field(hidden) on my new form afe_number is a field on the calling form after all a form is a class (sort of)
  4. tkcrosbie

    problem with openargs

    stlinkcriteria is just a variable name with my transfer value in it
  5. tkcrosbie

    problem with openargs

    form1 code stDocName = "ItemApproval" stLinkCriteria = Me.req_idx DoCmd.OpenForm stDocName, , , , , , stLinkCriteria form2 code Sub Form_Open(Cancel As Integer) test = Forms!ItemApproval.OpenArgs debug shows the value in stlinkcriteria in form1 the value is null in form2...
  6. tkcrosbie

    problem with openargs

    when I use the openargs paramater of the docmd.openform method the first time I call the new form the openargs value is null! After it is called once then the value is passed as required. Is anyone familiar with this situation??? I am using officexp and windows xp
  7. tkcrosbie

    using transfertext and specificationname

    sorry for the delay. I went on vacation. The error has been solved. How I don't know. I encountered the error after shutting down my system, then booting up the next day. This is when the error occured. After another shutdown and restart the next day (or later that day) the problem...
  8. tkcrosbie

    using transfertext and specificationname

    I have written a new form which uses docmd.transfertext with a specification name. Everything works perfectly -- except. I have to open the specification manually before running the form. If I dont I get errors about unknown specification and file names from the transfer text string. I am...
  9. tkcrosbie

    crystal 8 on win xp - no help system

    Thanks for the reply's. I got help installed by going back to the install disk and selecting reinsall, and then selecting the compiled help install.
  10. tkcrosbie

    crystal 8 on win xp - no help system

    I have installed crystal 8 on my new xp system. There were no messages or problems during the installation but I now find that I cannot access the help system. I recieve a message saying that help has not been installed. It appears to be installed(files,dir's etc). Any suggestions anyone
  11. tkcrosbie

    suppress column headings on page with group data

    The group data is the data associated with the Group Header. In this case the data printed on a group header break fills an entire page
  12. tkcrosbie

    suppress column headings on page with group data

    I have a report where the group data is printed on a seperate page. How do I prevent the detail data column headings from printing on the page with the group data. The group data has new page before and after set to insure a page break.

Part and Inventory Search

Back
Top