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

    Using VB - GetObject and Excel

    I want to use GetObject to edit an Excel file, and I don't want it to be visible. But if I don't include: objExcel.Application.Visible = True objExcel.Parent.Windows(1).Visible = True when I open up test.xls, Excel opens but does not load the workbook. Please Help, Thanks. Sub...
  2. kutibo

    Word Header and Footer

    Sorry, without opening the document.
  3. kutibo

    Word Header and Footer

    Does anyone know how to remove the header and footer from a Word document without opening it?
  4. kutibo

    Alter Word doc without opening it

    Does anyone know how to remove the header and footer from a Word document without opening it?
  5. kutibo

    100%

    How can I force percentages to add up to 100% in '97? Example: Qty. Total Qty. Percent 100 300 33.33% 100 300 33.33% 100 300 33.34% Thanks
  6. kutibo

    Short Question- 100% Percent?

    Thanks and good idea... but I have to use '97
  7. kutibo

    Short Question- 100% Percent?

    How can I force percentages to add up to 100%? Example: Qty. Total Qty. Percent 100 300 33.33% 100 300 33.33% 100 300 33.34% Thanks
  8. kutibo

    subform ODER BY

    I have a form that has a subform. I need to sort the subform by fldDate, a date, not a key, not unique and another field, fldEntryID, which is an integer, not a key, not unique. Currently I'm using the ORDER BY property. I've made the 2 fields keys and it did not make a difference. It...
  9. kutibo

    Subform ORDER BY

    I have a form that has a subform. I need to sort the subform by fldDate, a date, not a key, not unique and another field, fldEntryID, which is an integer, not a key, not unique. Currently I'm using the ORDER BY property. I've made the 2 fields keys and it did not make a difference. It...
  10. kutibo

    Error 3075

    I have a form whose record source is a table. I need to retrieve the unitcost from a query by fldVintage and fldSize and save it in the table. My code does not work when there is not match for the fldVintage and fldSize, I get error 3075. Eg.) Syntax error in string in query expression...
  11. kutibo

    Error 3075

    I have a form whose record source is a table. I need to retrieve the unitcost from a query by fldVintage and fldSize and save it in the table. My code does not work when there is not match for the fldVintage and fldSize, I get error 3075. Eg.) Syntax error in string in query expression...
  12. kutibo

    How can I make this run faster?

    This function looks up values in the specified table, (either L1 or L05) column, (SURVIVE or EXPECT) and row. How can I make this run faster? Function lookupBLDcurve(fldCurve, number) Select Case fldCurve Case "SL1" lookupBLDcurve = Nz(DLookup("SURVIVE&quot...
  13. kutibo

    RUNNING SUM

    Hi, I need to have a runnning sum for each record in a subform. I have a beginning balance and entiries. I want to add each entry and display the answer for each subsequent record. For example, if each entry was 100. The results would be: 100, 200, 300, 400 etc. The entries are grouped. They...
  14. kutibo

    Runnning Sum

    Thanks for your help and sorry i didn't explain this better. The entries are grouped. They are grouped by with a combination of two fields which are numbers. So the number of entries vary from group to group. So that method won't work well. I tired dsum but that won't do it. I also used sql...
  15. kutibo

    Runnning Sum

    How can I calculate a running sum in a form? I have a beginning balance and entiries. I want to add each entry to the beg. balance and display the answer for each subsequent record. For example, if the beginning blance was 100, and each entry was 100. The results would be: 200, 300, 400 etc...
  16. kutibo

    Repeat Section Question

    I have a report with a header and footer for account and a header and footer for building. I want the building header to be repeated when the records exceed one page. But when the repeat section property is set to yes the report only displays the first account because when I try to go to the...
  17. kutibo

    Repeat Section Question

    I have a report with a header and footer for account and a header and footer for building. I want the building header to be repeated when the records exceed one page. But when the repeat section property is set to yes the report only displays the first account because when I try to go to the...
  18. kutibo

    Multiple Criteria Question?

    How do I add another field to the stLinkCriteria section without getting an error? Thanks for your help. Dim stDocName As String Dim stLinkCriteria As String stDocName = "ADJ" stLinkCriteria = "[fldAcct]=" & Me![fldAcct] DoCmd.OpenForm...
  19. kutibo

    How can I make a report display onl

    How can I make a report display only one report header based on criteria... If the account number is 387 or 390 then display the the building header, else display the account header? Thanks
  20. kutibo

    Only display one report header.

    How can I make a report only display one report header based on criteria.. If the account number is 387 or 390 then display the the building header, else display the account header? Thanks

Part and Inventory Search

Back
Top