Search results for query: *

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

Thank you! Changing the query properties to Snapshot did exactly what I needed it to do, and it was a very easy fix! Thanks again!

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

Thank you so much for the information. This will be very helpful as a starting point!

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 PHV and idd! A star for each of you! Between both of your posts, this is exactly what I needed and everything is working fine.

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

With all of your suggestions, I was able to set up two buttons that are working just fine. Thanks everybody!!!!!

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