Search results for query: *

Does anyone know what causes the error message "Cannot shift objects off sheet" in Excel? The help system has nothing on it. I get the error when I try to hide details in groups by using the little 123 grouping buttons in the top left corner. I'm not sure which objects it is trying to...

I have two ranges, one call PNames and the other is Sch_Date. PNames goes from A2:A10. Sch_Data goes from D2:J10. I'm trying to code a line in VBA that will look at the value in A2 (to see if it has the word Total in it) and if so will then conditionally format the cells in Sch_Data that are...

I've created two buttons. One adds subtotals to a worksheet and conditionally formats the sheet to highlight any totals that don't add up to 100. The other removes the subtotals and resets the formatting to normal. The reset option is working fine, but I can't get the function that formats...

I thought there would be an easy way to insert a row and keep the formulas from the rows above, but if there is, I haven't found it. No faqs or previous posts seem to have covered it. What is the best way to do this? It's funny that conditional formatting does seem to work for newly inserted...

I'm trying to build a dynamic list that functions as follows. A normal list with the numbers 1 through 6 enters a value into column A. Another list in column B needs to look at the value in column A to be able to present a subset of options that only purtain to the value in A. The various...

I've got a range defined that includes a series of groups that were created manually. I'd like to be able to Show Details and Hide Details for all of the groups in the range (or in the entire worksheet) at once. Does anybody know a fast way to do this in VBA code? I'll be using it in a...

I'm trying to create a "visual scheduler". I have a series of narrow columns each of which represents one day in a calendar. Down the first column I have a list of names of people who will be assigned to projects on specific days. Above all of this I have several rows that show the project...

Does anybody know of any good tools for tracking people working on projects by their specific skills? An MS Project add-in or even an Excel spreadsheet might do the trick but I haven't found one yet. My scenario is that I have a pool of developers working on multiple projects which make up...

This is really basic but I'd appreciate some help. I have a table called tblDetails that has a field called QorA, which holds either the letter Q or the letter A (big surprise, eh?). The field defaults to Q as per the table setup. Whenever data is entered into that table using a certain form...

Is there an easy way to create popup text boxes for Visio shapes? I've saved some diagrams as HTML files and added DHTML effects to do this. I was just wondering if there is any way to do it directly within Visio using the native file format? Thanks..........Dan

I've been trying to pick up Access development in my spare time. I used to do a lot of dBase, Foxpro, Rbase and C programming but that was over 10 years ago. I bought the Access Bible but find it very poor quality with regards to real world practical samples, and it barely touches on...

This is weird. I've created a form thatI want to use to add new data or edit existing records. Using a combo box I want to select customerID and then have cust_name and cust_address show up. All info is in the same table. Access will let me choose a value in the combo box but it doesn't...

Is there an easy way to filter records in a form based on a selection from a combo box? I have a table called tblSystems. I want to choose a sysID from it using a combo box. I then want this selection to populate the other fields from the same table on the form. Lastly, tblSystem is linked...

I was trying to use the Northwinds example to model the tables for a database I need, but the Northwinds database seems to suffer from the same problem I'm having. In the Order form for Northwinds, you select a customer from a combo box and it brings up the details in a subform. If you then...

Here's a generic description of a problem I'm facing. I want to track support requirements for different items. Each item requires different numbers of support widgets, gidgets, gadgets and baskets when used in different environments. There are 7 environment types but more could be added...