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 Replies


ADVERTISEMENT

General :: Filtering Split Form

Oct 20, 2013

i attached database & would like to filter the data by ISO N & Joint N.the first filter is working but there is small problen in filter joint N.

View 2 Replies View Related

General :: Tracking Time Off From Work - Weekly Schedule?

Dec 10, 2013

I have been tasked at my work to create a database for tracking time off from work. I have built several databases in Access 2003 and have now transitioned to 2010 and it is seems to be going well. My past databases have been rather simple data in data out not really that big of a deal. However on this database they need a report that will show them a week view that shows them all the employees regular days off and any additional time off they have schedule in that week.

I have an employee info table that has employee basic info, Emp name, Emp number, Work Week code (which identifies which days off the employee has) Hire Dates (for seniority sorting) and then I have 7 fields listed as D1, D2, D3 and so on until D7 (I will try to explain these fields later).

I have another table (Time Requests) that has 3 fields, Date, Emp number, and Time code (which identifies why they are off work or unavailable to be assigned).

The last table I will refer to has 7 fields, they are Date1, Date 2 – Date7

I now have a form. This form has the 7, fields Date1, Date2 – Date7.

On my form Date1 field is updated by a manager with a date that is a Sunday then Date2 = [Date1]+1,
Date3 = [Date1]+2 and so on until I have all 7 fields showing date from Sunday – Saturday.

These fields are lined across the top in a vertical direction positioned above a subform of the employee info table. So directly below the 7 Date fields are the D1, D2, D3, D4, D5, D6, D7 fields then to the right is the Emp name and Emp number, This gives me a Week view of who is working.

I have been able to get the D1, D2….. fields to show their respective Work Week codes by writing very simple “If Then” statements . So here is where I AM STUCK…When I am showing this week view how do I get D1 –D7 to identify what date they are supposed to be in reference to Date1 – Date7 then compare themselves to the table “Time Requests” to see if they have a match and then set the value of D1, D2 …. to the “Time code” in that table. D1 – D7 need to auto populate and do this for about 50 employees.

Here is a screen shot of what I have so far and where I am stuck: [URL] ....

View 2 Replies View Related

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 4 Replies View Related

General :: Work Offline Feature In Split Database?

Feb 20, 2013

Any way to "work-off-line" in a split database, and then sync the data when one is done working?

View 9 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 :: Setting Focus To Control On Single Form Side Of Split Form

Jun 24, 2013

When I right click a row on the data sheet side of a split form an select "New Record" I want the curser to go to the first field on the single record side. I've placed this in the OnCurrent but it did no good.

Code:

If Me.NewRecord Then
Me!Descrfiption.SetFocus.
End If

Any way to set the focus to the single form Side of a split form?

View 4 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 :: Filtering On Form Load

Aug 9, 2013

I am having a problem filtering a form on load.What I am trying to say is if the role = Agent then filter on todays completed records and records that have a completed date of Null for the particular agent.

Here is the code:

If Me.txtRole = "Agent" Then
AgentFilter = "(CASEOWNER ='" & Me.txtName & "')"
DateCompletedFilter = "((DATECOMPLETED = #" & Date & "#)OR (DATECOMPLETED Is Null))"
DoCmd.ApplyFilter , AgentFilter & " And " & DateCompletedFilter
Exit Sub
End If

The filter on the agents works and the filter on the completed date of null apeears to work however when a record is completed it diappears on refreshing of the form even though the record has been completed on todays date.I have investigated the code an the issue appears to be with the DATECOMPLETED = #" & Date & "# part of the code.

View 5 Replies View Related

Forms :: Filtering A Query Using A Form

Feb 9, 2014

I currently have this form (combobox) that filters using one piece of criteria.

Private Sub cboSelectPress_AfterUpdate()
'Moves to Press field and
'finds records where "press" matches whatever is selected in the combo box
DoCmd.ShowAllRecords
Me!Press.SetFocus
DoCmd.FindRecord Me!cboSelectPress

