Date Specific For Each Record?

Nov 20, 2006

Hello friends,
Thanks for having me.

I was wondering how I could select a date for a particular field in my main form. What I'm trying to do is this:
When I make a particular selection in one of my fields, I need to be able to specify a date that will be displayed on the main form, and also print on the report. I need to be able to select a specific date, and not a default date.

Hope this is clear, trying to keep it simple - which can be pretty complex.

Thanks for any input.

View Replies

Select Record For A Specific Date

May 19, 2005

I have a table that stores price records with a field for the effective date but there is no field for the inactive date. How can I write a query to return the price for a date that falls between recorded effective dates?

Example: A record exists for 12/03/2005 and the next is 01/04/2005. How can I find the effective price on 18/04/2005?

Thanks

View 2 Replies View Related

General :: Delete Specific Range Of Date Record

Jun 26, 2014

I want to make a delete query, which delete record between certain dates, I want access to ask user to specify range of date before executing the query.

View 11 Replies View Related

General :: Sum Values From Date Range From Specific Record

Mar 11, 2013

I'm working on a loan database for my personal use and obviously I'm new to access

See attachment ...

View 5 Replies View Related

Pulling Specific Data For Specific Date Range

Jul 14, 2007

so i have an interesting question and im hoping that someone can help on this one. i need to pull date from a specific table, no problem, that's written and working fine, next i need to be able to join the data from another table by a primary key, again no problem. third, i need to be able to select the date (using WHERE) for a specific date range. (i.e. i enter the date range of 01/7/2007 to 15/7/2007) and the query comes back only showing the data from that specific time, not the data from before or after. this is where my problem lies, all the entered data is being shown after entering my date range. i am going to include my SQL statement, just so you can actually see what im really talking about.

SELECT srealest.Name0, srealest.Dist1, SREpayments.Face2Pd, SREpayments.Penalty2Pd, SREpayments.[2paid], SREpayments.Face3Pd, SREpayments.Penalty3Pd, SREpayments.[3paid], SREpayments.Face4Pd, SREpayments.Penalty4Pd, SREpayments.[4paid], srealest.Map, srealest.Parcel, srealest.LeaseHold, srealest.TaxRebate1, srealest.TaxFace1, srealest.TaxPenalty1, srealest.TaxYear, srealest.BillNo, srealest.PdRebate1, srealest.PdFace1, srealest.PdPenalty1, srealest.DatePd
FROM SREpayments INNER JOIN srealest ON SREpayments.BillNo=srealest.BillNo
WHERE (((SREpayments.[2paid]) Between Forms![SD SRE]![Beginning Date] And Forms![SD SRE]![Ending Date]) Or ((SREpayments.[3paid]) Between Forms![SD SRE]![Beginning Date] And Forms![SD SRE]![Ending Date]) Or ((SREpayments.[4paid]) Between Forms![SD SRE]![Beginning Date] And Forms![SD SRE]![Ending Date])) Or (((srealest.DatePd) Between Forms![SD SRE]![Beginning Date] And Forms![SD SRE]![Ending Date]))
ORDER BY srealest.Name0;

any thoughts or ideas on how to accomplish this would be greatly appreciated!

View 2 Replies View Related

Forms :: How To Hyperlink From Query To Specific Record In A Specific Form

Jul 23, 2013

I want to hyperlink from a query direct to the relevant record in a specific form. I have a hyperlink field in the form which shows up in the query. When clicked in the query, this hyperlinks to the form but I cannot make it select the correct record in the form.How do I get it to select the correct record?

View 3 Replies View Related

Locking A Specific Field Of A Specific Record

Oct 3, 2005

Hello, I have just spent ages doing searches and reading everything I can on locking. But, I have yet to find an answer as to how I can lock a specific field in a specific record.

e.g. Staff enter customer details, then at the end of the day the admin (me) checks it over and presses a big old button that stops them from locking certain fields in the current record only - they must still have access to the unlocked fields of the current record, and it must not lock any other records.

I'm guessing there's some VB code in the form of fieldname.lock = true, but then it locks the field throughout the whole table!

Can anyone tell me how to do this please?

View 11 Replies View Related

Forms :: Copy Specific Fields From Selected Record To Specific Fields In Subform?

Jul 9, 2015

