Forms :: Audit Form - Combobox For Current / Terminated Employees

Jul 10, 2015

I'm creating an Audit form with a combobox from which the employee name performing the audit can be selected. The data source is the EmpNames query which selects from the Employees table, linked to another database. The EmpNames query includes a record selection criteria where Employees.TermDate is null so that terminated employees will not appear in the dropdown list.

This is fine as audit records are being added in the form for current employees, but in the future, if an employee is terminated and we go back to one of his audit records, the name will be blank because EmpNames won't include it. The Audit table doesn't store the employee's name -- just his employee ID, and the combobox has a two-column data source where the column 1 width is 0 and column 2 is the name. Is there a way to have only current employees be selectable but still be able to see terminated employees in existing audit records?

View Replies


ADVERTISEMENT

Record Current Windows Username In Audit Field

Jun 11, 2012

I am trying to record the current windows username in an audit field. But all i can get is the Username Admin?

Dim MyForm As Form, C As Control, xName As String
Set MyForm = Screen.ActiveForm
'Set date and current user if form has been updated.
MyForm!Audit = MyForm!Audit & Chr(13) & Chr(10) & _
"Changes made on " & Now & Date & " by " & CurrentUser() & ";"

[Code] ....

View 3 Replies View Related

Forms :: Employees Work Schedule - Filtering A Split Form

Aug 6, 2013

I have a database and form that is used to register times and various codes for employees to enter their work schedule for the day. Right now I am using a split form where they enter a ID code in the form and it auto populates with their name/department/and date. They then go and fill out a few boxes regarding time spent, machine used, and purchase order.

Once the information is added it is seen below due to it being a split form.

My question is this: Can I make the bottom portion (split form) filter and display only that specific employees ID number and his previous entries? Right now it is possible to view all of the entries placed and due to it being used on a network connection there are many submissions, I want it to narrow down so that once the employee enters his/her own ID only their previous submissions for that day can be viewed.

View 1 Replies View Related

Forms :: Automate Combobox Selection Based On Current Time

May 26, 2015

I have a form with continuous sub form.

The main form contains a combobox, populated from a query which pulls in specific data (time) from a table

The subform is linked to the combo box on the main form. Based on the combobox selection, the subform updates with associated records with the combobox selection

I would like to add additional functionality in the form load event, that would read the current time and identify the nearest value in my combobox.

I have tested the code below behind a button and it works

If Time() > "13.00:00" And Time() < "14:30:00" Then
MsgBox "The Time is " & Time()
cboPricingCADeadline.Value = "14:30:00"
Else
cboPricingCADeadline.Value = "NA"
End If

Would a loop through the recordset of the Combobox be best used here? Set the first and second values of the recordset to variables, query the time and then return the value if statement is true, or move to the next record in the rs replacing the first and second variable values

eg
If value1 > time() and value 1 < value2 then
cboPricingCADeadline.Value = value1
end if

If this is a good lead, how do I go about setting up my recordset?

View 4 Replies View Related

Forms :: Goto Form With Current User And Current Date

Aug 27, 2013

What I really need is for when the form opens, it looks at todays date, then matches current user and then goes to that record for today, if no current user there, then will goto new record..

i know, sounds complicated, and probably is really easy, but my heads not with it today, as about to get drunk as its my 40th, and got people ringing and texting and still trying to get this done....

I've included a copy of this database, named Timecards..

View 1 Replies View Related

Forms :: Calculate Review Dates For Employees

Jul 18, 2013

I have a form with date fields I need to calculate review dates for employees. Example 45 day 60 day 90 day what would be the best option to do this?

View 1 Replies View Related

No More Than 4 Employees Allowed On Form

Oct 25, 2012

On my form I need to limit the number of employees that can be entered using OnCall as the criteria or use ExpName or Employee ID

If this criteria is NOT met then disable On Call. In other words if they try and enter a 5th employee then the field On Call/checkbox is disabled

name of field is OnCall and actual control is named On Call

I need this to fire on the OnCurrent Event for the form which is named frm_Employees_on_Call_What_Order

