Search results for query: *

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

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

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

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

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

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

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

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

I distribute an Access Demo and I want to limit a user to no more than fifty (50) record entries in each form. I have tried the below code that was supplied to me, but I can not get it to work. I am NOT good with code. I would very much appreciate an EASY way to do this. Public Sub...

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

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

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

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

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

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

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

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

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

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

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