Computer Support Forum

MS Outlook 2003 - Reverse Date in Subject Field

Question: MS Outlook 2003 - Reverse Date in Subject Field

I want to be able to place the date in reverse order in the subject line of new emails when I press a button on the toolbar. The format of the date should read '20061003' for the 3rd Oct 2006 - I know i should be able to use a macro or write VB scipt, bit i am not that clever - please help - many thanks

Relevance 100%
Preferred Solution: MS Outlook 2003 - Reverse Date in Subject Field

I recommend downloading and running Reimage. It's a computer repair tool that has been proven to identify and fix many Windows problems with a high level of success.

I've used it in the past to identify and fix everything from blue screens (BSOD's), ActiveX errors, corrupt files and processes, dll/exe/sys errors, recover lost memory, Windows update problems, defragging, malware removal etc.

You can download it direct from this link http://downloadreimage.com/download.php. (This link will automatically start a download of Reimage that you can save to your computer.)

Answer: MS Outlook 2003 - Reverse Date in Subject Field

06.10.03 - subject.It's easier to read and there will not be a filing problem for the next 94 years or so.I'll leave the technical stuff to others

8 more replies
Relevance 104.96%

I use due dates on my Outlook tasks. When I customize my Tasks list (in the Calendar view) to group by due date, I just get too many groupings (one for each due date!). I would like to know if I can create a custom field called 'Due Month' and/or 'Due Week', extracted from the 'Due Date', so I can view my tasks by what is due during a given week or month. If the answer is yes, any suggestions on the technique I would use would be greatly appreciated.
Thanks in advance,
Mac
 

More replies
Relevance 100.45%

