Search results for query: *

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.

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

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

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

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

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

I am having a problem with saving dates to my database via my VB 6 application. I have dates automatically put into a textbox when the user clicks "Add notes" When the button is clicked, the following happens txtNDate.Text = Format(Date, "yyyy-mm-dd") It shows up in the...

I am looking to have my Access 2000 db automatically send out an e-mail warning saying that an important date is coming up (380, 367, 365 and 180 days in advance). Also, how can I get Access to calculate the days? Any help is greatly appreciated. ambra19

I have a form where there is a list box. It contains file numbers. I click on the file number, it displays information that can be edited. New files can obviously be entered too. So this form has Add, Edit, Save and Cancel buttons. Each file, can be bought and sold several times. I need...

Hi, I would like my VB 6 application which uses an Access 2000 database to be installed on a network in order that several users can use it. after compiling, where do i put everything (the dlls and the database)? Thanks.