Add Live Time Clock Using Activex, Just Calindar In MS Access
Since you can add Calindar in access using activex so that I can select any date and pass that on to a field in a form, is there any way you can add a clock using activex so that I can select any time that I want to put in to a field? any suggestion? Thanks.
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 !
Live Information In Access
Hello, Right guys, new to access but have experience with MySQL. Basically, i have one table with a few fields, ID, Customername, Rating, Customer_email, Comments, Removalcompany. I created a query to get all of the ratings from that table, and average them. What i want to do now is put that average into a table and to have it only showing in one record. I have achieved this, but i would like to have it so that the number for the average rating is live. This is to be used as a backend for a website. Any suggestions?
View Replies !
Installer For MS ACCESS With ActiveX
Hi. Your help is highly appreciated. I recieved an aready made ACCESS 2003 application that I need to distribute (build installer). 1. This app uses ActiveX controls. Is there a way to get a list of all the ActiveX controls that the app uses? 2. How can I install ActiveX components to the client? Thanks a lot Roy
View Replies !
Track/log Changes To Live Data
I have created a database that I am happy with, and I am about to receive information to populate it with. I know I am about to be asked to about security and logging of changes made to the data, which I know nothing about!! As a result before I get into this part of my project I would like to know myself what is and what is not possible!! Currently I have 2 tables and 3 forms, one of which is a sub form........ All changes will be done via the forms, adding new records, editing existing records or even deleting obsolete records. •Is it possible to record any changes made to the live data? oFor this to happen I presume that I need to setup users and access rights? •What type of information can be saved if any? oWhat form would this be saved in and where (a temp table?)? While typing this a change of plan – if it is possible I am going to start building it regardless, as it will enhance my database. Thanks
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 !
Storing Live Data? (Stock Control Help)
Hi guys,I'm new to Access except using it years back but much has changed from the 2000 version to the 2007 version - it's slowly coming back to me though, as it's mostly just an interface change. Although I'm highly experienced in SQL (mySQL) and database design / structure from being a Web Programmer.I'm wanting to store a stock amount for products. Using 3 tables, for products, orders and sales. Here's a real basic layout:productsprodID | productName | productStockordersorderID | supplier | prodID | quantityBoughtsalessaleID | customer | prodID | quantitySoldThe products table is just a list of the products. Sales is where I log what I sell to customers and the orders are what I buy from my suppliers.What I'm wishing to do is use the products table to store the stock of that item so as soon as I make a sale, that quantity for that prodID is subtracted instantly from the productStock and when I make an order it's instantly added.Is this possible, or is there a good way to do this?All help appreciated! :)Thanks,Nick.
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 !
Calculating The Total Time Of All Recorded Time (MS Access 2000 And 2003)
Hello, Here I am having a little bit confusion about how to calculate the total time of steps of a process (for example: registering a new user for a website) in MS Access: - step1: entering a user name in a text box will take 00:00:10,94 - step2: entering a user password in a text box will take 00:00:03,12 - step3: entering a user confirmation password will take 00:01:30,16 - step4: entering a user email address in a text box will take 00:00:07,79 so, the total time of each step will be 00:00:52,01 the idea is that I have two fields in a table named "Total Time". the first field i named it "Process Type", where I type each step of a process as I mentioned above. And the second field I named it as "Timing", where I type the time manually for each step. in a form, there will be a control source "text box" that will calculate or sum all time that are in the "Timing" field which are listed manually by me. I need a solution of it, because it is my first time to deal with this concept????
View Replies !
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 Replies !
Time In Access: Keeping "medium Time" Format
I've run into a bug, I think. I have a time field with it set to show "Medium Time" which is "hh:mm(AM/PM)", however, when I combine the information with another field in a query (=[OfficeDay]&" - "&[POfficeTime]), the time comes out as "Long Time" or "hh:mm:ss(AM/PM)". End result is Wednesday - 10:30:00AM when it should be Wednesday - 10:30AMDoes anyone know a way around this?
View Replies !
Time Format - Short Time Displayed As Medium Time
I have an application with a backend db on PC 1, and the same application on PC 2 linked to the backend db on PC 1 via the network. The link works fine but the time formats are different. On PC 1 the time format is shortime and displays as it should i.e. in 24 hour clock format However on PC 2, opening the same database via the network, the time format is still shorttime but when you read the time within the code it comes out in AM/PM format. Also, when the defaul tiem should be #20:00:00# but this changes to #8:00:00 PM# Weirdly though, when you just open the table, the times are in the correct shorttime format. Guessing, it must be a setting within the main core of Access 2003 that is different between the 2 instances? Any ideas? This screen shot may help:
View Replies !
Time Format - Short Time Displayed As Medium Time
I have an application with a backend db on PC 1, and the same application on PC 2 linked to the backend db on PC 1 via the network. The link works fine but the time formats are different. On PC 1 the time format is shortime and displays as it should i.e. in 24 hour clock format However on PC 2, opening the same database via the network, the time format is still short time but the format is in AM/PM or medium time. Guessing, it must be a setting within the main core of Access 2003 that is different between the 2 instances? Any ideas?
View Replies !
ActiveX
I have a subform with loads of command buttoms on it but if I try and select any of them I get the message "The OnClick you entered as the property setting produced the following error: A problem occured while BCF data collection tool was communicating with the OLE server or ActiveX control". I don't understand what this means and just wondered if anyone could point me in the right direction for resolving the issue.
View Replies !
"live" Form
i want to have a form which, after a job number is entered show a single bar graph of the time taken for that job (DLookUp ed from a query / Table). For example, if the total time is two hours and the job takes one hour, half the bar would be coloured in. i can do it by opening another form once the job number is entered but I'd rather like the form to be "live" - once the job is entered the colouring in of the bar happens AfterUpdate. I don't feel as though I've explained this very well. I hope someone can help. Steve
View Replies !
Choice... ActiveX Or DLL
If you had a choice of using either an ActiveX or a DLL object in an application that is used on various systems, what would you choose? This is going on a .MDE project and my main concern is stability or compatibility. I am more interested in general practices of what you would use (either an ActiveX or a DLL object) to add functionality to your Access application. If we had to go into something specific... then lets just generalize it into 2 catagories: 1) General added functionality. 2) Security I would like to hear pros and cons about both. Thanks.
View Replies !
|
TRACKER
