Recent content by lilFlip

Yeah, drop this function in a module somewhere in your project... Private Declare Function GetVolumeInformation Lib "Kernel32" Alias "GetVolumeInformationA" (ByVal lpRootPathName As String, ByVal lpVolumeNameBuffer As String, ByVal nVolumeNameSize As Long, lpVolumeSerialNumber As Long...

Doc Man... Thanks for the information.

Gaz, Thanks for the reply. I'm not too worried about them modifying the contents of the db other than through the established forms. I have implemented the Security outlined through another thread on this forum provided by Mr. Len Boorman (I must say that it was quite easy to do with his...

Hello, I have a database that will be installed on a network server and then accessed by the client workstations. I want to be able to lock down the db to that particular machine, so that the client cannot port/copy the db to any other machine and then run it from there. Is this possible to...

I know that this thread is pretty old, but i have a question along this line. I have inherited an Access application that has all the forms/macros/queries/tables in one mdb file. We added our own Login table which contains employee data in it. We added a splash screen which allows them to log...

OK, figured it out for myself...sorry for all the bother...

OK, nevermind I figured out how to do it with Mr. Allen Browne's help.... he has all kinds of wonderful articles and writeups.... BUT, HERE is the next item. If I have code that needs to go into every form, is there a quick way (similar to searching through them) to paste it into the code...

Is it possible to loop through all forms within a project and look at its controls? I was requested to change some object names to a more generic name, but I would like to find all references of the form within the Access application. Is there an easy way to do this? I know that the...

Dave, Thanks for the information. I believe I might have found some information on a VBForum that I am going to try and implement. We'll see how it goes, but nonetheless thanks for the help and information. Chuck

No, that seems like more of a user level security which I have already embedded within the application. I was thinking more along the lines of an Activation Code, like the ones you have to type in when you install Microsoft Office or other applications (ie. Macromedia Dreamweaver, etc.). I've...

ghudson, Thanks for the information again. I re-thought the design and am using a temporary tables that is saved back to the main table when the user saves the parent/main record. The temporary table is removed once the user closes the parent record. Thanks for all the help.

Hello Access Gurus, Our application can be broken into several modules, and we want to be able to shut off all modules, but then activate them by entering an Activation/Authorization code for each module. The issue is that I'm fairly new to Access, and have never done this type of...

ghudson, Thanks for the information. I'll have to rethink the design then. Thanks again...

ghudson, I guess that's where I'm trying to do something different or odd. I'm used to using a different backend and developing all the forms in VB rather than Access. It appears that Access handles the containers/subforms in a different manner when either a query is attached to it (Record...

Yeah, I can handle the transaction processing through the ADODB recordset object. I have no problem with that, but with the subform created in Access, it doesn't allow you to leave the row once it has focus. I'm guessing there is a difference in how the subform container responds when it has a...