Adding A Simple Text Clock To A Form
Trying to make a simple clock inside my form.
So far I got my clock but it isn't running.
It only get's the time when I open the form but I want it to keep track of time.
Searched the forums but couldn't find anything that relates to this problem.
View Complete Forum Thread with Replies
Related Forum Messages:
Time Clock / Punch Clock App
Has anyone created a time clock Access application? I'm referring to a app that will allow the user to sign-in at the beginning of the day then sign-out for lunch, sign back in then sign out at close of business. Then be able to total the number of hours at work. I've searched the forum and see others have asked the question in the distant past, but have found no answers. What I'm 'hoping' for is that someone has a sample app they are willing to share so others can see how to set this up. Thanks in advance for any help or suggestions. rickyT
View Replies !
Time Management - Simple Time Clock
Hi all, I havent' been around in a while (toddler, work, getting my BS degree and new baby coming in a week and a half) so I am hopefully not asking a previously posted question. I'm suspecting my new work isn't accurately paying for the hours worked. I made a quick simple DB where I input my punch times in short time format. There's the typical In, Out for Lunch, In from Lunch, and Out. I've got it correctly adding the times so that it reports the total hours worked per day, though, in order for it to display correctly, that total is in short time as well. The problem is, when I group a week together, as soon as the sum of the totals reaches 24 or more, it goes back to 0, as it's on the idea that there's only 24 hours in a day. Hopefully, it's just a formatting issue or is there a function to convert the times (or just the sum) to number of hours? Thanks and Happy New Year to all. -Jim
View Replies !
Adding Data To Table From Form Text Box
Hey, im developing a taxi service database and i am working on adding new customers to the customers table through a form using text boxes. Im wondering if its possible to have text boxes as inputs and once all the data is entered (first name, last name etc) have a button to simply click and have all the data transferred to the table. Im also trying to do this without having all other records shown as well. I've included a screen and the db to show you what i mean: http://shieldfilez.fasthost.tv/images/screen.jpg
View Replies !
Simple T-SQL Problem Adding A 0 With A Field
Hello, I am having a small problem inserting a 0 in a text field that contains a date. I work with large amounts of data derived from other systems and I have to format them to meet the requirements to be feed into others. I need a query that will only insert a 0 to the single digit day within a date where a text field date looks like say 01/2/1998 and I need it to look like 01/02/1998. Thanks in advance for any help!!!:
View Replies !
Adding Instruction Text In Text Box?
I've looked around and check the help file, I'm sure I'm probably not looking for right thing here. What I want to do is include text in the text box that would appear prior to the user typing in their text. So say I have my text box and in it appears <Type E-mail message body here>. Then when the user clicked in the box to type out their message my instruction message would either disappear or the user could erase it. I know this is something simple, I just don't know what I'm looking for here. Sorry for the trouble.
View Replies !
Simple Text Box Question
Yow, I know nothing about Access - ive forgotten so much. Basically i want a text box in a form (that the user cannot edit) that will refer to a value in my table. My table looks like: Magtable Magazine | MagName | Amount 1 ---------|----bla----|*want to display this field in txtbox1 2 ---------|---great---| *and this in txt box2 etc 3 4(autonum) Thanks in advance! Acs
View Replies !
Want Cursor To Appear In Certain Text Box(simple Question But Cant Figure Out)
I have a form. On the form is a pull down box. When the user clicks a submit button on the form, it displays a message box if the name field is not filled out. I want to make it so that after the user clicks 'ok' on the message box, the cursor goes to the name text box so it makes it easier for the user to input his/her name. I would appreciate if some one could help me on this matter. Thank you.
View Replies !
Realtime Clock
I've got 5 time zones showing on the main screen of my db, just by doing date() and subtracting number of hours for each time zone. Only problem is need a refresh button on it for people to click. Can you get a realtime clock ticking away on an access form?
View Replies !
Sync With Computer Clock
Hi, My question is...is there any way to get Access to work out the actual day of the week from a date entered into the computer? The reason for this is...I am designing and implimenting a bookings data base for a village hall, and I wish access to automatically store what day of the week it will be on the specified date, in a field called 'Day'. I need this field to produce a report for the week ahead, showing exactly what is in on which day of the week. Is there any way this can be done? Or do the days just have to be typed in manually, i.e. check a calendar and type them in? I would appreciate it if anyone could give me info...on ANY way this can be implimented...be it store the dates in a table or use a giant Iif statement or whatever! And the tags necessary would be helpful, Thank-you for your help in advance, and i apologise for such a lengthy post! Please get in touch directly through c.majury@ntlworld.com or alternatively post the answer here. Chris
View Replies !
Employee Punch Clock
The company I work for has a central office and out employees work at different locations around the city. I have setup a database so that reports and requests made by employees are put into the database and sent to our office and clients office, instead of the tri copy forms we have been using. One thing that we were interested in doing was setting up a punch clock in the database so when employees come and go they punch in and out and there is a report that can be printed weekly or biweekly. Unfortunately I have no idea how to start making that feature, I would appreciate any help or advice on what direction to go...
View Replies !
Adding Text Into A Textbox
Hi Is the following possible? I have the code to add the text to a textbox, but what I would like to do is rather than to keep adding the text onto the end. Make it so that it will add it before what I previously added, so that the newer data is always at the top. Can I do this? The following is how I'm currently entering the data into the textbox: If IsNull(Me.LastContact) Then Me.LastContact = Me.List35.Value & " contacted " & Me.List38.Value & " by " & Me.cmboEngagement & " on " & Date & vbCrLf & _ txtInput.Value Else If Not IsNull(Me.LastContact) Then Me.LastContact = Me.LastContact & vbCrLf & Me.txtInput.Value End If End If Thanks
View Replies !
Text Box, Adding But No Editing
I have a text box that I only want people to add new data to. I would like them to be able to view previously entered data but not able to edit it. I've tried to lock the data but then I can't add new data. Any suggestions appreciated, Joe
View Replies !
Adding Text Box Values In Report -
Am I missing something simple here? I have several text boxes, which I want to add the values. I have tried these formulae, but dont work: =Sum([Postage],[ProgTotal]) =Sum([Postage] + [ProgTotal]) =DSum([Postage],[ProgTotal]) Any help would be greatly appreciated!
View Replies !
Adding Standard Text To A Record
I have two tables: T_Action and T_Mailing T_Mailing has only 1 field Filenumber T_Action has 4 fields: Filenumber , Date of action, Action and Person I want to add to T_Action a record with the same text: Date of action=29/03/2006, Action="Mailing send 2006" and to Person="SH" (my initials) Only to the records that are similar with T_Mailing. Seems simple but i cant manage to do it. Some help would great!
View Replies !
Adding Date And Time To Text
Hi Apologies first if there is an easy answer to this post as I'm new to Access. I have a notes box on a form that users update with the latest progress of work done. At the end of each progress I would like Access to automatically add the date, time and user's network id so that I can track who did what and when. Is there an easy way to code this?
View Replies !
Import Text File Plus Adding A Field
Hi, I'm importing the contents of lots of text files using a combination of a loop and DoCmd.TransferText. This works fine and I can get the contents of several hundred files in a few seconds. The files are called 1.dbb, 2.dbb... and each has an associated image file, 1.bmp, 2.bmp... etc. After the import I move the files to a new folder. I need to create a link to the bmp file but this information is not included in the text file so I need to rely on a field which contains the file name. How can I populate a field at import time to include the name of the imported file? Anyone give me a clue please. Regards, Bernard D
View Replies !
Adding A Auto Increment Text/Number
I have a daabase that I am importing via excel. I want the entries to be numbered ex: MT0001 MT0002 etc.... I would like it to promt the user for the last number(or next number in sequence) entered, then fill in the blank records with the next increment number. The prefix will also change to so eventually the user would enter into the prompt RD0001. then autofill the 140 imported records with RD0002, rd0003... etc.... I can't really make seperate fields because the MT0001 number will become a barcode and putting them seperate causes many issues. can this be done? Any help would be great I am still a beginner but slowly learning! Thanks!
View Replies !
|
TRACKER
