Search results for query: *

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

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

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

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

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

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

I have code to relink tables to the front end from a command button on my switchboard. It deletes all table, then relinks all tables; but you have to know the path. I also have code to automatically look for the back end on startup, but it only links tables. I would like for the code to be...

I have been distributing my Access application for quite some time using Package and Deployment (Runtime). The Runtime has been installing fine all along. All of a sudden, I am getting an error trying to setup my app using the P&D. When I package my app., I now get a file (msado21) that is...

I was supplied with some code to edit my existing code to automatically link tables on startup. The Thread # is 705-824349. MNDRLION told me his code was an alternative to my RefreshLinks Function. I am not very good with code. I got it to delete the tables but it would not Relink them. I am...

I have posted this before but did not get a response. I would appreciate any help. I use the below module to automatically look for the Back End on Startup. It works great. If the back end is not found, it opens a window and allows the user to navigate through the folders and select the back...

I use the below module to automatically look for the Back End on Startup. It works great. If the back end is not found, it opens a window and allows the user to navigate through the folders and select the back end. Problem is it does not automatically link any NEW tables that are added later...

I am brand new to Access Security. I have an application that I distribute as an .mde file using Runtime. I pretty much have the security working like I want as far as log on and passwords. When I use the security wizard, it creates a backup, a secure icon and a secure file. The only way I can...

I use the below code to automatically link the Front End to the Back End on Startup. It works great. If not linked, it opnes a folder on startup and lets the user navigate through the folders and selct the Back End. BUT, I would also like for it to first DELETE ALL links and then restablish...

I know absoultely nothing about SQL. I have an app that I distribute using the Runtime P&D wizard. I distibute it as Front End and Back End. It automatically checks for Table links at startup by open a Windows Open Folder and lettinf the user navigate through the folders and select the Back End...

I need to be able to re-link Tables in Runtime. I package an .mde file using Access P&D. I need an easy way for the Front End to Re-Link to the Back End once installed on a client's server. I understand it can done with code. Problem is, I know very little about code. If code is provided...

I have a prospective customer that approximately sixty (60) users. I package my application using the Package and Deployment of Access Developer. I want to distribute using Access Runtime. If I package it at home, how do I package it so that the Front End can find the Back End on THEIR network...