End Sub

"Press" is a machine number. How can I add more combo boxes to filter additional information from my query. Like "room" or "product" or "date?" What happens if the user leaves one of the boxes blank?

My fields are

"Date"- date the product was ran
"press"- the press it was ran on
"product"- the name of the product
"shift"- the shift it was ran on

I want the user to be able to select ALL or none of these fields for results.

I am using Access 2013

View 2 Replies View Related

Forms :: Form Filtering From Ribbon

May 15, 2015

I can't figure out Form Filters. Basically I have a load of controls on the form. The first control I select I'm able to click the Filter button on the Ribbon and get shown a load of checkboxes to filter the field on (see capture.png)On subsequent controls, clicking the Filter button on the ribbon doesn't show the checkboxes for that control (see capture2.png).

View 6 Replies View Related

Forms :: Filtering A Combo Box On A Form

Jan 21, 2014

Im having trouble filtering a combobox on a form. I have two Comboboxes, one is called (FleaTickWorming) depending on what is elected in this cobo, will deside on what is available in the other combo which is called (Product). The form is a continuous form. The filtering works, in as far as it changes the list each time, but it also deletes the item that I have chosen on previous records if the list is different. My code is as follows:

Code:
Private Sub FleaTickWorming_BeforeUpdate(Cancel As Integer)
If Me.FleaTickWorming.Column(0) = 1 Then
Me.Product.RowSource = "qry_FleaProducts"
ElseIf Me.FleaTickWorming.Column(0) = 2 Then

[code]....

View 3 Replies View Related

Forms :: Design Form That Looks Very Similar To Either Split Form Or Subform

Jun 2, 2014

Basically I need to design form that looks very similar to either Split Form or Subform. I have attached a print screen of what I roughly need. The form is split into two parts. In the first/top part there are some List Box/Date fields that act as filters to the bottom form, so the bottom form displays only records that match values in red. The second part of the top form has some field that require input from user and then these records are added to the bottom form. I was trying to use both Split Form and Subform and none of it is working,I have attached an example of database and this form would be based on data from Query1.

View 5 Replies View Related

Forms :: Two Split Views On The Same Form?

Jan 16, 2015

