I'm creating s simple database to track my printer toner supplies, what i want is that..every time I select a date (using date picker) it will automatically deduct 1 from the total number of toners on stock. Right now, i have to input 1 in a field and it will update the remaining toners.
View RepliesI have attached a sample of a database.
Table 1 has all the items I am trying to sell with sell by date after which I cannot sell this item. Then in Table 2 I have forecasted sales. So now I am trying to calculate stock consumption to see if I will be left with any stock that I cannot sell.
So now somehow I need to deduct sales forecast from my stock holding but it needs to go by date i.e. consume all stock for Item 1 with date 16/09 before moving to Item 1 with sale by date 23/09.
So based on the attached example, I can see that on 16/09 I will consume only 5 cases from sell by date 16/09 and another sale is 18/09. So that would give me information that I will be left with 95 items dated 16/09, which I cannot sell because they will be out of date.
Ideally I would like also to include the logic that if Item is out of date it would move to the next sell by date.
So in this case sale of Item 1 forecasted for 18/09 (94) would consume the whole stock (50) with date 23/09 and another 44 from date 01/10
For Item 2 I can see that units with Sell by date 30/09 will be consumed on 25/09 and I will start taking stock from next sell by date which is 14/10.
I have created 3 tables for simple inventory.
a) Item details
b) stock in
c) stock out
All I simply want to do is create a new table by item id to show balance of stock.
I am operating in MS Access 2007 and unfortunately have to stick with the "out of the box" controls. I have data entries of notes in my database for "most workdays" - but not holidays or weekends. I want to allow the user to be able to edit notes for "most workdays" - but not let them pick a day to edit that doesn't have notes - by selecting them from a calendar date picker. Essentially, I want to gray-out/lock the non-workdays from editing.Is there a smart enough Active X or other control as a Date Picker that uses the results of a query to show valid/invalid dates?
View 2 Replies View RelatedI can make the DATE picker work, but I need to add the TIME to the same picker. At least that would be preferred.
View 6 Replies View RelatedHi
I use the Date and Time Picker. i know that i can get many other calendars, however, my theory is that i would rather use something that is directly supported by microsoft. but as i found out now that may not be the case.
on of my users updated his Office 2003 after he was having problems using my database (created on 2002 sp3). i know that the same database works on 2003 sp1. however, now microsoft is serving 2003 sp2. so after the update he he can't use the database.
so my questions:
1. how do i generally prevent users from getting update errors. i would like to atleast alert them with a meaningful message that their version of Office needs to be updated.
2. is this true that the Date and Time Picker doesn't work anymore? and if so, why isn't backwards compatible? and how do i prevent this from happening with other controls or scripts?
thanks,
sam
I have a subform that is in Datasheet view. If I open this subform on it's own, the Date Picker works for the Date field. However, if I open the main form with the subform on it, the date picker doesn't work? Nothing happens when I select a date on the calender.
I am using MS Access 2010.
I have managed to develop a database for my small business and am feeling very proud of myself. However, on fine tuning I would like to introduce a Date Picker for ease of use. I have a Check in Date and a Check out Date. At the moment they are working perfectly using the Date/Time field. I want to change that field to a datepicker. I have found out how to insert the date picker and it works great when inserted on a new record BUT all the previous dates in the database change to the current date. Is there a way I can still display the previous dates in the field and also introduce a date picker?
View 3 Replies View RelatedI'm currently working on fixing an older 97 database that I've updated to 2010. I have just populated the Drop down box with about three fields. Ideally what I want to do is after having selected the item number from the drop down box I then hit the button that creates a report with the information about that item number.
At the moment...If the box is blank it reports all the item numbers, however if i fill the box(select an item) it returns nothing i.e the report is blank.
I've looked at the query that builds the report, there are only three fields that populate the. location, part number and description. from a tbl called MainDetails
the only other thing:
If([Forms]![frmReports]![FLoc] Is Null,[FUNCTIONAL LOCATION] Is Not Null,[FUNCTIONAL LOCATION] Like [Forms]![frmReports]![FLoc])
it has a criteria of <>False
*FLoc is the drop down box *functional location is the location field.
I believe all the above does is populate the report if Floc is empty.
What can I put to make the report generate what ever I pick in the drop down box 'FLoc' source the three fields from the 'MainDetails table'.
I have created queries from Incoming Raw Material and Out Going Raw material Tables..Now how to get balance Stock of Item wise,
My Query Look as under
item wt In Coils Out Coils Wt Bala Stock
part A 100 kg 10 3 30 Kg 7
part A 100 kg 10 5 30 Kg 5
I want that Balance Stock shall be 2 Coils of Part A , How shall I get the same result.
In my Access app I need to get the latest record added of an item from a MS Sql table and check the period between now and the date saved in the record.
So my guess is:
Select TOP 1 * from tbl_StockItems
Where StockId = Loc_StockId
I then need to check the days between tbl_StockItems.LastStockDate and Today.
How would I write an Access VBA query to give me the amount of days and put that number into a variable.
Running Access 2010. I have a large data set here is sample:
Type Capture Date Volume
1 1/5/2014 7
1 1/15/2014 5
1 1/8/2014 3
1 1/10/2014 4
Is there any way to sum the total values for each change in date while keeping chronological order? To get access to produce something like this:
Type Capture Date Volume
1 1/5/2014 7
1 1/8/2014 10
1 1/10/2014 14
1 1/15/2014 19
I am using Access 2007 and I have had a curious issue arise.
I like to use the Date Picker feature on all my forms to make it easier to enter dates. I have set up each table's date field property to "show date picker for dates", as per attached (.jpg)
When I use that particular field in a form, I also set up the field to allow for the Date Picker option (date picker form property sheet.jpg)
The curious part is that not every form that I set up actually shows the date picker when I select the date field. Some forms it works perfectly, others it doesn't.
I have a textbox on my form that is for "week of", always a Monday. There is vba to populate the appropriate Monday when the user selects something other than Monday via the date picker. This code is in the on change event. However, this is not friendly to a user entering a date in this field. I did try after update event, but that requires user to leave the "week of" field. This is not acceptable in this instance, there are other form fields that change as a result of this "week of" value.I also tried evaluating the length of the text or else exiting the code. However, I was expecting the date being returned from the date picker to always be 10 positions, but for March 3rd, it would return 3/3/2015...which is only 8 positions.
View 2 Replies View RelatedThe query is there to query data, not to edit data or manipulate data in anyway. However, I am disgusted by the appearance of the date picker when I pick a field that is a date field.
Is there a way to hide/remove these date pickers from the query sheet?
Within the table itself I turned the "Show date picker" property to "Never" but that didn't make a difference.
I've been trying to get a datepicker working in Access, unfortunately Access doesn't really seem to support it very well. I suppose I could make my own if I had to.
I miss VB.NET. VB.NET had built in date functions that allowed you to do a lot of things with dates. VB 6.0 has hardly any such functionality.
What I'd like to do though, is to be able to figure out which day of the week any given date is on. I don't want to write code like that myself, it feels like it would be too much work. Does anyone know of any code that would help out with a solution like this?
I want to let the user to select the date and time by showing a control/screen fot this. I used the MS access control: Microsoft Date and Time Picker Control 6.0. however, this doesnt show the date properly.
Is there any Fully Free software that I can use to show a screen to allow the user to pick the date and time?
Thanks,
Hi
I'm using the activeX control Date and Time Picker which work fine. I'm having trouble though to set the MaxDate and MinDate from VBA.
For instance me.DateTimepicker12.MaxDate="01.01.2008" returns an error 'Invalid date......'.
I have tried many different formats for the date, but not the right one.
Is there someone who can shed some light on this?
Thanks in advance
I must be missing something obvious.
It would be nice to have a date picker, to reduce input errors.
I'm trying to get a combo box datepicker to work from a popup form. I've looked at fontstuff's version (http://www.fontstuff.com/access/acctut13a.htm), but it has the date on the main form (as do the examples I've found using search).
I have to run two queries to get the data I need, and the best way is to have them called at the same time from a macro - hence the popup form. If I use a text box txt_Date formatted as a date box forms![GetDate]![txt_Date] works fine. How do I get the variabe txt_Date to accept the results of the three combo boxes as a single date value?
Here is what i need help with i have the basic lay out but i just need someone to help me figure out the rest of this. Attached is a sample database with what i am trying to do. if someone would be so kind to help me figure this out that would be great.
thanks
chad
in access xp, there was a handy active x DTP. it doesn't seem to be available in access 2003. is calendar control 11 there only option here?? it really isn't as convenient as the DTP. maybe there's a way I can make the calendar control operate in a similar way to the DTP?? or maybe there is a DTP but its called another name in the active x list.
any ideas are appreciated.
Well this is bizzare,
I am using the microsoft date picker in my form. I have made it non editable (i.e. editable=false) when the form loads.
I am making it editable on the click of a button... Seems all so simple huh..
But my problem is that when I click the button, the date picker is displaced at the top of the form..
when I move the slide bar of the form, it again comes back to its original position..
Can anyone explain this?? and how to make it simple?
Hi
I am using the Date Time Picker in MS Access. When I transfer my database to another computer the control shows as a blank white box. I have already done
regsvr32 to register the relevant ocx and ticked the Microsoft Windows Common Controls -2 6.0 (SP6) in the reference box. Is there any other way to repair
this control without having to reinstall the whole thing.
Thanks - Rob
Hi All,
I know there are several examples of calendar date and time pickers about so I thought I would offer mine up for critique.
No modules, very little code, code used is simple and can be called from subforms as well as forms.
I used these forms in an application where the users find filling in date and times in the correct format difficult with limited keyboard skills.
If it can be improved let me know..... :)
Garry
PS I think the contributions Banana has been making to this forum are invaluable.
Keep up the good work.
How do I change the ms date/time picker control 6 to have a default null
value?
Hi All,
Is it possible to change the format of a date picker, for instance once i have selected a date, its is visible as 09/11/2006, can this be edited to just the month and the year 11/2006.