Computer Support Forum

How do you insert a date field in Word 2007?

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

How do you insert a date field in Word 2007?

Relevance 100%
Preferred Solution: How do you insert a date field in Word 2007?

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: 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 103.73%

Please help!

When I select Insert Caption from the toolbar, or right click Insert Caption, that field inserts a figure number, but the caption field (at the top) does not let me populate a figure title. I cannot enter data as I usually do. And, the figure number does not populate in this field as it normally does. This is an important document, and there are many users. We are all frustrated!

Thank you for your expertise.

Rich
 

Answer:Word 2007, Insert Caption pop up field

In the caption dialogue box click the New Label... button and create your label, but don't include the numbering. The numbering ( or lettering if you choose that ) is automatically added to your "label" to create the "caption". That's why you can't directly edit the Caption text box. Word keeps track of the numbering for you.
 

1 more replies
Relevance 80.36%

Hi!

I have a Word for Mac 2011 doc that will be a template for an invoice. As pictured, I have a field that I would like to serve as the Sales Order field. I'd like the first number to be 000001. What I'd like to have happen is that each time the template is opened, the value in the Sales order field increments by 1, so the next opening would be 000002, then 000003, etc.

I know I need either some VBA code or a Macro, but I'm really unclear how to do this. Also, how do I get the code to apply specifically to the cell where the sales order number is? Unlike Excel, there's no position value to the cell, like A1. Is there a way to apply VBA code or a Macro by selecting the cell somehow?

All help appreciated!

Thanks!
 

More replies
Relevance 79.13%

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 78.72%

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 78.31%

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 78.31%

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 77.49%

I would like for my Access 2007 database to automatically record the date/time when the data in a SPECIFIC field is modified (not when any data in the record changes).

Here is a simplified explanation of my scenario. This database keeps track of cases in my office. A data entry form named "Cases" feeds a table named "Cases." The form includes text boxes that correspond to the fields in the table. Three of these are: "Case_Notes," "Case_Status," and "Date_Status_Change."

I would like for the "Date_Status_Change" field to automatically reflect the current date/time whenever the data in the "Case_Status" field changes. I do not want the date/time to change when information in the "Case_Notes" field is modified.

What code would accomplish this?

The following code will enter the date/time for a change anywhere in the record:

Private Sub Form_BeforeUpdate(Cancel As Integer)
Me![Date_Status_Change].Value = Now()
End Sub

But I want to limit it so that it dates changes ONLY in the ?Case_Status? field.
 

More replies
Relevance 77.08%

Hi,I am trying to make a list(Column)with the date/day for a month(s).
e.g in A1 I have the month say March in A2 I want 1st Wed. Is it possible to then drag down to fill the rest of the month with date day?. Help please

Answer:Insert Date and Day and Month Excel 2007

In second cell type 1/3/17, in next cell below Right click on bottom left of cell, drag down to cell 33 let go and choose fill series

3 more replies
Relevance 77.08%

When writing letter using Word, I always insert date using the shortcut ctrl-alt-D and I configured it in such a way that when I open a doc, today's date would show.By this I mean that if I open a "saved" letter written last month, todays date will show and that is not practical of course for if I want to copy/scan the letter, the date it was written wont show.Does anyone know how to correct this please.

Answer:Insert date in Word

Insert > Field > Date and Time > CreateDate.

4 more replies
Relevance 76.67%

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 76.26%

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
Relevance 76.26%

Hi guys

Can you please tell me or show me the code or anything like that that i can use to insert date automatically into word document with just one click or something faster than typing.

This is a document where i have to prepare for my boss every week, it's a schedule for him of what to do every week.

thanks in advance
 

Answer:Insert date in word doc automatically

8 more replies
Relevance 76.26%

I'd like to have a date automatically inserted in a Word template (in a Memo heading) so when I open the template (File, New), todays date is there. The completed letter is then saved as a Word document. That seems straightforward but if I open the saved document some dayslater, Word puts in that current day so I don't know when I originally wrote the letter.I've tried inserting the Date through Insert, Date and Time and through Insert, Field, Date and Time but the opened Word document always picks up the current days date. I though there was an option to right click the date and Update Field option that would update the date but only if you requested it but haven't had much success there either.

Answer:Word 97/2000 and Insert Date

Im sorry but I only have word 2002. When I create a blank template and insert date/time there is a box I can tick to say update automatically. Is this option in 2000?

5 more replies
Relevance 76.26%