In other words, no more than 4 employees are allowed to be on call at the same time. The fields for the query the form is based on are:

All are form the Employees table

Employee ID Employee autonumber primary key
ExpName name of employee, includes first and last name
On Call Yes/No checkbox used for if a employee is on call or not

query used is named qry_On_Call

View 1 Replies View Related

Forms :: Adding Duplicate Record To A Number Of Employees At Same Time

May 8, 2014

Currently if an employee attends a mandatory training session the details are entered individually into in a single table which contains all the employees' attendances to training, this is achieved via a bound form.

Works Fine.

My question is, if the training is carried out by a number of employees can this attendance be recorded on one form and assigned to each of the employees who attended?

Using Access 2003

View 3 Replies View Related

Forms :: Date Stamped Audit Field For Notes

May 20, 2014

I have a form containing two memo fields - Fld_Note and Fld_History.

What I was aiming for is that when someone enters info into Fld_Note, that either automatically when they leave the form - or when a button is pressed - the text from Fld-Note is copied to Fld_History and date stamped.

Any future notes are also date stamped and appended to the info in Fld_History (ideally most recent first) so that users have an audit trail in Fld_History of what notes have been added and when e.g.

20-05-2014 Contacted group treasurer regarding transfer of funds.
19-15-2014 Application for grant funding approved.
12-05-2014 Grant application received.

View 3 Replies View Related

Forms :: Create List Box To Only Display Information From Another Form Related To Current Form

Mar 20, 2014

What I would like to do is create a list box that will only display the information from another form that is related to the current form.So I have a form call Equipment Catalog and that form is related to Equipment features 1 to M relationship and the Equipment Features is related to a Features form M to 1.

So what I want to do is display all the related equipment features in a listbox that is related to the current PK of that form.So if there is only one feature on one form the list box will only display that one item however is there is 6 features on another it will display all 6.I have been trying SQL and Queries but I still can't get it to work.

View 1 Replies View Related

Forms :: Button To Copy Values From 5 Fields In Current Form To New Form

Sep 30, 2013

I would like to create a command button on my form that copies values from 5 fields in the current record into a new record leaving all the other fields blank except for the new record ID.

The fields that contain the data that I want copied into a new form are:

1. Member_Name
2. Member_ID
3. Account
4. UBH/PBH
5. Assigned_WRCA

View 8 Replies View Related

Forms :: Access 2010 - Opening New Form And Closing Current Form?

Mar 14, 2013

I am using Access 2010 - Version 14.0.61.29.5000 (32-bit)

I am building a custom Export Wizard to export data to Excel using the Report Wizard for the basic ideas.

All I am trying to do is have a [Back] button on a form to open another form and close the current form.

Private Sub cmdBack_Click()
DoCmd.OpenForm "frm_ExportWizardPage2", , , , , , Nz(Me.OpenArgs)
DoCmd.Close acForm, "frm_ExportWizardPage3"
End Sub

The new form is opening but then the current form is not closing. All forms are the same size, shape and positioned centrally although this should not make any difference.

Could this be anything to do with which form has the focus when I open the new form?

View 2 Replies View Related

Forms :: Network User Login With Privileges And Audit Trail

Dec 19, 2013

I am in the process of creating a database with multiple tables. Multiple users access through network with access data back end on server and Different Forms with user and group access of MS Access. The file is in mdb format and current version of MS Access used by all my users is Access 2007.

Requirements :

1. User Login (Access user login preferred as, one can set permission for read only, write permission for specific field etc.) But whether if any user who has readonly rights create his own db, wont be able to edit their own because of the rights that i have set rights in their pc??

2. need to fetch this user id with time stamp in each table to find who has altered the data, though audit trail table with ip address will be ideal.

3. Hide the navigation pane and ribbon for anyone other than administrator, including office button.

4. User level security is it required to set in every pc where the front end sits or one pc where the data is located.

View 5 Replies View Related

Show Current Record Value From Table In Combobox In Addition To Query Results

May 3, 2015

I have a table, with a related value in another table. E.g. A Items table with a batch value from another table.

I have a form to enter how many of these items has been used and from which batch number they belong.