A number of years ago, my work PC had a button on the Outlook e-mail menu bar that, when selected, placed the current date/time (yyyymmdd_hh.ss) and a set "Authorised Mail:" phrase in the e-mail subject window. This saved typing the date, time and phrase in EVERY email sent. Is this done with a VB macro (with which I'm only vaguely familiar) or is it available as a function of Outlook? Any help greatly appreciated!!

Answer:Auto Date in E-Mail Subject in Outlook 2003

Not really sure what you're trying to do.But any e-mail client (and certainly Outlook and Outlook Express) automatically inserts the date and time when you send an e-mail and that info can be seen by the recipient.Try sending an e-mail to yourself to check if that's what you want.

7 more replies
Relevance 86.92%

Any advice please, the subject field has dissapeared from my new mail screen in outlook XP.

Answer:Lost subject field in Outlook XP

Look in View/ Current View/ Format Columns

8 more replies
Relevance 86.92%

Can anyone help with creating a button to insert a standard phrase into the Subject field of an Outlook 2002 email message? For instance I want to be able to insert "Internet-authorised: " when I email onto the Internet instead of the company LAN.

Answer:Standard Subject Field in Outlook

I believe a macro, with a button linked to it, is the solution.  At the moment, I can't tell you how to do that.  I've never created a macro in Outlook but I see it can not be done as easily in Word and Excel; you can not simply use the Macro Recorder, you have to open the Visual Basic editor and create code there.  I happen to have recently obtained two libary references on Outlook, a book and a DVD.  If I can find time to delve into this further and get an actual macro recorded, I'll post the coding for it.

2 more replies
Relevance 82%

I am attempting to find add-ons for Outlook 2010. This is what I need the add-on to do:
Export an email from Outlook onto our server, and into a job folder.
Save file with date email was received, not exported out of Outlook, and subject line.
Thanks
 

Answer:Outlook 2010/export emails from outlook to CSV folder with received date and subject

Why not drag and drop the email to the file system?
 

3 more replies
Relevance 78.31%

Hello

Access 2003
Windows XP

I am creating a new table and would like to format a field to short date. Here is my code. Is there a way to format to short date from here?

Thanks

Set fld = tbl.CreateField("Date", dbDate)
fld.Required = True
tbl.Fields.Append fld
 

Answer:Access 2003 - Format field to Short Date

try this:
fld.NumberFormat = "m/d/yyyy"
 

3 more replies
Relevance 78.31%

I have a linked Excel spreadsheet to show invoices received and I insert a date when they are paid. I cannot figure out the expression to use to show all records where no date has been inserted. Can anyone help please.Thankyou

More replies
Relevance 77.49%

Good day guys

My puzzler today (and has been for ages) is this:

In my Access report, I pull in "StartDate" and "EndDate" fields from the calling form and wish to display them as part of a report subtitle.

I therefore have a field called "DateDetails" in my report header whose ControlSource is:
Code:
="Records Selected between " & Forms!Reports!StartDate & " and " & Forms!Reports!EndDate
The dates actually derive from a table and the date format for both fields in that table is "General Date".

The result is that the report shows the following as an example:
Records Selected between 17/05/07 12:00:07 and 10/08/07 12:00:07

BUT what I want is the following:

Records Selected between 17/05/07 and 10/08/07

or even nicer

Records Selected between 17-May-2007 and 10-August-2007

Can this be done in such a control?

Chris
 

Answer:Solved: Access 2003 - Date Format in a Calculated Field

7 more replies
Relevance 76.67%

We have just upgraded to new machines in our office (Windows xp and office 2003) and I cant find anywhere on how to change something or even if its possible. When a link is sent by email outlook automatically inserts in the subject line emailing: in front of the "name" of what you are sending. Is there a way to remove that so nothing is inserted in the subject line automatically? or at least emailing isnt inserted into the subject line? Any help would be appreciated. Thanks in advance
 

Answer:Outlook 2003 Subject Line

7 more replies
Relevance 76.67%

HI,
Is there a way to add a statement to the subject line when updating a meeting. I.E
text Update: Meeting
Many Thanks
 

More replies
Relevance 76.67%

HI,
Is there a way to add a statement to the subject line when updating a meeting. I.E
text Update: Meeting
Many Thanks
 

Answer:Subject Line Outlook 2003

please do not duplicate posts here
closing this post

continue here
http://forums.techguy.org/web-email/1087998-subject-line-outlook-2003-a.html
 

1 more replies
Relevance 76.67%

Hi, I was kindly helped my AJ on this site to end up with

=SUMPRODUCT(((A7:A18)>=A6)*((A7:A18)<=B6)*(B7:B18))

for the folowing:
2 colums, 'A' with the year (currently as plain number) 'B' with a simple number. There are roughtly 5/8 entries for each year, from 1989 to 2008. I need to sum 'b' for a range of years, (say 1990 to 1995), I can do it for one year value but not more.

but the further problem I have is:
I have a list of 160 rows with the year being the key data field and selecting various ranges say 1995 to 2006.

I need to capture the data in a way that I need to keep historic info for years gone (2006,2007) but then alter the sheet (remove a row if no longer relevant) for current and future years.

I was thinking of having a final column with a "year removed field" and the main formula above being dependant on that for inclusion, make sense?
Many thanks
 

Answer:Excel 2003 - Selecting data within a date range with a further logic field?

8 more replies
Relevance 75.03%

I have windows XP Professional.

In Outlook 2002 I have set up my Inbox to group my e-mails by Subject. I am able to merge two different email subject lines into one by using drag and drop. When I do this the subject line I am dragging changes into the name of the subject line I am dropping it into.
I can not do this in Outlook 2003, it doesn't allow me to drag anything. Is there any way you know of to be able to accomplish the same thing as in Outloook 2002.
Tks and rgds
Larry
 

More replies
Relevance 75.03%

Is there any way to edit the subject field on emails that have been received?  (Friends replay without changing the subject, and I would like to save the email with the subject field corrected)

Answer:Outlook 2003, edit subject on received emails?

When someone replies to an email from you, the subject has "Re:" inserted, doesn't it?  So, why do you want to change the subject?  It should remain the same.  The "Re:" clearly indicates it's a reply, not an original message.  And, if you reply back to such a message, the subject line will start with "Re: re:".  That creates a sort of a trail which can be useful in recognizing the history of the message.  So, why try to change the subject line?

14 more replies
Relevance 72.16%

HiOutlook 2003I would like to add a column in my inbox with personal notes of the emails.How can I do it?Thanks

Answer:Outlook 2003. New field?

I don't use Outlook, but in Incredimail one can customize the In Box columns, by right-clicking on the column header bar.

7 more replies
Relevance 72.16%

I am looking for add the "From" field in Outlook 2003 here at work? We have multiple mailboxes we send mail from and I have added them but I don't know how to tell outlook which to show I am sending from.
 

Answer:From Field in Outlook 2003?

carloswill said:



I am looking for add the "From" field in Outlook 2003 here at work? We have multiple mailboxes we send mail from and I have added them but I don't know how to tell outlook which to show I am sending from.Click to expand...

Start a new email message, click "View", then click on "From field".
 

6 more replies
Relevance 72.16%

When you start typing in that field, previous e-mail addresses come up who you've sent to before. Where are these stored?
 

Answer:Outlook 2003 TO field

What exactly are you trying to do? Edit that list?
 

5 more replies
Relevance 71.75%

we use outlook to view messages in the military. these messages are most likely refrenced by their date time group. in the message ( body of the email ) it will state the DTG.. example DTG: 291323Z Apr 10

i would like to make a field in my view so i can have the messages displaed by DTG. is this possible? if so how?

thanks
 

More replies
Relevance 71.34%

I use Outlook 2003 and when i compose or reply a new email, i sometimes want the BCC field to be visible. Under Outlook 2000 i used a addon called TWEAKOL and it allowed the BCC to be visibleI am using Outlook 2003 and would like to know if there is a (possibly free) way of doing the same thing.I have tried TWEAKOL to see if it will work under Outlook 2003 and it does not.

Answer:BCC field to be visible in Outlook 2003

"Under Outlook 2000 i used a addon called TWEAKOL and it allowed the BCC to be visible "under Outlook 2002 open a blank message, View Menu, tick Bcc Field....

10 more replies
Relevance 71.34%

I'm running Outlook 2003 under Windows 7. I often get e-mails from my cousin, which she sends to a lot of people whose addresses she puts in the Bcc field. Under Windows XP, Outlook used to translate those addresses to "Undisclosed-recipients" in the To field, which is how I saw them. Now, under Windows 7, both the Bcc and To fields are blank, and the message contains all of the HTML routing and other formatting information, making it impossible to read. Is there a fix for this that I can download?
 

Answer:Outlook 2003 Bcc Field in Windows 7

OK, got to watch this one I have Office Outlook 2003 on W7 and never seen that happen, going to switch over to W7 and have a look.
 

2 more replies
Relevance 70.52%

Can I create a field in Outlook 2003 that can be viewed on the first tab of a contact record where the address, name, company and telelphone fields are? In addition - can the information in this field be exported and imported?
 

More replies
Relevance 69.7%

I need a date field changed into a text field of YYYYMMDD so for example the date of birth field is 3/17/1953 and I need that converted to 19530317 in the Excel spreadsheet. Thanks.

Answer:I need a date field changed into a text field of YYYYMMDD

under the format options.

5 more replies
Relevance 69.7%

Is there anyone out there who knows a lot about Microsoft Outlook 2003 ? The reason I ask I have an issue with Microsoft Outlook 2003 on the service desk on which I work. Customers send emails to the service desk for a variety of reasons but it all gets a bit messy as service desk personnel open emails and we have no idea of who has opened what and therefore who is dealing with what.

I have been told one way to deal with this is field chooser as you can create an additional column called ?Analyst? , when each analyst then places is name against the email he/ she is currently working on and that way all the remaining team members are aware of who is working on what. It works in a similar way to flags but with the flexibility of when the team grows instead of running out of coloured flags we just add the name.

I have been tasked with implementing this but I can not get beyond setting up field chooser and adding the ?Analyst? column. Has anyone done a similar thing or know how to resolve this, I would be really grateful for any help here.
 

Answer:Field Chooser Issue On Microsoft Outlook 2003

The company I work for has one dispatcher who assigns each request with a tech's ID number in the subject line then all follow up emails are subjected with that number only - you see your number you open reply etc...
If at your company this is out of the question try this...
Set up each analyst with an ID number...

As each of you open emails change the subject line to your established analyst number ID and request that the user refer to this number for the entirity of this email but if the subject changes a new request will have to be submitted and this will tell others its been responded to and to whom is responding.

Good Luck
 

1 more replies
Relevance 69.7%

I've seen this a few places on the web but have fond no answer.


XP, MS Outlook and Word 2003

Dell Laptop Inspiron ET505


I list a name and address n the TO field, ie, john doe <[email protected]>

I copy the whole john doe <[email protected]>

I paste it into the text box or a word doc and get only "john doe"


I've been told that if I make my Outlook display name = john doe <[email protected]> it would then copy the whole thing (including email address). It doesn't.



I once read that Outlook doesn't recognize < >. I use Yahoo for personal mail and I often need to transfer there, so prefer to keep my emails in this format.



I know you can go to "properties" and gather the email address (all the posts say this), but if I click on the name in the To field, the "Email Properties" gives me a display name that does NOT include the email address--though the display name in the address book does. I like to copy both the name and the address at once and this takes two steps. If I go to the address book, hit Properties, then, yes, I can get the full john doe <[email protected]>. That is obviously cumbersome for multiple names and I find this an unacceptable solution.


Surely some computer whiz has bypassed this asinine malfunction and created a program that allows you to copy an email address in a mail program!! To say it's like creating a car w/o a starter motor ... Read more

More replies
Relevance 69.7%

computer: Windows XP Professional Version 2002 Sp2outlook: microsof Outlook 2002 (10.6838.6845) SP3Is there any way to overturn a txt file for example, the subject field of all emails in a tray outlook?"La experiencia es algo maravilloso. Nos permite reconocer un error cada vez que lo volvemos a cometer.", Franklin P. Jones

Answer:dump the subject field to a file

Cannot understand what you mean???

3 more replies
Relevance 67.24%

First the background: We are gradually deploying Office 2007, but not everyone in the agency has it. I have both 2003 and 2007 installed on my system, but I do my work in 2003, and none of our databases have actually been converted to 2007 format (at least, none that I work with). There are occasionally people who use 2007 when viewing databases, but I don't know if any of the people who are working in this particular database are using 2007. The problem is reproducible in 2003 and so I've been trying to fix it here. The query behind the problem report used to work. It has been a problem for several months (it is run monthly, and every month for the past five they've had problems with it) and I've finally gotten to the root of the actual issue.

The purpose of the report is to generate invoice for outstanding loans. The DateNextPayment is a calculated field based on the payment plan for the loan. It is calculated using a function in the query named qryGetSitesDDInvoices1. This is the function that is called (I did not write this function, I'm supporting this db long after the original writer has left):
Code:
Function DateNextPayment(PaymentSchedule As String, DateFirstPayment As Date, Balance As Currency)

On Error GoTo Handle_err

Dim Date1 As Date
Dim Date2 As Date
Dim Date3 As Date
Dim NextQtrDate As Date

'The code adds one month to datenextpayment at start of each month. Or yearly or weekly

... Read more

Answer:Solved: Date Parameter Failing in Query from calculated date field using DateValue Ac

16 more replies
Relevance 67.24%

Hi! Does anyone know what is the format of the date in the field "(battery) Manufacture Date" informed by Lenovo Vantage (Hardware Configuration > Energy)? It seems not to follow Windows setting. In my case, it is set to Brazilian Portuguese DD/MM/YYYY, but there is not a leading "0" in the returned value (see attached image). Does it really disregard the Windows setting and presents it in a fixed format (maybe American English)? When was my battery manufactured (Oct. 07 or July 10)?Thanks in advance.  

More replies
Relevance 66.83%

Although decently experience with excel, I am quite new with VBA and I cannot "record" this macro, so any help writing this in VBA is much appreciated.

1) I need to create a macro that will take a number that is entered into a cell, and upon hitting a button in the excel sheet create an email where the subject line is the number that was in that original cell.

1b)I would like to do this without changing the name of the excel file though, or at least have another macro that resets the file to its original name.

2) Also, if possible, the same macro/vba as above, only with two cells, a number in one and a name in the other, which then shows up as "Number-Name" as the subject line in the email.

