Computer Support Forum

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

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

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.

Relevance 100%
Preferred Solution: I need a date field changed into a text field of YYYYMMDD

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 (This link will automatically start a download of Reimage that you can save to your computer.)

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

under the format options.

5 more replies
Relevance 97.44%

I support a software program that has a proprietary menu item when you right-click a calculated field. It has been this way for 10-15years and has worked in WinXP through Win10 with never an issue. This past week I had 3 different customers tell me that when they right-click one of these fields to access what is normally the Cut/Copy/Paste/ menu that also includes our menu item, they are now getting the Windows default cut/copy/paste/Right to Left Reading order/Show Unicode control characters/ etc menu. The only thing I can think of that they all have in common besides these are all Window 10 64bit pc's, is that they all have one update to Adobe Acrobat (17.012.20098).
I was able to resolve for a moment on two of these workstations by having the user go into Language/Advanced settings and actually selected "English (Unites States) from the "Override for Windows display language" even though that settings is implied by the "recommended". But after the pc was turned off over night and back to it the next day, the problem is back and that setting is still selected. All language and regional settings on all the pc's are defaulted to English/Unites States. I do not know what other avenue to go in. Could something hae been switched on or off in Windows (by this Adobe update perhaps?) that would make the context text menu switch to Windows text default right-click menu?

Any help is appreciated!

More replies
Relevance 86.13%

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:\\" AA} and {IncludeText "C:\\" 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,


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 83.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,

More replies
Relevance 79.75%

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


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

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):
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 95.53%

I have a table titled time_slips used to track the amount of time an attorney spends with a member. In the time_slips table there is a field titled reference_id which is a combo box pulling it's displayed information from another table titled references. Also in the time_slips table is a field named details which is native to this table.

My question is, can I have the details field auto-populate "no charge" when a certain reference id is selected (i.e. 300)?

Thanks for any help you can provide.

Answer:Solved: Access Auto-Populate a Field using a field from another table

15 more replies
Relevance 94.3%

Hi. Here is the situation.

I have two tables (Field_a & Table A and field_b & Table b) and I wanna set up validation rule for field_b (Table b).

Rules needed for field_b:
1. If field_a (Table A) = 0, field_b (Table b) = 0.
2. If field_a (Table A) = 1, field_b (Table b) > 0.

Thanks a lot for the help!

More replies
Relevance 94.3%

I attached my database what i would like to do is create a form when an end user will enter a corresponding user ID from that I wish to populate textbox fields with Agent Name, Supervisor, Location, Dept *all seperate text boxes of course* I have attached the database if someone could help me do this it would be great. Let me know if you need any further details to help get me through this.

Answer:update field A in form based on entry in field b

Welcome to the forum, before answering you question can I suggest some improvements to your database.
Currently you do not have any "Key", "Indexed" fields in your tables and there are no relationships set up between the tables.
Also do you really need the Archive Table?
The data looks like it has been exported in from a spreadsheet, relational databases work quite differently to spreadsheets, so to make the most of their advantages you need to correctly relate your Tables.
Your UserID Roster also has some disconnect between the Field Names and the actual data in them, particularly the Name and Type feilds.
In the Supervisor Table the Birthdate does not seem to have Translated correctly.

2 more replies
Relevance 94.3%

I'm doing a quick-and-(very)dirty design as a proof of concept. During this process I fat-fingered the word Description, as Ddescription. No problem, I know what it means, right. But it annoyed me, so I changed the underlying table (where the error occurred), deleted the control from the form, and added the (now correctly spelled) control.

However, every time I try and ruin the form it wants a value for the now non-existent field Ddescription. I simpy click-through, and the form runs fine. When I look at the available fields in the form's View query's Field List, it still shows Ddescription, and i seems to think it's coming from the underlying table.

Any ideas on how I can remove this phantom field? I can't find anything called "The_View_for_form_FooBar" anywhere, but I know it must exist somewhere...


More replies
Relevance 94.3%

I am setting up kiosks that once in the field will be locked down and not accessible to anyone in the field nor do we want anyone else accessing them. However, I need the ability to remote into the system if there is an issue.

