Forms :: Subform With Date Picker To Input Multiple Dates

May 14, 2013

On my main form, I have a subform to input multiple dates, using date picker.

I also have a text box on the main form to input single dates, again using Date Picker.

On entering both the single date text box and the subform, I don't want the (default) date to be visible. I only want the date to be visible once I have selected a date from the Date Picker.

I have figured out how to do this with the single date text box. I have simply defaulted the forecolor to be white so that you can't see the font against the white backcolor. Then on the Change Event, I set the forecolor to be black. Works like a charm.

However... This same approach will not work with the subform. I've tried playing around with a bunch of different events, but so far nothing allows me to re-create what I am able to do with the single date text box on the main form.

View Replies

Forms :: How To Use Date Picker And Input Mask Together

Nov 26, 2013

I have a form (Access 2007) that requires user to enter a date.

Using the standard date field (short date format) with the date picker works fine however some users prefer to enter the date via the keyboard (some prefer the date picker).

If I set an input mask (to facilitate keyboard entry) for the text box then the date picker disappears.

Is there any way to apply the date picker and the input mask to the control to accommodate all users?

View 1 Replies View Related

General :: Display Previous Dates In Field And Also Introduce A Date Picker

Aug 24, 2012

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 Related

General :: Datasheet View - Date Picker Not Working In Subform?

Sep 11, 2012

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.

View 1 Replies View Related

Forms :: Show Date Picker On Selecting Date Field?

Apr 26, 2014

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.

View 2 Replies View Related

Forms :: Code For Date Picker Use AND User Date Entry

Mar 26, 2015

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 Related

Forms :: Disable Date Picker In Access 2010

Mar 6, 2014

disable the data picker for every field on every form in my application - without doing it the long winded way of manually turning it off for every field?

View 2 Replies View Related

Forms :: Date Picker - Show Saturdays Only In Any Given Month?

Nov 11, 2014

Is there a way to force the Date picker to show only Saturdays in any given month?

View 6 Replies View Related

Parameter (Date) Query To Get Input Dates On Report?

Apr 28, 2006

I have a report that has an underlying query that asks for Start Date and End Date.

Is there anyway that I can get what the user inputs into the box to be put into the Page header of the report?

ie: user enters into the parameters
[Start Date] 01/01/2006
[End Date] 04/04/2006

Then when the report displays it says

Report for the period 01/01/2006 to 04/04/2006

Thank you for your time

View 4 Replies View Related

Forms :: Disable Date Picker In Access 2010 Runtime?

Jul 10, 2013

I have an application created in A2003, but my client's machines nearly all use A2010 runtime. How I can disable the Date Picker completely on all forms as I have no need for it. Obviously I can't access the 2010 property sheets to disable it that way.

View 2 Replies View Related

Query From Multiple Tables Using Date Input

Feb 22, 2008

I have 3 tables, "Customer", "Offsite Service" and "Service".

Customer:
ID
Last Name
First Name
...

Service:
ID
Date
Price
Trans#

Offsite Service:
ID
Date
Price
Trans#

All 3tables are joined by the ID#.

I need to create a sales report/query based on the results of the user input, which is a date range. I've got it working great with two of the tables, but not the third. Here's the code for the working one I have now. I had to add the Trans# to make sure it returned all the results. If I take it out it only shows a small percentage of the records. The Trans# is NOT the same on both the service tables.

This pulls the information from "Customer" and "Service" tables and returns
Last Name - First Name - Date(Based on user input) - Price

