Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gmmastros on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. rhicks

    Getting the most recent date.

    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
  2. rhicks

    Can you hide the database window?

    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
  3. rhicks

    Calculator control?

    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
  4. rhicks

    DateDiff function-HElP!

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

    Form opens at startup but cannot access tables, or open in design view

    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
  6. rhicks

    wizard not working

    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
  7. rhicks

    Date Modiefied

    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)...
  8. rhicks

    Automatic Date

    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...
  9. rhicks

    &quot;Dumb&quot; Font Question

    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
  10. rhicks

    How to Enter a New Line in a Concatenated Line

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

    Form is Main

    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...
  12. rhicks

    Print Specifaclly

    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...
  13. rhicks

    Cracking Passwords

    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...
  14. rhicks

    Cracking Passwords

    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...
  15. rhicks

    How many controls on a form? 256. Controls on subforms count?

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

    How many controls on a form? 256. Controls on subforms count?

    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...
  17. rhicks

    Placing a sum from a control box into a table.

    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...
  18. rhicks

    Loss of Wizard

    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
  19. rhicks

    Using 2 versions of Access

    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...
  20. rhicks

    Using 2 versions of Access

    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...

Part and Inventory Search

Back
Top