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 Replies
ADVERTISEMENT
Sep 9, 2014
I've got a continuous form that displays my massive 3,000+ inventory, with the option to filter down to specific categories. Some categories have 5 items, others have hundreds. The design I have used makes it look really tacky once I filter down to one of the categories that has 5 items, because there is no scroll bar.
What I've tried using is:
Code:
If Me.RecordsetClone.RecordCount < 10 Then
Me.Scrollbars = 2 'vertical only
Else
Me.Scrollbars = 2
End If
But it still doesn't display correctly (nobar.png). This is probably my biggest headache right now, and every "solution" I've found, doesn't work.
View 11 Replies
View Related
Feb 4, 2007
Hi there,
i am writing a query that calculates a date
ExpiryDate: DateAdd("yyyy",[NATATable].[NATAExpiryPeriod],[NATATable].[NATADate])
which works
The expiry period is always 2 or 4 and the natadate is a date i want it to add 2 or 4 years to the date the NATA was done... works no problems.
Now i want a query in another field as a status
ExpiryStatus: Expired or Valid
ExpiryStatus: IIf([ExpiryDate]>=Now(),"Expired", "Valid")
Which works
i am ultimatley aiming to end up with 3 Fields - Expiry date (working), Status (working) and Remark (not working)
Remark is based on this excel query
=IF(AL3<NOW(),(IF(AL3<(NOW()-365/4),"(3) Expired more than 3 months ago","(2) EXPIRED during last 3 months")),(IF(AL3<(NOW()+365/4),"(1) Expires within next 3 months","(4) Expires in more than 3 months time")))
which i need to change to an acess query.
Where AL3 is the expiry date.
Please help
Thanks
Kris
View 1 Replies
View Related
May 25, 2005
I would like to know in Acess how to create a Form
Let's say to lookup Products you sold by date in like a month period on a form
To select the items from the list and have it display by that date.
Thanks,
Mike Van Der STad
View 3 Replies
View Related
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
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
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
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
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
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
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
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 1 Replies
View Related
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
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
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
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
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
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
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
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
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
Feb 12, 2015
I am making a tracker to track events and how close we are to the next time the event has to be done. Specifically the event has to be done every 6 (180 days) months. I am looking for a conditional format formula that can color code when certain days have been hit. When it is less then 30 days or less from the next event color it yellow, when 31-180 color it green and anything past due color it red.
Using todays date as an example 12-Feb-15 it would be colored green. 150-179 days from now I would need it to be colored yellow. Anything beyond 180 days from now would need to be red.
View 2 Replies
View Related
Dec 19, 2005
I am trying to pull just a specific date that a Claim was sent to be processed. But the query has 40 tables that it needs to go through to get all possible dates. I know you will all say this is over kill on the tables, but each table represent a travel claim.
The problem I have is that I get to the 10th claim and it stops pulling the date. I put the following statement in the criteria:
[Type the beginning date MM/DD/YYYY]
any ideas?
View 14 Replies
View Related
Dec 11, 2005
Hi, i cannot load posts from a specified date and time
PostDate = now()
'AID = accountID of the poster
'read post after added into DB
Set rsForum = Server.CreateObject("ADODB.Recordset")
strForumSQL = "Select * From tblPost where tblPost.PostDate = '"&PostDate&"' and tblPost.PostBy = "&AID&""
rsForum.Open strForumSQL, strForumCon,3,3
PostID = rsForum("PostID")
I gets an error when posting messages, i think is because: tblPost.PostDate = '"&PostDate&"'
PostDate is no text field, its a Date field and i tried to use this symbol: ' around postdate, i also tried to not use it, but then i gets another error:
[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'tblPost.PostDate = 12/11/2005 10:32:50 AM and tblPost.PostBy = 6'.
but that is because the date/time format uses spaces.
How can i fix this?
Thanks in advance
View 4 Replies
View Related
Nov 2, 2013
I have a query of "Donations" in a sub form and want to use a combo box to specify all donations having a specific date.is this a job for VBA code? or is there some other way.
View 3 Replies
View Related
Nov 26, 2014
I have a query from a table (to reduce the number of fields).The list is all the positions people have performed, as person could have one record another could have 10 the number is unlimited.
Fields are:-
-employee ID
-start date
-position
I need to find any records that were active ON or AFTER 01/09/2014. This will be 1 record for most but some could have multiple.I think it makes it more difficult that there is no END DATE.
View 6 Replies
View Related