Is there anyway to set up the machine so that I can do this without someone being in the field at the machine?


Answer:Remote connect to a system in the field w/o user in field


3 more replies
Relevance 94.3%

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


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.



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

I am working on a database that stores genus, species, and variety I want to sort the data with genus, then species, then variety.

Now the tricky part. Sometimes there is no species. When this is the case, I want the database to sort that record off of variety.

I have though of a way to do this, but need help with the code.

If I make a species2 field, I could create an expression that would look at the species field. If the species field is empty, it could copy the data from variety. If it is not empty, then copy the data in the species field.

Once the species2 field has the updated data, I could then do a sort

genus, species2, variety

The report would have genus, species and variety showing and species2 would be checked off to not show in the report.

I am using Microsoft Access 2000.

Any help would greatly be appreciated.

Answer:Access - if field is blank, copy field A, if not copy field B

You should not actually need another field to do this, just another column in your report's Query. Something like this as a Field header :-

dummySpecies: iif(isnull([species]), [genus], [species])

this should provide a column with the species in if it there and the genus if it is not, which you can use in place of your actual species field in the report for sorting.

1 more replies
Relevance 92.66%

Hello everyone,

I have the current formula

CompPassFail: IIf([specifiedComp]>[PCcomp],"Fail","Pass")

This works O.K, but I am being told that it should pass or fail if is within -/+3percent. Both field are percentage fields, where[specifiedComp]is the main number that [PCcomp] has to more or less align to.

More replies
Relevance 92.25%

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

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

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

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

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

Hi all, 
I have a matter about placeholder in html. The placeholder will be disappeared when focus
on text filed with IE. But I want to keep hint text of placeholder when do that. Could you give me any suggestion?

More replies
Relevance 90.2%

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

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

1 more replies
Relevance 90.2%

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 ?


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

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

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?


Answer:MS Access - autofill date field

6 more replies
Relevance 90.2%

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


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.


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


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'

Reuel Miller

1 more replies
Relevance 89.38%

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


exit celll with ctrl, shift, enter

1 more replies
Relevance 89.38%

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

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!


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

16 more replies
Relevance 89.38%

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: and Answer. The way of learning.Dell Dimension 8300Intel Pentium 4 HT @ 3.20 GHz4 GB RAMNvidia Geforce FX5200

2 more replies
Relevance 89.38%

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

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

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

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

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

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

I am using a search function as described in thread click here. I have a keywords field and would like to search the whole field with the QBF function. Is there a way to do this as it will not recognise "art" in painting, art, drawing.Also can i search a number of fields at once with this Query By Form function?Thanks in advance.(If you have a script which is fairly large, just send it to me by email by clicking the envelope at the top).

Answer:Searching more than one field/any part of field.

Just a quick suggestion, have you tried to see if "%art%" will work in your search?The % is the wildcard character within SQL server, and may be simliar in access!R.

4 more replies
Relevance 88.97%

when I print to Hewlett-Packard 800 series, instead of printing the page number (or other information) I get...
{page} or whatever the instruction is for the field. In print preview, it shows the number, but then when printed, I get the instruction information.

Answer:field text in Office 97

Please let us know which program next time.

If it's Word (I suspect), go to Tools-Options-Print tab. Remove "field codes".

3 more replies
Relevance 88.97%

How do I get Firefox to remember something typed into a specific field? This text box pops up after I select 'Merchant Accept Liability' from the dropdown menu. I have to type 'We accept liability' into the text box at least 200 times a day. If there was some way for Firefox to remember this, it'd be extremely convenient. Attached screenshot.

Answer:Remembering a text field

One of the best rated form fillers is Roboform. It works in Firefox and IE.


Quality Artificial Intelligence
RoboForm is really smart in filling in forms; it is the most precise form filler on the market. We use Artificial Intelligence techniques to achieve this kind of precision and we test RoboForm thoroughly.

Selective Form Filling
You can ask RoboForm to fill just a part of your form, rather than the complete form. Simply select (highlight) the fields that you want RoboForm to fill and click any form filling button -- only the selected fields will be filled.

You could also try one of these Firefox addons:




