Search results for query: *

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

The limit is 754 for each form. Each time a control is added to the form the control count increments by 1. If you delete any controls from the form this number does not reduce .... even if you compact the db. So when the accumulated total reaches 754 you will receive an error. The only way to...

Haitham, this is very bad advice ..... Both Marquis and Jerry could have easily told him how to save the result in the table. But as both replied &quot;it is not the proper thing to do&quot;. This breaks the &quot;Rules of Relational Database Normalization&quot; and will almost always come back...

This is a known problem in Access 2000. Go to the location below for info and a fix. http://support.microsoft.com/support/kb/articles/Q242/2/18.ASP HTH RDH Ricky Hicks

You should have been able to rename the file unless you had a program open that was using the file at the time. Make sure all unnecessary programs are closed and try to rename it again or just try this next procedure. Check and see if this is the article you are refering to...

I have Access 97, Access 2000 and Access 2002 on my machine and have very few problems. The key to success is the order of installation. Follow the lonk below, this should give you all the info you need for the two versions you speak of...