Search:

It seems that the subtotal command no longer works when you use Microsoft Query to dump out data to Excel. I've dumped data to a table and the subtotal command under the outline group is greyed out....

I added a new local user to a laptop. I want this user to be a PowerUser but they don't seem to have the permissions of a PowerUser on files that are existing on the laptop. The only way I can get...

Thanks, Steve!

Good point! I'll let the programs people know and see what they want to do...I don't think that they have thought of that either.

Thanks!

Hey, thanks anyway, Jerry. The more variations I get, the more I learn for next time...nothing's wasted...so Thank you!

Thanks again, Hans...(for this VBA version). You are truly an Excel guru :-)

Thank you very much!!

It seems so simple now that I look at it...why couldn't I think of that :-)

I really appreciate your help!

This spreadsheet will be going to users who don' t know VBA at all (I know a little) so the Excel version would likely be best.

If you have the time, I would like to know the VBA version as...

I have a spreadsheet of exam marks. It calculates the average total mark for 4 exams. Because of some issues with Exam 4, everyone who has an overall average between 50% and 59%, automatically...

We have a database that has a first name and a last name in once cell, separated by a comma. Is there any formula that will let us separate the first name and last name into two separate cells. I...

Thank you! That was my problem (I obviously have not done this for awhile :-)

Thanks again

Christa

I'm trying to assign a macro to a command button on a spreadsheet...however, the "Assign Macro" command does not come up in the short cut menu when I right-click the button...how come?

Thanks,
...

The hosts file?...how do I do that?

Thanks,

Christa

Hi,

I have one workstation in the office that suddenly can't access any Yahoo sites. Other workstations have no problem so I know it's not a firewall issue. We've tried rebooting the machine,...

You are a lifesaver!!! Thanks!

I've figured it out...the formula works as long as there is already a record for the particular item in the Used table. If there is no record in the Used table for the item, the quantity on hand...

A stripped down version of the database is attached. Thanks for all your help.

I don't get any error messages...the field just remains blank.

Thanks,

Christa

This morning I copied the formula you send into the Control source of a new text box and the quantity on hand came up...it worked perfectly!...however since then I've added some macros to open forms...

Thank you so much!!!

In the attached database, I would like to have the quantity on hand (On_Hand field in the On Hand query) appear on the 'Used' form. The quantity on hand should correspond to the description the user...

Thank you very much!

I would like to do a query/run a report on our database that groups transaction records based on the customer ID number. I would like all records to be summarized into one line per ID number and...

Hi Wendell,

What you are describing sounds great and it's a goal that I would like to get to. The reason there is more than one table for inventory is because I was experimenting on how to get...

I'm building a database for inventory. This is my second go around. I've created a form that works well to enter new inventory items (see attached database). I then built a query that concatenates...