Making A Selection Based On A Month

Jan 15, 2006

Hi

I have a subform on which I log the times spent on any particular project.

I have another subform on which I want to select a month and use this to select all the instances on which work was done on any given project for a particular month. I would prefer to use a pop up calender to select the month (i.e. by slecting the last day of the month in question)

Has anyone got any idea how I might do this - I am completely stumped.

Thanks in advance

Cheers

Rob

View Replies


ADVERTISEMENT

Vibisble A Box By Making A Selection

Dec 18, 2006

In de attachment you see a form.
By selecting a item in box 1 in want to appear box 2.

Who can help me?

Thanks

View 2 Replies View Related

Making The Selection In A Combo Box Stay.

Jan 28, 2008

Hi everyone,

I have created a combo box in my form, the options for the combo box are coming from a table. It all works fine expect for some odd reason, when I click on an option in the combo box then come out of access, when I go back into the database the one I had chosen has gone. Do you know how I do so what I put in the combo box will stay?

Thank you in advance for your help.

View 1 Replies View Related

Making A Selection On Two Tables And Then RIGHT JOIN

Oct 28, 2005

Hello,

I want to comine the following queries into one so that I can alter the parameters from a webpage.

I have a users table that has the department in and I have a TimeTable Table which has dates and option codes.

I need to select everybody in a department in the example it's Logistics.
I then want to link these people to the timeTable Table based upon a field.
The problen is that I want to select only a specific week. I can do this using two queries but that isn't going to work in ASP.

The Results should be as follows:

Person Date Option
A
B 01/10/2005 1
B 02/10/2005 2
C 01/10/2005 1


The two Queries look as follows:


