Recent content by Alvinwhit

  1. A

    Barcode scanning Example

    oH Really???
  2. A

    Update Notes with datetime stamp using memo fields

    I have the same problem I would like to use one text box to enter information and the other to store the information. So once I press enter the notes will populate in the other text box and be locked so to speak. I would also like for it to have a date stamp and a username stamp so that I know...
  3. A

    Max records in a Table

    Okay, never mind I figured it out. Thank you for your help.
  4. A

    Barcode scanning Example

    Hello, I would like to know if this could work for scanning credit cards, if so what changes (if any) would I have to make?
  5. A

    Max records in a Table

    Thanks, I'm not sure I follow though, I have a table with a member ID field that is set at Long integer. I need for access to disallow new entrys after the number of records on that table is at the desired max. If this is not possible is there a way to create a Code that will publish a msgbox...
  6. A

    Max records in a Table

    Is there a way to limit the amount of records that are on one table, for example, if I only want ten records to be on my table at any given time, what can I do to prevent users from adding more than ten records to that table?
  7. A

    validation rule error

    Thanks soo much worked like a charm!:D
  8. A

    validation rule error

    I gave it a try and I got a Compile Error Message Expected Expression: With this line highlighted Private Sub Form_BeforeUpdate(Cancel As Integer) I'm new at this you, can probably tell it by now.
  9. A

    validation rule error

    Thanks so much I'll give it a try.
  10. A

    validation rule error

    I am trying a validation rule using VBA for my Date of Birth field, however even if the field is valid I get the msgbox message I put in the code. Plese help. This is the code. If (DOB.Value < 1912) Or (DOB.Value > 1994) Then MsgBox ("Date is Invalid, Member May Not Qualify Or A User Error...
  11. A

    Re: Hyperlinks - Linking to Objects in Database

    Re: Hyperlinks - Linking to Objects in Database Okay no prob. I don't even know how to do a screen shot, but i'll give this another try, then try to figure the screen shot out. In my database members are separated by teams (there are seven). So I also have Seven separate tables (I know that...
  12. A

    Re: Hyperlinks - Linking to Objects in Database

    Re: Hyperlinks - Linking to Objects in Database Yes, and thanks for answering my post. In my database I have a Member Information Table. Each member has a Member ID and each member has An Associated Member/s. (Member/s who they have invited) The associated member field (anothers members ID...
  13. A

    Re: Hyperlinks - Linking to Objects in Database

    Re: Hyperlinks - Linking to Objects in Database I have been having the same problem. I have Access 2007 and I use to be able to Hyperlink to an oblect in my database 9no upgrade0 But suddenly this option is not available. What can I do?:rolleyes:
Top Bottom