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!

Register Log in
  • Congratulations derfloh 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: *

  • Users: tomcat21
  • Order by date
  1. tomcat21

    Disable Shift Key at Startup

    faq181-143 is where I got the above code from but I can not get it to work. Thomas Bailey www.reportcop.com tomcat@reportcop.com
  2. tomcat21

    Disable Shift Key at Startup

    I found the following code to Disable and Re-Enable the shift key at startup. To Disable I have: Public Sub DisableByPassKeyProperty() Dim db As Database Dim prp As Property Set db = CurrentDb Set prp = db.CreateProperty("AllowByPassKey", dbBoolean, False) db.Properties.Append prp End Sub To...
  3. tomcat21

    Picture in a Form

    What's the best way to store a photo in a form. I currently have an OLE object in a table and the form attached to that. Problem is, it bogs down the database bad. How do you store the phot somehwere else and just store the path in the database? Thomas Bailey www.reportcop.com...
  4. tomcat21

    DCount to Limit the Number of Records

    Also, I modified to instead of =50, to >50. Plus, it works great from the command button on the Main Switchboard, but it still opens from the database window. Of course I will hide the database window on Startup, but doesn't it still go to it by holding down the shift key? Thomas Bailey...
  5. tomcat21

    DCount to Limit the Number of Records

    GREAT, I got it to work. How would I do the Warning part? Thomas Bailey www.reportcop.com tomcat@reportcop.com
  6. tomcat21

    DCount to Limit the Number of Records

    First of all, I apologize for the many posts relating to this, but I have searched as thouroghly as I can and I am drawing a blank. I am trying to protect a DEMO application that I send out to prospective customers. I have it to where it shuts off after a certain date but I also want to limit...
  7. tomcat21

    JAZZZ - Limit Number of Records?

    I added a field inside my Table named uses; I added my Table name. What is the Other Field? Also, I am attempting to place the code in the On Click event of my command button on the switchboard. Is this right? Thomas Bailey www.reportcop.com tomcat@reportcop.com
  8. tomcat21

    JAZZZ - Limit Number of Records?

    What you want to do is add the dlookup code to whatever form you have opening and then include a message that your trial period has expired. I have code that does all this if you need it let me know and I will post it all. JAZZ: Would you please post your code for this? I am trying to use the...
  9. tomcat21

    Access DEMO - Limit Records

    ...this. Public Sub CountRec() Dim rst As Recordset Dim db As Database Dim rec As Integer Set db = CurrentDb Set rst = db.OpenRecordset("Select * from [MyTableName]") rst.MoveLast rec = rst.RecordCount If rec > 50 Then MsgBox "You have exceded the number of entries in this demo_ " Edition...
  10. tomcat21

    printing current record

    Try this: (If this is close to what you are asking): Create a Macro and name it say; Print Current Record. In the first Macro Action line select: RunCommand and in the command line select; SelectRecord. In the second Action line select; PrintOut and in the Print Range line select; Selection...
  11. tomcat21

    Open Form on New Record

    If you are wanting to automatically open the form to a new record; In Form design, create a command button to open a form; in the On Click event, select Event Procedure; then type in the following; DoCmd.OpenForm "FormName" DoCmd.GoToRecord , , AcNewRec Hope this helps. Thomas Bailey...
  12. tomcat21

    Windows Version!!!!! - QUESTION?

    I created a package using P&D in Windows 98. I have since upgraded to XP. I then created the same application in P&D with XP. The earlier package loads fine on a Windows 2000 system. The latter (XP package) does NOT load automatically on the same Windows 2000. I have been scratching my head...
  13. tomcat21

    Cannot change Admin password

    If there is an existing password, you will need to know it to change it. If it does NOT have an existing password, leave the old password line blank and just fill in the New and confirm lines. If all this fails, you could try deleting and reinstalling Access. It will all depend on the extent of...
  14. tomcat21

    Application Setup Problem!!!!

    I distribute an application using the Runtime P&D. It has been working fine for years, but now I have a problem. After I package it, I double click on the setup and It tells me my System is out of date and need to restart. I restart and nothing changes. The Runtime setup installs fine but not...
  15. tomcat21

    Access DEMO

    I get a Compiled Error on this line: Private Sub Form_AfterUpdate() Thomas Bailey www.reportcop.com tomcat@reportcop.com
  16. tomcat21

    Runtime Setup!

    Okay, I'll try that. I had reloaded Office 2000 Premium and 2000 Developer and it did not fix it. Hopefully that dll file will fix both problems. Will let you know. Thomas Bailey www.reportcop.com tomcat@reportcop.com
  17. tomcat21

    Access DEMO

    I distribute an application as a DEMO and as an .mde file. I use a Date that is located in a Module to restrict access after a specified date. My worry is that the user can just back date their computer to get around this. My question: What is an EASY way to limit the number of record entries...
  18. tomcat21

    Runtime Setup!

    I have been using the Package and Deployment of Access 2000 developer for quite some time with no problems. All of a sudden I am getting an error message when trying to install on a user. The application setup itself tells me the system is out of date and needs to be restarted. Restarting dose...
  19. tomcat21

    Running an Access Database without having Access installed on a PC

    Go to Ebay Item number: 3676171084. It is a Brand New version of Office 2000 Developer Edition still shrink wrapped. Thomas Bailey www.reportcop.com tomcat@reportcop.com
  20. tomcat21

    Send Keys!!!!!

    I used "Send Keys" years ago to tansfer data from a field in one form to the same field in the next record. I can not find it. Wouild someone please supply me with the corrrect Send Keys code. Thanks, Thomas Bailey www.reportcop.com tomcat@reportcop.com

Part and Inventory Search

Back
Top