SELECT TimeTable.*
FROM TimeTable
WHERE (((TimeTable.Date)>=#10/24/2005# And (TimeTable.Date)<=#10/30/2005#));

The above is then saved as Query1

SELECT Users.*, Query1.*, Query1.TimeOfDay, Query1.Date
FROM Query1 RIGHT JOIN Users ON Query1.UserID = Users.ID
WHERE (((Users.Department)="Logistics"))
ORDER BY Users.Surname, Users.Firstname, Query1.TimeOfDay, Query1.Date;

Any help would be great!

Cheers,

Matt

View 2 Replies View Related

Hide Selection Option On Form By Making Lines On A Table INACTIVE

Jan 15, 2014

I have several tables linking our employees to certain supervisors, etc.On the Form, there is a drop down with all employees listed that someone can select and then enter the stats required. When someone leaves the firm, I want to remove them from the form dropdown list, but not delete them from the corresponding table. I have seen this in other databases where they someone added an 'Inactive' column with a Yes/No response and when you selected the inactive - yes, that name would disappear from the form when people select names from a dropdown to enter stats.how to make the names disappear from the view in a form, but not in the table related to that form?

View 6 Replies View Related

Date Selection Criteria - Show Last Day Of The Every Month

Apr 16, 2015

I have a big list of data, with a row of data for every day for each client.

I need a selection criteria that will provide show the last day of the every month (historic data) for each client.

I've had a go but I'm not making much progress.

View 4 Replies View Related

Making A Calc Based On A Table

Mar 7, 2006

Hello everyone. I am very new to databases, may have bitten off more than I can chew, but I was tried of working in 4 different spreadsheets and decided to pull them all into a database so that I could get what I wanted when I wanted. Here is what I need to be able to do: In a table I have 3 different industries entered 5 different times. They all cover a Monday to a Friday. Each day for each industry I record a reading from a meter. I make a calculation by subtracting Mondays number from Tuesadays, Tuesday from Wednesday, Wednesday from Thursday and Thursday from Friday. This calculation gives me how much water each industry used each day, over 24 hours. Doing this in a spreadsheet was simple. My table has the Industry name, date, previous day meter reading, present day reading. I want to have the calc show in my query. How do I set up this calculation. Any help would be greatly appreciated. Thank you. I attached a sample database that contains the table and query.:confused:

View 3 Replies View Related

Modules & VBA :: Making A Field Required Based On Value Of Another

Sep 6, 2014

I have a subForm set to continuous forms. I need a field called txtStatusDetails required (cannot be null) if the field txtDutyStatus = "Not Available"

Here's what I have so far:

Private Sub Form_Current()
' This procedure runs after the record changes.
On Error GoTo Err_Handler
ResetAvailability
Exit_Proc:
On Error Resume Next
Exit Sub

[Code] ....

View 3 Replies View Related

Return Dates Based On Day And Month Only

Jan 3, 2006

I would like a query to return dates based upon the input of just the day and month. At the moment I have a parameter query which asks for 'start date' and 'end date' and this works fine, but I want the query to return all the records for all the years in the database and not just the current one (date format is dd/mm/yy)

So if I type <start date> 01/01 and <end date> 02/01 the query will return:

01/01/04
01/01/05
01/01/06
02/01/04
02/01/05
02/01/06

Does anyone know a solution - I have been searching all afternoon!!??

View 1 Replies View Related

Date Query Based On Month

Apr 3, 2007

I am very new to access so thank you in advance for your help and patience.

I have creadted a database for tracking students.

I would like to give them progress reports every three month based on thier start date (I have a 'short date' field for the start date).

If I run the query in January I would like results for all student who started in Jan, April, July & Aug.

Thank you again!

View 6 Replies View Related

Query Based On Current Month

Dec 9, 2004

I am looking at creating a query which would report whether a specific field is yes/no. However, I would like it to based on that days specific month. For example, I have 12 check box fields, one for each month, and I would like to create a report where it would look up whether or not the current month has a check box in it. Additionally, I would like to create another where the criteria would require me to put in a month to search for. For example, to search to see whether or not december has been checked.

Tim

View 1 Replies View Related

Modules & VBA :: Subtotal Based On Month Not Day?

Oct 4, 2013

I have created some subtotals in some columns of data which for example are the dates, names, and amounts of invoices.

The code I used is:

Range(Range("C1"), Range("C1").End(xlDown)).Select
Selection.CurrentRegion.Subtotal GroupBy:=1, Function:=xlSum, TotalList:=Array(3)

This is working of sorts but it is giving me subtotals based on the day in the date column. How can I change this to group by the month?

View 10 Replies View Related

Msg Box Based On List Box Selection

Jun 20, 2005

I have a form that contains a list box with 11 separate options. Within this list is the option named "None". My desire is to have a message box displayed when any option is selected other than "None". I have searched various threads, however I have been unsucessful nailing down my issue. Thanks in advance for the assistance.

View 1 Replies View Related

New Form Based On Selection

Feb 3, 2006

Is there a way to take a form, select the fields that you want to display on a template(I created the template)? Then the fields that aren't selected grey/disable them? In other words. We perform several tests, ie. test 2006.01 and 2006.02 etc. Each test is based on 1 table. So instead of having to go in each time a new test is needed, can I create a form that has selectable fields(checkboxes), and once I say ok it opens the "new" template it will have the fields that need to be on that test then grey out the ones that aren't going to be used this time around? Sort of new to this....

View 2 Replies View Related

Autofill Based On Selection - Please Help

Sep 28, 2004

I am learning Access fairly quick, but still a newbie and stuck on an autofill problem. I have read everything I could find and it seems there may be code involved, which I'm not sure about.

The problem seems simple enough: I want to populate field "Rate" in the table "Services" based on the selection from a dropdown menu referencing ClientID in the Clients table. Specifically, my form uses a drop down menu to select ClientID for the Client table to associate with fields in the Project table and I have imbedded another form at the bottom which contains fields from the Services table including the Rate field I want autofilled based on the ClientID selection. Here are the tables and fields I'm working with...

...table...
Client
...fields...
ClientID (PK)
Rate
<and more>

...table...
Project
...fields...
ProjectID (PK)
ClientID
<and more>

...table...
Services
...fields...
ServicesID (PK)
ProjectID
Rate
<and more>

Please be easy on me if this is a simple problem. Thanks!!!

View 7 Replies View Related

Grouping Results Based On Date By Month

Oct 20, 2005

I need a subgrouping for a report I am working on.

I have a DateIn field that contains date as mm/dd/yy. I have managed to get a count of all of a certain type of document that came in during a certain period of time that usally spans a quarterly period. So typically there are three months in the query. I would like a subgroup that breaks the numbers up in the 3 month period by each month.

So if a total of 150 docs moved in 3 months it shows 50 moved the first month, 50 the second, etc. I believe this is grouping by month. I have not been able to determine the criteria for getting the query to group by a single month as well as the three months period being grouped by document type. Here is what I have so far.

SELECT ctblDocuments.DocTypeID, tlkpDocTypeList.DocType, Count(ctblDocuments.DateIn) AS CountOfDateIn
FROM ctblDocuments INNER JOIN tlkpDocTypeList ON ctblDocuments.DocTypeID = tlkpDocTypeList.DocTypeID
WHERE (((ctblDocuments.DateIn) Between #7/1/2005# And #9/30/2005#))
GROUP BY ctblDocuments.DocTypeID, tlkpDocTypeList.DocType
ORDER BY tlkpDocTypeList.DocType;

View 5 Replies View Related

Modules & VBA :: Deleting Records Based On Month

Jul 26, 2013

I want to write an sql or vba code to delete records based on the month...For example I have a field called date which contains a date and I want to delete all Dates that are In April

Ive tried
Delete from LinkTable Where month(Date) = 'April'
Still Nothing

View 3 Replies View Related

Querying Based On Combo Selection

Jan 27, 2006

Right, I think this is a quick and easy one....just not for me!

I have a combo box with a list of names. I want to use whichever name a user selects as criteria for a query.

What do I need to type in the query criteria box or as SQL?

View 2 Replies View Related

Insert Relevant Value Based On Selection

Jun 15, 2005

I have a form with a combo box this combo box looks up values in my STC table. The STC table has two fields STC & Resolver and each STC has a unique associated Resolver. What i want to happen is after the user has selected the STC from the combo box on the form the associated Resolver be displayed in a textbox on the form. I am ussing the following code but nothing seems to be happening:

Private Sub cboSTC_AfterUpdate()
Dim ResolverSource As String

ResolverSource = "SELECT tblSTC.[Resolver] " & _
"FROM tblSTC " & _
"WHERE tblSTC.[STC]='" & Me.cboSTC.Value & "';"

Me.txtResolver.RowSource = AgentSource
Me.txtResolver.Requery


End Sub

View 1 Replies View Related

Textbox Based On Combo Selection

Jan 19, 2006

I choose a ‘Year’ from a combo box. Why doesn’t the data in my textbox update? (It’s a count of records for that year)

View 2 Replies View Related

Display Subform Based On Selection

Mar 20, 2006

A tricky one this. Searched for answer but cannot find.

Acc 2003.

I have a main menu with 2 subforms.

In the on load event it sets the source object of the first subform, which displays a list of options (menu Style).

When choosing an option from SubForm1, I want SubForm2 to display the form I have coded in.

I currently have within subform 1 in the on click event the following.

Form_MainMenu.subform1.sourceobject = "formtodisplayinsubform2"

When running this from the main menu, nothing at all happens.

When opening just the subform 1 on it's own and clicking the option, it merely opens the main menu form.

Can anyone see what I am missing?

Thanks in advance

View 2 Replies View Related

Forms :: Validation Based On Yes / No Selection

May 8, 2013

I inquired on this original thread [URL] .... to hide/show fields based on two Yes/No dropdowns.

Summary:
1.
If "OtherUnivEmployeesInvolved" = "Yes":
The fields
"OtherUnivEmployeeFullName1"
"OtherUnivEmployeeFullName2"
"OtherUnivEmployeeFullName3" are shown.

If "OtherUnivEmployeesInvolved" = "No": These 3 fields are hidden.

2.
If "OutsideRepresentVendor" = "Yes":
The fields
"OutsideIndividualLastName"
"OutsideIndividualFirstName"
"OutsideIndividualCompanyName"
"OutsideCompanyStreetAddress"
"OutsideCompanyCity"
"OutsideCompanyState"
"OutsideCompanyZip" are shown.

If "OutsideRepresentVendor" = "No": These 7 fields are hidden.

I have this basic validation code when a user hits the save button:

Code:
Private Sub Form_BeforeUpdate(Cancel As Integer)
Dim ctrl As Control
For Each ctrl In Me.Controls
If ctrl.Tag <> "skip" Then

[Code] .....

Within "1." - If yes is selected, I only need "OtherUnivEmployeeFullName1" required.

Usually skipping FullName2 and FullName3 would be easy using the ctrl.tag "skip" but I am already using the control to show hide these fields so how to do that.

Within "2." - If yes is selected, I need all 7 fields required.

So I need to figure out how to require fields based on those Yes/No selections because right now the form is checking every field regardless of the yes/no selections. I would also need to skip "OtherUnivEmployeeFullName2" and "OtherUnivEmployeeFullName3" everytime.

View 13 Replies View Related

General :: Based On Combo Box One Selection

Jul 29, 2012

if it is possible whereby if a user makes a selection in combobox 1 it must automatically generate the given vaules in combobox2 from the selection in combobox 1.

View 1 Replies View Related

Combo Box Event Based On Selection

Oct 18, 2011

I know how to assign an event to a combo box, but I want to be able to launch a specific link, app, or email template, based on the actual selection from the combo box. So when I make a selection, whatever program or event I assign, to that specific selection, will launch.

View 14 Replies View Related

Query For A Month Range Based On Combobox Entry

Aug 2, 2005

Hi,

I currently have a form that creates a report based on a query that takes in a start date and an end date.
What I would like to do is to create comboboxes that will let the user choose a month and year for the report.
Is there a simple way to choose an entire month in access? I've tried using the Month() function to no avail.

The SQL statement for where I select the start and end date is below:

WHERE ((([tblData].[EntryDate])
Between [Forms]![frmByRange]![BeginningDate] And [Forms]![frmByRange]![EndingDate])

Any help would be much appreciated!

View 2 Replies View Related

Modules & VBA :: Calculate Next Service Month Based On Dates

Jan 16, 2015

I've been trying to solve this problem for the past month and at the verge of destroying my PC! I've trawled through numerous web sites but just cant seem to figure this one out.I'm trying to get access to tell me what the next service moth is based on the start date, end date, and the frequency of service.

For example:

Start date: 01/01/2014
End date: 31/12/2015

service frequency: Every 4 months

Using the above information the service months are:
1 - April 2014
2 - August 2014
3 - December 2014
4 - April 2015
5 - August 2015
6 - December 2015

View 6 Replies View Related







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