Recent content by ambra19

It works, thanks Brian!

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

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.

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

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

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

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

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

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?

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

It worked. Thanks again Transcend. ambra19

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

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

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

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