I am new to access i have a problem which is i have made a form which contains a subform and a read only subreport, what i want is the ability to select a record in read only subreport as in the picture attached and make a button that when i press on it, it should copy the values of the itemsID field, Packing field, ContainerNo field and origin field from the selected record and then paste them in the subform below.

Also i want to add more then one item, so the when i press on another record it should paste the values below the first record.

View 12 Replies View Related

List All Clients In A Specific Date From 3 Date Fields

Oct 12, 2007

Ok let me explainI have a list of 50 people who may have accessed events A,B,C at different times but what I want to do is to put a date in my form, run the quaery which will list all people who have Attended A,B or CWhen I do my normal query, I put the fields in, but if I put a date filter in Event A, it will not show up any person who may have attended event B but not Event A.I thought about running an append query but this would mean running the data several times with possible duplication of client names.Ideally I would like to have my report to showDate: 31/07/2006Name A B CK.Brown Y YJ Blogg Y YK Smith YK Ellum Y Ythen I can just use a count at the bottom :)The methods I have tired will filter event date A, but will not show J BloggIf I create another append for Event B, and append that data to a table, then I will have duplicaion of K Brown.. Any Help Appreciated.Last thing - when I run the append queriy and get my duplications, the fields where I had a Y/N option - if it was YES then I get a -1 instead of 1 ??? Why? and how do I make sure that when appending that the Y answer is a 1 not a -1

View 14 Replies View Related

Modules & VBA :: Get First Working Date After Specific Date

Nov 14, 2013

There are a variety of date functions but I specifically want to show the date or the first working day after the 25th of each month.

Eg:
if 25 Oct is a Monday then result = 25 Oct
if 25 Oct is a Sunday then result = 26 Oct

View 4 Replies View Related

Forms :: How To Get A Specific Record To Be First Record Of Continuous Form

Nov 8, 2013

I have a continuous form for which the recordsource is a query that retrieves dates from 10 days in the past to 10 days in the present. I want the record with today's date to be at the top of the form. The record with the oldest date is always on top. Is this a scrolling issue? How can I get the record with today's date to appear on top?

View 5 Replies View Related

The First Of The Month Following A Specific Date

Jun 29, 2005

I need a query that calculates a date that is the first of the month following a specific date. Example: The first of the month following the 65th birthday.

Is there any way this can be done?

View 9 Replies View Related

Date Specific Query....

Jan 26, 2007

Hello all...New to Access & still crawling under the tables....So any help is most appreciated.

I have a table w/ a field named 'Week Ending'....The 'Week Ending' column is based on each Friday's date, and may contain anywhere from 5 - 30 entries per Week End date.

Now for the simple question I'm obviously missing the answer too...I have a query that I run weekly based on the entire record set for the 'current' week ending.

My last set is obviously 1/26/2007. Is there anyway to make the most recent week ending date the default criteria for the record set; instead of changing the query design each time? It may seem trivial to some, but I just want to cut any step possible for any additional users..

thanks again...

View 1 Replies View Related

The First Of The Month Following A Specific Date

Jun 29, 2005

I need a query that calculates a date that is the first of the month following a specific date. Example: The first of the month following the 65th birthday.

Is there any way this can be done?

View 5 Replies View Related

Cannot Search For Specific Date

Feb 22, 2006

Hi,
Can anyone help. I am trying to search an access database for entries for a specific date i.e 26/02/2006

The below works fine, but how do i search for all entries for a specific date i.e 26/02/2006

sSQL="SELECT * FROM tavern_tbl ORDER By ReturnDate ASC, ReturnTime ASC"

Table name is tavern_tbl
ReturnDate / ReturnTime are column names

Any help would be appreciated.

View 3 Replies View Related

Age At Specific Date Calculation

Apr 3, 2007

Hi

In need of some assistance please.

I am looking to calculate in a form someones age in years and months at a specific date.

I have tried various different functions but can't seem to work out where i'm going wrong.

The persons date of birth is entered manually into the "DoB" field. I then want their age to be calculated in a text box below this, if it needs 2 text boxes then so be it.

The specific date is 25/05/2007 (UK date).

I am currently using the datediff function but I need the calc to be more specific than just the year.

Hope this makes sense.
Thanks in advance

View 2 Replies View Related

Go To A Specific Record

Mar 3, 2005

Hi,

Does anyone know some code that will take me to the record whose field "A" has value "B"?

It sounds very simple but I can't find anything the does it!

