Computer Support Forum

Need help to send automated email based on the date field

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

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.

Relevance 100%
Preferred Solution: Need help to send automated email based on the 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.)

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

I've read the previous post with the same issue, but I'm unable to understand how to use the other codes posted within my product. I would like to send an email based on a date. I will attach my document so it is easier for me to explain the requirement. Columns L37-L45 have due dates - I would like the email to be sent 60 days prior. I have posted some mock emails in R37-R45 and the email message in the EMAIL workbook tab. Any assistance would be greatly appreciated.

Thank you so much!
 

Answer:Auto send an email based on date in Excel

Welcome to the board.
I've had to save it as 2003 version but the code works under 2007

See attached my copy of your sheet with the code in ThisWorksheet module.

This just a simple way of doing it and you will have to edit it for your needs but maybe it can put you on the right track.
 

2 more replies
Relevance 83.23%

Hello everyone,

I'm hoping that I can get help with my issue at hand. I have a problem that from the looks of it has been asked a few times. However my understanding of excel and visual basic is to very limited to solve my problem without any help.

Here is what I'm faced with:

I made a workbook for keeping track of maintenance and DOT requirements for the trucks in our yard. Each sheet is set up with service date or inspection date visual reminders based off of conditional formation. I get a visual warning (X) amount of days before and a past due warning 1 day after, all depending on my requirements.

After searching the forms I found a thread that looks to be the closest that I can find to my needs. http://forums.techguy.org/business-applications/636786-set-email-reminder-base-excel.html

Since I have multiple dates and need for an email reminder the coding gets confusing to me. I have a very basic understanding of coding principals but have never used visual basic.

What I would like to happen based off of my understanding of the other thread:
Using task scheduler run a VB file that would then open the Excel file everyday at (X) time and check my date parameters and send an email with a warning that a due date is coming up or if past due then an email saying it is past due. The close file.

I'm sure more information will be need to give me any type of help. I have attached the workbook for reference and so my explanation will make more sense.

I'm ... Read more

Answer:Excel: Automated email based on Conditional Formatting

Hi there, I noticed that your post has gone unanswered, you posted on March 25th an looks like nobody has taken a chance on it.
You mention you're using office 2013 but your file is Office 2003 or earlier; I assume this is a file you've been using for quite some time.
What you're asking is in a certain way not that complicated but needs to be thought about very carefully. Usign the scheduler to open the Excel file, check it and then close it is not that muvh of an issue but you do have to realize that if you're using Excel for something else and all at once the scheduler triggers it you could run into some problems and might loose the data you're working on.
In the 'Abq Truck & DOT Reguirements' sheet you've got 4 columns with dates, which one is the one you trigger the mail on, all four? What email address?
Conditional formatting is nice for visual triggers but will not trigger a macro so that all together will be some vba code which needs thinking and writing.
The samples on other posts can of course be used and like you say some coding / vba knowledge is required to adapt it to your needs.
Think about it and update with some extra information, maybe some simple code can be written and used
 

1 more replies
Relevance 82.82%

Hello,
Firstly, let me apologise, I'm a complete Access noob & am trying to teach myself as I've got no one to help me in person.

Ok,
I'm trying to build a Time Sheet database that should record daily duties via an entry form:
"frm_Work_Hours"

This form updates an underlying table:
"Work_Hours"

The date field of the "Work_Hours" table is:
"Date_Worked"

However, workers get paid fortnightly and all their entitlements, allowances & overtime are calculated on these fortnightly periods. To be more specific, the workers are paid for a certain amount of overtime for each fortnight upfront & when they exceed that, then they are entitled to all excess time back in TIME OFF. So it's pretty important that each day's duties are assigned to the correct fortnight period so that their overtime & so-forth are calculated correctly.

Each fortnightly period is numbered according to year. For example, each year there are 26 fortnightly periods, so as an example today (3rd October 2013) falls in period 2013-19 (23rd September 2013 to 6th October 2013).

I've created a table called:
"tbl_Pay_Period"

Which has the following Fields:
"ID" (Auto-number)
"Period_Start" (date - the first day of each new fortnight period)
"Period_Number" (number - eg: 2013-19)

Back in the "Work_Hours" table, I inserted a new (Number) FIELD called:
"Pay_Period"

and set ... Read more

Answer:Solved: MS Access - How to get a field auto-update based on date entered in a form

9 more replies
Relevance 81.18%

Hi everybody,

First time poster. I currently have 9 tabs open and hours of researching trying to figure this out. I can say I'm more educated now with excel than I was this morning. Very powerful software.

I seen current thread that were very close to what I need but was unsuccessful with achieving what I needed.

I'm trying to set an email reminder sent to my team when a task has not been completed (Column D) by the due date (Column C) and some indicator on column H when completed. It would be most ideal if the subject had the part number "123453 Rev 06 Doc Control Update" and body said Dear Andy(Task Owner) reminder, please update documentation related to your department. Thanks.

I currently have a macro for 'Task completed' be filled in a green color when complete. I'll copy and paste below what i currently have. I know this is probably a long shot but I am getting somewhat stressed and losing hope with this, please please please help. function is more critical for me then the looks, if i have to move some cells around I don't mind one bit.
Code:
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Cells.Count > 1 Then Exit Sub
If Not Intersect(Target, Range("D2:D100")) Is Nothing Then
With Target(1, 2)
.Value = Date & " " & Time
.EntireColumn.AutoFit
End With
End If
End Sub

Sub eMail()
Dim lRow As Integer
Dim i As Integer
Dim toDate As Date
Dim... Read more

Answer:Automated email in excel, driven by due date

Code:
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Cells.Count > 1 Then Exit Sub
If Not Intersect(Target, Range("D2:D100")) Is Nothing Then
With Target(1, 2)
.Value = Date & " " & Time
.EntireColumn.AutoFit
End With
End If
End Sub

Sub eMail()
Dim lRow As Integer
Dim i As Integer
Dim toDate As Date
Dim toList As String
Dim eSubject As String
Dim eBody As String
With Application
.ScreenUpdating = False
.EnableEvents = False
.DisplayAlerts = False
End With
Sheets(1).Select
lRow = Cells(Rows.Count, 4).End(xlUp).Row
For i = 2 To lRow
toDate = Replace(Cells(i, 3), ".", "/")
If Left(Cells(i, 5), 4) <> "Mail" And toDate - Date <= 7 Then
Set OutApp = CreateObject("Outlook.Application")
Set OutMail = OutApp.CreateItem(0)
toList = Cells(i, 4) 'gets the recipient from col G
eSubject = "Document Control Status update "
eBody = "Reminder," "Please update your project status."

On Error Resume Next
With OutMail
.To = toList
.CC = ""
.BCC = ""
.Subject = eSubject
.Body = eBody
.bodyformat = 1
'.Display ' ********* Creates draft emails. Comment this out when you are ready
.Send '********** UN-comment this when you are ready to go live
End With

On ... Read more

1 more replies
Relevance 77.08%

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

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

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

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

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

More replies
Relevance 77.08%

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

Hi Guys,
I am trying to create a macro that sends an email when a specific cell equals Yes,
please see below,
Cheers

Private Sub Worksheet_Calculate()
Dim FormulaRange As Range
Dim NotSentMsg As String
Dim MyMsg As String
Dim SentMsg As String
Dim MyLimit As Double

NotSentMsg = "Not Sent"
SentMsg = "Sent"

'Equal the MyLimit value it will run the macro
MyLimit = Y

'Set the range with Formulas that you want to check
Set FormulaRange = Me.Range("B3:B7")

On Error GoTo EndMacro:
For Each FormulaCell In FormulaRange.Cells
With FormulaCell
If IsNumeric(.Value) = False Then
MyMsg = "Not numeric"
Else
If .Value = MyLimit Then
MyMsg = SentMsg
If .Offset(0, 1).Value = NotSentMsg Then
Call Mail_with_outlook2
End If
Else
MyMsg = NotSentMsg
End If
End If
Application.EnableEvents = False
.Offset(0, 1).Value = MyMsg
Application.EnableEvents = True
End With
Next FormulaCell