The batch number is from a dropdown, and batches can be finished(exhausted) and marked such in the table so they no more show in the dropdown.

All this works fine, until, I go back to a entry which was from a batch that has been finished. The combobox is empty although the (Already finished) batch number is mentioned in the table. This is perfectly normal as my query for the combobox is :

Code:

SELECT ItemBatch.ItemId, ItemBatch.ItemBatchNumber, ItemBatch.Finished, ItemBatch.ItemName
FROM ItemBatch
WHERE (((ItemBatch.Finished)=False)
AND ((ItemBatch.ItemName)=[Forms]![ItemMasterForm]![ItemDataSheet].[Form]![ItemName]));

What I want is to show the current batch number as well. I tried to make this query get the current value, but wasn't successful. I tried to make a calculated field based on the dropdown and show its value.

Is there any way I can show the batch number in the datasheet? I have to use a datasheet and not a form, because there will be many sub records for the main form, and having a form will be very uneasy.

View 3 Replies View Related

Forms :: Determine Which Form Is Displayed After Current Form Is Closed

May 1, 2014

I have a series of forms that become current in a certain order. For example a menu form comes up. This is followed by a search form where the user gives search parameters. Then appears the results list. If the user wants a detail form comes after that, etc. Now when the user closes the last form I want the form before that one to show up and when he closes that one the one before that and so on. That is I am going to use the close button to go back to the previous step. How can I do this.

View 5 Replies View Related

Forms :: Update Row-source Of Combobox Based On Value Selected On Another ComboBox?

Apr 26, 2015

I am trying to use a combobox called Manufacturer to select which table the combobox called Model gets it's rowsource from using the code below.

Code:

Private Sub Manufacturer_AfterUpdate()
If (Me.Manufacturer.Value = "Siemens") Then
Me.Model.RowSourceType = "Table/Query"
Me.Model.Recordset = "SeimensTable"
Me.Model.RowSource = "SELECT Model FROM SeimensTable"
Else
If (Me.Manufacturer.Value = "Samsung") Then
Me.Model.RowSourceType = "Table/Query"
Me.Model.Recordset = "SamsungTable"
Me.Model.RowSource = "SELECT Model FROM SamsungTable"
End If
End If
End Sub

But when I run the form and select Manufacturer. Combobox Model remains empty. tell me what I'm doing wrong?

View 5 Replies View Related

Forms :: Open A Form Based On Current Form?

Nov 23, 2014

When I have a form called "SiteForm" open and click a button "NewCalloutButton" I would like it to open up a form called "CalloutFormEntry"

I've done this using

Private Sub cmdOpenDetail_Click()
DoCmd.OpenForm "CalloutFormEntry", , , "CalloutID = " & Me!CalloutID
End Sub

However this brings up all the records linked to the calloutID

What I'm after is to open the CalloutFormEntry from the SiteForm in a dataentry kind of format but to carry over the current SiteID based on which site is open on the SiteForm. That way there's no user error logging callouts to incorrect sites.

View 9 Replies View Related

Forms :: ComboBox To Pop-up Form To Add Data

Nov 13, 2013

I'm working on a db that will track students for a summer camp. One of my fields in my student records (CamperInfo) is "School". Currently, the field is set up as a combobox in the CamperInfo Subform in the FamilyInfo form. I would like the combobox to be able to add schools if the school is not listed by a pop-up when the "add school" (or whatever) is selected.

Code:

Private Sub School_AfterUpdate()
On Error GoTo Err_School_AfterUpdate
Dim strForm As String
If Me.School = "Schools" = True Then
strForm = "Schools"
DoCmd.OpenForm Me.School
Err_School_AfterUpdate:
MsgBox Err.Description
End If
End Sub

As you might have guessed, it doesn't work. no errors, it just doesn't do anything. I added the "Schools" data.

View 3 Replies View Related

Forms :: ComboBox - How To Get Form To Look At Third Column

Dec 3, 2013

I have a combobox (cbo_Breed) that Holds the Breed_ID, Breed and BreedType_ID.

