Textbox Code for Date Format

Pretty sure it's something silly on my part.

form contain combobox  'Date'
(It looks up dates from specified dates within payroll timeframes)
No-Control text box placed next to combo box to have Day of Week appear to 
keep people on right day. (I don't like the calendar idea, because I need to 
keep people in the correct payroll date range and other items.)

For text box, from property window / data tab / control source I've entered

=Formate([Date],"dddd") expecting the day of the week to appear on focus.
Field populates fine but shows wrong day of the week.

Actual Date in [Date] combo box is 1/23/10.
Text box is returning 'Sunday'.

Am using Access 2003
Op System Windows XP

Thanks so much.


0
Utf
2/7/2010 3:20:01 PM
access.formscoding 7493 articles. 0 followers. Follow

1 Replies
1719 Views

Similar Articles

[PageSpeed] 8

FerryMary,
    First... don't name a control [Date].  It's a reserved word in Access.
    Try PayrollDate, or PayDate, etc...
    Still have a problem?  Post back on this thread...
-- 
    hth
    Al Campagna
    Microsoft Access MVP 2006-2009
    http://home.comcast.net/~cccsolutions/index.html

    "Find a job that you love... and you'll never work a day in your life."

"FerryMary" <FerryMary@discussions.microsoft.com> wrote in message 
news:636561CF-1954-443C-885A-082FDEC6D772@microsoft.com...
> Pretty sure it's something silly on my part.
>
> form contain combobox  'Date'
> (It looks up dates from specified dates within payroll timeframes)
> No-Control text box placed next to combo box to have Day of Week appear to
> keep people on right day. (I don't like the calendar idea, because I need 
> to
> keep people in the correct payroll date range and other items.)
>
> For text box, from property window / data tab / control source I've 
> entered
>
> =Formate([Date],"dddd") expecting the day of the week to appear on focus.
> Field populates fine but shows wrong day of the week.
>
> Actual Date in [Date] combo box is 1/23/10.
> Text box is returning 'Sunday'.
>
> Am using Access 2003
> Op System Windows XP
>
> Thanks so much.
>
> 


0
Al
2/7/2010 3:51:42 PM
Reply:

Similar Artilces:

Be able to enter UPC Codes on the inventory card
-- HK ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/Businesssolutions/Community/NewsGroups/dgbrowser/en-us/default.mspx?mid=fea181b3-023c-48d0-aa8a-ac0926980706&dg=microsoft.public.greatplains I asked for this in an earlier post. The s...

Fixed Formating
I have every other row highlighted. When I sort, the sort takes the row format so that rows are no longer highlighted every other row. Is there a way that I can fix/lock the formating by row? Thanks Hi have a look at http://www.cpearson.com/excel/banding.htm -- Regards Frank Kabel Frankfurt, Germany Ronbo wrote: > I have every other row highlighted. When I sort, the > sort takes the row format so that rows are no longer > highlighted every other row. Is there a way that I can > fix/lock the formating by row? Thanks ...

Bulk Date Change on Activities
Am new to CRM 3.0 however I would like to find a way of changing the due date on mulitple activites. I would like to be able to select multiple activites then apply possibly a rule that asks for a new due date for all activities selected. Anyone got any ideas???? ...

Format Table linked to Excel
I have created a macro in Excel which names a range depending on the amount of rows used. I have then created a link in Word which is linked to the named range, so the table in Word only shows the used rows. The trouble is when I update the link, the formatting of the table is lost. I want the table to show gridlines and keep row heights and column widths. The column widths are a problem because when they update, they are different across each row ie, they don't line up under each other. Is there a way to fix this other than manually fixing the table after updating the...

Join tables by dates
I have 2 tables that I need to join. The first table contains the fields PhoneNumber, FromDate, Todate, PlanCost. The second tables contains the fields PhoneNumber, DateOfCall, CallCost. There are multiple plans for each phone number in the first table as the phone plans change over time. I want to add the phone plan, to the second table, that relates to the date of the call so that I can check we were being charged the correct amount. Any ideas? "Ryan" <Ryan@discussions.microsoft.com> wrote in message news:BCA73978-8C43-4375-81C9-6FA748CF5D35@microsoft.co...

Trouble formatting Date data
I am using a Line chart to plot specific milestones over a series of dates. Each line in the chart represents the series of data and its progression over time. I have managed to create each series of data with my dates showing up in the X axis as a Time-Scale. However, I need my categories (the names of the milestones) to appear in the Y axis and I can't figure this out. I also want to experiment with having the dates appear in the Y axis, and categories in the X, although this does not appear to be possible. I believe this would represent my data more meaningfully. Your help i...

