Creating A Timer Event That Checks System Time?
I need a query run that brings up a list of customers that need maintence after 6 months after their last maintence service. As soon as you open the DB, the event/query runs and if there are any customers past due to display them. And if there are none, to not even show the query at all.
I have very little experience with timers and if/then statements and don't know how to set this up.
Any help would be greatly appreciated. Thanks in advance.
View Complete Forum Thread with Replies
Related Forum Messages:
Timer Event
I'm looking for a code that close my databse when a user is unactive for a set time. I've search the forums but nothing workked for me Is there someone who already have a code for this or maybe can help me? thanks in advance
View Replies !
Simple (?) Timer Event Problem
I created a form to list the number of customers in my lobby. In the Form Footer I placed a field to count the number of customers waiting (Name: CC1, Control Source: =Count([LName]). Works fine. I want a Beep on the form if the customers exeed 5. I placed the following code in the Timer event but I cannot get the event to work. I believe it has something to do with the field name but I'm unsure. Any help would be appreciated. Private Sub Form_Timer() Requery If [CC1] >= 5 Then Beep Else End If End Sub
View Replies !
Skip On Timer Event Cycle
My form is always open and runs a timer event which runs a series of functions and procedures. I don't want to run a certain procedure on every timer cycle, but rather, every other timer cycle. Any thoughts on how best to accomplish this. I'm having a mental block! Scott
View Replies !
Creating A Follow-Up System In A Text Box
Does anyone know how to go about this or know previous thread stating how to go about this?I have a Follow-Up labeled Text Box (Short Date) and I want for the associate to be able to set a desired follow-up date and for the account to disappear from the list afterwards till the follow-up date expires and it becomes viewable again.Any suggestions?
View Replies !
Creating A Register System/table
Ok, firstly im sorry if this is in the wrong forum. I say this because my problem first begins with the tables but then i need to sort a problem out with the form aswell, but i will put it in here. Here is the problem. Im sorry if im not too clear with this. I need to create a register system E.G. A child comes into a club, he is registered. At the end of the session the child leaves the club. His depature is registered and his departure time is also recorded down. Like a paper based school register but electronically. How would I go about implementing this into a system? Would I need a child table (with fields such as Child ID, Forename, Surname etc.) and a register table (not sure on the fields)? k, this bit below probably goes in the forms section... How would I get this to work on a form so there were boxes to check for arrival and departure, and when a button is clicked the depature time is filled in for each day of the term?
View Replies !
Help With Time Tracking System
I have a time tracking system where users can clock in and clock out. I want to have an error message when they clock in and then accidently clock in again. Therefore, they can only clock out after they have clocked in. The data goes into the table called "Timeclock Table". The fields in that table are SSN, Clock-In, Clock-Out, and TimeStamp. The clock in and clock out are check boxes. can you guys help me?????? Im just a beginner.
View Replies !
Help With Time Tracking System
I have a time tracking system where users can clock in and clock out. I want to have an error message when they clock in and then accidently clock in again. Therefore, they can only clock out after they have clocked in. The data goes into the table called "Timeclock Table". The fields in that table are SSN, Clock-In, Clock-Out, and TimeStamp. The clock in and clock out are check boxes. can you guys help me?????? Im just a beginner.
View Replies !
System Date And Time
Hello, I have a form that displays the system date and time for every entry. When the data gets stored in the table, the date and time do not get stored. How can i save the date and time with all the other information. Also, everyday when i open the form, it shows me all the data from the previous day but the date for all that data has changed to taday. I want that everyday when i open the form, it should be blank and all data from the previous day must be stored in the table along with the date and time. Hope someone can help me with this Thanks
View Replies !
Time Tracking System
I have a time tracking system where users can clock in and clock out. I want to have an error message when they clock in and then accidently clock in again. Therefore, they can only clock out after they have clocked in. The data goes into the table called "Timeclock Table". The fields in that table are SSN, Clock-In, Clock-Out, and TimeStamp. the clock in and clock out are check boxes. can you guys help me??????
View Replies !
Rnd Based Off System Time/date
Hey all, I'm trying to find a solution to a problem. Is there any way using VBA to generate a random number, based off the current system date and time? The theory is that a random number seeded by the system date/time will be truly unique and the possiblity of it ever occuring again will be nearly nil. Or is there a better way to create unique ID's (such as member ID's, or something similiar) based off the system date/time that can be used as a primary key in a relational db.
View Replies !
Employee Time Card System
I need to develope a system that will allow for employees to login and imput their "time card". I found one post on here about something similar, but it didn't give much info. I am very very new to Access so please give info in simple terms or very well explained. I am hoping that I can have a login and password so employees can't access eachothers time card. All it will need to track is Date Type of work Hours Rate Comments I am hoping that this is going to be an easy task, but I need some help. Anyone have any ideas or directions... or even better know where I could just download a template. Thanks, Chrissy
View Replies !
Creating A Report That Conforms To ASCII Format Of Another Data Collection System
I have a need to convert the export of an Access report to an ASCII file. The export needs to have a specific format - described below: Field Position | Field Length | Field Name | Field format 1-6 | 6 | Member # | text - right justified 7-12 | 6 | Trans Date | YYMMDD 13-15 | 3 | Pay code | Alpha/ NUM - Left 16-26 | 11 | Amount | -9999999.99 (*) 64-71 | 8 | Check # | Right general comments and questions: This report needs to interface with some sort of transaction accounting system - No Idea what it is, but this format of the report will interface. The field positions go from 1 to 73. I need only supply the data above, so the check # is way out of sequence. Do I need to have the space inbetween "Amount" and Check Number in the report? Will a simple text file work with all the fieds together? or will I need the space in there? Is there a way to design a report in an ASCII format in access? Specific Questions I think I need to change the format of the amount and date fields. I am currently using the short date format 8/30/04, but need to return the date as YYMMDD - 040830. How can I change this format to reflect the ASCII format. The form is also set with the default "=Date()" so the user doesn't have to enter the date everytime - it can also be edited for older data. I would like the date to appear the way it is on the form 08/30/04 but get entered to the table as 040830. Is there a way to do that? The amount field is odd - I'll include the exact criteria that is desired: "All Amount Fields must be right justified and space filled. If the amount is a credit, show the "-" sign at the beginning of the number. Payment should be entered as positive amounts. If zero, assign the fied as 0.00 (space filled)" Is this just a mask that needs to be added? Currently, The field shows $7.00 when 7 is entered to add cent, you must type in 7.50, tab will put in the "$". I need to get rid of the $ and space fill the field? Any help would be great
View Replies !
Time & Billing - Project Management System Upgrades
We'll it's been out for a while so now I'm gonna give people who use it or would like to use it the chance to have there say as to what goes into the next version.If you've got any idears for something that you think should be included with "I've Got Time To Bill Ya Now" nows your chance to have your say.Main Topic http://www.access-programmers.co.uk/forums/showthread.php?t=121117
View Replies !
Calulate Time On A Button Event
Hello All, I am using a timer function to hopefully calulate have long a call has lasted, I have setup a rolling clock called "ElapsedTime" and i have the start time running off the P.C. Time this is called "txt_Start", this works fine no issues. Now comes the fun bit i have a button called "cmd_Finish", i wish the time to be calulated and the total time to be placed in a text box called "txt_Finish" sound easy but nope this would apear not to be. The Following Setup is used:- ElapsedTime = "00:00:00" txt_Start = Time(), formated to LongTime txt_Finish = Formated to Long Time Example of what i would like to happen txt_Start = 10:40:02 ElapsedTime = 00:00:11 txt_Finish = 10:40:13 I have tried the following Code: ********************************************* Private Sub Command5_Click() Me.txt_Finish = ([ElapsedTime] + [txt_Start]) End Sub ********************************************* Can anybody help me on this please. Alastair :eek: UPDATE *****************************RESOLVED THANKS TO ALASTAIR69 (ME) & Allan57********************
View Replies !
Disable Button - Time Event?
Hello All, I was wondering if there is a way to disable a command button after it has been clicked for a small period of time. (lets say 1 second) stopping the user from any happy clicking. (fast repetitive clicks) This is to do with viewing embedded images, i can explain more if required. Thanks, Aaron
View Replies !
Finding A Minimum Time For A Swimming Event
I am trying to produce a database that will select a swimmers, best time for each event, and will select the overall best time done by any swimmer in the events. At the moment I am having some trouble with my queries. When trying to get the query to select a swimmers best time for the events, It will work when selecting min for the time field and including the following fields: Forename Surname Stroke Distance Age group Gender However I also wish to include the name of the swimming pool the time was done at and the date at which it was achieved. My problem is that when I add these fields into the query, it looks for the swimmers minimum time in the event, on the date, and at the venue and consequently comes up with all the times the swimmer has done, rather than just the best ones. I would Really appreciated if anyone had any suggestions as to how I can get over this problem Thanks in advance Jennifer
View Replies !
Added Current Time On Click Event
I have two fields in my form contained Start time and End time. Currently, Both fields using default Time$() on form. However, End time always wrong because until we get our job done, It took atleast 20 or 30 minutes more than current default time. My question is, is there any way I can setup the End time to just click on it, and a new current default time populated? Thanks in advance..
View Replies !
Creating Time Field
I have a form that has two text fields "Time From" and "Time To". I can get the current time to show up with either =Date() or = Time(). Althought when I use Date() the time shows up correctly in the field until I click on the field to edit it and then it shows the Date instead of the time until I tab out o the field. But I want the user to be able to pick another time without having to type it in. Kind of like a list box but with a scroll that with either increase or decrease the time. Also I am trying to get the "Time To" field to be 30 minute higher than the "Time From" I have tried different things like DateAdd("n", 30, [TimeFrom]) and although it does add 30 minutes when I click in the field it shows the Date and time (3/6/2006 12:30:00 AM) and not just the Medium Time (12:30 AM) even though I have the Conrol and the table field formated to Medium Time. I'm at a loss.
View Replies !
Comparing A Date/Time Field To System Date
Hi, I am trying to compare a value in my databse produced by the date() function, short date format, to one that is exactly 24 hours after the value recorded by the date() function. If the value in the database is 24 hours prior to the current date(), I need to flag a text box a diffrent color to alert the user. I am unsure on the If statement that I will need to produce this result. Any help would be greatly appreciated!!!! Thanks Mikeco555
View Replies !
Validation Checks
hi can anyone tell me all the different types of data checks that can be used in database tables such as field length check and range check thank you
View Replies !
Presence Checks???
i have a combo box which basically gives you the option of yes and no.... then if the yes is selected, you choose a time from another combo box i want to be able to write an IIf statement which basically hides the second combo box unless the first one has the value 'yes' Can anyone help me please???
View Replies !
Creating Time Series For Portfolio Values
Dear All, once again I need your help, I have no idea how to tackle the following problem. I am taking records of stock market transactions. As a final result I want to have a query which gives me for every end of the day the total value of my portfolio. Therefore I have two tables. The first one, called tblTransactions with columns - among others - Date, Ticker, Quantity, Price does contain my transactions. The second one, called tblQuotes with columns Date, Ticker, LastPrice contains prices for each security traded for every day. The following SQL code gives me the portfolio holdings with the respective LastPrices on an arbitrarily chosen date (03/09/07): SELECT T.Ticker, sum(T.Qty) AS TotQty, Q.qCl AS [Last Price], (T.Qty*Q.qCl) AS [SubTotalValue] FROM tblTransactions AS T INNER JOIN tblQuotes AS Q ON T.Ticker=Q.qTicker WHERE T.Date<=#3/9/2007# And Q.qDate=#3/9/2007# GROUP BY T.Ticker, Q.qCl, (T.Qty*Q.qCl) HAVING sum(T.Qty) >0 ORDER BY T.Ticker; This works so far. However, now I struggle with the next step. I want to have a query, which for each date (I could use the date column of tblQuotes) adds all SubTotalValues, i.e. gives me the total value of my portfolio for each day. Could you give me please some hints on how to proceed from here? I would be very pleased if somebody could help me with that question. Best regards JapanFreak
View Replies !
Unchecking All Checks In A Table
I want to uncheck a check box field for all records in a table. I want to do this with a push of a button which will implement a function or sub or query that clears only that field. I?d like to know: a) How will this hit performance? There will be approximately 150 records (max) that will be effected. Is this something that will slow the system to a crawl? If it takes a minute or so for these records to be altered, I can live with that. b) How can this be implemented? Say a user hits the button to clear them, how does it get implemented? For instance, a select statement that grabs all the records that have -1 (a ?check?) in that field and then do an update statement for each one that changes it to a 0 (unchecked). Any suggestions? Thanks, scratch
View Replies !
Validation Checks On New Records
I have a table of animals each with a unique ear mark. I also have a table of vaccination records. When adding new records to the vaccination table via a form i would like a validation check on weather the animal actually appears in the animal table or not with an appropriate error message. Please help. Many thanks.
View Replies !
Creating Admin Function To Validate Time And Task
Hi all, was wondering if there was a simple way out there, or if someone could give me some ideas on how to use an admin function to either approve or deny a users time and tasks... this wouldnt neccesarily have to a be a daily function... but i would like to have this done before the end of a pay period(2 weeks). i feel like this could be as simple as using a check box to show approval, but i wouldnt know how to have the users submission go into a place where the admin could view to approve or deny.. has anyone seen something like this done before? thanks in advance
View Replies !
|
TRACKER