On the form opening I want to look at the thrird column and if its a "1" then to do something. How do I get the form to look at the third column? This is what I have written (I know its wrong, but needed a starting point)

Code:
If Me.Breed.[Column](3) = "1" Then

View 5 Replies View Related

Determining A Forms Location (when Form Is Not Current)

May 31, 2005

Greetings. :)

I am trying to position opened forms so that they are cascaded on the screen. I have discovered the movesize action (for the DoCmd) and Move property of a form (for Acc 2002/2003). However, if the application is opened up on different monitors (e.g.; 17" or 19"), the relative location of the opened form is not the same (i.e.; on the bigger monitor the opened form is too far over to the right and too high).

What I want to do is ...

When the subsequent (or second) form is opened up I would like to find the absolute location of the first form (always centered). This way I will be able to reposition the second and third forms relative to the first form.

Is this possible?

I'm having trouble referencing the first form from within the second form. The first form is still open, but they are not linked forms (not parent/child). I've tried:

forms("firstformname").left
forms("firstformname").top

but this does not work.

I've gone to online help and I've looked around in the newsgroups. But can't find any info. Anybody out there will suggestions?

Regards,
SueB :confused:

View 1 Replies View Related

Forms :: Search Bar Is Only Looking At Current Form And Not At Records

Jan 9, 2014

I have several forms in a navigation form. On all the forms, the little search bar at the bottom shows # of 103 records. On my navigation form it shows 1 of 1 and won't allow me to search.It would seem that the search bar is only looking at the current form and not at the records.

View 1 Replies View Related

Forms :: Passing Two Combobox Value To Two Textbox In Form?

May 2, 2015

Private Sub CardName_AfterUpdate()
Me.Purchasing = Me.CardName.Column(2)
Me.Selling = Me.CardName.Column(3)
End Sub

I get value of Column(2) in Purchasing textbox but in Selling textbox not why?

View 14 Replies View Related

Forms :: Populate Combobox Value With Open Form

Aug 13, 2014

I have a unbound combobox in my form. I wanna populate list value in my combobox. first value is current year. Every time populate 6 values. like as

2014-2015
2015-2016
2016-2017
2017-2018
2018-2019
2019-2020

View 1 Replies View Related

Forms :: Opening A Form Using Combobox And A Button

Oct 28, 2014

I'm having some trouble opening a group of forms using a combobox. I think I'm really close, but I'm having some errors that prevent me from doing so.

I have a Combobox called "Letter Type" that contains the names of all of the other forms that exist. I want to be able to select a form from the combobox and click on the button "Compose." This should then open that form.

I had some trouble trying to get the Combobox value to work properly so I decided I would just create a hard workaround by using If/Then statements.

This is what I have in the On_Click event of my button.

Private Sub Compose_Click()
If Me.Letter_Type = "Refund Request" Then
strForm = "Refund_Request"
ElseIf Me.Letter_Type = "Request for Records" Then
strForm = "Request_for_Records"
End If
DoCmd.OpenForm strForm, , , Me.[Reference_#] = Forms![Reference_#]
End Sub

The catch is that I want the form to only open with one record and I want that record to be the same record the user was viewing on the previous form. I thought I would tie them together using the "Reference #" since it is unique.

When I click on Compose I get a "type mismatch" on the Reference #, though I'm not sure why.

View 5 Replies View Related

Forms :: Navigation Form Printing Current Record Out As PDF

May 31, 2014

I have made a navigation form that prints the current record out as a PDF and also the option to send the current record by email as a PDF. Both work perfect when you open the form outside the navigation form. But when you open it inside the navigation form, it does not print any of the information.

The problem is in the Query report, In the criteria box for field [RequsetID] it has

Code : [Forms]![FRMRequestForm]![RequestID]

(The above works outside the navigation form.)

I have also tried adding the navigation form name

Code : [Forms]![Main]![FRMRequestForm]![RequestID]

But none work.

View 4 Replies View Related

Forms :: Unable To Print Current Record In The Form

Jun 4, 2014

I tried to follow the Allen Brown print the current record in the form and its not coming up. I can print all of the records but not the current.

View 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved