Search results for query: *

Ok, all I want 2 do it find a easy way to not have to enter the address part of the email into the email field on the employee table and form. All the employees have the same address tag(@companyXYZ.com). So when we add a new employee, the address is already there, we just need to add their id...

the examples they had were for ssn, phone, inv #, etc. Is there a better way to achieve the same goal?

I am trying to create an input mask for email. Every employee in company has the same address, but different names. How do you create a new mask that allows you to put the employee name in front of the @companyXYZ.com blue

I created a database last year that I saved on disc. Security was set up for multiple users. I now need that db design for creation of a new db. However, when I try to open it, it get an error message saying "You do not the the necessary permission to open db". I have looked all over the net...

What is the best way, and how do I create a "Find". I have a db that I need to do a find based on a field "Title". Most of the users have minimal computer experience, so I want to create a blank field that they can type part of the title, and the records that match (in whole or part)will be...

I added the DueDate field to the PatientInventory table instead of the TransactionLog table. That way the users can see it as part of their stats section on the "Welcome Page". I referenced it (via. the checkout button) to post it in the TransactionLog table using the same field title. I have...

Thanks PHV!! Should that be an unbound field on a form? I would like to have it as field in the Transaction table, so I can report on it. If so. where would I put that code, in the "Validate Rule" spot? Blue

Sorry,if I did not mention that. It is the field that houses "CHECKED-OUT" and "AVAILABLE" in the TransactinLog table Oh, The Average Length code worked GREAT!!! Thank You. Question: I would like to create a field called "DueDate" in the PatientInventory table (houses all the individual...

Sorry, extra explanation required. The code I posted works in regards to calculating by user the # of transactions. However the "Month/date" piece needs to be added to what I posted in the previous message. Blue

The code for month total did not work. The code below however does works. I tinkered for a few hours to no avail trying to add the month piece to this: =DCount("StatusID","TransactionLog","StatusID='CHECKED-OUT' And EmployeeID = '" & DLookUp("LastName","tblEmployees","UserID='" &...

I, with the assistance of PHV and Rubbernilly, have created a Transaction Log table, that logs every time a user checks out, and returns a patient file. I need to create stats based on that log. On the users personal stats pages, I have 4 unbound text boxes that are designed to hold their...

Thanks guys. With the current corrections to the code. On checkout click, it posts the date, user, and changes the status on the table "PatientInventory" and table "TransactionLog" (That part is good.) However, now on "Return" it's deleting the info in the table "Transactionlog". I still need...

Hi rubbernilly!! With these changes, a couple things are happening. The check-out works good with one recored. If I go to checkout another record, I get runtime error 3464 Data Type Mismatch in Crtieria Expression, pointed at: "' AND ((ReturnDate) Is Null)") When I click on "Return" button, I...

I placed the additional code in. I'm getting a runtime error #3021, "No Current Record". Also since, we have added the previous code, when the check-out button is selected, it does everything it is to do. But, now the only way to view the name (from EmployeeID) you have to move to the next...

The LOG WORKS GREAT. Only issue this has created though, is, the check-out and the "return" become two different transactions. And because we wipe out the EmployeeId on the "Return", I dont know what to reference for the "return" transaction to the "Check-Out" transacation. Is there a way to...

No, it is not built yet. I have searched and searched to no avail. Yes, assistance with that would be greatly appreciated. This was my Thread question: I have a button on a form that when clicked, updates the status, date stamps, and post the current user who has been assigend that record. I...

Hi guys! Rubbernilly, you are correct. The subform does list all the records assigned. In an attempt to make the Welcome screen look seemless, I took out all those controls. I have a section (boxed off) at the top of the welcome screen that has "Quick Facts" info. That is where the unbound...

Since I am new to Access, I will take the long way around the block to ask this simple question. At initial logon, a "Welcome/Status" page for each user (based on their UserID) is the first page they see (there is no traditional switchboard). This page is designed to show the records they have...

It's me again. I am getting this error when I place the me.requery in the OnActivate on employee form. It points to the 13th line "Me.Bookmark = strBookMark" Private Sub Form_Activate() Me.Requery End Sub Private Sub Form_Open(Cancel As Integer) Dim rs As DAO.Recordset Dim strBookMark As...

My new and dear friend Rubbernilly, as I'm sure you are aware, I am new at this. That just went over my head (LOL). You got me in the kitchen making coffee to calm my nerves, and I dont drink coffee. Just kidding. I got the first part of your opening statment, however, I did not get the second...