Thanks to anyone that can help - Mike
 

Answer:Excel Macro -> email created with field data as subject line

8 more replies
Relevance 66.42%

Hello,

I have a large report of application forms which have been submitted including the date when they were submitted however the dates are formatted incorrectly.

1. Although the cell formatting is dd/mm/yyyy the data is being shown in mm/dd/yyyy which means the dates are incorrect (e.g. 2nd January would read as 1st February.)
2. As a result of this dates which are passed the 12th of a month are not accepted as dates (it reads the day figure as months and there is no 13th month etc)

I have tried to use the text to columns function but that makes no difference and I have tried to extract just the dates but I've had no luck.

Can anyone help, I've attached a small sample of the data.

Thanks

Daniel
 

Answer:Exported date field not recognized as date in Excel

Where does the data come from?
What do you get if you have no cell format?
 

3 more replies
Relevance 66.42%

I accidentally formatted the date cell & it only accept numbers

Answer:how to correct a date field when you enter a date a number a

I don't know what you mean by "it only accepts numbers".Why can't you just format it as a date again?Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

2 more replies
Relevance 65.19%

Hi there,

I am trying to get a macro for Outlook 2003 that when I compose a new email in Outlook 2003, the date will appear in the subject line automatically in the following format:
20101009-
I have tried looking into it in Outlook but it says that macros will not work in Outlook and I have to do in in VB Editor. Unfortunately I am a complete novice (or noob as my son would call me) with VB Editor.
Would anyone be able to help me out please?
 

Answer:Date Macro for Outlook 2003

10 more replies
Relevance 65.19%

Hi All,

Is there any encountered a problem when sending a msg from outlook 2003 and to forward in same account the date appeared is lastday. for example today is November 13, 2008 so I compose a msg and send to same account it appear to my inbox as lastday which is dated November 12, 2008.but when i send a msg to the another email add, it appear as what the date today. I am thinking that problem is on the terminal, so that I check the date of the PC but it is correct for the date today.I don't know on where the outlook get the date if it is on my computer or in the server or etc..

hoping for your response
 

More replies
Relevance 65.19%

Hello,
First off what a knowledgeable and useful site you have. I have been trying to sort out several IT issues now that I have become my organisations IT guy i.e. I can fix a few software and hardware issue without calling in tech support. However my Outlook Macro skills have been found wanting so by searching this site I found this old closed thread

http://forums.techguy.org/business-applications/867198-date-macro-outlook-2003-a.html

which is exactly what I was looking for, to Rollin_Again for his great advice, on how to get the date inserted automatically into outlook 2003 subject line when I open an email using the date time group of yyyyMMdd. I'm using his recommended code:

Sub CreateMail()

Dim objOutlookMsg As Outlook.MailItem
Set objOutlookMsg = Application.CreateItem(olMailItem)
objOutlookMsg.Subject = Year(Date) & Month(Date) & Day(Date) & " - TEST SUBJECT"
objOutlookMsg.Display

End Sub

And I have the macro set up and working.

The only problem is that instead of displaying the date time group as yyyyMMdd so that for 1 Feb 2010 it would read 20100201 it will display it without the month and date with a preceding zero such as 201021. I've searched this site and goggled for the last 4 days to try and sort the issue out myself but no luck hence the post here. I have changed my regional settings in the control panel trying out other date formats and customising my own, they replicate through to word and excel but I just can't... Read more

More replies
Relevance 64.78%

Help! This should be easy but I can't get it to work.

I have a report that must group by Trip# and sort by ascending activity date all of the various activities that took place on multiple days of the trip.
Further, the trip with the earliest date must come first regardless of the Trip#.
I've accomplished getting the earliest starting date trip first and grouping its detail with a unique string made up of the earliest date of each trip formatted to YYYYMMDD+Trip#. This prints a trip total and works fine.

But the daily activity for the trip is out of date sequence.
Adding a Date field to the 'Sorting and Grouping' insists on breaking on and printing a sub-total for each of the trips activity dates.
Without the sorting & grouping by date the trip records are out of sequence even though the data source query is sorted ascending by activity date.

(see attachments that show the above)