Automate Firefox. Record and replay repetitious work. If you love the Firefox web browser, but are tired of repetitive tasks like visiting the same sites every days, filling out forms, and remembering passwords, then iMacros for Firefox is the solution you?ve been dreaming of! Whatever you do with Firefox, iMacros can automate it.

3 more replies
Relevance 88.97%
Question: Text Field Issues

While the main reason for this help request is to help me fix the text field problem Im having, there are a couple other problems as well.

It has become an ongoing problem, no clue what causes it. In certain games, so far only Mabinogi and Test Drive Unlimited, when I go to type something in a text field, my computer pauses, and people talking in Ventrilo repeat themselves over and over for a couple seconds. The same thing happens when I exit a text field in said games. No one else I have talked to has this issue, and I am fairly certain they have slower computers than me, so no clue what the issue is.

The other problem is my graphics card. I have an ATI Radeon x800 card, and when I am playing games, I get errors when it does not even seem to be taking up much memory. I was playing Test Drive Unlimited which I just got today, and I was getting a report error window for ccc.exe about every minute in game. If I ignored it, I could keep going, but eventually another error window popped up saying the same thing, so I shut the game down. I meet the minimum requirements, but I have no clue why its doing this. My computer has a history of overheating, but I don't know if its due to that.

Also, is there a program I can use to monitor the heat in my computer? I'd like to know if that is truly the problem here, as I have been told that my card could be damaged by now if it is overheating.

Answer:Text Field Issues

First heer is a link to the site that has a monitor for CPU and Heat along with a few other things. It is called MBM and about the 11th item down. It is Freeware.I would also suggest getting any Driver updates needed. I do not know what system you have but you can go to the manufacturers site and retrieve them from there. Do these two things and then try the game again so we know if it is a heat problem which it sounds like back and let us knowThank you Jitaa

12 more replies
Relevance 88.56%


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

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

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;

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


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?


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

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

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

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

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?

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

10 more replies
Relevance 88.56%

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 :

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

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

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.


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

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:

4 more replies
Relevance 88.56%

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,


More replies
Relevance 88.15%

I am currently building myself a stock database system in MS Access 2000. On one of my forms and reports. I want my text in a textbox element to flow vertically. I have found a method to do this, but the text runs the wrong way. Would it be possible for my to correct this in anyway? If so how would I do it?

Answer:MS Access text field orientation

Help! Anyone? Please.

2 more replies
Relevance 88.15%

Recently there's been an annoying little animation pop up whenever I click something. I can't really explain it, but it's similar to the blinking | you see when typing in text fields. Everything I click on something it shows up. It's really annoying. It even happens when I click a picture, except it appears as a HUGE blinking bar. Can someone help?

Answer:Not sure.. text field-like highlights when I click anything

A sometime worth a thousand words, can you post a screenshot?


7 more replies
Relevance 88.15%

Hello All.
Public Sub AutoExec()
MsgBox ("The Word Startup Folder is: " _
& vbCrLf & Word.Application.StartupPath)
End Sub
First, I want to again thank everyone who helped me with my first question: Text Form Field in Word 2003.

My next question is: Is there a way to automatically tab to the next form field?

End Time
I would like to key in the hour (00), skip over the colon, key in the minutes (01) and have Word or VBA tab to the next field.

Can this be done? Any ideas?

More replies
Relevance 88.15%

I have a table consisting of 8 columns by 26 rows. In each cell, I'm adding a Text Form Field. Is there anyway, besides doing it cell by cell, where I can just copy a row, then paste the same Text Form Field with text length maximums in the other 25 rows?

Answer:Word - Text Form Field

Sure, Brian.
Create first row.
In Print Layout view, take your mouse pointer to the left of the left-most cell in the row, and it should turn into a 1:00 pointing arrow. Click to select the whole row, then Ctrl+C to copy. Place your cursor in front of the paragraph return just below the table OR in the left-most cell of the row that you want a new row above, and hit Paste.

3 more replies
Relevance 88.15%

When creating, forwarding, or replying an email; the text field does not open automatically. It must be expanded manually. What is my problem? Thank you.

Answer:Outlook Express Text field

Have you tried this.