I use a macro to insert address and date but when I reopen the letter the date is changed to todays date.Please can someone tell me how do I stop this as I want to check when I sent the original.

Answer:word 2003 date insert

When you insert date you get a Date and Time format box-uncheck the update automatically

1 more replies
Relevance 75.44%

I have a Word 2010 document and I want to have specific text appear if a date is more than 42 days away from today (whatever today happens to be). I've got a three-cell table that looks like:


________________________________________________________

| DATE: | 12/25/13 | { =IF(B1-TODAY()>42,TRUE,FALSE) } |
________________________________________________________



I keep getting a Syntax Error on my field in the 3rd cell. I think the problem is that Word doesn't understand "TODAY()" like Excel does, but I don't know if there is any other way to calculate the days between two dates? My eternal gratitude to anyone who can figure out how to do this properly.

Answer:Date calculation using Word 2010 table/field Syntax Error

You will need to create a spreadsheet then "Link" that spreadsheet containing the calc cells.

Things to Remember When Linking
If you move the linked Excel file, you break the link. To fix this, you need to relink the file.
Double-click on the Excel data in your document to edit it: this opens the linked spreadsheet.
You can also edit the spreadsheet directly: the changes appear in your Word document once you save the Excel spreadsheet.
Regards,
GEWB

3 more replies
Relevance 75.44%

Years ago, I was able to automatically insert the current date in a Word document by holding down ctrl and hitting the : Has this been changed to another hotkey? Is there a web resource for these type automatic inserts? Unable to locate with google.
 

Answer:Microsoft Word - auto insert date

You could adjust your normal.dot, which is the template Word uses whenever creating a new document. It is located in the directory C:\Documents and Settings\username\Application Data\Microsoft\Templates

where username is the name of the profile you are logging into. If you were to right-click and select open for normal.dot in this folder, you can add the current date by clicking insert -> date and time, and saving. (Make sure you check the box beside "Automatically Update"!) Then, whenever you create a new document, it will have the date.
 

10 more replies
Relevance 75.44%

Hi,

Is there a way in word to insert Last Weeks date (i.e. Todays date - 7 days). Would want this to auto update whenever the Document is opened.
TIA
Raw2K
 

Answer:Word 2002 - Insert Date of last week.

15 more replies
Relevance 74.62%

I have created a document with many names in it and wish to index as follows

SMITH
JOHN
FRED
etc. When I use the indexing tools all I get is
FRED SMITH
JOHN SMITH

How do I set the field codes so that the index lists surnames alphabetically as my example?
I know how to get to the field codes. It is knowing the right ones and the correct order.

Any help would be much appreciated

regards

Rodit
 

More replies
Relevance 74.62%

I am trying to use a REF field in Word 2007. The REF is Malename and is set to title case and the font is set to Arial Regular 12 however the first word comes out in regular font and the other words come out in bold. I cannot make them all go into regular font. I have others set for bold and caps and that works fine on both words however the regular font wont work. I have tried highlighting all the code and the space after (there is no space before as it is the first word after an autonumbered paragraph). I have even tried highlighting the whole document and ensuring it is not in bold however as soon as I fill in the field box the text comes back in bold (only the subsequent words though the first word is not bold as it should be!) Help I am tearing my hair out! Oh I have tried the *\charformat code too and that didnt work either.
 

More replies
Relevance 74.62%

footer, using field codes, numpages returns correct value, but adding "-1" returns a blank (no result). When I toggle to the code it shows, but the result doesn't
 

More replies
Relevance 73.8%

Hello, i am writing for the first time on this forum and i appologise for my english.. I'm glad that i have found a part of the solution for saving one word file to difrent locations with these code Sub SaveX2()Dim strFN As StringDim strFX As StringDim strL1 As StringDim strL2 As String'setup two locations - ending with /strL1 = "H:/"strL2 = "C:/Temp/"'get filename from userstrFN = InputBox("Enter file name without extension", "Save to Stick and HDD")'check for no file extensionIf InStr(1, strFX, ".") > 0 Then strFX = Left(strFX, InStr(1, strFX, "."))End If'get existing filename and extract file extensionstrFX = ActiveDocument.Name'test for file extension on current documentIf InStr(1, strFX, ".") = 0 Then 'none so use a default strFX = ".doc" Else 'use existing strFX = Right(strFX, Len(strFX) - InStr(1, strFX, ".") + 1)End If'create the filenamestrFN = strFN & strFX'save to stick firstActiveDocument.SaveAs FileName:=strL1 & strFN'save to HDD secondActiveDocument.SaveAs FileName:=strL2 & strFNEnd SubNow my question is can i insert the date and hour automaticly as file name in stade of typing the name of file in the input box ? please can you help me ? Thank you.