Ability to enter a invoice due date.
Why doesn't Great Pains allow for the entery of a due date for invoices? Currently you have to trick GP with an invoice date in the future. Also, why doesn't Great Pains have an Invoice Date field that isn't used to drive the posting period. The date keyed should drive the period that an invoice is posted too, while the invoice date should drive when the invoice is paid. Great Plains is the worst accounting system that I have ever seen. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for...

Code to automate Calendar options/add holidays
Can someone help me to get a code(any language) to automate below mentioned tasks? 1.Select Calendar Options, and under Calendar options, click Add Holidays. 2.Select the check box next to 'South Africa' . You may Uncheck other Boxes as necessary. You may add holidays of other countries by checking the box as needed. Regards, Zamsheer Sendkeys? If you want to eliminate the need to browse the long list of countries, you can edit the outlook.hol file in notepad and delete all of the countries that users are unlikely to need then email the file. Users dou...

group-object formatting question
Hello there, one question on the formatting of the group-object output. Using dir | Get-Acl | ForEach-Object { $_.Access } | Group-Object IdentityReference I get a table with Count, Name and Group. Count Name Group ----- ---- ----- 9 predefines\Administr... {System.. 9 grpTP-FILES-IT-RW {System.Secur How can I access just the Name field of this output? Thanks very much, Uwe R2V0IHRoZSBwcm9wZXJ0eSB2YWx1ZSBmcm9tIGVhY2ggW01pY3Jvc29mdC5Qb3dlclNoZWxsLkNv bW1hbmRzLkdyb3VwSW5mb10NCg0KZGlyIHwgR2V0LU...

Code help needed for Option Buttons to control Subs
I have a User form with (20) option buttons on it. It does what I want by only being able to check 1 option button. Option Button Names: OB_601 OB_602 - OB_619 OB_620 What I need help with is when user checks the correct option button, that button exicutes code located in a module. Code in Module: There are (20) Subs named like below Sub String_01() Sub String_02() - Sub String_19() Sub String_20() I think the code for each Option button is something like this, because there default position is False and they only show true when selected. If OB_601 = True the...

Open and Convert Mac .numbers to excel file format tools
Are there any tools that allow PC user of Excel to open a Mac .numbers extension file? kspalladino@yahoo.com ...

How To Match Dates
On worksheet1, I have a several columns (A-M) one of which (colA) is the daily date in the format of 21-Nov-2004 so by the end of a year there will be approx 365 rows. On worksheet2, there is a single row monthly summary of the above data (so sheet1 has approx 30 rows per month while worksheet2 has a one row summary) where the date on this second worksheet is headed as Month Begining (A1) 01-Nov-2004, (A2) 01-Dec-2004, (A3) 01-Jan-2005 I now need reference a date from sheet1 to the summary on sheet2, so if I input 12-Jan-2005 on sheet1, I need to have the monthly summary row from she...

Formatting Task Description
I don't know how to add the 'ruler' for formatting my task descriptions Click "View ruler" in upper right corner of Note area. davedel2001 wrote: > I don't know how to add the 'ruler' for formatting my task descriptions ...

Formatting Date in Header or Footer
How can I change the default date format (8/18/2004) in the header/footer to a different date format (18-Sep-04)? Is there a way without using VBA? Thanks Hi see your other post -- Regards Frank Kabel Frankfurt, Germany "Emile Zac" <emilezac@hotmail.com> schrieb im Newsbeitrag news:u16wacYhEHA.3320@TK2MSFTNGP11.phx.gbl... > How can I change the default date format (8/18/2004) in the header/footer to > a different date format (18-Sep-04)? Is there a way without using VBA? > > Thanks > > ...

maximize main window by code
I searched the group to find out how i can make window state MAX by code, while window opening at the very beginnig. Common solution is to write the code below in Open Event of main form. DoCmd.RunCommand acCmdAppMaximize It is not working! Do you have any other suggestion? On Jul 13, 6:20 pm, Klatuu <Kla...@discussions.microsoft.com> wrote: > Docmd.Maximize > The code you are trying to use is out of date. > Also, use the Activate event rather than the Load event. This is so that if > the user moves to another form, report, or whatever and returns to the form > it will...

YTD showing Life to date in Smartlists
I am having trouble with the Customers and Receivables transaction Smartlists showing life to date, when the column name is Total Sales YTD. Does anyone have any suggestions as to why this might be happening? Ta, Travis. Hello Travis, That data is extracted from the summary table. It might be that you need to reconcile your data in order for the right data to show up, that is if your summary data is not correct. Kind Regards Eddie Fourie MBS Specialist TV> I am having trouble with the Customers and Receivables transaction TV> Smartlists showing life to date, when the column na...

how I can format a number like hundreds, thoudsands
I am from INdia and need to format the numbers in Indian style like comma sepration based on hundreds, thousand pattern Very first hit on Google searching for Format and Indian:- From a Google search here is a reply by David Richie to the same question in January If you have Excel 2002 or later look up bhattext in help. Otherwise the following format might help you [>=10000000]##\,##\,##\,##0.00;[>=100000]##\,##\,##0.00;##,##0.00 (This format separates groups for India/Thailand, format valid for positive numbers up to 99,99,99,999.99 or 999,999,999.99) in Excel XP see function Bh...

Adding time to date-time formatted cell
Not sure quite how to do this... I have a cell (A1) which I have formatted to read the date and time (MM/DD/YYYY HH:MM AM/PM). That is my starting time. What I want to do now is be able to input a time period in hours (A2) and have another cell (B1) add those hours to A1 so B1 will read the "ending time" - formatted with the (MM/DD/YYYY HH:MM AM/PM) format. Is this possible? Thanks! Basically, I want it to lay out like this: Cell A1: 8/12/05 2:00am Cell B1: 12 (it takes 12 hours to run this process) Cell A2: 8/12/05 2:00pm Thought that might make it more clear what I&...

Problems moving Microsoft Date and Time Picker Control on MFC dialog
I've got an MFC CDialog class that displays and manages a dialog. There are several controls on the dialog (combo boxes, edit boxes, static text boxes, etc.). Included in the mix are four Microsoft date and time picker controls. The dialog is used in three separate instances. Not all of the controls are relevant in all three instances so we hide the controls that aren't relevant in each instance, move the controls around on the screen, and resize the dialog to eliminate dead areas on the dialog. We are getting the CWnd for each control and using the SetWindowPos method for each control...

Code Execution has been interupted
I have written a macro within excel. Works really well but can take up to an hour to process. Problem is that every now and again, I get the message "code execution has been interupted". I read the help file and this does not help. I am not pressing "Ctrl-break" or any other combination of keys. In fact I am not even touching the keyboard at the time! Anyone any clues as to why this might happen? The macro does access some other spreadsheet, but these are no opened by anyone else at the time (they are all on my C drive). Help anyone? Without seeing the code, it...

Modifying Date Range 2
Now, I need to modify the expression: Between [Forms].[frmReport].[StartDate] And [Forms].[frmReport].[EndDate] Is there a way to modify the expression above so that: [StartDate] mm/dd/yyyy mm=01, dd =01, and yyyy= the year entered and [EndDate] mm/dd/yyyy mm= the month entered, dd= the day entered, and yyyy= the year entered A date is entered into [StartDate] and [EndDate] from the form “frmReport” in the format of mm/dd/yyyy. Thanks Again -- Message posted via http://www.accessmonster.com Thanks Ken -- Message posted via AccessMonster.com http://www.accessmonster.com/Uw...

Storing data in Short Date format
Hi, I have produced a couple of other Access databases where, in the Table design, I have selected Short Date and only the date has been stored in the table. In the current database I am working on I have selected Short Date on table fields but find that the date AND time is being saved. This is causing problems whem I want to seach by date. Can anyone suggest why, on this occasion, Short Date format is causing date and time to be saved (like the General Date format) when data is entered through a form (where the control is also set to Short Date format)? The problem is evident on all t...

switch off transforming number into date
"aa" <aa@microsoft.com> wrote in message news:%2323$vYzhKHA.5604@TK2MSFTNGP04.phx.gbl... > How do I switch off that autocomplete or autoformat or whatever the name > of > that feature, which transform a decimal number like 12.42 into > marcian-looking date like Dec.42 ? > It does it at random in some cells > > You might also look at "Transitional formula entry" in the customization settings. mike ====================== in my Options-->Transitions--> the box Transition formula evaluation is not ticked ...

using find in excel from C# code
Hi, I am working to make an aplication that open an existing excel file, search for some text and notifies the result. Now, when I run it, before the excel file's opens get this error: COMException Types mismatch (Exception HRESULT: 0x80020005 (DISP_E_TYPEMISMATCH)) My code is: object oMissing = System.Reflection.Missing.Value; Excel.ApplicationClass oExcel = new Excel.ApplicationClass(); oExcel.Visible = true; Excel.Workbooks oBooks = oExcel.Workbooks; Excel._Workbook oBook = null; ...

Number format in queries
Hopefully this is easy. Does anyone know if it is possible to change the default number format for number fields to "standard" (or any other format). I'm getting very tired of going into properties all the time to flip the setting so that large numbers are actually readable. Thanks, Tom. "Tom Telford" <TomTelford@discussions.microsoft.com> wrote in message news:058E7F53-4280-4EA4-A80B-C832F4017BC5@microsoft.com... > > Does anyone know if it is possible to change the default number format for > number fields to "standard" (or any other f...