I am using MS Word 2003.....I have created a number of command buttons in a document that provide tidbits of information when clicked. The code I am using to create these buttons is as follows:
Private Sub CommandButtonNameofButton_Click()
intMessage = MsgBox("This is my text.", vbInformation...
I have created a secured database in which users are able to click a button and bring up the results of a query. Users can then view this information, can select the records, and can copy them into Excel to create a report with their own formatting, etc.
In setting up the query, I read...
Has anyone tried to create a knowledge database using Microsoft Access? I have found some software (called General Knowledge Base 2.0) that appears to use Access, but the project I am working on has no budget and I doubt I will be able to spend any money for any purchased product.
I need to...
I am having a problem using the NETWORKDAYS function and I haven't been able to locate an answer.....
I am trying to perform a calculation on dates from project plans. I need to know the number of work days (excluding weekends and holidays) between a project's actual end date and its baseline...
I have the Shift key blocked on the database for added security, but before I began messing with the settings, I turned the feature off, and tested it, and I was able to get around the security settings with the Shift key. I then altered the Security settings as mentioned above, then I couldn't...
Thanks for your help.
I can't even get to the point of logging in - when I click on the shortcut, I immediately get the "necessary permissions" error message.
I was hoping to be able to correct this myself, but I have resorted to asking our technical people to pull yesterday's network backup...
To answer your questions:
Yes, a custom MDW file was created, using Access 2000. I'm not sure what you mean by superuser - as the administrator, I set myself up as having full rights to everything in the database. Users connect to the database by using a special shortcut and logging in with...
As careful as I thought I had been, I have finally done it - I (and all of our users) are locked out of the database.
I have a number of copies of the database, but I seem to be locked out of all of them as well.
The database was secured with the Security Wizard and all was fine. I was...
I don't know what operating system the server is running. I will have to ask our Technical Support folks that question. Would it just be better to ask them to remove these files from the server, or is it something I will have to do, as the Administrator of the database?
Last week one of our databases became corrupt. After all of the standard attempts to compact/repair/import the database information, it was determined that the database was corrupted beyond repair, and we opted to use a backup of the database that (luckily!) had just been made a few hours...
Thank you so much! This is exactly what I needed, BUT.....
when I open and close the form, a dialog box appears asking if I want to append/update records. I don't want the users of the database to see this - I want it to occur invisibly for them. Is there any way to turn off this message and...
This is the very simple code I tried to use on the "On Open" event:
Private Sub Form_Open(Cancel As Integer)
[Users]![User] = CurrentUser()
[Users]![Login] = Now()
End Sub
I get the following error message:
Run-time error 2465
Microsoft Access can't find the field "|" referred to in your...
I have searched the forums for the answer to my question, but I can't quite seem to find what I need.
I have created a secure database (using the Wizard) and the security features seem to be working fine. However, for tracking/usage monitoring purposes, I now need to track the activtiy of the...
Thanks! I just assumed that each user should have a unique PID. I will delete/re-add the users without PIDs and begin using the same identifier for all users.
Is there a way to find the PIDs that are assigned to users when new users are created in conjunction with database security?
I have a list of the PIDs for almost all of the users, but there are a couple that I don't have the IDs for (and also for one group that was created).
I saw a previous...
Thanks, jbento - that was helpful information. I'm trying to figure out the best scenario for my purpose.
SiJP - To try your code, I created a new test database containing only a form with a lock and unlock button. I created a new module and pasted your code into it. My problem is this: I...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.