The only solution I can think of is to create a sub-report sorted by activity date.

Does anyone have any better ideas?

Jim Shannon
JES Computer Systems
Access Developer.
 

Answer:How sort by 2nd field (date) without grouping when date changes?

7 more replies
Relevance 64.37%

Hi.

Is there something I can add to my Outlook code to reformat the Date from mm/dd/yyyy to a date format that uses the month name instead of number? Also, is there any way to place the date in a specific part of the email body? Right now it appears at the bottom left of the email body. Thanks!

Here's what I'm using:

Code:

Sub StampDateHTML()
Dim objOL As Outlook.Application
Dim objNS As Outlook.NameSpace
Dim objItem As Object
Dim strStamp As String
On Error Resume Next
Set objOL = Application
Set objItem = objOL.ActiveInspector.CurrentItem
If Not objItem Is Nothing Then
If objItem.BodyFormat = olFormatHTML Then
Set objNS = objOL.Session
strStamp = "<p>" & Date
objItem.HTMLBody = Replace(objItem.HTMLBody, _
"</body>", _
strStamp & "</body>", _
, , vbTextCompare)
End If
End If
Set objOL = Nothing
Set objNS = Nothing
Set objItem = Nothing
End Sub
 

More replies
Relevance 64.37%

I've done this before so I know it can be done. But for the life of me I can't remember how to run a rule in (wondows xp) outlook 2003 for a specific date.

I've made changes to some rules I have and I need to run them on email in the inbox but only for a specific date.

Any help would be greatly appreciated
 

More replies
Relevance 64.37%

I have spoke to someone who is dependent on sending customers' emails. It is vital that the email dates are correct. I think the problem started when the clocks went ahead.I have instructed them to do all updates for outlook 2003. I verified that the problem is not related to their email host. The date stramps are correct when they send out email usijng webmail. Her computer is free of viruses and spyware and is maintained very well. She did a detect and repair as well.She has Mcafee as her antivirus scanner and no firewalls that I know of.I spoke to her email server and they have not any such issues regarding their server.Maybe someone out there has dealt with thiis before. My hunch is that maybe by upgrading to outlook 2007, this problem would get resolved. She doesn't want to use outlook express, which has it's own problems and is not supported any more.I am clueless to what would be the next step.

Answer:Outlook 2003 has wrong date stamp

I made sure the time, dsate and region was correct in the control panel and even in the bios. and it was correct.

9 more replies
Relevance 63.96%

Is it possible, without scripting in VBA, to sort Outlook 2003 contacts by last saved/edited date? I need to import contacts to my cell phone, which has a primitive mechanism that requires me to manually synchronize with Outlook. This sorting ability would help determine which entries have changed since the last time I updated my phone.
 

Answer:Sort Outlook 2003 contacts by last saved date?

Welcome to the forum.

I found a last saved time field but it did not seem to work for some reason.
 

1 more replies
Relevance 63.96%

I have recently had to reformat by Window XP Laptop reqiring a reinstallation of all ProgrammsOutlook 2003 has since this reload returned a none date when sending emails to the outbox.It should change the email into italics and have a send date by each email.Is there a simple setting to change this back.I have already tried uninstalling and reinstalling Office 2003 but to no avail.Does anyone have any ideas please?Thanks

More replies
Relevance 63.96%

In my Outlook 2003 there are large lines separating the items in the inbox by date. How does one remove them?

Answer:Outlook 2003 - Removing Date Separation In Inbox

Solved it! I thought it would be in options, but one deselects "sort in groups" under View/Arrange by

Thanks.

1 more replies
Relevance 63.96%

Instead of having the date displayed within your calendar view as:

Is there a setting that can be changed so that it reads the day (ie. Friday 4 January) instead?
 

Answer:Solved: Outlook 2003 Calendar Display Day instead of Date?

8 more replies
Relevance 63.96%

Hi there,

Previously I requested assistance in trying to get a macro for Outlook 2003 that when I compose a new email in Outlook 2003, the date will appear in the subject line automatically in the following format:
20101009-

Member Rollin_Again very kindly gave me the following data:

Sub CreateMail()

Dim objOutlookMsg As Outlook.MailItem
Set objOutlookMsg = Application.CreateItem(olMailItem)
objOutlookMsg.Subject = Year(Date) & Month(Date) & Day(Date) & " - TEST SUBJECT"
objOutlookMsg.Display

End Sub

It works apart from now a new year has started, the month only date only appear as a single figure if less that 10 (eg 201011 rather than 20100101)
I have tried editing with it but no joy.

Can anyone help please?
 

Answer:Solved: Editing Macro Date for Outlook 2003

9 more replies
Relevance 63.14%

This just started.

If I create a new folder in Outlook and move emails there, the date/time stamp of these emails change to the date/time I created the folder.

Doesn't happen when I move them to existing folders though, only new folders.

To see if it's specific to my Outlook, I connected to another on a terminal session and the same problem occurs.

Help!!!
 

More replies
Relevance 62.73%

I would like to have the people on my distribution list see only the name of the distribution list in the "To:" field of the e-mail I've sent, rather than the names of all 25 members in the dist list. I'm aware of using the BCC method, but am wondering if there is a better way.
 

Answer:Show ONLY Dist. List name in "To:" Field, Outlook 2003

I think this is only possible if you are using a MS Exchange Server distribution list that was set up as 'Hide Distribution List Membership'.

I don't think you can do it with your local distribution list.

However, there are some clever people in TSG so .....

rgds
Hew
 

1 more replies
Relevance 62.73%

I have a working Exchange 2003 server and clients running outlook 2003. Everything seems to be working well except for one thing.

I created a shared contact folder in the public folders. I then added a bunch of contacts and gave editor permission to a "Staff List". Staff List is a distrobution group in AD.

Each member of the group and go down to public folders and open the Public Contacts folder and see/edit the contacts in there. So that seems to be working great.

I then right-clicked on the folder and checked the box to add the Public Contacts to the outlook contacts options. Now when I user starts a new message and clicks the "To" button they see a option under "Global Contacts" for Public Contacts.

The problem is that the Public Contacts are empty there. It is as if they can't see them at all, but they can if they go down to the actual folder in the public folders.

Any ideas?

Thanks
 

More replies
Relevance 62.73%

Hi: I want to add the Notes field to a Category view of appointments.

I managed to get the Notes field showing by using the Field Chooser, and picking Notes from the All Appointment Fields list.

I later removed the Notes column by dragging it off the bar with column names, and now can't get it back again.

I've looked in the Field chooser, but Notes no longer appears in the All Appointments fields list in Field chooser.

Help!
 

More replies
Relevance 62.32%

I know the Include Field will include part of the text from an Include File if it is in a bookmark. The format is {IncludeText "File Path" Bookmark}. I have 2 files: Source and Target.