Answer:insert date and hour in macro code for word 2010

First, a posting tip:Please click on the blue line at the end of this post and read the instructions on how post VBA code in this forum. Using the method described in that How To will make viewing the code easier for all.As for your question, you cannot use a "/" or a ":" in a filename so please tell us what you want the filename to look like.e.g. 4/8/2013 12:45:23 PM is not valid.4-8-2013 12_45_23 PM is.How would you like the filename formatted?Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

5 more replies
Relevance 73.8%

I'm trying to create a word doc with text form fields. I have them in the doc but I want them to remain the in the same location after I type in each box. Currently when I type enough characters in the box the next text form box moves to the next tab location. How can I make each box "freeze" where it is before I start typing in it? Any Suggestions?
 

Answer:Word 2007 - Text Form Field Help Needed

Embed the form field inside a frame. You can then set the frames border so that it is invisible so that it can't be seen.

Regards,
Rollin
 

1 more replies
Relevance 73.8%

Hi

I am trying to create a custom field using the numpages field in word 2007. I was trying to input from scratch (using the ctrl+F9). Also tried modifying the already inserted numpages field as well.

{={NUMPAGES}+2} - so increase the number of pages by 2 so when I create a pdf later I can add in some attachments.

I have searched around and tried placing spaces inbetween the mathical operators and commands, however I am still getting "!Syntax Error, {". I have also changed the security settings to allow macros (lowest security settings) and restart the document. Nothing happens and still getting the same error.

Any help would be greatly appreciated

Thanks
 

More replies
Relevance 73.8%

Hi everyone!

I'm sure this is probably something very simple that I'm missing...

I am creating a document template for a specific document type.

I have two rich text controls added to a document via the developer tab.

The first is the document's number in a series of documents to be created. The second is the actual document title.

In the footer area, I want these to be shown in reverse - i.e. the document name, then the document's number, so I am making it very easy to check the number of the document when flicking through a physical folder.

I tried to do this with bookmarks and cross-referencing, but the bookmarks are not saved when you create a new document based on that template.

I tried with a macro, but after recording the macro, it didn't really do what I wanted.

Is there an easy way to get this working? If not, is there a way I can assign names to the rich text controls in my template to run a macro more efficiently?

Answer:Word 2007 dynamically updated text field

See Word Variables etc. Editor which will allow you to easily map content controls to achieve what you want to do.

1 more replies
Relevance 73.8%

Hi everyone!

I'm sure this is probably something very simple that I'm missing...

I am creating a document template for a specific document type.

I have two rich text controls added to a document via the developer tab.

The first is the document's number in a series of documents to be created. The second is the actual document title.

In the footer area, I want these to be shown in reverse - i.e. the document name, then the document's number, so I am making it very easy to check the number of the document when flicking through a physical folder.

I tried to do this with bookmarks and cross-referencing, but the bookmarks are not saved when you create a new document based on that template.

I tried with a macro, but after recording the macro, it didn't really do what I wanted.

Is there an easy way to get this working? If not, is there a way I can assign names to the rich text controls in my template to run a macro more efficiently?
 

More replies
Relevance 72.98%

I am trying to create an AutoOpen VBA Macro in Word 2010 files for automatically inserting the same dates into 2 different text boxes when I first open the file. Ideally, I would want 1 file to do this always for Yesterday's date (whatever that may be) and another file to do this for Friday's date (whatever that may be).

