Replies

Correct, the 36,000 row table had one row for a Store with 52 columns of weekly sales data.
The 1millon plus row table had one row for each Store / Week combination with a column for the sales data.

I typically go for the normalized option as well. Just 1 million rows seemed like a lot, so I wanted to double check with folks that have more experience than I.

Thanks

Thanks.

That is where I was headed, but with that many rows I wanted to get some other views.

Many thanks.
This will help a lot.

I will give this a try.

Thanks for you help

That is the issue. The sheet does get Protection set = true. I do have both Locked and unLocked cells on the sheet. As I did not create this, the style was set before I got it. I to do something similar with the fill for unLocked cells.

I was hoping for a simple way to find all the locked cells, but it seems if I have both on a sheet, I will just have to check each cell individually.

Thanks to everyone for your feedback.

Set the ControlSource of the combo box to be the CityID field.

You could build a for loop that would loop through the tables collection. Inside the loop you chould have a SQL statement that would look for the requested value and if found update a text string. When the loop completed the text string would be the list of tables containing the search value.

Maybe not the best solution, but with so many tables it would work. Also, you would not need to update the code if tables were added.

Hope this helps.

Are you looking for a results set or just the names of the tables where records were found?

Thank you, I will check it out.

Found it.

Thanks

No, I think I misstated. We are not wishing to change the name of the control, just the contents of the control. txtDate_1 would always be txtDate_1, but depending on the month selected by the user, the contents would change.

This will be a repeaative task. We are building a grid on a from and depending on the month selected would like for the text box at the top of the grid to show the date for that square.

I will take a look at the Object Model and see what we can come up with.

Thanks for the help.

This should do the trick. The inventory date should never be a Sunday.

Thank you for the help.

Have you tried the Conditional formatting?

HA, I found it….

I opened the Contorl Toolbox Toolbar and set the workbook to Design mode. This allowed me to select and delete the form objects.

GREAT.