Recent content by rhicks

I think he will need to Group by the field that identifies the person .. then select Max for the date field in the Totals query. RDH Ricky Hicks Birmingham, Alabama

In Access 2000 or 2002 .. trigger the following line of code in the first form that opens in your app. Application.SetOption "ShowWindowsinTaskbar", False HTH RDH Ricky Hicks Birmingham, Alabama

See if the one at the link below will work for you. http://www.utteraccess.com/forums/showthreaded.php?Cat=&Board=codearchive&Number=110298&page=2&view=expanded&sb=5&o=&fpart=1 HTH RDH Ricky Hicks Birmingham, Alabama

DateDiff(&quot;yyyy&quot;, DOB, Date) + (Date < DateSerial(Year(Date), Month(DOB), Day(DOB))) RDH Ricky Hicks Birmingham, Alabama

Hold down the Shift Key on your keyboard while opening the db. This should bypass any Startup options you have set. HTH RDH Ricky Hicks Birmingham, Alabama

Go to the location below for an explanation and a fix. http://support.microsoft.com/support/kb/articles/q242/2/18.asp HTH RDH Ricky Hicks Birmingham, Alabama

You can do this at form level. Place a txtbox on the form (it can be hidden if desired), set the Control Source for the txtbox to a Date/Time field in the table to store the info. Use the form's Before Update event to populate the txtbox. Private Sub Form_BeforeUpdate(Cancel As Integer)...

The problem may be caused by your not declaring the &quot;Datatype&quot; for you variable. You have: Dim MyDate If you do not declare the datatype for the variable Access will assign the datatype as a &quot;Variant&quot;. This could be causing the problem ... Access could be evaluating...

Access will substitute a font for any font not installed on other machines. You must include and install the font on the other machine if you expect the font to be the same as you used in your design. HTH RDH Ricky Hicks Birmingham, Alabama

Try the following: &quot;Your First Section of Text&quot; & vbCrLf & &quot;Your Next Section of Text&quot; HTH RDH Ricky Hicks Birmingham, Alabama

You don't say what version of Access your are using. Here is a way to fill a ListBox on a form with all the Reports in your Database using DAO. If you are using Access 2000/2002, you will need to enable Microsoft DAO 3.6 Library and alter the code slightly to get it to work. Private Sub...

If you are sending your reports directly to the printer (not previewing them), here is a way to get the Print Dialog Box to show so you can choose the printer settings. You will notice that the report is opened acPreview but don't worry, it will not become visible on screen. Just follow the...

Christopher ..... If you indeed are authorized to open this secured database, I will be happy to give you hand. If this is Access User Level Security ............ Hopefully you still have a copy of the security file (.mdw), if you don't ... you are in trouble. Email me a copy of the .mdw...

I've been using Passware from lostpassword.com for a couple of years. They have a package that will break the passwords on most any program that uses one. It will give you all the information stored in the .mdw security file (Group info and User Passwords). This covers &quot;Database Level&quot...

You are welcome ..... :-) Happy Holidays, RDH Ricky Hicks Birmimgham, Alabama