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

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

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

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

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

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

I am trying to disable the Close ("X") button on the Access application window (I have already taken care of the X button on the form) so that users must click the Close button I created on the form to run the necessary procedures. Thanks to a lot of help on this forum, I am almost...

Using Access 2000, I am trying to disable the shift key on my database so that my users can't bypass my startup procedures. I found a good example on this site, in FAQ 181-1172 (Disable Design View Through VB Coding). Since I have security set up, I thought this would be a good approach...

I have a very simple form, consisting only of an ID field, a title associated with the ID, three date fields, a comment field, and a search button so that the user can bring up data associated with the ID number. What I need to accomplish is to require that an entry be made in the comment field...

I am attempting to secure a database in Access 2000 and have used the User-Level Security Wizard to begin the process. The database is opening via a shortcut requiring a password, and, for the most part, I am seeing the results I expect (the correct users are accessing/not accessing the...

Hi - I posted the message below on the Access Forms forum, but I'm not sure I'll get a reply on my security problem, so I'm posting here as well..... I have a couple of questions regarding a form in an Access 2000 database. The form is very simple, consisting only of an ID field, a title...

I have a couple of questions regarding a form in an Access 2000 database. The form is very simple, consisting only of an ID field, a title associated with the ID, three date fields, a comment field, and a search button so that the user can bring up data associated with the ID number. I used...

Using Excel 2000, I created four individual workbooks. It was determined that all four of these reports should be combined into one workbook. I copied this information into one workbook containing four worksheets, one for each of the individual reports. After this copy/paste was done, the new...

We are using very basic Word forms constructed as tables with text fields. As we begin to want more and more functionality with these forms, it appears that our basic knowledge is no longer doing the job. Are there any useful books, articles, etc. that have specific references for creating...

We have created a variety of forms using MS Word 2000. Certain of these forms are created based on tables in which each row is a separate data entry. We use form fields to allow data entry while the form is protected. One of the problems we have is that we may create a form allowing for the...