Recent content by SmallTomato

Thank you for your reply. I believe that solution is when the tab control does not roll over to a second row. My tab control rolls over to a second row perfectly fine, what I want to do it make it start a second row before it would automatically do it. I went ahead and just manually set the...

How can I manually make new tabs appear on the second row when they normally would not? I want to force some tabs onto the second row of a multirow tab control

Well the forms are all pivotcharts. If I split my pivotcharts in two Reports (full size with Can Grow: No) and use those as subreports in another report everything works fine. This work around is sufficent for my issue, thanks!

I have a report with several forms, these are all graphs. In order to fit them all on one report, I need them to be able to grow. This works fine in Report View, they grow as expected, however when exporting to PDF, printing or print preview, they do not grow. I set them all to Yes for Can...

On my forms OnLoad event I am trying to set the pivotcharts marker shape with the following: ChartSpace.Charts(0).SeriesCollection(0).Marker.Style = xlMarkerStyleSquare However, it causes my markers to disappear completely. Can someone advise what I am doing wrong? Hm, just noticed...

Federal law is the law in every state, each state can have laws on issues not addressed by the federal government and laws explicitly left to the state by the federal government. States in some cases can have laws that work off of federal law (for example, federal minimum wage is x, a state can...

Here is Microsofts post concerning it: http://office.microsoft.com/en-us/access-help/remove-user-level-security-mdb-HP005188240.aspx

So in the end, you have a 2/3 chance of it being a 100% chance of a red dot on the other side and a 1/3 chance of it being a 0% chance of a red dot on the other side. It's 2/3rds. :)

Think of it this way, what are the odds the dot facing up belongs to the Red/Red card compared to the Red/Blank card.

I change my answer to 2/3 now that I had time to sleep on it. Yes, your first outcome is already decided with 100% probability (red dot facing up). However, for 50% you're assuming the odds of it being the Red/Red or the Red/Blank are 50/50. They are not. Since you are MORE likely that the...

We all know this is the inverse of your Blood alcohol level^1-colorblindness factor/42. 42 being the car color constant.

It is 50%.

I would think it is set to open with Adobe because someone on the computer associated the .laccdb filetype with Adobe Reader. By default, a laccdb locking file is used with accdb databases. There is no reason to change anything. .ldb was used with .mdb databases. By default, it will open with...

All I am doing is running a make table query that combines information from tables where all the values are set to number and wrapping them in nz(,0) but my make query makes every field text. Any simple reason this would happen? Or am I just wrong and somewhere something isn't what I think it is?

Yeah it is text grrr. Thanks, I didnt even think to check.