Search results for query: *

I tried following the steps for creating a secure database in Access using a 12-step instruction sheet from a link on Access Security Methods. I backed up the "system.mdw" as "system-bak.mdw" in another folder. I created a new .mdw and named it secure.mdw using Workgroup...

Because I changed the default menu in Tools | Startup for my current database project, and I changed the Menu bar to my own, I am not able to use Tools | Options and check off "compact database on exit". I want to be able to perform this function on exiting, but now I can't access...

I was trying to import an Excel datasheet with an EmployeeID column formatted as Text in Excel, and I want it to remain a text field in Access, because some of the EmployeeIDs have leading zeros that should not be truncated, e.g. 0023335. It imports EmployeeID as datatype double. But since the...

I created backup data queries on my db, but I'd like to have a variable that stores the number of times the db was accessed, and tell that user, as when using Quicken/Money for example, that data should be backed up. As long as the program is open, I can create a static variable, for example...

Is there any "formula-like" way of resolving the issue of a many-to-many table relationship? If, for example, I had two tables, 1 called PASSENGERS and another called FLIGHTS, I might be in quandary because a passenger could have many flights, and flights could have many passengers...

I recently had my Win 2000 Professional PC de-virused and have both Norton's LiveUpdate on when I'm online and Zone Alarm's firewall runs whenever I boot the computer. One problem that they didn't resolve, because I forgot to mention it to the techs who de-virused it, was a problem with the...

In the general declaration of my form I Dim Rs as DAO.Recordset. In the form's load event, I Set Rs = Me.RecordSetClone Why do I get an error message in the form's close event that an object variable is not set, when I put the following code into the form's close event: Set rs = Nothing...

Using a table to backup data created by two different users for patients (tblPatients). Will automate this to allow the admin. in dept. to simply press a button and append all records to a backup table of Patients (tblPatients_Backup). Because there is a primary key (PatientID) in both the...

Before submitting this, I did read other posts regarding this run-time error but didn't find the answer. It's a simple DAO Recordset (Dim Rs as DAO.Recordset), and I get this error, saying there TOO MANY PARAMETERS, Expected 1 -- and no help available on the subject. strSQL = "SELECT...

Before submitting this, I did read other posts regarding this run-time error but didn't find the answer. It's a simple DAO Recordset (Dim Rs as DAO.Recordset), and I get this error, saying there are TOO MANY PARAMETERS, Expected 1 -- and no help available on the subject. strSQL = "SELECT...

When I call a function in a sub, how do I return to the next line in the sub after processing the function? I've always written forms where a function is called, but never yet where I went back to the sub. Sorry for my ignorance. For example: cmdButton_Click() call function1 ' more lines of...

I created an HTML Help file for my Access database using the HTML Workshop; it seems to work fine, except for 1 issue: I have had to repeat the name and path of my help file in each form that I open, with its respective Help Context ID. I realized that you can set a Help file in the project...

In a module I declared a public variable called gUserName As String, available to be used on any form or object in the database. It's current value is stored depending on who logs on from a logon form. For example, I am using the value of gUserName to determine what happens when a form loads...

I have read several posts here regarding this run-time error, but alas they haven't helped me. I am trying to insert a date from a popup-dialog into the date control of a subform. The button that inserts the date doesn't recognize the existence of the parent object --let alone worrying about the...

I have a problem with a form which will open a second form and filter it on the criteria below. The behavior of the form that is being opened doesn't always filter, though, and I'm not sure why. Code in command button: Dim LinkCriteria As String LinkCriteria = "[ID] & [Date]= " &...

Form2 (the many side of the relationship) opens from a command button on Form1 (the 1 side of the relationship) -- Thus when I press on the Add | Edit Records button from Form1, Form2 opens up on the linked criteria (e.g., "[ID] = '" & Me.ID & "'"), and it correctly displays...

I looked through this forum as well as Access Help but still can't find the answer on how to do this. I want to format a field in a table to only allow text (a,b,c,d,e, etc.) or capitilizations of letters -- no numbers or symbols. I only want data entry people to enter "letters" in the...

Yesterday I uploaded a prototype database to a shared drive. I don't believe that anyone is currently using the file, but I am getting 2 types of errors: one, that the Access file is read-only (which it is not) and a Windows critical error message that I can't delete the file (Critical Error...

Whatever type of record locking I use, where should I set the type of record locking, on the front end db where the tables are linked, or on the BE database? Obviously, I shouldn't set this on both the BE and FE. In this prototype, which has caused no problems so far, I have decided to be very...

I have a book here on using VBA in Access and using the immediate window to run a sub or function. But let's say you were looking at the code module of a Form's Close or Open Event. How could you debug that in the immediate windows. Normally I'd type the function or sub's name preceded by a ...