SELECT [Customer List].[Last Name], [Customer List].[First Name], First([Service Records].Date) AS [First Of Date], Sum([Service Records].Price) AS Price
FROM [Customer List] INNER JOIN [Service Records] ON [Customer List].ID = [Service Records].ID
GROUP BY [Customer List].[Last Name], [Customer List].[First Name], [Service Records].[Trans #]
HAVING (((First([Service Records].Date))>=["Start Date" Use format MM/DD/YY] And (First([Service Records].Date))<["End Date" Use format: MM/DD/YY]))
ORDER BY [Customer List].[Last Name];

This pulls the information from "Customer" and "Offsite Service" tables and returns
Last Name - First Name - Date(Based on user input) - Price

SELECT [Customer List].[Last Name], [Customer List].[First Name], First([Offsite Service Records].Date) AS FirstOfDate, Sum([Offsite Service Records].Price) AS SumOfPrice
FROM [Customer List] INNER JOIN [Offsite Service Records] ON [Customer List].ID = [Offsite Service Records].ID
GROUP BY [Customer List].[Last Name], [Customer List].[First Name], [Offsite Service Records].[Trans #]
HAVING (((First([Offsite Service Records].Date))>=["Start Date" Use format MM/DD/YY] And (First([Offsite Service Records].Date))<["End Date" Use format: MM/DD/YY]))
ORDER BY [Customer List].[Last Name];

I want to be able to pull records from a date range that returns customer name, the date and price from service AND the price from offsite service.This way I have the price from both tables that I can add up and get a total sales report.

And yes I'm an access dummy, so please keep your directions easy for me to understand. Thank you in advance.
Bill

View 3 Replies View Related

Multiple Effective Dates (latest Date)

Jan 17, 2007

Below is the code I have for a query. This query shows Processes, Operations, etc. Due to multiple Effective_ (Effective_ stands for Date) The Operations show multiple times. What I would like to do is have each Operation show only one time based on the latest Effective_ i.e. If Operation START-UP is listed three times due to three effective dates 2007-01-04, 2007-01-08 & 2007-01-17 I would only like to the the one associated with the 2007-01-17. Is there a way to accomplish this in my query?

SELECT ASSYROP.PROCESS, ASSYROP.OPERATION, ASSYROP.OPERATION_, ASSYWC1.PROCESS_AT, ASSYROP.OPERATIO_1, ASSYROP.EFFECTIVE_
FROM ASSYROP INNER JOIN ASSYWC1 ON ASSYROP.OPERATION = ASSYWC1.OPERATION
GROUP BY ASSYROP.PROCESS, ASSYROP.OPERATION, ASSYROP.OPERATION_, ASSYWC1.PROCESS_AT, ASSYROP.OPERATIO_1, ASSYROP.EFFECTIVE_
ORDER BY ASSYROP.PROCESS, ASSYROP.OPERATION, ASSYROP.EFFECTIVE_;

View 3 Replies View Related

Queries :: Hiding Date Picker From Date Fields

Nov 5, 2013

The 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.

View 2 Replies View Related

Date Picker Help

Aug 16, 2004

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?

View 5 Replies View Related

Automatically Sort Through Report By Date - How To Choose Multiple Dates Through Popup

Jul 26, 2013

I created a pop-up that appears when i open my report so that I can automatically sort through the report by date. However, the report will only allow me to choose one date and i need to be able to choose multiple dates. This pop-up is connected to a list box which has the multi select turned on. How can choose multiple dates through my pop-up?

View 1 Replies View Related

Forms :: Input Multiple Records At Once

May 22, 2014

A little bit of context first: I am producing a database to store information on overhead line structure renewals.

I have a table called tblStrucTasks with four fields; Task ID, Structure Type, Create (specifies whether the structure is to be created or removed) and Task. I need to enter multiple records which will have the same Structure Type and Create fields but different Task fields. There are many tasks for each structure so I'd like a form where you only have to select the Structure Type and Create fields once. Some sort of list where the tasks could be typed in would then be perfect.

I'm not sure whether this should be done with VBA or queries. I'm new to databases so I don't know a lot about queries but I have a little bit of experience with VBA from Excel.

View 2 Replies View Related

Date/Time Picker

Jul 26, 2007

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,

View 3 Replies View Related

Date Time Picker

Aug 27, 2007

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

View 7 Replies View Related

Combo Box Date Picker

Sep 10, 2006

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?

View 13 Replies View Related

Date/time Picker

Mar 18, 2005

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

View 6 Replies View Related

Date And Time Picker DTP

Mar 3, 2006

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.

View 6 Replies View Related

Wierd Date Picker!!

Oct 12, 2006

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?

View 6 Replies View Related

Forms :: Subform - Input Box Reappears When Closing Database

Nov 13, 2014

I have a

- form called "Hauptformular" and a
- subform called "qry_tracking_Unterformular". Then there is a
- button called "cb_filialname".

Now when opening the Database, the form appears with the subform containing the
- query "qry_tracking"

When hitting the button "cb_filialname" the subform receives the contents of the
- query "qry_tracking_FilName", that has a filtering option on the Column "Filiale": "Like [Filialname?]"

Now the filtering works fine with the following Code:

PHP Code:

Private Sub cb_filialname_Click()Me!qry_Tracking_Unterformular.Form.FilterOn =
FalseMe!qry_Tracking_Unterformular.Form.RecordSource = "qry_tracking_FilName"End Sub

-> when you hit the button, the inputbox

Filialname?

appears.

The problem now is, that after having used the button, when I click the "Exit" cross right up there, the inputbox appears again.

View 2 Replies View Related

Repair Date Time Picker

Mar 8, 2007

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

View 2 Replies View Related

Calendar Date And Time Picker

Nov 27, 2007

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.