make Windows Mail or Outlook Express open email messages to windows that make use of all the available screen space automatically:

Open any email in its own window by double-clicking it in its folder.
Make sure the window is not maximized.
Move the window so that its top left corner coincides with the top left corner of your screen.
Grab the handle in the window's bottom right corner with the mouse and drag it to the bottom right corner of the screen.
Close the message window

1 more replies
Relevance 88.15%

Where is the setting to change the color of text fields? The color options in the options menues just change or force colors on the webpages themselves. Im looking to just change the color of the address/google bar, and any text fields that happen to appear on a webpage. Right now they are all a dark ugly grey, where if I open the same page in IE everything is properly colored to the pages defaults or to my light colored xp theme.

More replies
Relevance 88.15%

From a specific text value in one field I need to count that field in multiple other fields. ie: in one column, for each text field marked Trip1, I need to add to a count in a Compartment1 field, a Compartment2 field, and a Compartment3 field.

Answer:How to count text values in another field

Perhaps we could be of some help if we knew what application you are talking about. Even if we know the application, I'm not sure there is enough information in your post for us to answer.Perhaps you could add a few details regarding what it is you are trying to count. Keep in mind that we can't see your computer from where we are sitting, so the more details you provide, the better.Thanks!Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

3 more replies
Relevance 88.15%

when i open yahoo mail ,nd go for composing , the text area does not appear nd so i could not able to wright mails to my friends.the page displays also done with error. pls help me out of this problem

More replies
Relevance 88.15%

Ok, first, I'm running Windows XP Pro SP2 on an HP Pavilion 8760c. It originally came with Windows 98, but the previous owner upgraded it to the XP sometime before giving the computer to me. I do NOT have any disks, neither the original system disks nor any restore disks, nor does there seem to be any restore partition on the hard drive.

First problem is -- for some reason when I try to type into any text fields in any windows based programs, the cursor goes into hyperblink mode, won't click into any text field, and won't let me type in any of them. I first noticed the problem when I tried to use internet explorer, I went to Google like normal and while it will let me type in the address bar at the top, it won't type into the Google search field. I have since found out it is NOT IE specific, but it won't let me type into the windows help search field, or the field where you enter a name for a restore point when manually setting it, or in the captcha box on a game program I use or pretty much anything windows based. I downloaded Firefox and I can type in Firefox with no problems, which is fine for searching the web, but does not fix the problem.

Second, with the system restore... this computer used to work fine. I used it occasionally at my old house, then we moved and the computer sat idle for about nine months, and I just hooked it back up last week. When I did I found problems with the sound as well as the problem with the text fields I mentione... Read more

More replies
Relevance 87.33%

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

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

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

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

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

2 more replies
Relevance 87.33%

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

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

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")
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 87.33%

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:
="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?


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

7 more replies
Relevance 87.33%

I am trying to insert an address and slide the text up so I do not have to see the blank lines plus extra space.

Answer:Access - slide text up if blank field

7 more replies
Relevance 87.33%

I was wondering if the following is possible:

I am using Microsoft Excel currently (on a Windows XP machine) and I have three columns, one is text (name) and the other two columns are MM/DD format (start date) (finish date).

Can I make something that will move the entire row to a new sheet/tab, after the second date is added?

Name Start Date Finish Date
ABC Company 07/11/07 07/15/07
BCF Company 07/15/07 _______

Any guidance with this problem would be greatly appreciated.

Thanks in Advance,

Answer:Solved: Moving text after completing a field

15 more replies
Relevance 87.33%

Hello All.

I am attempting to create Text Form Fields in a previously created Word document. It was not created from a form template.

The field is the DAY in the date field: 10//007. I put the insertion point in the DAY field, click on the Text Form Field icon and fill in the field attributes. Type=Number, Max length=2. I type in a Help description, click OK, save the file, and click on the Protect icon.

When I key in a 2-digit num and press tab, the next page comes up. The same thing happens if I try to put in alpha characters. My help message does not appear. I pressed F1.

I would appreciate any help with this issue.

Answer:MS Word 2003 Text Form Field

9 more replies
Relevance 87.33%