Source is a form template. I included a Text Form Field and gave it the bookmark AA. I also included other text in a "normal" bookmark, BB.

In Target I have 2 fields: {IncludeText "C:\\Source.dot" AA} and {IncludeText "C:\\Source.dot" BB}. The text from BB shows up, but the one for AA is blank.

If I go into Source and look under Bookmarks, both AA and BB are there.

BTW, I have tried it with the Source form both "Protected" and "Unprotected" and it didn't make any difference.

Any idea why this is happening, and more importantly, any idea on how to make this work? If not, it seems like a real bug in Word 2003 as they are both definitely considered to be bookmarks.

Thank you,

Stuart
 

Answer:Word 2003 - Include Text Field - Not Including Bookmark Text if in Form Field

Thread reopened for user to post solution.
 

3 more replies
Relevance 61.5%
Relevance 61.5%
Answer:Notepad F5 gives time then date, need to reverse order, to date then time

I believe the answer is available at https://www.experts-exchange.com/questions/20430625/Windows-Notepad-exe-change-F5-date-format.html

3 more replies
Relevance 58.63%

Hi,I'm trying to create an if formula and I'm a bit stuck.Column L contains dates separated by commas. I'm trying to create a formula to say:if L2 contains (fixed date from a single cell) then "Exclude" else "No"There are two issues. How do I make the if statement contains not just equals? How do I copy the cells down and keep the field with date in fixed?For example I added the date I needed to 'Delivery sheets d1':=IF(Data!L2='Delivery sheets'!D1,"exclude","No") but when I try and fill down the D1 continues in a series e.g. d1, d2, d3 etcI hope this makes sense. Thanks in advance!

More replies
Relevance 58.63%

Is it possible with Access 2010 to have a date field that would change to current date whenever another particular field is modified. For example, we have comment field and we would like to have another date field that would change to the current date when the comment field has a change.
 

Answer:field modified date

Yes you can do it with simple VBA code, you could also add it to the comment itself, so it appears at the beginning of the comment.
 

1 more replies
Relevance 58.63%
Question: Update date field

Thanks in advance for your help!

I used to know this and I did a search and couldn't find the answer.

How do you update a field to a date either 6 months away or 12 months away for the current date in that field?

Thanks again!
 

Answer:Update date field

6 more replies
Relevance 58.63%

I work with MS Access 2003.

I am creating a query to show all contracts set up in a certain year that have been cancelled in that specific year. This "Cancelled" field is not a yes/no field, but includes the date on which it has been cancelled (always starting 31/12/YYYY).

First, to show me the contracts set up in a certain year (say 2008) , i created a parameter under the "Contract Year" field, asking which year you want to see (in this case 2008).

I wish to add a criteria that then shows cancelled contracts at the end of that specific year, so 31/12/2008. So whether it is "2008" or another year is dependent on the value in the "Contract Year" field.

I tried the following as criteria for the Column "Cancelled":

#31/12/[Contract Year]#

to try and have it take the year mentioned in that field.
But it doesn't work. Access sees is as a second parameter, instead of a field name.
I tried adding LIKE to it and the &-sign, still no luck.

Is it possible to use a field name in a date criteria and if so, how could i do it?

Thank you very much in advance for your help.
 

More replies
Relevance 58.63%

Not sure how to go about this. I am not a programmer by any means but need to make a program.

I have a text file that is in what is called BAI format (bank standard format to send info). Basically this is a CSV file with a header. Right now I use a mail merge file to update the date field. I am looking to automate this so I would only need one "dummy" file and have a program that will update the date field automatically. The file is opened with notepad. I have done some VB but not a lot. I am looking for the best way to go about doing this. I tried to get some of the programmers to do it but no one wants to worry about supporting it, so I am taking a crack at it.

All help is very much appreciated. One idea I had is maybe a macro in excel but not sure if it would mess up the formating. I will try to get a copy of the file I use and post it.
 

Answer:Updating date field

6 more replies
Relevance 58.22%

Hello, I need help with the following:
I have a field (called Date_Time) which displays for example 1/31/2005 12:00:00 AM. I would like to run a query that converts that value to '200501' in a created field.
I tried the following below but I keep having problems.

select Account_Number, Date_Time,
concat(year(Date_Time), month(Date_Time)) as Date_Time_Modified
from table
where Account_Number = xxxx

Any insight into this would be greatly appreciated. Thank you.


 

Answer:Concatenating Date and Time Field in SQL

Just wanted to add some more examples:

Account_Number: Integer Type
Date_Time: Date Type
Date_Time: Modified: Character Type

Account_Number Date_Time Date_Time_Modified
3246 1/31/2005 12:00:00 AM 200501
4920 11/30/2008 12:00:00 AM 200811
5932 6/30/2011 12:00:00 AM 201106
... ... ....
 

1 more replies
Relevance 58.22%

Hi guys,

Something weird is happening. Some of my movie files (file type doesn't matter) became corrupted; when I play them in VLC they cause errors, they were just fine before and nothing has changed. I noticed in Explorer that these files have no Date Modified field, it's simply blank; I've never seen anything like that.

I did a chkdsk on the drive and see no errors. What could it be ?

Thanks.

Answer:Blank Date Modified Field ?

VLC should rebuild the Index, but that is a temporary fix. Depending on what format they are, there is "DIVFIX" and "Meteor MKV repair" you can try to run the faulty content through which of those is appropriate, you'll have to google it, cant remember the links.

3 more replies
Relevance 58.22%

Is there a way to insert a date merge field where the date is spelled out (June 10, 2008) and will not change if the document is reopened, resaved, modified, etc?   Thanks for any help!

Answer:MS Word merge field for date

I'm not quite sure I understand the question, but depending on the Word document...you can use the "Insert" link from Word's toolbar to insert the date into a document...formatted to your liking.Once the document is saved...the date will always appear as you have set it.

2 more replies
Relevance 58.22%

Can someone help please?

I'm setting up a query in Excel from an SQL database. How do I (or what do I) do to ensure only todays data is shown - I suppose I'm looking for an"=TODAY" type thing but don't know enough to be able to do it.

Thanks in anticipation.

Moll )
 

Answer:Excel query on Date field

it can depend on how the date system is set up but the following page has pretty much every SQL date function going

http://www.connx.com/products/connx/Connx%208.5%20UserGuide/sql_date.htm
 

1 more replies
Relevance 58.22%

Hello everyone,

I'm working on an order management database and I'm stuck on one item.

I have a form that users can fill in with purchase order data. One section of the form relates to contract review completion.

I would like to have a checkbox that the user can check when contract review is complete, but I'd also like for a completion date field to be auto-filled when the checkbox is checked.

I've tried a couple of things, both unsuccessful.

Any ideas?

Thanks.
 

Answer:MS Access - autofill date field

6 more replies
Relevance 58.22%

