Recent content by avcastner

Just tried it. It won't work because the randomization requeries and resets the filter. I think I really need to set the criteria in the query. Can anyone show me how to do this specifically? Thanks, Allison

I'll see if this works. I think it just might. Thank you so very, very much! Allison

for future reference when searching and replacing special codes in Word: hard page break = ^m section break = ^b line break = ^l paragraph break = ^p em-dash = ^+ en-dash = ^= tab = ^t hard (non-breaking) space = ^s

Have her turn on the bullets and then go up to the styles group. Right click on the style that is currently highlighted and select "Modify Style." You can change any of the formatting in the this style and save it. My guess is that someone removed the indentation on this style and saved over...

Sounds like you need to put the code in the "Update Form" module as well. Make sure that you actually move from one record to another when you scroll, otherwise the update won't register, as the record will not have saved since the change to DOB.

Even with the lines of longitude, Reno is further west of Los Angeles.

I use a form. The question and the answer are in the same table. I hide the answer and have a command button to unhide it (helps me review while I quiz with the kids). I want to change the criteria in the query, not update a field in the table or in the query. I would like to be able to...

So true. I was thinking Southern Nevada, actually (Vegas), as opposed to Reno.

My favorites (I have so many, I break them up by types): Christmas song: Silver Bells Christmas carol: Carol of the Bells Christmas hymn: Silent Night, Holy Night Winter Songs: Winter Wonderland and Little Jack Frost, Get Lost, Get Lost Christmas Memory: going to my Auntie Hilda's on...

Pbaldy, thank you, but last I checked Nevada is east of me. ;)

Knowledge puffeth up - so realize that you will never know everything there is to know about Access - and if you ever do, then Microsoft will come out with a new version, changing the names of keywords and grandfathering your favorite features.

I just started watching the new show on Amazon Prime. I really like Christopher Eccleston as the Doctor, but I am not so sure about David Tennant. Still, it is a great diversion. I am in the middle of Series 2 (Season 2 for US), and my favorite episodes so far have been the The Empty...

I have written a database that randomly selects questions for a Bible Quiz tournament. However, we are limited to no more than 4 of one type of question per round. Until the 4th question is asked the criteria parameter remains blank. Once the 5th question has been asked, then the criteria...

I would split the addresses and contact names into the actual address and name parts. Your database will morph eventually, and the more the data is split into it's own fields the better. You can always concatenate in reports and such, if necessary. You could create a drop-down for the county...

What do you call an intelligent blonde? a golden retriever (P.S. I'm blonde, so I'm only hurting myself with this one.)