Reason for this is because our mail room gets mail the day before I get it on my desk and I need to date stamp it using a Word 2010 template where I have 2 text boxes (please see attached file--oh, doesn't seem like I can attach the file???) for Tuesday through Friday. Right now, I am using the Macros I have created (1 for Yesterday's Date and another Macro for Friday's Date which is Date() -3).

I want to use that Macro logic to put that into the Text boxes I have when it first opens? Please help me with this anyone......

It doesn't seem like I can attach the file so here is the VBA code:

Sub AutoOpen()
'
' AutoOpen Macro that places the cursor at the last position of edit (not default of top left) (will work with Protected View)
If Application.ActiveProtectedViewWindow Is Nothing Then
Application.GoBack
End If

' InsertTextBox1 Macro
Dim Shp As Shape
Set Shp = ActiveDocument.Shapes.AddTextbox( _
Orientation:=msoTextOrientationVertical, _
Left:=22, Top:=252, Width:=25, Height:=170)
Shp.TextFrame.TextRange.Text = "NMM RECEIVED: "
Set Shp = Nothing
Selection.InsertAfter Format(Now() - 1, "dddd, ... Read more

More replies
Relevance 72.98%

Have created some basic online forms. Now I am tasked with displaying each entire field length (visually somehow) so the user can see approximately how much room they have to enter test. Examples:
Name: Field length highlighted or shaded
Location: Underlining would work to indicate field length
Phone: ( Parenthesis might work )

If I type "Enter Name Here" in Properties, under Default Text, only "Enter Name Here" is shaded. The shading does not extend to the maximum length I selected. The field extends that far, but no indicator of the entire field length. Thanks to everyone for being patient. Attempted to be specific as my question seemed unclear in other unrelated forums. This forum/posting/threads, etc. is new to me. I am 62, so go figure!

Answer:Forms/Word 2007/Display entire field length

Welcome to the Seven Forums.
This is unfamiliar to me, have you tried enter spaces in the chosen field?

6 more replies
Relevance 72.98%

We use Oracle's XML Publisher to generate reports. This is where an XML file is merged with a .rtf template to generate an output (usually PDF). We design our .rtf templates using Microsoft Word 2007. I have a need to print something in the same position on the last page of every report (in this case.. customer invoices). I am placing this logic in the footer so it will print in the same position. I also have logic in there that determines when it is the last page. It isn't working and I need some help. Right now I have { if {NUMPAGES}>{PAGE} "Not Last Page" "Last Page" }. I am getting "Last Page" on every page. (This isn't the wording that I really need to go there, I was just testing this functionality). I read an article from Microsoft Support (Article ID 211755) that says this is supposed to work with version 2000. I'm hoping it is still valid for 2007. If you have accomplished something like this or can help me I would appreciate it.
 

More replies
Relevance 72.57%

I'm new to Word 2007 (and not yet real happy with it). The documents I create for work contain lots of shapes, mostly arrows and text boxes. I click Insert>Shapes, select arrow, and insert it where I want it. Is there some way to make Word remain in the "insert" mode so I can insert a bunch of shapes without having to click three times for each one?
 

Answer:Word 2007 Insert Shape

Morning md2lgyk,
When you insert a shape, does the ribbon switch to the Format tab, where you can change the color and style of the shape? If so, on the far left of that tab you should see a box with all of the shapes in it. You can click and insert them at will from there, without going back to the Insert tab. Hope that helps.
 

2 more replies
Relevance 72.57%

When i insert a pdf into my document using insert, object then selecting the file it only ever shows the first page is this all that is possible or is there a way around?
 

Answer:Word 2007 insert object - pdf

I don't have 2007, but in previous versions what Word did was place the first page which was a link to the file - you double-clicked on it and the file opened up in Acrobat. However, in
Acrobat 8 you can save a .pdf file as a Word .doc or .xml (and there are several other options) - if you save your file as a Word .doc you can then merge it with any other Word .doc that you want it to be in.
 

1 more replies
Relevance 72.57%

I have been using Word 2003 for some considerable time but recently installed Office 2007 onto my main PC. Despite using the 2007 version for some weeks now, it was only tonight that I needed to insert a picture from scanner. I now find by googling that others have raised the question of this missing function and that the only way now is to scan, save the image and then insert. Anyone know better?

Answer:Word 2007 insert from scanner - not there!!

why not open Word, then in Menu maybe under Insert you can find Acquire for Scanner

9 more replies
Relevance 72.57%

HiA friend has just purchased a lap top with Word 2007 installed. The problem is when he inserts a publisher file for the heading it is split into two pages, can anyone helpI think it will be in page set up somewherechas

Answer:Word 2007 insert .pub problem

try importing the file into a blank document then adjust it to suit and save it as a word doc. Now open a new page and insert it.

2 more replies
Relevance 72.16%

Hello,

I write quite a few manuals, and I've recently upgraded to Word 2007.
I know there must be a way to do what I'd like.
I have a section where I have a table in the manual, and I want to be able to type a part number in one column, and have the description for the part automatically pop up in the next column.

I've tried searching different forums, but I keep hitting on answers on how to have it automatically fill in the same field.

Any help is greatly appreciated!!
 

More replies
Relevance 71.75%

Hello,

I'm new to this and word 2007, so please be patient with me.

i need a bit of help. I've got approx 200 word documents (template.rtf documents) that are unique to our system and i have to back them up (in case they are changed/amended or deleted by users, and also so that we can look at these and decide where we can condense them i.e. similar letters into one document etc).
Anyhow I have managed to copy these over into a folder but the problem I have is that the name of the document is not on the actual document so when these are printed out an passed over to a third party to look at and change it looks like i am going to have to write the name of the document onto each one.

Is there a way of automatically inserting the name of document into the actual document (the footer maybe) without having to open them up?

thanks
 

Answer:Automatically insert the document name - word 2007

6 more replies
Relevance 71.75%

please can someone explain why I can insert the divide sign on my PC (Win 7) by using
Alt 0247 yet when I try Alt 0247 on my laptop (Vista) it does not work. Both using Number pad on the keyboard. Both PC & Laptop are running Word 2007.

Answer:Word 2007 Insert divide sign

tonyq,
Have you got NumLock switched on, on the laptop?
Peter.

2 more replies
Relevance 71.75%

HiIn Word 2007 I have got a table say 7 rows by 7 columns. With the pointer on say row 4 I want to be able to insert a multiple number of rows. Say another six between rows 4 and 3It seems to me that the only way to insert rows and columns at various points within the table is one at a time.Is it possible to do the above and if so how. Or is this a short comming of Word 2007.I hope the above makes sense.Any help would be appreciated

Answer:Insert rows and columns in Word 2007

Select the number of rows to insert, right click, Insert > Insert rows below.

4 more replies
Relevance 71.75%

Tech Support Guy System Info Utility version 1.0.0.2
OS Version: Microsoft Windows 7 Home Premium, Service Pack 1, 64 bit
Processor: AMD A4-3305M APU with Radeon(tm) HD Graphics, AMD64 Family 18 Model 1 Stepping 0
Processor Count: 2
RAM: 3561 Mb
Graphics Card: AMD Radeon(TM) HD 6480G, 512 Mb
Hard Drives: C: Total - 280553 MB, Free - 164081 MB; D: Total - 20426 MB, Free - 2211 MB; E: Total - 4055 MB, Free - 1104 MB;
Motherboard: Hewlett-Packard, 3568
Antivirus: PC Cleaner Pro, Updated: Yes, On-Demand Scanner: Disabled
When I try to insert a pic from my files to a doc in word all I get is a sizing box and not the file I need. I have tried downloading old files that I have used before word 2007 and they do the same thing.
 

Answer:Solved: ms word 2007 insert pictures

9 more replies
Relevance 71.34%

Hi fellow PCReviewers

I'm having difficulties with my Word 2007 form. I have set it up to allow fields to be populated and have the sum total appear in another field. Unfortunately I am having no success in regards to the total automatically updating as data (numbers) are being populated.The F9 fails to update the total as well.

I have checked and double checked the properties and it all seems fine to me, ie, data fields all set to "calculate on exit", the total sum field is not set to "calculate on exit" and the calculation formula reads =Text1+Text2+Text3+Text4 i've even used =sum(Text1+Text2+Text3+Text4) without success.

As a footnote, I am able to open a former 2003 Word form and it does behave correctly. The form outlined above was created in W2007.

Can anyone help me please
Cheers
Mark
 

Answer:Word 2007 form calculate field fails to udate when data entered

https://www.pcreview.co.uk/forums/word-2007-form-fails-auto-calculate-total-t4049234.html
 

3 more replies
Relevance 70.93%

Anyone have any idea how to set a background sound in Word 2007 [as it is editing a complete web page]? Earlier MSO versions could not edit HTML documents in a WYSIWYG fashion (only as plain text editor to create/edit HTML code), which was why I purchased FrontPage some few years ago. I have accomplished this using MSO FP, but I want to learn Word's newer capabilities. MSO 2007's online help should be called NO Help At All; the closest thing I could find was insert voice comment (unsuitable).*
*Which does not function properly, further evidence of Darth Gates' rank and criminal incompetence...but what can you expect from a guy who stole incomplete work from his employer and pawned it off as his own, spawning the most ubiquitous sowftware giant ever, one whose hallmark IS selling incomplete products. I mean: Would you buy a new Caddilac if you had to buy a fourth wheel aftermarket (and a fifth as a spare)?

It's not libel or slander if it's true! Besides, I was very careful...is there actually a person named Darth Gates? Did I name the employer that was robbed? Did I even allege what was stolen? Did I name the purported software giant? No. Let the Evil Empire's legal minions have fun with that. In order for them to make a case, I'm pretty durned sure they would find that George Lucas, et al would prove more than uncooperative. I like denigrating bullies. What does it make one if one exhibits a penchant for picking on bullies? Someone who ha... Read more

Answer:Word 2007 (HTML) Insert background audio?

Re-opening as requested.
 

1 more replies
Relevance 70.52%

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 70.52%

I recently upgraded from Windows XP to Windows 7--no problems there. However, after the upgrade, I noticed that the 'insert symbol' dialog accessed from the pull down menu in Word 2003 seemed frozen. Today, I upgraded from Office 2003 to Office 2007 (not to correct that one problem; just needed to for work). Everything's working fine, except the insert symbol dialog. This leads me to think it might be a Windows 7 problem, but since it is occurring with Word, I chose this forum.

Here's the problem: When I attempt to insert a symbol, the Symbol dialog box appears, but the characters do not respond to clicks of the mouse. I can select a character or symbol using the arrow keys on the keyboard, but after inserting one character, the whole thing freezes up--can't click on a character and arrows don't work. If I then click on the tab 'Special Characters' and then click back on the tab 'Symbols', I can then use the arrow keys again, but only to select and insert one character. Then it refreezes, and I have to do the whole Special Characters-to-Symbols-and-back dance to unfreeze the thing. I can mouse click on all the other buttons in the Symbol dialog box, just not the character map. Speaking of which, I have put the Character Map from the System Tools folder on my taskbar. I can select symbols and characters from the Map by clicking, but it is a cumbersome procedure. I am a technical writer (medical), and I use a lot of symbols. Ca... Read more

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%

Hello everybody,

I have many images in my document which need captioning, and I would like to be able to automate an operation which up until now I have had to do manually: insert a punctuation mark after the text that is automatically added by word (i.e. label and number).

So I would like, for instance, when I add a new caption, the automatic text to not just be "Figure 1", but have a colon and a space added after it - "Figure 1: ".

I know you can customise labels, and also the way the numbering is done, but I haven't found a way of customising what comes after. Perhaps using a macro?

Thanks for any help.
 

More replies
Relevance 69.29%

When I open a word document that I have on file it automatically updates to the current date. The only auto update box I can find (and it is not ticked) is on insert date and time. Any ideas please

Answer:WORD 2007 date keeps on updating

but in Word 2000 you can insert a "Create date", via a field, which then doesn't update. It sounds as though you may have a field that is just "Date".Note that what I'm suggesting refers to a "Field".Apologies if this doesn't help!Regards,Simsy

3 more replies
Relevance 69.29%

Does anyone know how to remove the auto-complete of the date when using Word 2007. I've tried with earlier versions of Word but found that all I could do was to turn off auto-complete altogether. It's so irritating when I forget use the space-bar after the date and pressing Enter/Return auto-fills in American style.

Answer:Autocomplete of Date in Word 2007

Click here

5 more replies
Relevance 68.47%

1 December 2010-12-01 - that is, when I press enter, it auto sets the date

Anyone knows how to fix it

Answer:Word 2007 Date format issues

Not sure what you're saying when you press date and time on the insert menu it doesn't insert the format you choose?

alt, shift, d will give you the 11/30/2010 format

9 more replies
Relevance 68.47%

I know nothing really about visual basic! I have created a document in Word that list several different tasks that need to have due dates beside them. Here is a rough example (not my actual doc):

1. Deposit for project due ______. (this is also the project start date)
2. Paper is due ________.
3. Photos due _________.
4. Article is due _______.
5. Final prduct received ______.
I created a simple macro that takes the current date then adds a certain amout of days for the due date. But what I really need is to create a macro with a specific date then calculate the due dates based on the specific start date. So if I am filling my form in a couple weeks early I can put my desired start date then fill in due dates from there.

Thanks!!!
 

Answer:Word 2007 Calculate Date Macro

Why not do this in a spreadsheet?
 

1 more replies
Relevance 68.47%

How do I create a template which inserts the date automatically in a Word 2007 document, please. I thought that I had followed the directions, but the template which I have created does not change to 'today's date'.Thanks for any help.

Answer:Inserting date automatically in Word 2007

Provided the date is inserted as a field (under then insert menu) this should work fine provided the field is not locked.You may have to set the tickbox to update field under print options.You can use print preview to check that this is happening.

3 more replies
Relevance 68.47%

I am using Word 2007. Each time I open a .doc or .docx file, the date modified changes, as displayed in Windows Explorer. This happens when I just choose file open, and then exit, without ever doing anything with the file.

Previous versions of Word would appear to do the same thing. However, when the file was closed, the date modified in windows explorer to revert back to the previous date. Word 2007 causes the current date accessed to become the date modified.

This makes it very confusing, as it looks as though I am making changes to the file, when I am not.

Help appreciated...marty
 

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 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 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 65.19%

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 61.91%

"Insert" key doesn't work with Word 2007. Any advice. It's not a toggle on and off.

Answer:how to use "Insert" key with word 2007

Hi shrink and welcome to Vista Forums

Sorry for any delay in replying, but is this what you're looking for?

1 more replies
Relevance 61.5%

I'd like to be able to insert fields into the cells of an Excel workbook, rather than just in the header / footer.

I'm going to be completely in shock if this is not possible, but I'm not able to find anything whatsoever.

Help????

Thanks,

John
 

Answer:Insert field (e.g., &[Tab]) into worksheet cell

8 more replies
Relevance 61.5%

The following hyperlink in Microsoft Word opens up a contact from Outlook. Is there an easy macro that goes to that contact, and adds to the work document, the words from a certain field in the contact. I have new fields in my contact form, and want the word document to show the words from some of those fields.
Here is the easy hyperlink to a contact in a subfolder of contacts:
Outlook:Contacts/Subfolder Name/~Contact Name Thanks very much.
 

More replies
Relevance 61.09%

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.09%

hi, when i reboot my b50-10 i can't type any character in the windows10 pwd field. There is the field but it's impossible to type in. At the same time i can't reboot the system using the icon on the bottom-right corner. The mouse pointer seems to go correctly, but nothing happen. can you help me?tnks, fra.

More replies
Relevance 61.09%

hi, when i reboot my b50-10 i can't type any character in the windows10 pwd field. There is the field but it's impossible to type in. At the same time i can't reboot the system using the icon on the bottom-right corner. The mouse pointer seems to go correctly, but nothing happen. can you help me?tnks, fra.

More replies
Relevance 60.27%

In my database I have what I call the main form. This form , among other things, contains a persons social security number [SSN]. I have placed a control button on this form that allows for me to jump to a hyperlink and perform a search of a second database through ASP. Now, everything is working fine but what I would like to do is be able to "plug in", via code, the [SSN] field data into the static portions of the hyperlink string. The SSN would have to be taken from the currently viewed record on the main form. The code for the button, as shown below, has a dummy SSN of 999-99-9999 (in orange) and this is the data that I need inserted from the [SSN] on the main form.
_____________________

Private Sub Command215_Click()
FollowHyperlink "http://1.1.1.111/Prog/ProgWeb.aspx?Action=Search&Database=database name&SearchType=DocumentProfile&SearchValue=999-99-9999&ProfileFieldName=Document%20Title"

End Sub
___________________________________________________
As the code stands, it works as long as I manually place an SSN in there. Any suggestions that will allow me to take the SSN from the currently viewed record in the main form and place it between the two static portions of the hyperlink?

Thanks in advance.
 

Answer:Solved: Access: Insert field data into hyperlink

7 more replies
Relevance 60.27%

I have installed Windows 10 from Windows 7. My Outlook is still 2003 with 2007 compatibility. All seems to work well except that when typing into the "To:" field the relevant addresses pop up but will not insert into the field when clicked upon. I have looked at Tools/Options/Preferences/Email Options/Advanced Email Options/Suggest names....... and that is checked but still the insertion is not completed. Can you suggest a fix?

More replies
Relevance 59.45%

Macro formula to insert lines depending on quantity field Hello,If the quantity in Column G is >1 then I need to insert the same line one less times than the original quantity. In the example below in cell 2G the quantity = 3 so I have inserted 2 lines immediately below it and copied the text from cells 2A to 2F ..so that I now have a total of 3 lines for this item (making labels for these items).So the next cell requiring attention is 6G for Qty 5 (being >1) it will require 4 lines immediately under it with the same text as cells 6a to 6F.Note that cell 9G (Qty = 2) already has a blank line under it, as it is a division between groups of items so it still requires 1 additional line with this macro added. Exactly the same requirement for cell 12G and so on...Can any one help please with a macro to do this?

Answer:Macro formula to insert lines depending on quantity field

First, to eliminate any confusion we should make sure that we are using the correct terminology. 2 quick items:1 - The proper way to refer to Excel cells is to use the Column first, then the Row. e.g. G6, A6:F6, etc.2 - The term "macro formula" doesn't really mean anything. A macro is a series of VBA instructions, also known as "VBA code". A formula is built around an Excel function and entered into a spreadsheet cell. Formulas can be used within a macro, and a macro can put a formula in a cell, but the term "macro formula" is not typically used.OK, all that said, give this code a try. I suggest that you try this in a backup copy of your workbook since macros can not easily be undone.The code below is written based on the assumption that the data is in Sheet 1. That is easily changed.
Sub InsertRow_By_G_Value()
Dim lastRw, rw As Long
Application.ScreenUpdating = False
'Perform actions on Sheet 1
With Sheets(1)
'Determine last Row with data in Column G
lastRw = .Cells(Rows.Count, "G").End(xlUp).Row
'Loop through rows in reverse order
For rw = lastRw To 2 Step -1
'If Column G > 1, insert Rows and copy data
If .Cells(rw, "G") > 1 Then
For newRw = 1 To .Cells(rw, "G") - 1
'Insert Rows/Copy A-F
.Cells(rw + 1, "G").EntireRow.Insert shift:=xlDown
.Range(Cells(rw, "A"), Cells(rw, "F")).Copy Cells(rw + 1, "A")
Next
End If
Next
End With
Application.ScreenUpdating = False
End Sub
Click Here Before Post... Read more

2 more replies
Relevance 59.45%

I created an update query and when I run it I get the following message "An INSERT INTO query cannot contain a multi-valued field." I believe that problem is that I have two look up values in the Append to table. How do I solve this problem? How do I use an Assigned.To statement?
 

Answer:An INSERT INTO query cannot contain a multi-value field error message Append Qry

Is this is SQL? Anyway, please copy and paste the query
 

2 more replies
Relevance 59.04%

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 59.04%

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 59.04%
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 59.04%

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 59.04%

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

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 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%

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%

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,

Can someone help me please. I have a word merge running from an Access 2007 form to word (Mr Kallals' great code). The problem is that I set up certain underlying tables with numeric primary keys and then their second field contained the text I wanted to show on the form.

e.g. Column 1 Primary key
Column 2 Location

So PK 11 shows as 'Anywhere UK' on subsequent forms and queries. The problem is that my merge with the VBA module mentioned above and the word merge operation in Access' export facility only show '11' instead of ' Anywhere UK'.

I'm really stuck and very weak with vba. But surely this is something that might be fixed from within Word as much as Access

Can someone help.

Thanks
 

More replies
Relevance 57.81%

So I have this excel spreadsheet and an example of it basically looks like this:
Project Phase Person Capacity Start Date End Date
A Design 1 25% 1/15 3/16
A Model 1 25% 3/17 5/11
A Design 2 25% 1/15 3/16
A Model 2 25% 3/17 5/11

I'm looking to track a monthly outlook of capacity % over time for each person (in a pivot table), but I'm unable to get it exactly the way it should be. Essentially I would like it to look like this below:

Dates
Person Jan Feb Mar Apr May
1 25% 25% 25% 25% 25%
2 25% 25% 25%

Is this even possible, either in a pivot table, or even using formulas?
 

Answer:Excel 2007 - Start Date and End Date question

You should have posted that in "Business Applications" here: http://forums.techguy.org/16-business-applications/
 

3 more replies
Relevance 57.81%

So I have this excel spreadsheet and an example of it basically looks like this:

Project Phase Person Capacity Start Date End Date
A Design 1 25% 1/15 3/16
A Model 1 25% 3/17 5/11
A Design 2 25% 1/15 3/16
A Model 2 25% 3/17 5/11

I'm looking to track a monthly outlook of capacity % over time for each person (in a pivot table), but I'm unable to get it exactly the way it should be. Essentially I would like it to look like this below:

Dates
Person Jan Feb Mar Apr May
1 25% 25% 25% 25% 25%
2 25% 25% 25%

(Sorry, the text keeps left aligning so person 2 should actually have 25% under Mar, Apr, and May.)

Is this even possible, either in a pivot table, or even using formulas?
 

Answer:Excel 2007 - Start Date and End date question

16 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%

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%

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 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%

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%

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%

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%

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 56.99%

The title is self-explanatory. So far, I found a software that is able to change this called 'Attribute Changer' but it only changes the date modified in the folder and, when you go into the actual word application > file > info, the date created and modified are not changed. Any help would be greatly appreciated! Thank you!
 

Answer:Changing 'date created' and 'date modified' in Microsoft Word 2013

7 more replies
Relevance 56.99%

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

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 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%

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