hi, i searched in vain for an answer to this question:
when i edit an image file and resave, the date modified date does not change. since i started using computers 100s of years ago, this was automatic. how can i enable this (obvious) field? what point is there in even having a date modified field if it stays the same as the date created field? thanks!

Answer:date modification field does not change

Are you sure you have the Date Modified selected as a column to display?

Right click on the header column (has Name, Date, Type, etc.) and select the Date Modified tag.

9 more replies
Relevance 57.4%

I am trying to add a sequential number to a date field in an Access form.
The format of the field is PS 18 Jan 11 xx, the PS is fixed, the current date and the xx is my sequential number I want to add.

Is there a way, to do this when the date is entered? And I would need the sequential number to reset to 01 with a new day.

I'm new to this, any help would be great!

Thanks!
 

Answer:Help in appending a sequential number to a date field

16 more replies
Relevance 57.4%

How do you insert a date field in Word 2007?

Answer:How do you insert a date field in Word 2007?

In Office 2010 at least, it should be under the "Home" or "Insert " tab. Then there should be a sub-category like "Date" or "Time".By the way. In the future, you'll get better office results here:http://www.computing.net/forum/offi...Ask and Answer. The way of learning.Dell Dimension 8300Intel Pentium 4 HT @ 3.20 GHz4 GB RAMNvidia Geforce FX5200

2 more replies
Relevance 57.4%

Greetings

It's been a long time since I last posted here, but hopefully all you wonderful people will be able to help...

Here is my problem:

A customer of mine has a SQL database where one of the fields is a date/time field that looks like this:

13/02/2003 14:32:58
14/02/2003 08:59:10
15/02/2003 17:09:37

Now, I need to delete all the records for a particular day (One of their HD's failed, and they had to restore the data and lost a day, but the entries are still in the database, and can not be re-entered until the old entries are deleted).

How do I structure a query to delete all the records for a particular day? Preferably, I would like a SELECT statement first, just to check that the records found correspond to the delete criteria, and then the DELETE statement.

Thanks

Reuel Miller

The Ex-NT moderator on this board

Every morning is the dawn of a new error
 

Answer:SQL Query help required with date/time field

Greetings

Not to worry chaps, I figured out the answer all by my lonesome

the statements I used were:

select * from {database name} where {date field} > '14 February 2003' and {date field} < '15 February 2003'

delete from {database name} where {date field} > '14 February 2003' and {date field} < '15 February 2003'
cheers

Reuel Miller
 

1 more replies
Relevance 57.4%

Hello,Have a Excel file with multiple sheets , each sheet is identified by the persons ID numberSee attached file.Here i need to copy data from FILE1 in each sheet to FILE2As you see in file1 that data for each person is scar tared , that is date are up and down ...that data need to be moved to file2 where already date from 21 oct to 20 nov is marked.THANKS

Answer:Moving rows with Date field from one worksheet to another

Quotei need to copy data from FILE1 in each sheet to FILE2I'm wondering about the wording of the quoted part of your post.  I suspect it would be better worded like this: i need to copy data from each sheet in FILE1 in to corresponding sheets in FILE2.   Is that correct?  Are FILE1 and FILE2 names of separate Excel files?

14 more replies
Relevance 57.4%

I want to combine a text field and a date field into one field to use as a reference number. IE 'Mil - 05/11'.

I have got a field with the standard short date format 29/05/2011 (that I have to keep) and I have created a second field with the same date but formatted to a "mm/yy". When I concatenate the Operater Ref field "Mil" to the Date Ref field "05/11" I still get the full date format IE Mil - 29/05/2011.
 

Answer:MS Access Concatenate a date and text field

Jerry-

If you are creating the second field in your table, go to design view and change the Data Type to Text then try your concatenation. I built a mini-table and queried it and this worked for me... hope this works for you!
 

19 more replies
Relevance 57.4%

Hello,Have a Excel file with multiple sheets , each sheet is identified by the persons ID numberSee attached file.Here i need to copy data from FILE1 in each sheet to FILE2As you see in file1 that data for each person is scar tared , that is date are up and down ...that data need to be moved to file2 where already date from 21 oct to 20 nov is marked.THANKS

More replies
Relevance 57.4%

I receive periodic Word (.rtf) documents from a property rental agency whenever my property is rented. The document contains the dates rented, the renter's name, etc. There is a "date field" in each document which automatically shows today's date, rather than the date the doc was created and sent to me. If I want to forward the doc to the renter a week later how do I stop the date from updating when I send it and stop it from updating when the renter opens the file?
 

Answer:Solved: Stop Updating the Date Field

6 more replies
Relevance 57.4%

Have sent email to several friends, there is no attachment, just relatively straight forward item with some borders and a table in the email body copy. In one case the email was bounced back as 'delivery failed' with the message:This message has been rejected because it has an overlength date field which can be used to subvert Microsoft mail programs The following URL has further information click hereHave gone to hyperlink which says 'page removed'. Other emails I sent to this friend get through. My questions are:1. I assume this is a genuine block?2. Has anyone come across this and do you know what it means?3. Is there something I can do to get my message through? [I had put a lot of work into it]Many thanks Tiggertwo using Outlook Express and windows95

Answer:Email bounced 'overlength date field'

Sounds like some sort of anti spam program which is a little too zealous. Have you tried it again to the same user?

1 more replies
Relevance 57.4%

I have tried sending a message to a friend who, up until now has had no problem receiving. The message I am sending has no attachments. But this message has come back several times with the message:

This message has been rejected because it has
an overlength date field which can be used
to subvert Microsoft mail programs
The following URL has further information
http://www.securityfocus.com/frames/?content=/templates/article.html?id=61

but when I go to that hyperlink it is a page saying that the item 'might' have been removed.

Incidentally I have an uo to date virus checker running and have been able to send and receive emails to others since the first bounce of this email

Questions:
1. Is this a genuine response or some sort of problem at receivers end?
2. If genuine can someone explain what I might need to do, if anything can be done, at my end to get the message through. I have already tried maing the subject line smaller but that made no difference.
 

More replies
Relevance 57.4%

the answer to this might of been found with a search but hey i'm lazy today and wanted to see who the excel masters are

using excel 2007, cell a1 contains an array formula (CSE) like so - {=MAX(LEN(A2:A470000))}
cells a2 through a470000 contain dates such as
12/12/2011
etc, you get the idea, i need the formula or something else entirely to return 10 not 5

thanks in advance
 

Answer:Solved: excel length of date field

i'll answer if myself thanks to another web site, Mike these guys are slackin' 'round here it looks like

=MAX(LEN(TEXT(A2:A470000,"m/d/yyyy")))

exit celll with ctrl, shift, enter
 

1 more replies
Relevance 57.4%

I wish to sort the following from:-

Using PowerPoint Notes
Find out what to do when your notes runneth over.
January 13, 2006
Word's Work Menu
A little-known built-in menu you can add to get at documents you use often.
January 6, 2006
A New Tool in the Fight Against Spam
G-Lock SpamCombat lets you delete spam on the server so it never gets to your hard disk
December 30, 2005

to :-

A New Tool in the Fight Against Spam
G-Lock SpamCombat lets you delete spam on the server so it never gets to your hard disk
December 30, 2005

Word's Work Menu
A little-known built-in menu you can add to get at documents you use often.
January 6, 2006

Using PowerPoint Notes
Find out what to do when your notes runneth over.
January 13, 2006

I have tried using the sort feature in word but the text and dates get sorted into separate piles.

Regards
 

Answer:Reverse sorting in Word 2003

16 more replies
Relevance 56.99%

I have an excel sheet with dates displayed in European format dd/mm/yyyy :-)I import it into a letter ("you have been a member since") and it imports in American mm/dd/yyyy.I can't see how to properly format the merge field

