Search results

Have you tried DoCmd.Maximize in the OnOpen event of the form?

Good question RG!!! I should be in bed! I tend to check the forums just before I go to bed but because of your reply I started to implement the new calendar into all of the forms I needed it in. Then I just got sidetracked! Its now 03:54am - I have a shed load of work to do today - I'm...

Well I certainly appreciate it RG. I had a look at your profile Sir - a man of your experience is invaluable to a forum like this. May you continue to inform and enlighten those less versed in Access than you...

RG - you are becoming somewhat of a saviour of mine! Many thanks my friend - you are right, this seems to work at any level of nesting. This isn't the first time you have helped me and it certainly doesn't go unnoticed! Once again I am in your debt. Cheers RG - you are a star!

I have used the Calendar created by Brock W Denys that works within subforms (see attached). Its a great calendar and I am very grateful for the use of it. However, it only works for forms and subforms. Unfortunately I need it to work in a subform within a subform within a form! I am as good...

so how doesn't Robert88's example help?!

Thanks UG, Rich & Lagbolt - these are exactly the sorts of thing I am after, Cheers guys!

Thanks for the pointers UG. Will check them out in due course....

No I haven't tried the MoveSize method yet. Firstly, since Autocenter should work I would much rather it do the calculations for me! Secondly, most of my other forms do centre automatically so there is a reason why one or two of them don't - that is what I am looking for suggestions for. I...

I am a complete newbie to vba and I am sure I end up writing far more code than I need to. For example I needed to disable all but one control on the oncurrent event of a form and so I wrote: Me.controlname.Enabled = False Me.controlname2.Enabled = False etc etc I did this for 13 controls...

Yeah - I thought it did but I can assure you at least two of my forms are not centering vertically (see attachment - I have blanked the forms due to sensitive info!). It may well be that I have done something that may have affected things but I can't think what that could be. Any suggestions?

Thanks RG - thats the exact article I read that persuaded me to turn off the autocorrect! I don't understand why I get the error message though. Everytime I create a new file and import it always occurs (but only roughly after 5 open/closes). Strange.

Why is it that auto center doesn't auto centre? Yes it centres horizontally - but not vertically. Does anyone know how to actually center horizontally and vertically i.e centre!? (I have used both spellings in order to appeal to a larger audience!)

This only started to happen when I created a new file and imported the entirety of the old mdb into this new file. The only reason I did this was because I had read some article about minimising the possibility of corruption and the advice included turning off the name Autocorrect as it was...

When I exit my application I sometimes (about 1 in 5 times) get an error message (see attached jpg). This doesnt make any senese to me as I am closing my application NOT opening it. Is this happening because my mdb is corrupted? (I compact and repair on close)

This might be what you are after - however don't ask me how to use it -I dont know!! Good luck.

Click this link for another way http://forums.devarticles.com/microsoft-access-development-49/how-to-make-autonumber-to-start-with-value-11658.html or this one: http://www.mvps.org/access/tables/tbl0005.htm

You should try an Excel forum - http://www.vertex42.com/ExcelLinks/cat/excel-forums-1.html And try to be more specific with your questions! Good luck

what I do is put something like the following into the On Enter event of any other controls on the form (you neednt add anything to your command (exit) button). I am not sure if this is the most efficient way but it works! Private Sub Text2_Enter() If IsNull(Me.Combobox) or Me.Combobox = ""...

I put runsum = runsum + 1 in the on click event of the command button and everything appears to be working as I wanted. Thanks for the guidance Pat. Matt.