Search results

You always hope that when you ask a question - it has a difficult answer. Not an easy one that is staring you right in the face. Can't believe I missed this. Thanks!

I have a column of numbers: 15, 22, 11 etc I need to be able to have Excel go back and put a decimal point after the first number in each cell. There are about 600 entries and I don't want to have to physically change it to 1.5, 2.2 1.1 etc. Any suggestion?

Did you find the solution to this? Any other info you can add, as it works great for me.

Do you have vs XI? There is a function in the repository that already calculates without holidays and without weekends.

It is filtering a form - based on a query. I've looked at the filter property, to filter on one field, but with the three options I need the user to be able to choose from, can I include those in the filter property?

The code to check the option group is on a button called Search - the onclick event I went ahead and put it also on the after update event of the group. No luck. I can't help but wonder if there is a command in 03 that 07 doesn't like. Just can't figure out what it would be By the way - thanks...

filter code in Access 2007 Thanks. I agree, I would use Case Is - but this is someone else's code and he won't let me change it (because he isn't familiar with that statement) So I am limited. I have figured out that the first time I choose an option button - the filter works. But for some...

Has anyone had this issue: I make changes to the font, choose default, say yes to the prompt to save the Normal.dot, yet next time I get into Word (after closing it) the changes to the default font are not retained. This is in Word 2007. For some of my users, the change sticks, for others it...

I had code written in 2003 that works fine. It doesn't work in 2007. It is code that filters my query In a form I have an option group (to choose which field to filter on) An unbound control - (txtKeyword) they type the word they are looking for then click the option button of their choice...

keeping gh and detail together Yes, you can In design view - right click on your group header (the gray area, not the actual section) Go to Change Group Click on Options tab Choose the keep together option