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 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 !
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 !
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 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 !
Need Help With Subform Sync
Hello, I am really stuck - I have a form of companies with a subform of contacts. In the DB (SQL) the tables are related one to many CoKey to ContactCoKey. How do I synch these so any new contact record automatically gets a "new" ContactKey as well as the related ContactCoKey? Thanks,
View Replies !
Cant Get Pop-up To Sync With Sub-form?
Hi Gang, I am using Access 2000. I have a Main form that displays a sub-form. On the sub-form is a image box that displays a jpeg associated with the current record. The jpegs are stored outside of the db as links and the links are stored in a table in a field called Image1Lrg_Path. Due to the GUI design the image box is a set size = 4cms X 5cms. On the sub-form I have a cmd button that when clicked should open a seperate pop-up form that *should* display a large version of what ever jpeg is being displayed on the sub-form. The user would then have to close this pop-up to return to the db in order to continue scrolling through the records as normal. Main Form = frmPlant_Main Sub-Form = frmPlant_Sub1 Sub-Form Control = Garden_Sub Image Box = Image1 pop-up form = frmLargeImage1 pop-up Image Box = Image1Lrg Here's my problem: If I set the pop-up form up a normal form and have a linked control on it (to display the image) and a text box (in which to type in the image path and name) and a cmd button that, when clicked, sets the image box to the value of the text box. Then this all works great, what ever jpeg file name I type in the text box, providing it exists of course, is displayed when I click the command button. Iset it up this way first as a test to see if I could get the image displayed OK. Just for reference, here is the code I use for the command button; -------------------------Code Start--------------------------- Private Sub Command1_Click() On Error GoTo Err_Command1_Click Me!Image1Lrg.Picture = Me!Image1Lrg_Path.Value Exit_Command1_Click: Exit Sub Err_Command1_Click: MsgBox Err.Description Resume Exit_Command1_Click End Sub ----------------------Code End-------------------------------- Now, if I try to link the pop-up to the image being displayed in the sub-form Access throws up "Can't find the form" errors.Just while I set this up, I am using the cmb button to set the path but in the final db I will want the pop-up form to select what ever jpeg is being displayed on the sub-form as its path. Can any one suggest how I can get this to work? Again, for reference, here is the code that I am trying to use when linking the image in the pop-up with that shown on the sub-form; -------------------------Code Start--------------------------- Private Sub Command1_Click() On Error GoTo Err_Command1_Click Me!Image1Lrg.Picture = Forms![frmPlant_Main]![Garden_Sub].Form![Image1_Path].Value Exit_Command1_Click: Exit Sub Err_Command1_Click: MsgBox Err.Description Resume Exit_Command1_Click End Sub ----------------------Code End-------------------------------- My grateful thanks in advance, Kenny
View Replies !
How To Sync Up Fields Within Databases
I have written a VB.net application that uses an Access database. I have a table that displays the following information. Customer Name Customer Phone Customer Address Shipping status Now in my vb.net application I am displaying these 4 things in a data grid. But here is the problem. The shipping team updates their database daily with the new Shipping status. So to get the latest shipping status I created a linked table, lets call is link_shipping. Now All I have to do is somehow get the shipping status field from link_shipping and update the respective table in my database with this info. To do this I created a query. but now I am having to manually go into my database and run this query to make sure the shipping dates sync up. How can I do this in a better way. The only thing I can think of is to find some way to automate the running of this query every day. But I dont know how to do this. Can anyone suggest anything here.
View Replies !
How Do You Sync An Unmanaged Replica?
I need the same database as managed and unmanaged in repl manager, I think. My replica set got scrwd up and now I need to re add an unmanaged replica. Previously the map displayed a scheduled synchronization line to the replica not managed by synchronizer. I can add the unmanaged replica, but how do I add the synchronization line? Do I need the same replica added to the map 2x? 1 managed and the other unmanaged? i tried uploading 2 bmp files to show the way it was and is now but i dont see them, how do u add bmps to post?
View Replies !
Sync Two Forms To One Table
Does anyone have any idea how to sync two forms so that I can create one record in a table from the pair of them. I have a form which is so big that I have had to place a continuation to a new form on it. However, when I move to the new form, the data is placed into a new record instead of continuing on from where it left off. Someone please help Regards Jason
View Replies !
Record Selector Sync
I have a table with fields ID, NAME, ITEM, QUANTITY and DATE_IN. I have a query "qry_Logged_In" based on the table. I then have a form based on the query. I created a combo box as a "go to record" selector and used the following Row Source: SELECT DISTINCTROW qry_Logged_In.ID, qry_Logged_In.NAME, qry_Logged_In.ITEM, qry_Logged_In.QUANTITY, qry_Logged_In.DATE_IN FROM qry_Logged_In ORDER BY [ID]; On the After Update proceudre I have the following code: Sub Combo135_AfterUpdate() ' Find the record that matches the control. Me.RecordsetClone.FindFirst "[ID] = " & Me![Combo135] Me.Bookmark = Me.RecordsetClone.Bookmark End Sub It works fine, but one thing I would like is that as I toggle through records using the record selector (forward/backward) buttons, I would like for the record number in my combo box to also change keeping in sync with the record number. Unfortunately, it currently stays to the number I last selected in the combo box. Any suggestions on how to make the record number showing in my combo box to change with the record number? Thanks, Jim
View Replies !
Sync Tabbed Form
I have a Tabbed form where one of the tabs shows about 20 rows of a table. Another tab shows a single record from that table with all the fields for that record. I want to be able to move from tab to tab and and stay on the same record (hopefully that's clear). What is the cleanest approach... any suggestions? Thanks
View Replies !
How To Sync Up Fields Within Databases
I have written a VB.net application that uses an Access database. I have a table that displays the following information. Customer Name Customer Phone Customer Address Shipping status Now in my vb.net application I am displaying these 4 things in a data grid. But here is the problem. The shipping team updates their database daily with the new Shipping status. So to get the latest shipping status I created a linked table, lets call is link_shipping. Now All I have to do is somehow get the shipping status field from link_shipping and update the respective table in my database with this info. To do this I created a query. but now I am having to manually go into my database and run this query to make sure the shipping dates sync up. How can I do this in a better way. The only thing I can think of is to find some way to automate the running of this query every day. But I dont know how to do this. Can anyone suggest anything here.
View Replies !
Sync CheckBox To Update/Write To Text Field
Hey Guys, I'm looking to create a "Same As Billing Address" check box that would automatically udpate the address in an order to reflect the customer's billing address. I understand how to sync a combo box to an option group ( -- great article by the way) I Guess what I'm looking to do is: 1. Sync a "Same As" Checkbox to multiple text boxes in the form (Unit, StreetAddress, City, Province, Postal) such that these fields are UPDATED (writen to) with the same information as the billing address 2. [U]IF the "Same As" Option is selected, I need the updated fields to lock, allowing no further update... but must by unlocked if the "Same As" option is NOT selected. Please help me out with this one guys.. I really need it.
View Replies !
|
TRACKER
