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 Mike Lewis 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: *

  1. tjl99a1

    Macro in Excel

    Skip, The copy to on the LNG never changes, LNG is an overly complicated calc, the copy to on the last part which goes to the Review is what will change and the copied cells are from that same row. I'll try your code and let you know how it worked, thanks alot!!!! Tom
  2. tjl99a1

    Macro in Excel

    I am trying to create a macro in Excel. I need it to copy certain data from a specific row. The row would be based on the last cell with data in a specific column. After I copy each peice of data it gets pasted into another worksheet, then they all get put through a calculation, and I want the...
  3. tjl99a1

    Display/Layout Problem

    Have you tried putting the empty boxes in the Page Footer?
  4. tjl99a1

    light hearted relief

    If you increase the speed of the light won't that cause a clocking problem, a warping???? I guess it's all relative
  5. tjl99a1

    RUNNING TOTAL

    In queries you turn on the total row,[right click ,in design view and click on the sigma symbol] that should make it easier for you to figure out. On reports Open the report in Design view.Add a calculated text box to one or more of the following sections:How?To calculate a total or average for...
  6. tjl99a1

    Month Numbers

    Xianman, Not sure if this is what you want, you can create a label in design view and place next to the results, ex Jan. [results]123 or when you create your text box, name it as such. Is this what you need?
  7. tjl99a1

    Internet Explorer

    Try this download from Microsoft MS03-026 for windows XP, and the latest service patch for IE6, I had the same problem yesterday.
  8. tjl99a1

    Multiple queries

    Try this one, Create a SQL statement for a form Open the form in Design view or.Right-click the form selector or the report selector to open Build Event, then Expression Builder. You should be able to do it from there.
  9. tjl99a1

    Multiple queries

    This might help or you can do it all in a query first Modify SQL statement for a form or report Open the form in Design view or the report in Design view. Double-click the form selector or the report selector to open the property sheet. Click the Build button next to the RecordSource property...
  10. tjl99a1

    Published App Security

    I have set up a user's guide to be run with acrobat reader 6.0 on our system, the problem is now the users have access to the server's other files through acrobat. How can I stop this.
  11. tjl99a1

    USB devices

    I've had that problem with my Dell and Fuji Finepix, everything else I plug in works fine. I find turning the camera off & on fixes it, for that use anyway.

Part and Inventory Search

Back
Top