Over 1 million tech questions and answers.

Outlook 2003 Custom Field Extracted From 'Due Date' Field?

Q: Outlook 2003 Custom Field Extracted From 'Due Date' Field?

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

Read other answers
RELEVANCY SCORE 200
Preferred Solution: Outlook 2003 Custom Field Extracted From 'Due Date' Field?

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

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

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

RELEVANCY SCORE 107.2

Hello

Access 2003
Windows XP

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

Thanks

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

A:Access 2003 - Format field to Short Date

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

Read other 3 answers
RELEVANCY SCORE 106.4

Hello All!

I am a novice Access user. I just recently started using it to create a database for work that will track complaints. I have been searching high and low to try to figure out how to create a custom autonumber field but just don't know what to do. Maybe there is some help out there from one of you.

I wish to create an autonumber that displays the computer's date and generated numbering.
(Ex. 08/22/10-0001, 08/22/10-0002...)

Any help given would be much appreciated!

Thanks in advance,

-Julie
 

A:Solved: Access 2003: Help with creating custom autonumber field.

Read other 16 answers
RELEVANCY SCORE 106.4

Hello:

I'm using Access 2003 on a Windows 7 machine. The database I've created tracks the purchase and sale of industrial equipment and the form that's giving me trouble is for creating/viewing quotes.

On the quote form I have a quote number field that automatically generates a new number each time a new quote is created. In the Default Value for the QuoteNumber field I have the following formula: =Nz(DMax("[QuoteNumber]","tblQuote"))+1

Generating the new number works great but the users want to be able to go back and find a record using the quote number field. In the criteria in the "qryQuote" query I have [Enter the quote number].

To control the whole mess I have a switchboard with one of the buttons being "Find quote by quote #". If I create a macro that does the search and opens the query it works. But when I add the command to the macro to open the quote form I get all records and I only want to see the one I've searched for.

This is probably way more information than necessary but - better too much than too little.

I'm fairly new to programming in Access so please be kind...

Thanks!
 

A:Solved: Access 2003 find using custom autonumber field

Theresa, welcome to the Forum.
The simplest way to do what you want is to add a Find Combo to the actual quote form, you don't need a button or query.
The Form design "Combo Wizard" will create the combo and associated VBa for you.
When the user types the quote number in to the combo it automatically shortens the list of quotes depending on what you type, or the user can use the drop down side bar to move up or down the list as required.
 

Read other 2 answers
RELEVANCY SCORE 106

Good day guys

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

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

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

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

BUT what I want is the following:

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

or even nicer

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

Can this be done in such a control?

Chris
 

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

Read other 7 answers
RELEVANCY SCORE 104.8

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

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

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

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

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

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

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

Read other 8 answers
RELEVANCY SCORE 103.2

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
 

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

Thread reopened for user to post solution.
 

Read other 3 answers
RELEVANCY SCORE 102.4

Outlook 2013 has the following labels/fields for "Phone numbers":

AssistantBusinessBusiness 2Business FaxCallbackCarCompanyHomeHome 2Home FaxISDNMobileOtherOther FaxPagerPrimaryRadioTelexTTY/TDD
Is it possible to add a custom label/field?

Read other answers
RELEVANCY SCORE 102.4

Outlook 2013 has the following labels/fields for "Phone numbers":

Assistant
Business
Business 2
Business Fax
Callback
Car
Company
Home
Home 2
Home Fax
ISDN
Mobile
Other
Other Fax
Pager
Primary
Radio
Telex
TTY/TDD
Is it possible to add a custom label/field?

A:Add custom phone number field to Outlook 2013 Contact?

I do not believe it is possible to add a custom name to the list.

Read other 2 answers
RELEVANCY SCORE 100.4

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

A:Outlook 2003 Bcc Field in Windows 7

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

Read other 2 answers
RELEVANCY SCORE 99.2

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

Read other answers
RELEVANCY SCORE 94

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

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

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

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

Thank you!

Cheryl
 

Read other answers
RELEVANCY SCORE 93.6

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

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

Read other 16 answers
RELEVANCY SCORE 93.6

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

Read other answers
RELEVANCY SCORE 93.2

I'm using internet explorer 11 with windows 10.

As a way to expire cookies, I have set the 'expires=<DATE>' to a point in the past.

