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

    CR 8.5 - Subtotal of column by person

    It works, thanks Brian!
  2. ambra19

    CR 8.5 - Subtotal of column by person

    Sorry, we don't need a running total just a total per person. Total # of J's and S's per person Here is the formula I currently have: numbervar totalsales; if {Column2} = "J" or {Column2} = "S" then totalsales := totalsales + 1 else totalsales := totalsales + 0 Do I need a loop? And if...
  3. ambra19

    CR 8.5 - Subtotal of column by person

    Column 1 Column 2 Bob J Bob J Bob N Bob S Subtotal = 3 Chuck J Chuck N Chuck S Subtotal = 2 I need the formula to get the subtotal of J's and S's for each person.
  4. ambra19

    Excel Macro - Copy rows with specific date range to another worksheet.

    Hi Dale, I had sent you the file on Wednesday of last week. It was under the e-mail of ambra19@hotmail.com. The name that would have come up is K 19. I was just confirming whether you had received this. Thanks again Dale. regards, ambra19
  5. ambra19

    Excel Macro - Copy rows with specific date range to another worksheet.

    I am trying to create a macro that will copy rows that fall within a certain date range to be copied into a new worksheet. On worksheet 1, I have the date selection criteria (via dropdowns) and the selected "To" date is placed in C1, the "From" date is placed in C2...
  6. ambra19

    Excel 2000-"No more new fonts may be applied in this workbook"

    I am getting the following error in Excel: -"No more new fonts may be applied in this workbook" I have about 30 worksheets, of which 20 have charts (6/sheet). I get this message, click Ok (repeated about 4 times) and then Excel Crashes. Why is this? How can I fix this? Please...
  7. ambra19

    Create dll error + an installing my program on a network question

    Thanks again Johnwm. I realized that I don't need dll's. I thought i needed them from a prevoius school project example. Thanks for your help and patience. Regards, ambra19
  8. ambra19

    Create dll error + an installing my program on a network question

    Johnwm, As I said above, I created my forms and classes (+BODT classes). So, in the project explorer window (i believe that's the name, i am not in front of my home computer right now) there was a folder called forms, with the forms, a folder classes etc. I then added a project and selected...
  9. ambra19

    Create dll error + an installing my program on a network question

    Thanks Johnwm, My main concern is whether I need the dll's as i wasn't able to create them. Will the Installer create the dll's for me?
  10. ambra19

    Create dll error + an installing my program on a network question

    I am trying to create 3 dll's. I created my forms, modules, and classes. The program now works. What I want to do is to create the dll's. I went to Add Project>ActiveX DLL and then I added the forms to this dll. I went to make the dll and got the following error: "No creatable public...
  11. ambra19

    One SQL statement works, other doesn't in VB6 App

    It worked. Thanks again Transcend. ambra19
  12. ambra19

    One SQL statement works, other doesn't in VB6 App

    Transcend, Thanks for the idea. I tried it running as a query in Access. I guess that 'Note' as a column heading doesn't work on an INSERT STATEMENT for reasons I do not know. I will try this tomorrow and let you know how it works. Thanks. ambra19
  13. ambra19

    One SQL statement works, other doesn't in VB6 App

    Hi Transcend, Thank you for your prompt response. I did check the strSQL and have included the results below. I did, here is what I get for both: 1. The SQL statement that works from the Franchisee Form: INSERT INTO tblFranchNotes (FNDate, Notes, Fid)VALUES('2003-03-19','Here is the...
  14. ambra19

    One SQL statement works, other doesn't in VB6 App

    I have a Note box on a form that deals with Franchisees. It allows that I can add new notes for different call dates. Each Note has it's own id. These can only be added and not editted. I have a second form that has something similar however, these notes can be editted later. Here is where...
  15. ambra19

    Click Button, Open word template, populate address

    Hi, I have a form that appears with an individual's name & address. What I want to do, is allow the user to click the button on the form that opens a Word template (a letter). It will populate the address of the person and the "Dear LastName" part from the information on the form...
  16. ambra19

    Search a listbox using a text box

    jollypathak, I just encountered a problem, when I type in the first letters ie 't', 'ti' then change to 'tu' it works, but when i get rid of all of the letters in order to go to the 's' for example, i get the following error: Runtime error 318 Invalid property array index because the the id...
  17. ambra19

    Search a listbox using a text box

    jollypathak, thank you very much, it works perfectly. ambra19
  18. ambra19

    Constant Window/Form Size independent of screen settings

    How can I adjust the window (MDI form?) that opens up to be a certain size (not adjustable)? How can i make this independant of display setting as some users will have 1024 X 768 and others will have settings that are higher? Any help is appreciated. Regards, ambra19
  19. ambra19

    Search a listbox using a text box

    I tried this, but it I got a "Compile Error: Method or data not Found" How can I fix this? thanks. ambra19
  20. ambra19

    Search a listbox using a text box

    I want to add a search functionality to my program. I have a listbox (which contains names, format: last name, first name) and want to put a textbox above it that searches the listbox in the following manner: for example, i am looking for the last name "Smith" when i type the letter...

Part and Inventory Search

Back
Top