Answer:Mail merge a date field screws the formatting!

It all has to do with how your Operating System Date is set up.If your in the US then the default is mm/dd/yyyyYou can change how Excel Displays the date to dd/mm/yyyy, but it Stores the date in the System Date format of mm/dd/yyyy.When you import the date to Word, the System Date format is used.See here for how to change the format:http://cybertext.wordpress.com/2009...alsohttp://www.ashbee.co.uk/index.php/f...MIKEhttp://www.skeptic.com/

4 more replies
Relevance 56.99%

This one has got me. Has anyone figured out a way to do this easily? I can create a new column and extract the right characters and make it work ... but just wondering if there is a quicker way out there!

Thanks in advance for your time/help ...
 

Answer:Excel: Extract hour ONLY from a date/time field

Ok, got it to work ... but not sure if there is a better way.

I created a 2nd colummn and used the =RIGHT(D107,5) to isolate the time (10:32) from the date/time field (JAN 12,2014 10:32)

I then created another column and used =TIME(HOUR(C107),0,0) to pull out the hour ONLY in 10:00 AM format.

Is there a quicker way out there?
 

2 more replies
Relevance 56.99%

I have a Date field in a Form. I want the Date to be appear in red when it is more than 6 months older than today's date. Where and how do I make that happen?
Thanks
 

Answer:Access 2010 Date Field in Form Macro or ()Iff ??

10 more replies
Relevance 56.99%

Hey everyone,

I'm having problems with Access, where I have a date/time field, which stores a month and a year (successfully), but still automatically assigns the first date of the month in question.

I used the following input mask (00/0000;;_) for the date field, and so far I haven't had any troubles with putting in a month and year. So far so good. But when I complete the date and move on, Access changes it to a full date. e.g. 06/2010 --> 01/06/2010.

Now, I'm actually fine with this part, my only problem is that I don't want it to do this in forms (both datasheet and normal view) or reports.