Help, I am a novice at Access 2010 and am attempting to write a custom [COLOR=green !important][COLOR=green !important]database[/COLOR][/COLOR] from scratch.
How do I get data from multiple text fields to show up combined in a seperate text field. I want to combine the First, Middle Initial, and Last Name fields so they will be combined in a seperate field I named Complete Name.

I typed the following into the Validation Rule of the Property section for the Complete Name text field however, the Complete Name text field remains blank in Form as well as Table.

Trim$([FirstName] & " " & [MI] & " " & [LastName])

I hope I explained this correctly as I am relatively new to Access. Can you give me any advice or suggestions? Thank You


Answer:MS Access 2010 Text Field Question

There are 3 ways to do this.
1. This method uses a query to combine the data, but it will not store the combined data and it will not refresh on it's own if you add or change the data.
2. This method combines the data in and Unbound field by making it the Control Source of the Field. This will not save the data to a table but will automatically update.
3. This method uses VBA in the After Update Event Procedures of the 3 fields and will automatically update the data and also save it to a table if required.
The choice is yours.

1 more replies
Relevance 87.33%

Hi all, been away for a long time.My problem is this :I have an MS Access 2000 database listing song titles. I have built a form and added control buttons for "First Title", "Last Title","Next Title" and "Previous Title"These four controls work successfully, going to the denoted record as required with no problems.THE PROBLEM:I have tried to add a combo box using the "TITLE" field only from my form data. Song titles often include the character apostrophe ('), example...."Don't Cry For Me Argentina"When I click in the combo box and select a title with the ' in it I get a runtime error 3077 and cannot go to that record. Titles without the ' in them display in the form with no problem.MY QUESTION:Is there any way to display the song title correctly (including the ') without the combo box treating it as a rem and thus throwing up the runtime error?My db has a number of fields giving info on the song and display on the form.Operating System Windows 98SEProcessor Intel 600E CoppermineRAM = 256 MbHDD 40 GbMS Access 2000 is the db.Grateful for any advice.btw....I only have a very limited idea of Visual and Access Basic !!!

Answer:MS Access 2000 text field characters.

I would do a search of the MS knowledge base, refining it to searching Access 2000.

3 more replies
Relevance 87.33%

I am looking to create a MS Word 2003 document for work that has a text field that has a character limit to it and I can't seem to find anything in Word that does that. I know it is possible, as we have various documents corporate HQ has us use that has text fields with character limits on them. Does anyone know where I can find this in Word 2003?


Answer:Text field w/character limit in MS Word 03

7 more replies
Relevance 87.33%

I have a memo field in my application that the user needs to put a lot of text in with numbered items that require indentint. The finished report looks awful because she is forced to space between the numbers and the text instead of a clean indent. I am using the runtime version of Access 2007 field. I need find a text editor that will hold formatting and keep it in the field for the report.

Answer:Text Editor for Access 2007 Field

8 more replies
Relevance 87.33%

I have completed a 4 page form in LiveCycle, however, I cannot figure out one important thing. I would like to have a text field repeated on everypage. A job number for example that someone filling out the form would enter, I would like that job number to appear at the top of every page.

How do I do this? Is there an easy "click" I am missing?

More replies
Relevance 87.33%

My Access 2007 database contains records with a text field of up to 255 characters. these records are being imported into a system that allows up to 39 characters for this data. I'm seeking help to create a query(queries) or macro(s) that will create additional records with each one containing the next 39 characters in the text field. For example, a record contains 125 characters in its text field. I need to end up with 4 records such that record #1 contains the first 39 characters, record #2 contains the next 39 characters, and so forth.

Answer:Parsing text field in Access 2007

6 more replies
Relevance 87.33%


i want to update the text box based on the combo box selection based on the user form in excel. I am using the below code but the problem is combo box value is hidden once i selected but text box value is coming.
'Private Sub ComboBox1_Change()
'ComboBox1.Value = Worksheets("OptionPage").Range("Af28").Value
'TextBox7.Value = Worksheets("OptionPage").Range("Ag28").Value
'End Sub

I am assigning the value of combo box into af28 and from there i am doing a vlookup in ag28 to get a value. In the combo box i have row source of particular range in the sheet.

Please help.....

Answer:Solved: Combo box text field updation

Hi, could you just post a sample with dummy data, it makes it easer to 'see' what you need / want.

3 more replies
Relevance 87.33%

i have a access 2007 database and have to print a lot of reports for the client. however when you have calculated field (i am counting the amount of weeks) on the form - and you then put a textbox on the form - which is a memo field in the table - that pulls information from the database(memo field) some of the data gets cut off.
i have set the 'can grow' and 'can shrink' properties to yes for the field.

once you delete the calculated field from the query - the text stretches and all the memo field text shows correctly.
is there away around this?

Answer:calculated field on reports causes text to disappear

Is the calculated field in the Header, Detail or Footer section?

3 more replies
Relevance 87.33%


I have a doc which I have added the many checkboxes by using Check Box Form Field. Now I want to add textbox for others to enter text. I have added a Text Form Field to the doc but it is kind of hard to tell that there is a field in there. How I can make something like this:




so others can enter text above the lines only or making an enclosed box so others can only enter text inside the box?

Thank you for any help,


Answer:How to use the Text Form Field in MS Word 2000?

7 more replies
Relevance 87.33%

I create demo files for testing. The way I have it now I have the file laid out with two merge fields. These link back to another docucment where I input a month's worth of dates. The first being Date created and the second column is File Load date.

Once this DateInput doc is updated I go through each record in the merge document and save each one as the DateCreated number as the file name and as a txt file.

Any ideas on how to automate this? I tried using Access to fill in the merge and I was able to have it input today and tomorrow dates using command buttons and these subs

Private Sub cmdToday_Click()
txtFrom = Date
txtTo = DateAdd("d", -1, Date)
End Sub

Private Sub cmdTomorrow_Click()
txtFrom = DateAdd("d", 1, Date)
txtTo = Date
End Sub

But that only gets me two days, I need to see about automating the whole month.

Any help would be appreciated. Thanks

Answer:Whole month of text files with merge field

Any ideas on how to do this? I have tried everything that I know. I tried making a macro in Word, but could not get that to work either.

1 more replies
Relevance 87.33%

I am trying to create a worksheet to help me track my business.  In it I need a text field where  I can enter daily information. Is there some type of a text box or table that I can insert and use that will not increase the size of the worksheet when I update?  Thanks, lindee

More replies
Relevance 86.51%


I have been struggling with this for a couple of days.

Here's the scenario: I have 2 sets of data, one shows repeat calls for a list of customers, the other shows trouble reports for the same set of customers. I want to count how many times each of these customers called within 30 days of the original trouble report.

I have tried using a nested count Iif expression but I don't have a lot of experience with expressions and apparently am using it incorrectly. What I have tried is something like this:

=Count(IIf([Contact Date/Time],+30,1))

Any suggestions or ideas are welcome at this point. Thank you in advance!



Answer:Access 2013 - Count only if date falls within 30 days of field from different table

I would create a 'groupby' query using the DateAdd function for criteria. If this is a report you should be able to link this query to the report query by acct number or something.
SQL looks like this example
SELECT Table1.Name2, Count(Table1.ID) AS NameCount
FROM Table1
WHERE (((Table1.Date1)>DateAdd('d',-30,Date())))
GROUP BY Table1.Name2;

1 more replies
Relevance 86.51%

When items are loaned out we want them returned in 30 working days (approximately 6 weeks I'm not going to bother trying to calculate holidays) but to only come back on a week day Monday through Friday.

Field Name ReturnDate_Fld this needs to be calculated as 30 working days from the current date

or should I not worry about the extra effort and use the approximate by adding 42 to the BorrowDate_Fld (plus 42 days = 6 weeks)

Should I worry about this in a form or only set it as field in the report/query?

Answer:Solved: Access 2010 Set a date field to today plus 30 working days

16 more replies
Relevance 86.51%

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.

3 more replies
Relevance 86.51%

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


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

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

Can anyone help me with this following issue?
I don't really know how I should write the hole thing (receiving errors).

Here is the link

Thanks in advance

PS: VBA 6.3 and Outlook 2003

More replies
Relevance 86.1%

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