ExitMacro:
Exit Sub

EndMacro:
Application.EnableEvents = True

MsgBox "Some Error occurred." _
& vbLf & Err.Number _
& vbLf & Err.Description

End Sub
 

More replies
Relevance 77.08%

Hi,

Im quite new to this excel programming thing and could really do with some help.

I need to send an automated email to 3 recipients (always the same 3 email addresses) when a number (formatted from a countdown of days to go) is 10 or less. Also i need a different automated email to be sent when a date is manually entered into a different cell.

I have managed to get the current date and time on my spreadsheet and used the format to work out the days to go to the deadline.

I have looked over all different types of forums but unfortunately because i'm still very green when it comes to excel i get lost and confused when trying to do this.

Is there anyone out there who can treat me as an alien and help me through this step by step.???
 

Answer:Solved: Send an automated email (outlook) from Excel spreadsheet dependent upon comle

10 more replies
Relevance 75.03%

Windows 98
Using any web browser(IE and Netscape, etc.)

I can logon to yahoo or other web based email sites, but whenever I try to send email on one of our computers, it cant find the site and wont send.
I dont know if the problem is related, but I also cant post this thread from the computer as well(im using another one to post this).

In yahoo I can only load my mail screen. If I try and click any option like 'inbox', it searches and wont find the site.

Help!
 

Answer:Can't send web based email

What message do you get? Can't display page?
Do you have a firewall or antivirus software? Which one?
 

1 more replies
Relevance 74.21%

Hi Guys,Currently am working on a Excel VBA to alert me through Outlook email based on the following conditions,I've the deadline dates for each tasks listed in Column 'G'. Now i want the VBA to check this deadline date and if the deadline date is 7 days from today, then it should copy the particular Row data and email the data to my email address.This should be performed everyday automatically, without opening the excel sheet.Am very new to VBA. So,Your help is much appreciated.Cheers,PK

Answer:Excel VBA To Email Row Data Based on Date

re: "This should be performed everyday automatically, without opening the excel sheet."I don't think that Excel or VBA for Excel is not going to be able to do this with opening the file - or at least some file.You can't have a macro running inside a closed file, constantly monitoring itself. Something has to trigger the code and/or update the formula that checks the dates, such as the file being opened or perhaps another open file pulling data from the closed file, etc.I guess you could schedule a windows task to open the file once a day or something similar, but there is going to have to be some "action" that initiates the running of the code.

14 more replies
Relevance 74.21%

I have created a spreadsheet to register equipment and record last inspection date. This date is a constant as all inspections are carried out at the same time. I then applied a simple formula to calculate the next due date, this is either 12 months; 6 months or 3 months.
14 days prior to the next due inspection the cell adjacent to the Next Due Date becomes Red and reads "TEST"
I need this event to trigger an email to various recipients but the spreadsheet will rarely be opened. From what I have read so far, I should create an event in Scheduler that will open the spreadsheet then trigger an email to the required recipients.
The problem is that I have no idea where to start.
Any help will be greatly appreciated.
Serial NumberREFERENCE STANDARDLast Inspection DateDescriptionLocationNext Inspection DateStatus16433-1Visual Inspection19/4/11Wire rope sling 16mm x 3 metre H/S IWRCContainer18/4/12OK
 

Answer:Trigger Email based on due date for inspection

I seem to have had a lot of views but no assistance yet so I thought it may be helpful to attach an excerpt from the Workbook I am trying to automate.
Thanks in Advance.
 

3 more replies
Relevance 74.21%