Is it possible (haven't found a way yet) to have two "split subforms" on a parent form side-by-side? When I try the multiple rows portion of the split view I created as a subform doesn't appear?

Want to have a form when I have search/filter/select record for table 1 (on the left) and table 2 (on the right) with a means in between to create a relationship which has a few parameters.

View 1 Replies View Related

Forms :: Filtering Form For All Records In Datasheet?

Apr 29, 2015

I'm using a datasheet that can be filtered for certain fields. I have a macro that opens a form to the record that was selected (aka "current") in the datasheet. It filters this opened form to "1 of 1" which makes sense. How would I go about filtering that form for all of the records left (after filtering) in the datasheet?

I hate macros, but I'm doing client-specific work. The primary key is a field (autonumber) called "ListingNumber".

View 3 Replies View Related

Forms :: Show All Records On Split Form?

Feb 21, 2014

I created a split form. My main form is just a form, based off of tblBlotter. The subform is based off a query, which is the based off the same tblBlotter. (Not sure if this is proper - maybe I just need the table?)

I have a link master and link child field set to ID. When I open the form "subBlotterHistory", it opens and shows as a new record only. I want it to show ALL records on the query subform and be able to scroll up, down and edit.

Attached is a sample w bogus data.

View 3 Replies View Related

Forms :: Putting A Button In A Split Form

Dec 9, 2014

i have a split form in ms access that has the data source of a linked table in sql server. this form has some fields those are bound to the columns of a table. I want to have a button that would appear in front of each rows. do you know how i can do this?

in a continius form when i will create a button it will be appeared continiously. how can i do this for split form in ms access

View 1 Replies View Related

Forms :: Down Arrow Key Not Working On Split Form

Dec 19, 2013

When I select a row on a split form I would like the up and down arrow keys to move to the previous and next record. However this isn't happening.

When I select a row and press the down arrow nothing happens.

I have the navigation buttons set to no because of the issues I'm having with them.

How to get the up/down arrow keys to work on a split form??

View 3 Replies View Related

Forms :: Filtering Data Field On Main Form?

Jan 22, 2014

Is it possible to use Filter option in my form without using Query Wizard? - So that the user would be able to edit and change the other field on the same form

View 2 Replies View Related

Forms :: Filtering A Form Based On ADODB Recordset?

Oct 16, 2013

I have a form that shows records from ADODB recordset.When I try to apply filter to the underlying recordset it works all right but the form doesn't reflect the changes. It shows same rows as before filtering. In debug I can see that the recordset contains only filtered records. Me.Refresh (Recalc, Requery) doesn't work.

Code is as follows:

Dim rs As New ADODB.Recordset
rs.Open sql, conn, adOpenStatic, adLockOptimistic
Set Me.Recordset = rs

Sub combo_AfterUpdate()
Me.Recordset.Filter = "CompanyNo = 123"
End Sub

The form is in Continuous forms mode. I cant use DAO because the data comes from SQL server user-defined function.

View 5 Replies View Related

Forms :: Filtering A Subform On Tab Control From A Separate Form

Sep 11, 2013

I am trying to filter a subform on a tab control based on an input on a second form.

Mainform: frm Index Page 2
Tab Control on Mainform: tabctrlMain
Subform: Customer Details
Tab Name: tabCustomerDetails

The second form is basically a separate Search Form where users can look for a customer ID and returns the ID back to Customer Details form.So far I have managed to redirect focus to the correct tab on the tab control using the following code:

DoCmd.OpenForm "frm Index Page 2"
With Forms("frm Index Page 2")
!tabctrlMain.Value = !tabCustomerDetails.PageIndex
End With

However, I am stuck with the filtering part. Everything was working fine before I began putting the forms together into one big tab control (I tried using Navigation Pane but there were too many referencing problems so I gave up on that one).

View 2 Replies View Related

Forms :: While Filtering Main Form Subform Also Gets Filtered

May 6, 2013

I have faced with a problem while i was filtering my main form.....my problem is when i filter the main or parent form the related sub-form also gets filtered how to manage the main form so that when i filter it the sub-form should not be filtered so that i can get the related record to my filtered one in the sub-form... as for the time being when i filter the main form the related record in the sub-form is not shown and when i press unfiltered on the sub-form its data gets appeared....

View 11 Replies View Related

Forms :: No Data In Split Form's Navigation Buttons?

Apr 14, 2013

If I hide the AutoNumber ID field in a split form datasheet, nothing is displayed in the forms navigation buttons (Record x of x).

If I unhide the ID field, the record number and number of records correctly.

The control is Enabled and Visible.

View 8 Replies View Related

Forms :: FindRecord Split Form Records From Combo Box

Dec 21, 2013

I have a split form with many of a combobox (date, text,numbers and both).

How can displayed only the records in the datasheet based on a combo box selection?

How to build this mechanism and write a sample code?

View 14 Replies View Related

Forms :: Using Split Form With Datasheet - Find Not Working

Nov 9, 2013

I'm using a split form with the datasheet on the left.

When I use the 'Find' in the Navigation buttons at the bottom of the form, it refuse to find text in a particular text box.

The text box is a memo field and is enabled.

Example:

I have text in the memo field which is a title of an episode - "The Outcast."

When I start typing "the" it finds this text in the memo field. But when I type the entire title it the finds the text in another field. ie "out."

I've tried the 3 different Search setting in options. When I use the Find command from the ribbon it work ok as long as I select the text box to search in first.

View 1 Replies View Related







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