When I tested

The following formats are not supported. (Cookie was not removed.)

Set-Cookie: expires=Wed, 01-Jan-70 00:00:00 GMT
However, the following formats are supported. (Cookie was removed.)

Set-Cookie: expires=Wed, 01 Jan 1970 00:00:00 GMT
I confirmed that the former was rfc850 and the latter was rfc1123.

I wonder if there is an official document or reference for this result.

Read other answers
RELEVANCY SCORE 92

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
 

A: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?
 

Read other 3 answers
RELEVANCY SCORE 92

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.
 

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

Read other 15 answers
RELEVANCY SCORE 91.2

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.
 

A: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.
 

Read other 2 answers
RELEVANCY SCORE 91.2

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?

Brett.

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

Teamviewer.

Read other 3 answers
RELEVANCY SCORE 91.2

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!
 

Read other answers
RELEVANCY SCORE 90.4

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.
 

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

Read other 7 answers
RELEVANCY SCORE 90

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.
 

A: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.
 

Read other 1 answers
RELEVANCY SCORE 89.2

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.
 

A:Updating date field

Read other 6 answers
RELEVANCY SCORE 89.2

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!
 

A:Update date field

Read other 6 answers
RELEVANCY SCORE 89.2

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.
 

A: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.
 

Read other 1 answers
RELEVANCY SCORE 88.4

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

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

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

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

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

rgds
Hew
 

Read other 1 answers
RELEVANCY SCORE 88.4

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

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

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

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

Help!
 

Read other answers
RELEVANCY SCORE 88

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!

A: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.

Read other 9 answers
RELEVANCY SCORE 88

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.

A: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.

Read other 3 answers
RELEVANCY SCORE 88

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.


 

A: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
... ... ....
 

Read other 1 answers
RELEVANCY SCORE 88

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.
 

A:MS Access - autofill date field

Read other 6 answers
RELEVANCY SCORE 88

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 )
 

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

Read other 1 answers
RELEVANCY SCORE 87.2

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?
 

A:Solved: Stop Updating the Date Field

Read other 6 answers
RELEVANCY SCORE 87.2

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!
 

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

Read other 16 answers
RELEVANCY SCORE 87.2

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
 

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

Read other 1 answers
RELEVANCY SCORE 87.2

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
 

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

Read other 1 answers
RELEVANCY SCORE 87.2

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.
 

Read other answers
RELEVANCY SCORE 86.8

Hello all,

I am a not a novice computer user by any means, or even a novice MS Office user. I am, however, brand new to Access.

We are currently in the process of creating a database with which to track complaints that we have received, so that we can ensure they are processed in a timely manner with all the appropriate steps taken. We would like to have a unique case number assigned to each complaint, automatically populated when a new complaint is entered into the database. I've created and populated the database from the Excel spreadsheet that we had been using to track these complaints.

The problem I'm having however is creating the autonumber in the "case" field that we want! We want our complaints to be auto-populated with a case number "XX-YYYY" where XX is the last two digits of the year in which the complaint was entered and YYYY is an autonumber, starting with 0001 and going up from there.

Can anyone help me with how I can make this populate correctly? I tried using the following in the Format mask in design view, based on the in-program help:

"10-"****

with the thinking that if necessary I can create a database file for each calendar year (useful for archiving purposes at least). However, ~every~ entry shows up as "10-" (with nothing after the hyphen) until I click on it (at which time a seemingly random, but sequential, 8-digit number shows up, starting with "69313633").

Please help!!
 

A:Access 2007: Help with creating custom autonumber field

Read other 8 answers
RELEVANCY SCORE 86

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.
 

A: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.
 

Read other 1 answers
RELEVANCY SCORE 86

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

A: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?
 

Read other 2 answers
RELEVANCY SCORE 86

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.
 

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

Read other 7 answers
RELEVANCY SCORE 86

Hey everyone,

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

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

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

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

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

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

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

Read other 8 answers
RELEVANCY SCORE 86

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
 

A: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.
 

Read other 2 answers
RELEVANCY SCORE 86

from email address removed by Dreamboat

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

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

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

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

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

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

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

A:Solved: Extrapolate Month from an Access date field

Read other 16 answers
RELEVANCY SCORE 86

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

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

Read other 10 answers