Kind Of Countdown Reminder In A Date Column
Jun 29, 2007
hey,
Sorry to open with a question but its usually the way, i'm quite an experienced computer user but never used any office products before and just thought i should learn as i'm losing money every week by not keep track of things properly.
So then to my question..
I've made a table to cover all the orders i have had placed, this includes a date column for when that order was placed. I just wondered if it would be possible to have some kind of system where after 7 days without any acknowledgement from me it either pops up or turns red or something similiar. I'm thinking the acknowledgement could be the yes/no box and i tick that when i recieve the item back, if i dont it either pops up or turns red or something :confused:
any help much appreciated
View Replies
ADVERTISEMENT
Sep 21, 2005
This is my problem!!! Bit new to Access, so here goes! I am setting up a claibration database for test equipment, what i need to do is to set up the database so that say a week before a calibration date is due, the database will flag this up, say display a reminder!! Can anyone tell me is this possible and the best way to set this up????
Thanks.
View 1 Replies
View Related
Mar 14, 2006
I want to create a field for displaying a 90 day period date before the time of renewal.
This date will be displayed to remind me to send out a notice to a client and will be based on the actual renewal date field.
Can anyone please provide some insight into creating such a field.
Also, I will be creating a similar data field that will be based on 30 Days after the 90 day notice that I send out.
Thank you in advance...
Steve.
View 3 Replies
View Related
Apr 22, 2014
How I would accomplish the following scenario in Access 2010. I have created a data base for a funeral home. One of my tables includes the date of death of the individual (DOD) (i.e. 04/16/2014). From that date I want to trigger a reminder to follow up with a family letter 6 months from that date. Would I do this with a macro or would I do this with VBA Script?
View 7 Replies
View Related
Jul 15, 2015
I have a table called schedule maintenance.
In that table I have a "date" field
Is it possible that if " todays" date = a date in the field date a e-mail can be sent to me to remind me there is a scheduled maintenance to be done.
View 6 Replies
View Related
Oct 12, 2014
I want to make an application that reminder Radio Broadcaster to read ads based on airing hour.
I have a question , how to make reminder pop up based on selected hour or time and date of that advertisement.
View 3 Replies
View Related
Jul 26, 2015
I have a form (Access 2010) in which i insert contracts; each contract has a start and an expiry date, but instead of dd/mm/yyyy i would like the user to be able to insert just the year, while the day and month are predefined values and they are automatically inserted (i.e. 01/10/yyyy; the year being the only value that changes, and it is manually inserted by the user).
I would like to set a pop up remainder (on form load) x days before the expiry date, but, because too many of them have the same expiry date i am wondering if the reminder can be set on different days, based on another field (i.e. partner location [country]).. i.e. reminder for contracts with Austria to pop up 60 days before expiring, for UK = 67 days and so on.. or even a specific day for each, i.e. for Austria = 01/08/yyyy, for UK 01/09/yyyy).
View 2 Replies
View Related
Feb 4, 2006
I am creating a databse to help people with course registration. I have a form (Classes) and a sub form (Classes Subform). In the classes subform I have the following fields:
StudentID
Major
PhoneNumber
Grade
On the Classes form I have two fields I am concerened about. Seats and a field called Open Seats. If I set the number of Seats (Seats) to 31, I would like 31 to appear in my open seats field. As I add students to the Classes Subform (New Records) I would like open seats to decrease by one. I've seen this done, but have no idea how.
Once this is figured out, Is it possible for the form to automatically change my Status field from Open to Closed?
View 1 Replies
View Related
Jul 28, 2006
Is there a way to have this stopwatch to countdown from 10 minutes to 00:00:00:00?
Option Compare Database
Option Explicit
Dim TotalElapsedMilliSec As Long
Dim StartTickCount As Long
Private Declare Function GetTickCount Lib "kernel32" () As Long
Private Sub Form_Timer()
Dim Hours As String
Dim Minutes As String
Dim Seconds As String
Dim MilliSec As String
Dim Msg As String
Dim ElapsedMilliSec As Long
ElapsedMilliSec = (GetTickCount() - StartTickCount) + _
TotalElapsedMilliSec
Hours = Format((ElapsedMilliSec 3600000), "00")
Minutes = Format((ElapsedMilliSec 60000) Mod 60, "00")
Seconds = Format((ElapsedMilliSec 1000) Mod 60, "00")
MilliSec = Format((ElapsedMilliSec Mod 1000) 10, "00")
Me!ElapsedTime = Hours & ":" & Minutes & ":" & Seconds & ":" _
& MilliSec
End Sub
Private Sub btnStartStop_Click()
If Me.TimerInterval = 0 Then
StartTickCount = GetTickCount()
Me.TimerInterval = 15
Me!btnStartStop.Caption = "Stop"
Me!btnReset.Enabled = False
Else
TotalElapsedMilliSec = TotalElapsedMilliSec + _
(GetTickCount() - StartTickCount)
Me.TimerInterval = 0
Me!btnStartStop.Caption = "Start"
Me!btnReset.Enabled = True
End If
End Sub
Private Sub btnReset_Click()
TotalElapsedMilliSec = 0
Me!ElapsedTime = "00:00:00:00"
End Sub
View 1 Replies
View Related
Aug 23, 2005
I would like to have a form that simply has 4 or 5 due dates for certain things. I would also like to have a countdown field that takes todays date and all of the due dates and tells me how many days i have until then. Is this possible? And, if so, can anyone help?
View 1 Replies
View Related
Feb 7, 2005
i wonna count down for 20 minits and then autoclose my program. every time there is an activity the counter has to reset. any idea where and how to do it?
thx in advance
killroy
View 3 Replies
View Related
Oct 13, 2004
I have two databases; a server and a client. The server houses all of the tables, while the client has the tables linked and serves primarily as a form for users to enter data to the main table. Periodically I update the form, so I would like to be able to shut down each client while I upload the new files to update the client. Here is my thinking:
I have a table in server.mdb called admin with 3 columns and one record.
The fields are:
closex (text) - This will be populated when I want to send the close countdown command.
message (text) - The string I want to display in a warning popup box.
Timer (integer) - The time in seconds before the program will close.
Right now I have a hidden LIST box in the form (closemsg) that is bound to column 1 and column count=3.
Me.closemsg.column(0) is closex
Me.closemsg.column(1) is message
Me.closemsg.column(2) is timer
The box is requeryed every 2 seconds to check and see if the table has been updated along with another line of code that keeps the time current until someone starts to enter a record.
I have a macro that will perform the close operation. Here is the code I have thus far....any help would be greatly appreciated.
___________________________________________
Private Sub Form_Timer()
'Updates the Time to Current
If (IsNull(Agent)) Then
Me!Call_Time = Time()
End If
'Checks for updated values in Admin Table
Me.closemsg.Requery
' -------------
'| Force Close |
' -------------
'Message Variable from T.Admin
Dim message As String
'Timer Variable from T.Admin
Dim timer As Integer
'Macro Variable to Close App
Dim macroname As String
macroname = "Closeapp"
'Check to see if T.Admin has changed
If (IsNull(Me.closemsg.Column(0))) Then
Else
message = Me.closemsg.Column(1)
timer = Me.closemsg.Column(2)
'Set Timer
timer = timer * 1000
'Notify User
MsgBox message
Count:
timer = timer - 1
If timer > 0 Then
GoTo Count
Else
DoCmd.RunMacro macroname
End If
End If
End Sub
View 5 Replies
View Related
Jan 12, 2008
After designing the database that mean after creating all the tables and when pressed on relations buttuon it shows a diagram with relations established. Is this a kind of ERD. in this it shows relations between entities so can we call that an ERD?
View 3 Replies
View Related
Jun 20, 2006
Hi,
Im very new to sql so please excuse my ignorance, I ve been trying to do this for a while and not getting anywhere:
I have a table that has customer and product data in it. Its super market data.
I have a field that has customer education level (education), this holds text, (bachelors degree, graduate degree, high school degree, partial college, partial high school)
and a field low_fat which is boolean (0 or -1), wether the product purchased was low fat or not.
Im interested in the realtionship between education level and number of low_fat products purchased.
I'd like a resultset that counts the number of low_fat products purchased for each category of degree level. Something that looks like this
EDUCATION Low_fat_Count
bachelors degree 500
graduate degree 234
high school degree 124
partial college 333
partial high school 124
Is this possible?
So far I've come up with this:
SELECT education, COUNT(*)
FROM AllTablesMerged
WHERE low_fat=-1
GROUP BY education;
but access asks me for specify parameters for education and low_fat.
Thanks in advance for any help on this!
View 2 Replies
View Related
Aug 28, 2006
Can anyone give me a direction for the following problem please :
I would like to create a yearcalendar that might do the following job for me:
I have 12 firms with different amounts of people working for them. We need to see those people once a year and give every firm an amount of days that they can come see us. Every firm may send 5 people each day but we can see up to two firms per day. So we receive 10 people on a daily base but only a max of 5 belonging to one firm.
I would like to have a means of automaticaly according dates to those firms over a period of one year but I must be able to exclude or instance, week-ends, holidays and so on...
I hope you can give me a start because I realy don't know where to begin
View 1 Replies
View Related
Aug 13, 2007
Hello all,
I need help with making a query this will check the OrdQty for all items in a specific order against the Sup1inv field, then if supplier 1 can not fill the order have it check against Sup2inv field.
Here is an example of the data im working with
Order# Item# OrdQty Sup1Inv Sup2inv
555 widget1 2 1 3
555 widget2 1 1 4
556 widget3 1 3 0
557 widget1 7 1 3
The part i am having trouble with is making sure the query "understands" that both items on order 555 are the same order so the end result would tell me that order 555 needs to be placed at supplier 2, not 1.
Thanks in advance for the help,
Eddie
View 6 Replies
View Related
Jun 14, 2005
There are total three tables tblInternal, tblExternal, tblCourses. Table
tblInternal and tblCourses is one to many relationship by reference foreign
key InternalID from tblCourses to tblInternal. If I just use these two table
to set up Master form and subform in ACCESS, you can in subform Field Linker
window of subform property Data tab select primary and foreign key to
generate link between Master and subform. So if you select user name from
tblInternal in Master form ComboBox, you can see the detailed information the
user relates to.
Same relation between tblExternal and tblCourses.
Now I want to merger tblInternal, tblExternal to list user name in ComboBox
by Union statement. But in SubForm Field Linked window I just see one primary
key from one of these two tables instead of two primary keys from each table.
How to solve this issue?
View 1 Replies
View Related
Jul 31, 2012
I have created a countdown counter on a form using different Datediff's so to split the renaining time into days, hours, minutes and seconds.
The Datediff compares Now() to a text box called txt.Leaving which has a date/time unputted via a table (Format: General Date)
However the seconds and minutes work ok but the hours and days dont count down inline with the minutes and seconds reducing. The hours do alter when the minutes are 13 mins into the new hour. This would seem to point possibly to rounding off but I would expect that further into the hour.
Below is the Datediff that is set as the control source in a text box and the form it sits on has its timer set to 1000 and the event requeries the text box.
=DateDiff("d",Now(),[txt.Leaving]) & "d, " & DateDiff("h",Now(),[txt.Leaving]) Mod 24 & "h, " & DateDiff("n",Now(),[txt.Leaving]) Mod 60 & "m, " & DateDiff("s",Now(),[txt.Leaving]) Mod 60 & "s"
Using Access 2000.
View 2 Replies
View Related
Oct 11, 2005
Hi there,
I have built a Access solution for a music school, It was installed on 3 machines.
I'd like to protect my database from installing onto another machine without my permission.
I did install database as a mde file so they cannot see my codes. However, if they copy the database to another machine (esp. another machine in different school) they can use my software without my permission. How can I prevent this? If they copy the mde file into unauthorized machine, database should work as a demo version (such as limiting the number of records in tables to 10). How can I do this? What should I check, hd id, mainboard serial or what? Is there any ready solution (at least modifiable) for that kind of problem?
regards
View 14 Replies
View Related
Nov 29, 2007
(see sig for details on what I'm capable of before you toss code at me ;P )
Here's my current setup:
Table1(Assignments)
Instructor <related to Instructor table, pulls data from there)
Academic Year
Fallcourse# (where # = 1, 2, 3, 4), (course pulled from Courses table)
Fallcourse#comp
Fallcourse#notes
Wintercourse#
Wintercourse#comp
Wintercourse#notes
Springcourse#
Springcourse#comp
Springcourse#notes
Table2(Courses)
Coursename (unique)
Coursetype (required, elective)
Courselevel (ugrad, grad, MAS)
Table3(Instructors)
lastname
firstname
empID
rank
The purpose of the database is to assign courses to various professors and append supplementary compensation and, if necessary, notes to each course assignment. Each professor can be assigned up to 4 courses (or something to take the place of a course) per quarter.
My problem. I have created a quite a few reports with this setup including an academic year schedule, compensation reports for the year, sabatical / course release listings, etc. I am having trouble with what I am hoping to be my final report.
Requirements for the final report:
List of all courses for an academic year (filter by year)
group by level (easy)
group by type (easy)
append instructor's name to the end
Report/Relationship Problem:
I can't seem to set the relationship to allow more than one field's data into the report. I can only show courses from the [Fallcourse1] because I can't relate multiple fields from the "Assisgnments" table to one field in the "Courses" table. Effectively, that's what I want to do, but my mind's burnt and can't seem to figure it out.
Maybe you guys could help me out? Suggestions, questions - all welcomed.
View 6 Replies
View Related
Aug 27, 2014
I have access db sending report with outlook every Monday.
But the problem is if outlook is open when I start the db, email goes in to outgoing folder and msg box of outlook opens saying " outlook will close after countdown if I do not hit the "DO NOT EXIT" button or "EXIT AND SEND LATER" button.
If I hit "EXIT AND SEND LATER" button, it sends next time I open the outlook.
Is it possible to prevent outlook doing this?
View 14 Replies
View Related
Jun 2, 2015
I am creating a repayment schedule (as a report) and I want to display a series of fields as a column which return (show) a date one month after the date in the field above.
The first repayment date field (Line 1) will show a date one month after the loan was paid out. the Next field below will show the date one month later.
I can't simply insert the "Date + 30" because that would get out of since over the year. If the loan was issued on say the 15th of January, I need the first field to display 15th February and the next would be .... 15th March.... Yes - You've got it!
Now I could do that in Excel, but I don't know how to get Access to do it.
View 4 Replies
View Related
Mar 6, 2007
hi all.
there's a new db im making and i'd like to add in a 'follow up reminder' feature where; after 1 month of job completion (as updated by a auto update date field) we can give a 1 month follow up call with the customer just to say 'hey, just wanted to make sure your stuff is working' or so to speak. the reminder must say something to the likes of '1 month follow up required for customer vin deisel acct # 5777'... in other words the popup box gotta have the option to capture data from the db as well!
about 2 or 3 guys in here (total access noobs-myself included) are the ones making the db and we'd like some assistance here.
*hopes i posted this in the right forum!*
View 3 Replies
View Related
Oct 5, 2004
hi!
I'm doing a reminder program this program alerts you if you have things to do each day it has a code that I obtained on the internet wich retrieves the user name. My problem is that when I enter as a user a window shows up say my username and the number of things I have to do but I can't get it to count the number of things to do. I tried a query but it doesn't work (either it shows "#name" or it goes all blank)please help.
thanks in advance, newbiepr
View 4 Replies
View Related
Dec 28, 2005
I have created an email message to be sent via a closing button on a form, using the DoCmd.SendObject command. It all works fine except that MS Outlook then puts a message box on the screen with a countdown bar saying that MS Access is trying to access Outlook and to press Yes if this is to be allowed.
Is there any way that I can disable this message box please. I appreciate that this is more an Outlook problem than an Access one, but some database programmer has probably come across the same problem before.
Many thanks
Roger,
Newcastle, UK
View 3 Replies
View Related
Dec 3, 2012
how to terminate reminders.i have made borrowing system and it will have date taken and date return..for now, my pop up reminder will pop up in a week before the date return.
my problem right now is if the user return the cd early than the actual date return, the reminder will still pop up. it is because, i have no function to check out the cd..how to make the check out and also can disable the reminder if i click the check out for that borrowing.
View 4 Replies
View Related