I heard something about using a Format (http://office.microsoft.com/en-us/access/HP010990151033.aspx) to adjust the display, but I can't seem to get that to work. Is there any other way to tell Access how to display the date field, like what can be done in Excel?

This is rather urgent as I have a project due tomorrow and this problem (as well as others) have now been reached and I'd like to solve them as soon as possible.

Any help is appreciated, and I look forward to your responses.
 

Answer:Solved: Urgent: How do you format the DISPLAY of a date field?

8 more replies
Relevance 56.99%

Hi all,

I am looking for help on VB script to send automated emails based on the date column in excel sheet..

Uploading the excel sheet as well. The email should trigger on dates in column F to corresponding email addressed in column E ..

The email body should say :
Hi,

Your employee "Column C" is approaching his probation period on "Col D". Kindly confirm if you want to confirm on the date of "Column D" or modify it.
 

Answer:Need help to send automated email based on the date field

Have a look at the attached I have written the code necessary however if you have any changes you would like made let me know.
 

1 more replies
Relevance 56.99%

The company I work for has asked me to work with the DB (as you may well guess in this economy I now have to learn how to work with Access DB. This DB was created by someone who had a book “Access 2000 for dummies” in 2002, I have since then converted the 2000 DB to 2007 accdb format. That being said, in a form that is used to track records-TS# is the primary key, they want a YES/NO or actual name- Completed *check box for yes and blank for no*. I created the check box as you may know that was easy enough. The problem comes in when I go to the next record the box remains in whatever state it was on the previous record and does not show up anywhere else. I am sure this is likely because there are steps that I am omitting or not aware of. Any help offered would be amazing as I continue to work on this train wreck.

-Mike
 

Answer:Solved: Access 2007 YES/NO field with time/date

Mike, the Check Box field has to be in the Table that the Form uses as it's Record Source. The Check box has to be "Bound" to that table's field, i.e. it's "Contorl Source" of the check box in design view must be the table field.
 

2 more replies
Relevance 56.99%

I have a field that is date/time, formatted to display the long date (which starts with the day of the week). This has been extremely useful for some append, update and delete queries.

However, I would like to be able to do an update query based on the day of the week for each record. I know that the date/time field is stored as a number so I can't search for any string of letters. But, is there a way to take the long date format and copy what's there as a string so I can then extract the day of the week out of it? Otherwise, I guess I'm stuck with adding a separate field for day of the week, and manually inputting it. Seems like such a waste.
 

Answer:Solved: Access, Date/Time Field to String -- is it possible

7 more replies
Relevance 56.99%

Hello,

In Access, I am trying to develop a process for generating a unique client number that follows a very specific formula: XXX - XXXX - X - XXXX. The first group should represent the quarter and year when the client is first introduced (non-standard year: Feb-Jan). The second group should be a unique, sequential ID number with leading zeros (missing numbers won't matter and leading zeros seems impossible, so I'm planning to use a DMax calculation on the form that generates a sequential number). The third number represents the client's initial program phase ID. The final number relates to the grant contract ID.

I have generated the number with the following in a Select query:

UniqueNumber: DatePart("q",DateAdd("m",-1,[MonthStart])) & Format([MonthStart],"yy") & "-" & [SeqNum] & "-" & [InitialPhaseID] & "-" & [ContractID]

The table already has a primary key, but since I am required to generate client numbers in this format, I want the UniqueNumber to be saved and searchable. This field never needs to change once the original record is saved. I've tried an Append query, but can't make it work. I assume it's related to the fact that I'm combining Date and Number fields, not to mention the DatePart function. I consistently get a key violation error. Any thoughts on how I can proceed?
 

More replies
Relevance 56.99%

Hi guys, I'm very new to access and I'm having some issues. I have made a field for an expiry date, and I have attempted to create a calculated yes/no field that gets ticked when the expiry date is up, so basically I have a box that I want ticked for when the expiry date is before the current date (I hope that makes sense). Thanks guys,

George
 

More replies
Relevance 56.99%

from email address removed by Dreamboat

I have a database with a date field; 'Birthday'.

I want to take the month info from the date field and have access put it into another (adjacent) field. Ie;

Name:
Addr:
Birthday:
Month of B'day (New Field)

Also I want to be able to query the birthday field from previous data base tables which do not have the month field and make a table with the month information extrapolated to a new 'Month of B'day' field.

(Month([Birthday])) does not work.

I have printed a report with the 'Month of B'day" info extrapolated to the report but it is not useful because the report does not sort by the new information.

I know these must be possible but . . . . . AAAaaagh I'm going nuts.
 

Answer:Solved: Extrapolate Month from an Access date field

16 more replies
Relevance 56.99%

Hi

When you make a hyperlink there's a option of selecting email. Which then makes a box appear asking the me to insert the email address, subject line and body of text.

what I would like to do is auto-populate the subject line with words written in the document--or---auto populate the subject line with the contents of a fill-in form field.

Is this possible -- Oh i'm using Microsoft Word 2003.

Any assistance would be greatly appreciated.

Thanks in advance
 

Answer:Solved: Auto populate subject line in word 2003 - hyperlink

I figured it out!! I don't know how to remove the thread....
 

1 more replies
Relevance 56.58%

I have a unique problem. I am trying to use the INCLUDEPICTURE field code. The document I'm using is linked to a very sophisticated database software program and I have received instructions on merging data from this database INTO the INCLUDEPICTURE field to create the filename for the photo files. An example is typed below:

{INCLUDEPICTURE "G:\\START\\IMAGES\\PHOTOS\\{MERGEFIELD "PROVIDER_LAST_NAME"}_{MERGEFIELD "PROVIDER_FIRST_NAME"}.GIF"}

In the above example, the photo filenames are all matched up to the fields referenced in the formula (last_first.gif). These are the correct field codes, and the double slashes are important, I have been told.

My problem is that as soon as I save the document containing the above field, the underscores all change to "%20" and the field doesn't work!! No one at my software vendor's help desk can help me with this problem. Does anyone know anything about preventing this??

Thank you!

Cheryl
 

More replies
Relevance 56.17%

I've searched the forum and can't find the help I need...perhaps I'm not using the right keywords.

Anyway, I want to automatically have a time stamp entered in a field named "CancelDate" if a yes/no field named "Cancel?" is checked. On the form I use an action button for that field.

I'm new with VBA, but after some research I entered this code in the AfterUpdate line in Properties:

Private Sub CancelDate_AfterUpdate()
If Me.txtCancel?.value = 1 Then Me.txtCancelDate = Now()
End If
End Sub

...and it doesn't work. It seems to hang up because of the question mark. I get a Compile Error: Expected:Then or GoTo.

Can anyone help me?
 

Answer:Solved: Access 2007 Record Date When Field Updated

10 more replies
Relevance 56.17%

I want to add a validation rule to a date/time field in Access 2010. This worked in 2003 and I'd like to know why it won't work now.

The rule is

Is Null Or <= Date()

I have entered this through the expression builder as well as typing it to avoid typos.

The error message is:

Unknown function 'Date' in validation expression or default value on 'Artists.Date edited'.

I am doing this at work: we are running Windows 8, Server 2012, Access 2010 via virtual desktop.

Any help would be gratefully received!

Thank you
Alison
 

Answer:Solved: Access 2010 date field validation problem

Alison, welcome to the Forum.
I think you will find that this is an Access problem of Access 2010.
You may be able to overcome it by using Now() instead of Date().
If not I can provide you with some simple VBA code that will do the same thing that may work.
I have also seen advice to open a new 2010 blank database and import everything in to it to solve this problem.
 

2 more replies
Relevance 56.17%

While searching for some information in some old files, I noticed that every time I open a Word document, using Word 2007, the "date modified" shown in Windows Explorer automatically updates and changes the file properties to reflect the current date and time. I make no changes to the file and at no time am I asked to “Save” the document, which would justify the update of the “Date Modified” field.

This happens in both Vista and XP.

Is there any way I can change this setting? I only want the date modified to change when I actually make a modification to the document.
 

Answer:How to stop updates to Date Modified field in Windows Explorer

7 more replies
Relevance 56.17%

Access 2007 Update Query For Updating A Date Field

Hi I have been asked to write a query for an Access 2007 db

I need to update a date field in a table based on another date field in the same table

1st date field is the person's start date (StartDate)
2nd date field is the person's project date (ProjectDate)
Without going into too much detail, the Project Start date always begins on the 1st of the month

If the person's StartDate is between the 1st - 14th the project start date is counted as on the first day of the StartDate month/year

If the person's StartDate is between the 15th - end of month the project start date is counted on the 1st day of the NEXT month

Example:
StartDate = 7/1/2011
ProjectDate = 7/1/2011

StartDate = 7/14/2011
ProjectDate = 7/1/2011

StartDate = 7/15/2011
ProjectDate = 8/1/2011

StartDate = 7/30/2011
ProjectDate = 8/1/2011

I would like to update the ProjectDate in an update query

Any suggestions? Thanks
 

Answer:Access 2007 Update Query For Updating A Date Field

Create a Column heading like this
numdays: format([StartDate], "dd")
or
numdays: datepart("dd", [StartDate])
this will give you the day of the month on it's own
add a second Column
NewProjdate: IIf([numdays]>14,Format([StartDate],"mm")+1 & "/01/" & Format([StartDate],"yyyy"),Format([StartDate],"mm") & "/01/" & Format([StartDate],"yyyy"))

This will give you the date to use in the update query.
 

3 more replies
Relevance 56.17%

I am furious at not knowing why my date/clock in Windows 7 keep changins its appearance. It is as if the files or settings for Windows change mysteriously back and forth and I don't like it one bit.

The issue pertains to this clock/date shown at the bottom right corner on the screen just beside the system tray.

Sometimes it tells me the clock and no date or anything else is shown.
Some hours later it changes mysteriously to show the clock and the date format I once set, so that I get to see the day of the week, the date in numeral and the month in letters, and finally showing the year.

Something appear to be horribly wrong in Windows and I have no hope fixing it.

Only hope here is if this issue is familiar to other people.

Answer:Weird behavior by Windows 7, clock/date field changing

Do these changes happen when you hover your curser over the date? A few screenshots would be helpful!

9 more replies
Relevance 56.17%

How do I stop update of date field in Word? I set the date to original date and try to save as PDF but it updates on save.

Answer:can't stop date field in Word from auto update in old docs

What did you do to get the Date, Insert --> Date and Time?Or did you use a DATE FIELD:If you are using: { DATE } Then it will always display TODAY'S date.If you are using: { CREATEDATE } Then it will display the date the document was created or saved using Save As.MIKEhttp://www.skeptic.com/

2 more replies