Search results

Yes I just figured out how they have presented things in Help. Occasionally I would stumble on randomize then couldn't find it when I wanted it. Unusual but I guess it fine tunes things a bit. Any suggestions on what I should put in the [number]. ie Does it matter or can it be anything that...

PH Thank you for your assistance. I had found and tried the following in help, might I say with negative results; Randomize Statement Example This example uses the Randomize statement to initialize the random-number generator. Because the number argument has been omitted, Randomize uses the...

Sometimes Access can be fustrating. I have added Randomize to the form Open Event and then almost every other event plus used recalc at a variety of places as well,but still no luck. I've read almost every post on randomize but haven't been able to solve my small problem. Should Randomize be...

Thanks for your assistance. Where should I use randomise() to ensure it works?

I have a small unbound form which has a txt box with code something like =Rnd((20-1+1)*Rnd()+1)) to generate random numbers. When the db and form are first opened the field always contains the same number. Using F9 to refresh will generate another number but it is always the same too. If the...

Fullerm40 I'm not sura about setting the zoom to exactly 72% but a quick way to get close id to open the Report Properties and select the Auto resize to No. Then deag the Report sides to whatever size you want and save. If you want it to self center then before you save select the Centering to...

For what it is worth I have done the change 97, 2000 then 2003. In my opinion 97 was ok, 2000 not so good and 2003 great. Backup your 97 files just in case you don't like 2003. I don't think you will be disappointed.

I have Microsoft ActiveX Data Objects 2.x Library selected (ticked) already. I've searched most if not all the notinlist posts and tried most of the "tricks" but the ADO eludes me. The best I could do was to get the notinlist message box to appear with a following message "List Mismatch". I'm...

I added the notinlist event to an unbound combo (I use access 2003) and used the ADO code but no matter what I try I can't get it working. Out of desperation I substituted the DAO code and "bingo" I have a working combo which adds any data I type in etc, no errors no problems. My question now...

Thanks Uncle G.. I have followed your suggestion and done some edits and have things under control (for the moment ...lol). I hadn't realised that unbound combo's can be a little different in error behaviour to combo's based on tbls or qrys when it comes to using NotInList. Small as it might be...

I thought I would "jazz" up some of my dull old forms yesterday & started out using the AutoFormat button on the Access toolbar. It is a nice feature but I noticed that after completion of one or two small forms the size of the Db was starting to blow out. While the "bloat" wasn't too big I...

One Off Error I have the following in the after update event in a Combo bound to a tbl on a Main form; Sub Combo8_AfterUpdate() ' Find the record that matches the control. Me.RecordsetClone.FindFirst "[Vendor] = '" & Me![Combo8] & "'" Me.Bookmark = Me.RecordsetClone.Bookmark End...

RichO Thank you once again. When I tried it I had the 7th January but a quick reversal of the 1's & 7's and everything is working well. ;)

I have tried using the following to give me the most recent 1st July; =DateSerial(Year(Date())-1,7,1) It works ok until I get to the 1st July in the present year then it gives me the 1st July for last year. What will give me the most recent 1st July?

RichO Once again thank you for your assistance. With your help I have it all working 100%. ;)

What about a field where Nulls ? Could I use; If Me.Myfield.value=null then......

RichO Thank you. I had tried your suggestion and for some unexplained reason it didn't work, however after reading your post I did it that way again and of course it works. Thanks again. ;)

I wish to format Foreground in a Text only field. I have done it many times using Values but can't get it going for Text. eg. say a field containing names = AN60, I might want the forecolor to be Red. I have tried something like this; If Me.MyDateField.XXXX > AN60 Then Me. MyDateField.ForeColor...

I haven't had the problem of getting the date into more than one sub at one time. I've only had the problem not getting any date in any sub date field. have you tried Old Soft Boss's suggestion ?

Have a look at OldSoftBoss's suggestion. It is very quick to implement and works 100% on all forms & subs. Anyway copy & paste this; http://www.access-programmers.co.uk/forums/showthread.php?t=62606