I have created "IF" formula in excel 2010, based on a date it will create a send due in column "E", =IF(D5=$A$2,HYPERLINK(mailto:"&$K$1&"?subject="&A5&-B5&"&body="&$C$3,"sendworks great but, I have to go thru 86 rows in column "E" and hit "Send Due" then hit send again on the email, can we automate this some how, like a macro that engadges when I open my outlook every morning

Answer:send email from excel based on

This should be in the Office forum here: http://www.computing.net/forum/offi...

2 more replies
Relevance 73.39%

This is prasanna from india. i need a help in my company i want to trigger mail automatically based on the date.. its kind of probation tracking mail... Example :- IF an employee has completed three months automatically mail should trigger to concern person.. is it possible in excelThanks in advance

Answer:Sending automatic Email based on the date in row in excel

Look here:http://www.rondebruin.nl/sendmail.htmYou should be able to find something you can work with.MIKEhttp://www.skeptic.com/

2 more replies
Relevance 73.39%

Hi All,

My name is Diego.

Can anyone send me code to automatically send me an email when the date listed in "column J" is the same date as today. Also, it needs to email only once and even if I am not running excel or at my computer. I want to use Microsoft Outlook and use the ClickYes program as well if this helps that was talked about by Zack Barresse in

http://forums.techguy.org/business-a...s-using-2.html
Essentially I have to be reminded of a reapplication for specific state licensures on healthcare courses I provide. I don't want to forget which courses I have to reapply for so I need to have a program that will look at a date which I have in column J and then email me to remind me of this.

BTW - I am using Outlook 2007 and Excel 2007 on Vista.

Thanks. I appreciate your help! Also, extra points and praise for the person who solves this problem!
 

Answer:Automatic Email from Excel based on Date in Cell

16 more replies
Relevance 73.39%

I have a personnel tracker that tracks required documents that need to be renewed every year. There are 4 of these and each has a seperate column for each date. They are J,L,T and U.

I would like excel to scan each of these columns every time the document is opened for any of those dates that are 60-65 days from expiring, I use Now()-300 to check this.

But if the cell is blank I want it ignored, which right now it does not. If it finds 1 or even 80 that are in that range I want 1 email generated to a list of management personnel.

Currently it generates how ever many are blank or expiring. I use outlook.

My data starts on row 3 and goes down to 331, the required and maximum number of people allowed on the contract.

If I can get just one email with a generic message I would be happy. But if I could I would like the info that is actually doing the triggering to be copied and pasted in the email to include the info in A, C and D.

Here is my current code, I would change .display to .send once I have it working. please help.

Private Sub Workbook_Open()
Dim Cell As Range
Dim DateRng As Range
Dim Msg As String
Dim olApp As Object
Dim olEmail As Object
Dim RngEnd As Range
Dim Wks As Worksheet

Set Wks = Worksheets("Work Site Info")

Set DateRng = Wks.Range("J3")
Set RngEnd = Wks.Range("J331")
Set DateRng = IIf(RngEnd.Row < DateRng.Row, DateRng, Wks.Range(DateRng, RngEnd))

'Change this to what you want.
Msg = "This is message is the bo... Read more

Answer:Solved: Automatic email from excel based on date

16 more replies
Relevance 72.57%

Hi All,

My name is Diego.

Can anyone send me code to automatically send me an email when the date listed in "column J" is the same date as today. Also, it needs to email only once and even if I am not running excel or at my computer. I want to use Microsoft Outlook and use the ClickYes program as well if this helps that was talked about by Zack Barresse in

http://forums.techguy.org/business-applications/710581-solved-automatic-email-alerts-using-2.html
Essentially I have to be reminded of a reapplication for specific state licensures on healthcare courses I provide. I don't want to forget which courses I have to reapply for so I need to have a program that will look at a date which I have in column J and then email me to remind me of this.

BTW - I am using Outlook 2007 and Excel 2007 on Vista.

Thanks. I appreciate your help! Also, extra points and praise for the person who solves this problem!
 

Answer:Automatic Email Reminder from Excel based on Date in Cell

Please do not post duplicate threads.
One thread per issue.
Continue replies for this issue in this thread: http://forums.techguy.org/business-applications/856705-automatic-email-excel-based-date.html
Thank you.

Closing thread.
 

1 more replies
Relevance 72.57%

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

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

Hi,

I have multiple Excelsheets where in I use it for day today activites & tracking.
I have attached one of the simple one so that I can know the codes for sending mails & I can do it my self for the rest of the workbooks.

There is a sheet(dash board) where in all the details get updated.
When there are any changes to the value in column F, a mail should automatically sent to me giving the detials of the row. The file will be always live in the server.

I am very poor in coding & I need someone to help me in doing this.

Thanks in advance.
Rgds
Ganesh Hassan
 

Answer:Solved: Automatically send email from Excel based on the conditions

8 more replies
Relevance 71.75%

I am working with the attached spreadsheet in Excel 2010 and am trying to figure out how to code certain parameters that will make Excel send myself, my client or other individual an email (with text in body) if certain dates have not been entered into particular cells, or if a cell has exceeded a certain number of days in a particular cell. I have attached a sample spreadsheet and have listed at the bottom 8 points in which I need an email sent, what the trigger is and what the action (email sent to) is.

I just know enough to be very dangerous with Excel but have found that there is a way to code in Excel to send emails which would greatly help my business but I just don't know that much about codes at all.

Can anyone please help me??

Thanks!!
 

Answer:Excel Coding to Send Email based on Cell Entry

Hi, welcome to the forum.

I suggest you do a find in the forum, there are many posts that gao about this and there are many answers, I'm sure there is one that will help yu and of course one of us can help you if you're still stuck
 

2 more replies
Relevance 71.75%

I am wanting to develop a spreadsheet that will keep track of bulk liquid delivery amounts by date, not an issue, and notify individuals by email when account is due for refill based on previous delivery averages. I have attached a simple sheet to show what I mean.

Formula in b7 shows cells C3:N3, but this would go farther out for we could have multiple deliveries in a given month. I do not know how to change formula to account for more variable deliveries. In other words, C3:whatever.

I would like fill schedule do the following:

look at previous fill quantities
average fills (perhaps through out one high and one low).
show next projected fill date based on averages and with a 25% safety. If account holds 200, then don't let it get below 50 before email is sent.
Cell b10 needs to look at last entry in row 2, whatever that is, to determine new refill date.
I hope this makes sense and thanks for any assistance.
 

More replies
Relevance 70.93%

Tech Support Guy System Info Utility version 1.0.0.2
OS Version: Microsoft Windows 7 Professional, Service Pack 1, 64 bit
Processor: Intel(R) Core(TM) i5 CPU M 430 @ 2.27GHz, Intel64 Family 6 Model 37 Stepping 2
Processor Count: 4
RAM: 3956 Mb
Graphics Card: ATI Mobility Radeon HD 5650, 1024 Mb
Hard Drives: C: Total - 447861 MB, Free - 189776 MB; Z: Total - 150428 MB, Free - 86495 MB;
Motherboard: Acer, Aspire 7740
Antivirus: avast! Internet Security, Updated and Enabled

Hello. in Windows live, in the inbox, the "Date" and "Sent" date is almost always the same, even if the mail was written hours or days before receipt of the message. Why does the inbox not show the date that the mail was sent from the senders machine ?? They are sometimes a few seconds differant, I presume this may be something to that happens if download takes a longer time.
Thank you
Niedernsill
 

More replies
Relevance 70.93%

As the title says, I use Microsoft Outlook '07 to access my Roadrunner and AOL POP accounts. If I send email from either account to one particular friend who uses windstream.net, and accesses his mail through Windstream's web mail page, it disappears without any trace that I can find. Not only doesn't he receive my newly composed messages, but he does not receive my direct replies either. That rules out a misspell. There is no evidence other contacts are not receiving my emails. I first thought maybe he had me blocked, however if I go to either of my two accounts' web based email pages, he receives my messages just fine.

And I always receive his emails. The only odd thing that might be a clue is that, since this began, about half of the email he sends me now, whether I view them in Outlook or on the web, is in plain format with system fonts. Sometimes they come to me in HTML.

I never get any delivery failure notification either. The last time he got one of my emails is when I sent out a July monthly newsletter to about a hundred people including him. I usually get the same few failure notifications because some of our members' addresses have changed or can't be found... the usual reasons, and I need to update my distribution list. But he got that letter in July, and that's the last time I've been able to send him anything through Outlook on either AOL or Roadrunner. But both of those ISPs always deliver mail to him if I use their respective web pages to send it. What could... Read more

Answer:Outlook can't send email to one contact, but web based mssgs work fine

Well, about a week ago it started working again, and this one fellow can receive emails I send via Outlook with my roadrunner account.

However last night I sent out a newsletter to about 225 members of my aeromodelling club, and now I can't even send email to my wife. First, it appeared in her junk folder, then not at all. This is the same time last month my problem started. Today I've had several kicked back as "Containing possible spam." The newsletter I sent out contained one PDF of about 4.5MB. It also contained lots of pictures and videos... of airplanes. Any ideas?
Thanks,
Rusty

6 more replies
Relevance 70.93%

As the title says, I use Microsoft Outlook '07 to access my Roadrunner and AOL POP accounts. If I send email from either account to one particular friend who uses windstream.net, and accesses his mail through Windstream's web mail page, it disappears without any trace that I can find. Not only doesn't he receive my newly composed messages, but he does not receive my direct replies either. That rules out a misspell. There is no evidence other contacts are not receiving my emails. I first thought maybe he had me blocked, however if I go to either of my two accounts' web based email pages, he receives my messages just fine.

And I always receive his emails. The only odd thing that might be a clue is that, since this began, about half of the email he sends me now, whether I view them in Outlook or on the web, is in plain format with system fonts. Sometimes they come to me in HTML.

I never get any delivery failure notification either. The last time he got one of my emails is when I sent out a July monthly newsletter to about a hundred people including him. I usually get the same few failure notifications because some of our members' addresses have changed or can't be found... the usual reasons, and I need to update my distribution list. But he got that letter in July, and that's the last time I've been able to send him anything through Outlook on either AOL or Roadrunner. But both of those ISPs always deliver mail to him if I use their respective web pages to send it. What could... Read more

More replies
Relevance 70.52%

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

More replies
Relevance 70.52%

I have an equipment list and I would like to be able to be prompted 1 week prior to the date that my calibrations are due without having to remember to check all the time.Can you please help me set it up so that an email alert can be sent saying that a certain piece of equipment is due for calibration within 1 week.

Answer:how to get excel to send me an email when a due date arrives

I have only minimal skills with Macros but see if this site gives you some ideas:http://www.rondebruin.nl/win/sectio...MIKEhttp://www.skeptic.com/

6 more replies
Relevance 70.52%

Hi there,

I have a workbook which i would ideally like to send an automated mail when the date is within 30 days of "Todays date" .
I have found something similaar on past posts whichprints certain cells to an email but is triggered by a button press not date, but wondered if anyone could adjust it for me as my excel knowledge is very limited.
I really am struggling.

The password for the spreadsheet is Kalibratedbyme (capital K)

Best regards and many thanks!
 

Answer:macro to allow a date to send an email in excel

The content is different but why are you duplicating a post?
 

3 more replies
Relevance 70.11%

Situation:

I have a domain, let's call it mydomain.com, and a whole bunch of domain email aliases (eg: [email protected], [email protected], etc) that all forward to my ISP pop3 email address account (default account).

I currently have rules setup so that emails sent to certain aliases at mydomain.com (which all come into my IPS email account) go to their associated folders setup in Outlook 2000, eg: [email protected] goes to the "Jim" folder, [email protected] goes to the "Mike" folder, etc, etc.

I also have a LAN email account setup in this copy of Outlook 2000 (although it's not set as my default). Emails on my LAN account use a virtual domain name to send within the network, let's call it mylanaccount.com.

Rather than have the emails go to folders on my computer, I'd rather they be forwarded on to the relevant address on our LAN, eg: emails that came in from [email protected] would be forwarded to [email protected].

Of course because mylanaccount.com is a virtual domain that doesn't exist in the big wide internet, these emails need to be forwarded on using the LAN account, not my default ISP pop3 email account.

Queries

1) Ideally, I'd like to setup a rule with something like:

Check messages when they arrive.

Sent to people or distribution list.

"Forward it to people or distribution list using the specified account"

Of course this last option does not exist. You can only ch... Read more

Answer:Outlook 2000 - automatically send email using specific account based on contact used.

1b. & 2b.: Doesn't look that way here in Outlook 2003. Have you thought about spending $7 to 9/month per person and get an Exchange Server hosting account?
 

3 more replies
Relevance 69.7%

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

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

under the format options.

5 more replies
Relevance 69.7%

Hello,

I was able to successfully apply Hans' module and have the spreadsheet send an email when it was opened if something was out of the calibration date.

My question is now if it is possible to have it send 2 weeks in advance, and then again in 1 week later. I know that because the cell will be occupied that it was initially sent, it will not read it again for another send. Is there a way to automatically clear a column so that it just sends an email every time its opened within that range?

Finally, where do I add the column for a CC email?
Code:
Option Explicit

Public Sub eMail()
Dim lRow As Integer
Dim i As Integer
Dim toDate As Date
Dim toList As String
Dim eSubject As String
Dim EBody As String
Dim ws As Worksheet
With Application
.ScreenUpdating = False
.EnableEvents = False
.DisplayAlerts = False
End With
Set ws = Sheets("Master Equipment LIST")
Sheets(1).Select
lRow = WorksheetFunction.Max(3, ws.Cells(Rows.Count, "K").End(xlUp).Row)
If ws.Cells(lRow, "K").Value = "" Then Exit Sub
For i = 2 To lRow
toDate = Replace(Cells(i, "K"), ".", "/")
Debug.Print WorksheetFunction.Days360(Date, ws.Cells(i, "K").Value)
If WorksheetFunction.Days360(Date, ws.Cells(i, "K").Value) <= 14 And Len(Trim(ws.Cells(i, "M").Value)) = 0 Then
' If Left(Cells(i, 5), 4) <> "Mail" And toDate - Date <= 30 Then
t... Read more

More replies
Relevance 69.7%

hi !
I have a spread sheet of 100 of employees , i like every time the expiry date come for there id a notification email come to me , i attach the example excel sheet please help me with that, i am just learning VBA not very good in it i am using windows 8
 

More replies
Relevance 67.24%

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

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

On Error GoTo Handle_err

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

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

... Read more

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

16 more replies
Relevance 67.24%

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

More replies
Relevance 66.42%

Hello,

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

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

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

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

Thanks

Daniel
 

Answer:Exported date field not recognized as date in Excel

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

3 more replies
Relevance 66.42%

I accidentally formatted the date cell & it only accept numbers

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

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

2 more replies
Relevance 65.6%

Hi ! This refers to the subject of "Automatic email from excel based on date", and relevant thread http://forums.techguy.org/business-applications/927675-solved-automatic-email-excel-based.html

This was fantastic. Only one issue remaining.
This is generating multiple emails and even the items not due are generating blank mails.
I would like to generate only one mail with different items different expiration dates.
After that group the identical addressees and compose one message with all the relevant data.
Awaiting kind help.
 

Answer:Need Help reg "Automatic email from excel based on date "

7 more replies
Relevance 65.6%

Good day,

I was looking for someone to help me in this:

Please see the attached excel file, which automates Groupwise mails for due date reminder. However, it generates individual mails for each due items, whereas, I want one single mail with all due dates. How do I achieve it?
 

More replies
Relevance 64.78%

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

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

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

(see attachments that show the above)

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

Does anyone have any better ideas?

Jim Shannon
JES Computer Systems
Access Developer.
 

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

7 more replies
Relevance 64.37%

I know variations of what I want to do exist but I have not had success in implementation. I am using Excel 2007 and MS Outlook.

After opening the file, I would like the macro to look at all the dates in the sheet and send an email (.Display is preferred) each time a date gets within 1 year, 6 months (180 days) and 90 days of the current date.

The headers in the columns are:
A-First Name
B-Last Name
C-email address

D, E, F, G, H, I, J-Certification 1, 2 ,3 etc. (All contain various expiration dates)

K-1 Year email sent. I've gathered from reading that another column indicating if an email was sent is a good idea and may be needed to trigger the other events.
L-180 Day Email Sent
M-90 Day email sent
 

More replies
Relevance 64.37%

Mr. Database created the macro in this spreadsheet and it works great. I need to know how to update the macro when I need to add rows or columns.
 

More replies
Relevance 64.37%

I need to return a number associated with a date based on today's date. For example: A1:A24 are numbers 1 to 24 and B1:B24 contain the 15th and 30th for each month of the year; 15-Jan, 30-Jan, 15-Feb, 28-Feb, ... 30-Dec.Cell C1 needs to return the number from A1:A24 based upon today's date compared to the date in B1:B24.For example today is 08/21/15, what number should be returned in Cell C1. It should be 15 as 08/21 is less than 30-Aug.message edited by jmichels

Answer:Return a number based on today's date compared another date.

Try this formula, see how it work for you:=INDEX(A1:B24,MATCH(TODAY(),B1:B24,1),1)This will work for most dates, but errors out if the Date is 01/14/15 or less.MIKEhttp://www.skeptic.com/message edited by mmcconaghy

4 more replies
Relevance 64.37%

Hi all,I wish to create a macro that when i click a button i can input what month i wish to print out data for. I have 7 columns (A-G).Date Day Activity Income 02/01/2012 Monday Work (8) 48.00 02/01/2012 HMOT 5.00 02/01/2012 Peter Taylor 134024855 HMOT 5.00 02/01/2012 Susan Taylor 134023422 HMOT 5.00 02/01/2012 Steve Davy 13402737404/01/2012 Wednesday Work (8) 48.00 04/01/2012 HMOT 5.00 04/01/2012 Tom Thompson 134027410 HMOT 5.00 04/01/2012 John Ackroyd 134025131 HMOT 5.00 04/01/2012 Aftab Ilahi 134022546Above is an example of the sheet.In column A we have the date, B we have the day, C we have the activity, D we have the income, E is a cell with the previous month date in to track data for the month, F is a name and G is a number.I wish to be able to print all of january for example, rows A-G by clicking a button and entering something like 'january' or '01/12'. This will then select all of the rows with data in based on the date range in column A and print the selection.Please feel free if that doesn't make sense to ask questions.Thanks in advance.

Answer:acro to input date and print based on date range

Below is the code I have for a macro which I can't seem to get to work right.Thanks.
Public Sub PrintMonth()
On Error GoTo Proc_Error

Dim wksCurr As Worksheet
Dim rngTarget As Range

Dim strInput As String
Dim datInput As Date
Dim datStart As Date
Dim datEnd As Date

strInput = InputBox("input start date for month", "Enter date")
If strInput > "" Then
datInput = CDate(strInput)
If datInput > 0 Then
Set wksCurr = ActiveSheet
Set rngTarget = wksCurr.Columns(4)
datStart = WorksheetFunction.EoMonth(datInput, -1) + 1
datEnd = WorksheetFunction.EoMonth(datInput, 0) + 1
With wksCurr
If .AutoFilterMode Then
.AutoFilterMode = False
End If
.UsedRange.AutoFilter Field:=rngTarget.Column, Criteria1:=">=" & datStart, _
Operator:=xlAnd, Criteria2:="<" & datEnd
.PrintOut
.AutoFilterMode = False
End With

Set rngTarget = Nothing
Set rngDate = Nothing
Set wksCurr = Nothing
End If
End If

Proc_Exit:

Exit Sub

Proc_Error:

Select Case Err
Case Else
MsgBox "Error " & CStr(Err) & ": " & Err.Description
Resume Proc_Exit
End Select

Exit Sub

End Sub

3 more replies
Relevance 62.32%

System: WinXP and Win98SE

I need help with a script or vbcode that will automatically backup a file or files daily. The current format (so that I can identify the date it was backed up) is: date-filename.bak (ie. 040831-filename.bak).

I would prefer the date be generated automatically, but if there is a dialog box that appears so that the user enters the date manually, that would be fine also.

This particular need is going to be used as an intermediate step to the weekly backups of the datafiles, and is not intended to take the place of the full backup procedure. But I need a step in there incase the the file becomes corrupt, and the user does not know it until several days later, they can go back one or two days, not an entire week, to use as a starting point on the data.

Any help would be greatly appreciated.
Thank you.
 

Answer:Solved: Automated date script

16 more replies
Relevance 61.91%

I have 2 tables that are linked by a zipcode field. One one table there is a kinda count field. If the zipcode field on the first table is updated, then I want the count on the second table to increase by one.How can I go about doing this? Thanks for all the help.

Additional info left out: The zipcode field on the count table has a list of zipcodes. When a zipcode is entered on the other table, I want it to match the zipcode in the count table and update the count for that zipcode. Thanks.
 

Answer:Update one field in a table based on another field in another table.

Not quite sure what you are trying to do, but is linking the zip code fields a good idea? Are you tring to find the number of times that a particular zip code is entered?
 

2 more replies
Relevance 61.91%

Hello and yes, another one of this. Although I know absolutely nothing of VBA, I've read about a dozen topics on the subject on techguy and other communities in an attempt to figure out something, a way to do it.

I found the script that was the most likely to work in my case, analyzed it, switched the references, cells and so on. I think I am getting close to something functional, alas, I fear it is as far as my knowledge and Trials & Errors goes.

I'll be forever grateful if someone can fix this for me. I'll even donate 5$ to Tech Support Guy with a mention of your glorious name

I am using Excel 2010 in English, Windows 7 and Outlook.

Attached is the fruit of all my efforts. I am looking to make a task tracker that will email me should a task approach its due date (yes I know that sheet will have to remain opened, it isn't an issue )
Many thanks and best regards,
LordAzuRa
 

More replies
Relevance 61.5%

I have a sales report that automatically updates daily. Is there a way to setup automated emails from excel to different individuals? It would save so much time and effort. Any help is appreciated!
 

Answer:How to send automated emails from Excel?

There are quite a few similar threads with sample files and more.
Check these out.
There are two I helped with, one on October 13 was asked by vasu0505 and one from June 22 placed by truec
Search for posts by these posters and you'll come across them,

With the information you have given (Excel version missing) and no data explaining it's an open guess and guessing is no option

When you open this post similar threads are displayed below so you can directly click them.
Happy hunting
 

1 more replies
Relevance 61.5%

Hello,

I'm doing this on a Windows XP machine. I know this is a strange question but here is what I need and the reason why I need it.

What I need to do: Send a completely automated email through a .cmd file.

Why I need to do it:
I have an automated macro that I have running on my work computer to put together a csv (txt formatted) file.
I then have this .cmd file execute this command: ftp -s:"C:\AutoUpload.txt"

What I want to know is, if there's a way that I can (without installing 3rd party software) send myself an email confirming that the file has been successfully uploaded.

Thanks in advance,
Dan

Answer:Send Automated E-Mail through .cmd file?

You could create a VB Script and call it. The only downside is that it contains your email password in the script. I have used the following script to send email to myself. Copy the following script into a text file, modify the red items with your info, then save it as a .vbs file.Const fromEmail = "Sender Email Address"Const password = "Email Password"Const toEmail = "Recipient Email Address"Const mailSubject = "Email Subject"Const mailBody = "Email Body"Dim emailObj, emailConfigSet emailObj = CreateObject("CDO.Message")emailObj.From = fromEmailemailObj.To = toEmailemailObj.Subject = mailSubjectemailObj.TextBody = mailBodySet emailConfig = emailObj.ConfigurationemailConfig.Fields("http://schemas.microsoft.com/cdo/configuration/smtpserver") = "SMTP Server name"emailConfig.Fields("http://schemas.microsoft.com/cdo/configuration/smtpserverport") = SMTP Port NumberemailConfig.Fields("http://schemas.microsoft.com/cdo/configuration/sendusing") = 2emailConfig.Fields("http://schemas.microsoft.com/cdo/configuration/smtpauthenticate") = 1emailConfig.Fields("http://schemas.microsoft.com/cdo/configuration/smtpusessl") = true if SSL is needed, false if it is notemailConfig.Fields("http://schemas.microsoft.com/cdo/configuration/sendusername") = fromEmailemailConfig.Fields("http://schemas.microsoft.com/cdo/... Read more

4 more replies
Relevance 61.09%

I have a spreadsheet which I track students test scores which works great with the following vlookup. "=IF(D22>0,VLOOKUP(D22,MAST,2),"")"The location MAST is a name field on another tab and I can change that as I need based on 3 different program codes.But now that I have mixed classes I want to be able to (for example) start in cell range B2:B35 type in their program codes then have the forumula look in example B2 for the program code, then using name manager go to the scores tab and locate the score.On my score tab I have 9 columns (3 for each program). First column is Program ID (ex: MAST), second column is Score (ex: 75), 3rd is percentage (ex: 75%).How can I have the foumlua look in B2 for the Program Code then go to the 2nd sheet where the scores are and return the correct value?Thanks

Answer:Vlookup w/Name field based on Program ID

Look up the INDIRECT function in the Excel help files.INDIRECT returns the reference specified by a text string. e.g. with MAST in B2, this formula would be equivalent to yours:=IF(D22>0,VLOOKUP(D22,INDIRECT(B2),2),"")

2 more replies
Relevance 61.09%

Hey guys,
I have a question about coding and setting an excel file to send emails. I am using an excel file to track maintenance work orders and I would like to get an email each day for each work order that is requested to be finished on that days date. I have attached the excel file I am using, and the column that is important is C, "Date Needed" - If that date is today's date, the cell turns red and I would also like to get email notification about it. A separate email for each cell that matches today's date.

Also, if possible, I would like for it to look at all the sheets, not just the current month's sheet. For example, if a work order was filed in July but wasn't needed until September, I would still like to get the email reminding me that it needs to be finished on xx date in September.

I have attached the excel file I want to use.

I have searched all over this forum and others and have found many posts similar to this, but I am not a great manipulator of code, so I cannot get any of the other solutions to work.

Any help would be greatly appreciated, thanks!
 

Answer:Solved: Using Excel 07 to Send Emails When Date in Column = Today's Date

16 more replies
Relevance 60.68%

Can anyone help me please?I'm trying to get excel to send an automated email from outlook when a due date comes about in certain cells Desperately seeking help on this Thanks

Answer:Automated emails when cells in excel are at specific date?

Try here:http://www.rondebruin.nl/win/sectio...should give you a starting point.MIKEhttp://www.skeptic.com/

4 more replies
Relevance 60.68%

I am trying to create a database, to keep track for stores orders for the ship i am on.
I want to auto generate the stores order number (Order Number) in the format
0730/TAK/yy/$$$
The 0730 is fixed as is the TAK. The yy is 2 digit year and the $$$ is the sequential number.
The yy field i want to take the year from the "Order Date" field in the same form.

IS this possible?
I have Access 2007 but the final database may have to run on 2003.
The database is still in early stages so is still small can be forwarded if it helps

Many Thanks
Charles
 

Answer:Sequential numbering in access based on another field

11 more replies
Relevance 60.68%

I have a spreadsheet with hundreds of records. In row "I", there is a number that is representative of an employee. I need to move the entire row based on that one field.For example, in the below, I need to move Joe Smith and his entire row to sheet 2. I need to move Jason Doe and Jane Does and their entire row to sheet 3 and so on.Name DOB MR NXTASSESS Emp#Joe Smith 12/13/1984 307353 1/30/2012 1Jason Doe 7/31/1920 196986 2/2/2012 2Jane Does 6/29/1949 480904 2/2/2012 2Jim Doesnt 4/7/1942 198878 2/3/2012 3LOST, help!

Answer:Need to move multiple rows based on one field in each row

I suggest that you try the following:1 - Create a template with 11 sheets2 - Group Sheets 2 - 11 (Select Tab 2, Shift-Click Tab 11)3 - Hide the Columns that you want hidden4 - Enter your Column Headings5 - Ungroup the sheets. (Select any sheet tab other than the current sheet)6 - Press Alt-F11 to open the VBA editor7 - Paste the following code into the pane that opens8 - Create a button in Sheet1 and assign the macro to the button9 - Save the template, Macro enabled10 - Paste your data into Sheet1 and click the button to run the macro11 - Save the resulting sheet as an xlsx sheet, unless you want the macro to be saved with every sheet. Your choice.Note: The code assumes that you have column headings in Sheet1, so it starts searching Column I in Row 2.Sub CopyRowsToSheets()
'Determine last row with data in Sheet 1
last_srcRw = Sheets(1).Range("I" & Rows.Count).End(xlUp).Row
'Loop through Sheet 1 rows, starting in Row 2
For srcRw = 2 To last_srcRw
'Calculate destination sheet by adding 1 to value in Column I
dstSht = Sheets(1).Range("I" & srcRw) + 1
'Determine the next empty Row in destination sheet
next_dstRw = Sheets(dstSht).Range("I" & Rows.Count).End(xlUp).Row + 1
'Copy the row to the dstination sheet.
Range("I" & srcRw).EntireRow.Copy _
Destination:=Sheets(dstSht).Range("A" & next_dstRw)
Next
End SubClick Here Before Posting Data or VBA Code ---> How To Post Data or Code.

15 more replies
Relevance 60.68%

I have a field that contains say "Mel Gibson", what I need to do is pull Mel out and pull Gibson out and put into two new fields. I cannot for the life of me remember how to do this as it has been at least seven years since did this. Any help would be most appreciated. Thank you!
 

Answer:Two words in a field - extract based on space

8 more replies
Relevance 60.68%

Hi

I hope this is an "easy" answer.

We use an Access database to track class registrations for recreation programs.

Each program has a limit on class size.
How can I set a limit in Access so that when that number is reached, it displays a message....

I'd like to be able to continue to add records if it's decided that the class size can be adjusted, I really just want the message to appear.

I have a course table which has the course name, course code, start date, end date, and cost

I have a registration table in which all the registrants info is entered and the course is selected from the course table.

Thanks for any help with this.

Bobbi

 

Answer:Access 2K-Limit records based on a field

I would do a record count and see if it is equal to or less than the class limit. It is was, then I would do a messagebox or pop up window to give a message. you could to the message box with a yes or no. yes would add it, no would do nothing. the easiest is the message box. just look up msgbox in access help or give some more information on what you are doing.
 

2 more replies
Relevance 60.68%

So far i have read you can't do this. So i'm wondering how you achieve this the correct way. I work for a gas field company and the database i am redesigning has a lot of fields that need validation, like well site names, company names etc. The person who built the original database had no validation at all, and you could find the word Production spelled 12 different way sometimes. Made it very hard to keep data readable.

So the part im working on now is the well sites list. I have a table called Well Sites. I have a main work orders table where they must choose a well site which is a lookup of the well sites table. This is fine and dandy, however. If they choose not to use a name in the drop down list, they can simply type anything they want, which is what i want to avoid. I want them to ONLY be able to type names that exist in the well sites table.

I was hoping it would be as easy as setting up a validation rule but from what google is telling me that is not even possible. So how do i control what user's enter. I do NOT want to type in a list of 600 well site names using OR for a validation rule. That is unmanagable, but i need to restrict what they can type so we don't get mis-spellings and mis-labeled wells.

Now i understand some things but some things i've just never done before prior to now. If i setup a one to many relationship between two tables then it seems to work like i want. Only values that exist in the other table can be entered into... Read more

Answer:Field Validation based on another tables data

6 more replies
Relevance 60.68%

Hi,
I have a form that populates fields from lookup box. There are multiple records for one member and not all records for that members has data from table.

e.g.
memb1 has three records in table
first record has membname, category=2YO, Type is null
second record has membname, category=Pren, Type is AB

I need to show the type on the form but when selecting the memb1 but if type is null and type is AB - null shows but I need to see type AB.

I have an unbound textbox on form and populate with cboSearch.column(1)
This is in the unbound textbox: =forms!frmB!cboSearch.Column(1)

any suggestions on how I can show type ?

thanks,
 

More replies
Relevance 59.86%

Hi Everyone,I have an Excel sheet with records arranged in rows. The records represent activities, baseball, football, dance, swimming, etc. One of the columns (fields) contains an "activity description", another an activity name. I need to assign a category based on that information. The categories are things like Cultural Arts, Educational, Aquatics, Baseball, Football, Soccer, etc.Is there an Excel macro or some other tool or function that will search one column (or 2) then assign a value to another column (the category)? Does anyone have some other way to accomplish this? I need to end up with a .CSV file?Thanks in advance for your help !PS: Solution can be Windows based (Excel) but I also have a box with Ubuntu on it.

Answer:Search a field and assign a label based on results

A solution can probably be offered, but I'm not sure exactly sure what you are trying to accomplish. In order to have an Excel function or macro assign a category to each activity, it has to pull the information from some place. It has to know what category to assign, so that has to be entered someplace first.How would a function or macro save any time if you have to first set up a table that matches every activity to a category?Perhaps some more example data would help. Before posting example data, please click on the following line and read the instructions found via that link.Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

14 more replies
Relevance 59.86%

How does one create a mail merge document that will print only certain paragraphs or sentences based on data in each record? For example, a mail merge document where you wanted the first paragraph to be one thing if [fieldx] is "yes" and something else entirely if [fieldx] is "no"?
 

Answer:Word: Mailmerge Letter Contents Based on Field Value

Check here, Don:

http://www.mvps.org/word/FAQs/MailMerge/MMergeIfFields.htm
 

3 more replies
Relevance 59.86%

Here's a sample
Name/Order

Record 1 - John Smith #23 - want 1
Record 2 -John Smith #29 - want 2
Record 3 -John Smith #27 - want 3
Record 4 -Fred Jones #24 - want 1
Record 5 -Fred Jones #25 - want 2

So what I want is for each row of data to place a count #. So for record 1 it would have 1, record 2 would be 2, records 3 would be 3, record 4 would be 1 and record 5 would be 2.

I need a count of records for each name. I do not want a subtotal. I need it to actually list out 1,2,3, 1,2.

I can do this in Crystal reports - but I really need this is Access.
Ideas?
 

More replies
Relevance 59.86%

I have a form designed to track processing times for various activities. This information is entered from a Production Log that the employee completes throughout the day. The main form has the following fields: Name, ArrivalTime, DepartTime, ProductionDate. After the user enters data into these fields, the cursor moves to the subform where the activity id is entered, the start and end times for that activity, the beginning & ending sequence number, and several other fields.

Since some activities don't require entry into all fields, I would like to disable certain fields based on the value entered into the activity id field. I have 4 activity ID's that I want to trigger the disable event on 3 other fields in the subform. I need to know how to code this, where to code it, and then to check in the form's BeforeUpdate event that the above is correct.

Thank you for your help!
 

Answer:Solved: Disable Fields on Subform Based on Value of Another Field

10 more replies
Relevance 59.86%

Dear Guys,

I am trying to get MS Access to print labels with names on them times the number in another field (i.e., Joe Smith is the name in the "name" field and a field called "Tags" has the number of car tags he is alotted, let's say 4. I need the database to print his name on 4 labels.)
I don't write code! Is there any way to do this, even in code.
Please e-mail a response to [email protected]

Thank you.

Liz

 

Answer:Access: Print Label Quantity Based on Value in a Field

Make a query in which you join the table with the person's name to the table with the tags. I assume there's a common field between the two, or how could you count? Join the tables by drawing a line between the fields with your mouse in the query design window.

Add the fields you want to show up on your labels. Base the report on that query. Access will print one label for each instance of the name in the tags table, i.e. 4 labels for 4 tags.

Hope this helps.
 

1 more replies
Relevance 59.86%

This seems like it would be a common task in Access but I can't find any reference to it.

I have a combo box with three choices, Kamazaoo, Grand Rapids, and Traverse City. The field name is location. The location is entered only once but there is no limit to the amount of records that can be added. When one record is finished Access defaults to the previous location and starts a new record.

I know how to do a make table query but can I do a make table query based on the fields value? For instance if the entry person is finished entering data for Kalamazoo a button could be pushed that would make a Kalamazoo table.

------------------
Building the Ultimate site list for PC support.
 

Answer:Make table based on form field in Access

16 more replies
Relevance 59.04%

I'm building a database for a social service organization to track their rental/utilities assistance program, in which they track pledges clients receive from local churches and other organizations. Part of the year, they also have a program called Gift of Warmth to help with utilities. If clients are eligible for GOW, then GOW matches the amount of pledges they receive from the churches. So basically, I have a form with the controls:
[GOW] which is a yes/no checkbox
[Total Amount Needed]
[Total Client Payments] (calculated field from an underlying query)
[Total Other Funding](calculated field from an underlying query)
[Total Pledges Received](calculated field from an underlying query)
[GOW Amount](the field I need to work with)
[Amount Still Needed]{=[Total Amount Needed]-([Total Client Payments]+[Total Other Funding]+[Total Pledges Received]+[GOW Amount])}

So basically, if [GOW]=no then the field [GOW amount] needs to be set to zero, but if [GOW]=yes, then [GOW Amount]=[Total Pledges Received]

I really hope someone can help me with this. Other than this problem, the database is coming along nicely, and I want to be able to start testing it in real use soon, as they are using a shared excel workbook to track this now and are have tons of problems with it. They can't really afford to hire a professional database designer to do it, so i volunteered (or was volunteered, anyway).

Thanks so much,

Amanda
 

Answer:MS Access - Changing content of a calculated field based on value of checkbox-Help!

aaldridge said:



I'm building a database for a social service organization to track their rental/utilities assistance program, in which they track pledges clients receive from local churches and other organizations. Part of the year, they also have a program called Gift of Warmth to help with utilities. If clients are eligible for GOW, then GOW matches the amount of pledges they receive from the churches. So basically, I have a form with the controls:
[GOW] which is a yes/no checkbox
[Total Amount Needed]
[Total Client Payments] (calculated field from an underlying query)
[Total Other Funding](calculated field from an underlying query)
[Total Pledges Received](calculated field from an underlying query)
[GOW Amount](the field I need to work with)
[Amount Still Needed]{=[Total Amount Needed]-([Total Client Payments]+[Total Other Funding]+[Total Pledges Received]+[GOW Amount])}

So basically, if [GOW]=no then the field [GOW amount] needs to be set to zero, but if [GOW]=yes, then [GOW Amount]=[Total Pledges Received]

I really hope someone can help me with this. Other than this problem, the database is coming along nicely, and I want to be able to start testing it in real use soon, as they are using a shared excel workbook to track this now and are have tons of problems with it. They can't really afford to hire a professional database designer to do it, so i volunteered (or was volunteered, anyway).

Thanks so much,

AmandaClick to expan... Read more

6 more replies
Relevance 59.04%

Hi,
I am having data structure as below. I need some macro or some means to populate formula in Column D based on column C (as and when it changes) . All other column data are populated. This is beyond me. Any help or direction is greatly appreciated. Thanks in advance

Col | A | B | C | D | E
------------------------------------------------------------------------
Row | 1 | Test1 | | | 10
| 2 | Test2 | =A1 | =MAX(E2) }| 15
| 3 | Test3 | =A2 | =MAX(E3) | 20
| 4 | Test3 | =A1&","&A3| =MAX (E1,E3)| 30
 

Answer:Excel macro or formula - change field based on other cell

7 more replies
Relevance 59.04%

I have a table that has service information which is categorised as ServiceType, ServiceDescription, ServiceCode, etc. The are up to 200 unique ServiceDescription/ServiceCode enrties per ServiceType.

I am trying to create table for orders that will only allow ServiceType from a listbox. I then need service description to be listed as a listbox based on the selection made from service type. I then need the ServiceCode to show based on previous 2 selections.

--EG--

ServiceType ServiceDescription ServiceCode
Cleaning Clean Dwelling 001
Skips Empty Skip 002
Skips Replace Skip 003
Skips Remove Skip 004
Scaffold Erect New 005

So if I select Scaffold from drop down, it only shows Erect New in drop down for description and once that is selected, 005 is autofilled for Code
 

Answer:Solved: Access - Lookup Based On Previous Field Result?

This is fairly easy to achieve. The easiest is with the queries supplying your 2nd & 3rd Combos.
Asuming that your ServiceDescription Table contains the ServiceType ID
and the ServiceCode Table contains the ServiceDescription ID.
Create a query for your ServiceDescription including the ServiceType ID.
Create a query for your ServiceCode including the ServiceDescription ID.
In the first combo Afterupdate event procedure requery the 2nd Combo.
In the 2nd combo Afterupdate event procedure requery the 3rd Combo.
The key to make it work is to enter in to the 2nd combo's query's Criteria row for the
ServiceType ID - forms![fromname]![combo().column(1)]
where the second column of the 1st combo is the ServiceType ID.
Repeat this for the 3rd combo and the ServiceDescription ID.
 

2 more replies
Relevance 59.04%

Did not find answer when I searched.I have Windows XP Home Edition, SP2, and IE6, SP2.When I go to a web site and click on File, Send page by email or Send link by email, I get the message box entitled Enter Network Password, asking for user name and password.   How can I get it to go right to the Hot Mail message box so I can send?   In Tools, Internet Options, Programs, the Email section shows Hot Mail, so it should go right to Hot Mail.If I change the Internet Options, Programs, Email section to Yahoo Mail, instead of going to my Yahoo mail, I get a message box with the title Microsoft Exchange Setup Wizard, but it should take me to my Yahoo Mail.Anyone know how I can fix these two to work right?   Thanks much.Anna Ruth

Answer:File, send page by email, send link by email

Since you are using web client based e-mail it won't do this automatically...Copy and paste the links into Hotmail and it should work fine...

1 more replies
Relevance 58.63%

I work with MS Access 2003.

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

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

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

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

#31/12/[Contract Year]#

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

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

Thank you very much in advance for your help.
 

More replies
Relevance 58.63%

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

Answer:field modified date

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

1 more replies
Relevance 58.63%

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

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

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

Answer:Updating date field

6 more replies
Relevance 58.63%
Question: Update date field

Thanks in advance for your help!

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

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

Thanks again!
 

Answer:Update date field

6 more replies
Relevance 58.63%

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

More replies
Relevance 58.63%

System is infected. AVG detected those stated.
Keep getting it although I've finished scanning and healing those infected files with AVG.

I've attached a log of Hijackthis.

Logfile of Trend Micro HijackThis v2.0.2
Scan saved at 12:37:21 AM, on 4/9/2008
Platform: Windows XP SP2 (WinNT 5.01.2600)
MSIE: Internet Explorer v6.00 SP2 (6.00.2900.2180)
Boot mode: Normal

Running processes:
C:\WINDOWS\System32\smss.exe
C:\WINDOWS\system32\winlogon.exe
C:\WINDOWS\system32\services.exe
C:\WINDOWS\system32\lsass.exe
C:\WINDOWS\system32\svchost.exe
C:\WINDOWS\System32\svchost.exe
C:\Program Files\Ahead\InCD\InCDsrv.exe
C:\WINDOWS\system32\spoolsv.exe
D:\Program Files\Grisoft\AVG Anti-Spyware 7.5\guard.exe
D:\PROGRA~1\Grisoft\AVG7\avgamsvr.exe
D:\PROGRA~1\Grisoft\AVG7\avgupsvc.exe
D:\PROGRA~1\Grisoft\AVG7\avgemc.exe
D:\Program Files\IVT Corporation\BlueSoleil\BTNtService.exe
D:\Program Files\CA\eTrust EZ Armor\eTrust EZ Antivirus\ISafe.exe
C:\WINDOWS\system32\HPZipm12.exe
C:\WINDOWS\System32\svchost.exe
C:\WINDOWS\Explorer.EXE
D:\Program Files\CA\eTrust EZ Armor\eTrust EZ Antivirus\VetMsg.exe
C:\WINDOWS\System32\spool\DRIVERS\W32X86\3\E_S4I3T1.EXE
D:\Program Files\CA\eTrust EZ Armor\eTrust EZ Antivirus\CAVTray.exe
D:\Program Files\CA\eTrust EZ Armor\eTrust EZ Antivirus\CAVRID.exe
C:\WINDOWS\system32\rundll32.exe
D:\PROGRA~1\Grisoft\AVG7\avgcc.exe
C:\WINDOWS\system32\ctfmon.exe
D:\Program Files\IVT Corporation\BlueSoleil\BlueSoleil.exe
C:\Program Files... Read more

Answer:nncu6k & Trojan.PWS.Onlinegames detected. MSN automated-send links to contact.

And a log of Deckard's SS.

Deckard's System Scanner v20071014.68
Run by AdiBzZz on 2008-04-09 00:40:02
Computer is in Normal Mode.
--------------------------------------------------------------------------------

-- System Restore --------------------------------------------------------------

Successfully created a Deckard's System Scanner Restore Point.


-- Last 5 Restore Point(s) --
40: 2008-04-08 16:40:25 UTC - RP327 - Deckard's System Scanner Restore Point
39: 2008-04-08 08:01:45 UTC - RP326 - System Checkpoint
38: 2008-04-06 15:05:13 UTC - RP325 - System Checkpoint
37: 2008-04-05 13:01:04 UTC - RP324 - System Checkpoint
36: 2008-03-31 08:50:32 UTC - RP323 - System Checkpoint


-- First Restore Point --
1: 2008-01-27 05:47:49 UTC - RP288 - System Checkpoint


Backed up registry hives.
Performed disk cleanup.



-- HijackThis (run as AdiBzZz.exe) ---------------------------------------------

Logfile of Trend Micro HijackThis v2.0.2
Scan saved at 12:43:44 AM, on 4/9/2008
Platform: Windows XP SP2 (WinNT 5.01.2600)
MSIE: Internet Explorer v6.00 SP2 (6.00.2900.2180)
Boot mode: Normal

Running processes:
C:\WINDOWS\System32\smss.exe
C:\WINDOWS\system32\winlogon.exe
C:\WINDOWS\system32\services.exe
C:\WINDOWS\system32\lsass.exe
C:\WINDOWS\system32\svchost.exe
C:\WINDOWS\System32\svchost.exe
C:\Program Files\Ahead\InCD\InCDsrv.exe
C:\WINDOWS\system32\spoolsv.exe
D:\Program Files\Grisoft\AVG Anti-Spyware 7.5\guard.exe
D:\PROGRA~1... Read more

16 more replies
Relevance 58.63%

Hey there, long time reader first time poster!

(If you know of a great advanced tutorial on Access, please let me know. I know how to set up the basics, now I'd like to know how the program really runs)

I'm currently working on a form that allows users to search for equipment. The category of the equipment is slectable through a combo box, and the searched text is entered in a text field. The results are displayed in a list box.

What've I've tried is using a 'Find' button to enter this sql query into the RowSource of the list box:

Private Sub Equipment_Find_Click()

Me.Equipment_List.RowSource = "SELECT Equipment.Type, Equipment.Manufacturer, Equipment.Model FROM Equipment WHERE (((Equipment." & strQuote & Me.Equipment_Search_Category.Column(0) & strQuote & ")=" & strQuote & Me.Equipment_Find_Text & strQuote & "))ORDER BY Equipment.Type DESC;"

End Sub

The result i get is a pop up window with a text field. If i re-enter the text in that feild the info pops up nicely. What am I doing wrong, and how do i get rid of that popup?
 

Answer:Access 2003: Search criteria based on combo box and text field

12 more replies
Relevance 58.22%

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

Answer:MS Word merge field for date

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

2 more replies
Relevance 58.22%

Hi guys,

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

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

Thanks.

Answer:Blank Date Modified Field ?

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

3 more replies
Relevance 58.22%

Can someone help please?

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

Thanks in anticipation.

Moll )
 

Answer:Excel query on Date field

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

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

1 more replies
Relevance 58.22%

Hello everyone,

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

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

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

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

Any ideas?

Thanks.
 

Answer:MS Access - autofill date field

6 more replies
Relevance 58.22%

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

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

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


 

Answer:Concatenating Date and Time Field in SQL

Just wanted to add some more examples:

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

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

1 more replies
Relevance 58.22%

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

Answer:date modification field does not change

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

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

9 more replies
Relevance 57.81%

Good afternoon all!

I am working on writing a Security Incident Report program, and I am running into a problem. I have a Date/Time field, which I am attempting to auto-update from another Date/Time field, based on the result of a Yes/No field input. Is this even possible? To be specific, the user enters the date of the report. On the next form page, it asks the user if the report date is the same as the incident date. If the user answers Yes, I would like it to enter the data from the report date field and grey out the option to enter the new date. If the report date is different from the incident date, the user would then be required to enter the date of the incident. This takes place three different times on the same form, based on the incident date, date responders cleared from the incident, and the date the incident was placed under control. I am running Access 2007. Thank you!
 

Answer:Creating Access 2007 Auto-populate field based on different table Yes/No data

GrahamTechnology, welcome to the Forum.
Yes it is using VBA.
 

3 more replies
Relevance 57.81%

I have a table with a field called "current fund balance" which is intended to be a data entry field. I have a query with multiple calculated fields. Both the table and query share a common field. I'd like to have a datasheet form to where data from the query and table are combined and have that field "current fund balance" be a data entry field. I'm having the hardest time figuring this out.

I've read a form/subform would work but I need to be able to see all the records at once. And so, datasheet with all fields would be best. Anyone have any thoughts?
 

Answer:Solved: Having a form field in Access to enter data based on a query with calculated

16 more replies
Relevance 57.4%

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

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

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

14 more replies
Relevance 57.4%

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

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

Answer:MS Access Concatenate a date and text field

Jerry-

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

19 more replies
Relevance 57.4%

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

Answer:Solved: Stop Updating the Date Field

6 more replies
Relevance 57.4%

Greetings

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

Here is my problem:

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

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

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

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

Thanks

Reuel Miller

The Ex-NT moderator on this board

Every morning is the dawn of a new error
 

Answer:SQL Query help required with date/time field

Greetings

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

the statements I used were:

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

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

Reuel Miller
 

1 more replies
Relevance 57.4%

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

More replies
Relevance 57.4%

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

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

thanks in advance
 

Answer:Solved: excel length of date field

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

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

exit celll with ctrl, shift, enter
 

1 more replies
Relevance 57.4%

How do you insert a date field in Word 2007?

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

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

2 more replies
Relevance 57.4%

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

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

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

Thanks!
 

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

16 more replies