Basically I have a table or enquiry records, some of which are related. I just want to be able to click on a button to take the user straight to the related record. The current design does this using a filter but this is pretty rubbish as it meanhs that in order to search on all records I need to select all records again first.

View 1 Replies View Related

Go To Specific Record

Sep 29, 2005

The following is a function in my Form "Enter"

--------------------------------------------------------------------------
Private Sub PoNum()
Dim strForm As String
Dim strwhere As String

strForm = "GoodOne"
strwhere = "[Forms]![GoodOne]![Orders3].[Form]![PO_Num] ='" & txtPO & "'"

If [txtPO] <> "" Then

If DCount("[Po_Num]", "Orders", "[PO_Num] ='" & txtPO & "'") = 0 Then
MsgBox "Sorry, No record matched"
txtPO.SetFocus

Else

MsgBox "yes"
DoCmd.Close acForm, "frmPopUp"
DoCmd.OpenForm FormName:=strForm, wherecondition:=strwhere
End If

End If

End Sub
------------------------------------------------------------------------

"Orders3" is the subform of Form "GoodOne" .
When the user enter the PO Number in txtPo, and press "ok" , it will go to
that record.
BUT it just show a new blank reocrd instead.

What's wrong with the programme ??? (is it the matter of subform ?)

Thanks

View 3 Replies View Related

Filtering Specific Date Periods

Oct 29, 2006

Hi all!

I want to add a function to a form that filters records from a specific date period.

Each record has a field containing the date the record was added.
Example: I want to show the records added between 15.09.2006 and 10.10.2006.

Furthermore, the �from� and �to date� must be defined in textboxes, and the filter initiated with a button.

I need this functionality on a continuous form and in a report. How do I achieve this?

View 14 Replies View Related

Query Results For Specific Date

Feb 25, 2006

hi, i have certain jobs and i want to select them based on the job date.

in my current query, i use the job date parameter
[Enter a Date:]

when the user types in the date, then the jobs for that date and their corresponding information is displayed.

however, i have created a form for this query displaying the results as a datasheet.

instead of the user having to enter the date for the query manually, is there any way to modify the query to only show results for the current day.

eg. today is the 24/02/06.. so i would like the results from the query to automatically show the jobs for that date. this way, only todays jobs will be shown in my form.

View 3 Replies View Related

Select Specific Date Range

Dec 12, 2007

Hi all, I need to extract in a query a recent range of records, these records should be all before a certain date and all the following future records example:
if today date is 12/12/2007 I need to extract all records that are dated from the 1st of november and all the records that come after the 12/12/2007.
In the criteria I have set "Date()" what else should I be adding to get the range mentioned above?
Thanks

View 5 Replies View Related

Specific Date For Select Case

Apr 3, 2006

OK I have done a select case as follows
Private Sub Form_Current()

Select Case DatePart("w", Tape_Date)
Case 1, 3, 5

Clearly this runs/works on a Sunday, Tuesday and Thursday.

I have tried to adjust this to work on a specific date but I'm struggling.

Would I use 'datePart' or just 'Date' and what format in the case would I use.

Thanks in advance

View 6 Replies View Related

Opening A Form To A Specific Date

Feb 1, 2005

can someone please help me with some code.

I want a form - when opened - to open showing the clinic details for the next week (ie date() + 7)
The field in question is called DateID

Do I use the Event OnOpen or On Load.

Thanks

View 3 Replies View Related

Opening A Form To A Specific Date

Oct 10, 2005

If I have a form that has a field called Episode_Date how do I open the form to the record with the most recent date?

View 7 Replies View Related

Specific Date Range In A Report

Jan 12, 2006

I'm having issues with reports. What I want to do is only print specific dates in a report. I have read and tried everything to accomplish this but it just isn't working. Any suggestions????????????

View 2 Replies View Related

Inventory Status @ Specific Date

Dec 15, 2007

Hi there,
Thanks for having me as a member of your forum!

I'm completely new to all things Access (apart from using databases set up by others!), but now as a small business owner need to set up a simple inventory database.

I've got the database set up and all historical inventory transactions are entered. What I need now is the abiliy to run a report that will allow me to see what the inventory status was on a specific date. I will gladly send the database to anyone that can assist. Can anyone help me achieve this?

I've puzzled over this for days now without success! Thanks for any help that can be offered.

Craigie

View 1 Replies View Related