Search results for query: *

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

Sorry, without opening the document.

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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