Sync With Computer Clock

Jan 18, 2006

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


ADVERTISEMENT

Realtime Clock

Sep 5, 2005

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 1 Replies View Related

Analoge Clock

Jun 12, 2006

can you get an analoge clock on a form?

if so, how??

View 1 Replies View Related

Time Clock App In Access

Jun 6, 2005

Has anyone ever made a time clock application in Access? If so, can you post a sample application? I'm really at a loss with this one..

Thanks,
Cran56

View 4 Replies View Related

Anolog Clock Needed

Sep 10, 2004

Do you happen to know if I can get my hands on an anolog style clock to put on my form in Access?

Thanks in advance - John

View 1 Replies View Related

Employee Punch Clock

Jun 13, 2007

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 1 Replies View Related

Creating Employee Clock In / Out Application

Mar 4, 2012

I'm trying to create a database whereby employees within a business can select their name, or scan the barcode on their ID badges, to clock in and out of work.

View 2 Replies View Related

Table Design For A Clock Card System

Jan 8, 2005

i'm try to create a database to record staff sign in and out times and to get reports but i cannot for the life of me get it working after many many efforts. can any one help me?

View 2 Replies View Related

Adding A Simple Text Clock To A Form

Apr 19, 2005

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 9 Replies View Related

General :: Create Time Clock Button?

Aug 20, 2012

I want to create a toggle button (On/Off), that can show time clock on button. Click to start time, click again to stop time.

View 4 Replies View Related

Add Windows Widget Like Clock To Access Form

Mar 16, 2014

Can we add windows gadgets like clock and calender to access form?

View 6 Replies View Related

Need Help With Subform Sync

Feb 23, 2005

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 1 Replies View Related

Cant Get Pop-up To Sync With Sub-form?

May 31, 2005

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 2 Replies View Related

Add Live Time Clock Using Activex, Just Calindar In MS Access

Mar 6, 2008

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 2 Replies View Related

How Do You Sync An Unmanaged Replica?

Mar 14, 2008

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 1 Replies View Related

Sync A DSUM To A Record

Oct 13, 2005

Hi

Could someone help with showing me how to sync a DSUM to a record as i am currently summing all the records instead of the ones i need?

Thanks

View 12 Replies View Related

Sync Two Forms To One Table

Mar 16, 2006

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 2 Replies View Related

Record Selector Sync

Aug 27, 2006

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 7 Replies View Related

Sync Tabbed Form

Feb 25, 2008

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 12 Replies View Related

How To Sync Up Fields Within Databases

Feb 23, 2006

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 3 Replies View Related

Linked Table Not In Sync

Jun 25, 2014

Yesterday my work's IT department moved a network drive to another location. The old location still worked as read-only. I have two Access databases: One contains the tables and the other contains the forms and queries, and has links to the tables in the other files. In order to avoid having to use the linked table manager every time I move the databases, I use the networkaddress notation instead of drive letters, such that the database with the linked tables was pointing to the old, read-only location. I deleted the linked tables and relinked to them using the new location, and noticed that there was a discrepancy of 30 records I had entered through the forms not showing up once I linked to the tables in the new location.

It was clear that the database I use to enter data never actually inserted those records into the linked tables, but still acted as though it had in that it showed all records. Once I deleted the linked tables and linked to them again, those records completely disappeared. What's odd to me is that I'd entered these data into the database over a week ago. Why does Access take so long to synchronize the data between the linked tables and the actual tables? Are there any settings I can change to make sure the data are synchronized when I exit the application? Is it the ODBC refresh interval? If the default is 25 minutes (1500 seconds), does it mean that the data are never synchronized if I don't keep the database open for at least that long?? This is really puzzling.

I was able to go back to the old network location and get the old database showing all the records it's supposed to have. I had it import the linked tables as local tables and it looks like the local tables contain all records. This is not an ideal solution, but at least it seems like I recovered all the data.

View 6 Replies View Related

Forms :: Time Clock - Referencing Subforms On Navigation Form

Jan 15, 2014

I have a complete working timeclock and trying to add the forms within the navigation form. I know I have to go back and re-reference everything and have already done so with the queries. But I cannot get the setfocus to work.

Here is the setup.

NavigationForm (navigation form)
frmClockIn (top form)
frmClockIn_SUB (bottom form)
Open Navigation > Time Clock.
Select an EmployeeID from the dropdown
Click on clock in. (successful)
cboEmployeID goes blank and try selecting the same employeeID to clock out and I get a debug at

Me.frmClockIn_SUB.SetFocus

I think there is a problem with my cboEmployeeID_AfterUpdate() as well.(related?) which used to be
Private Sub cboEmployeeID_AfterUpdate()
me.refresh
End Sub

I have replaced "me.refresh" with "Me.frmClockIn_SUB.Form.Refresh"

(It used to break here, but not after I changed it.)

Not too sure where to set these forms to in the code

I have attached a blank copy ....

View 3 Replies View Related

Modules & VBA :: Force Windows Sync To Run

May 7, 2015

I have an application that is using SQL Express as a backend and syncing to a SQL database through SQL web synchronization. This all works great and my clients have my custom application to interface with their local database and do work and it syncs back to the corporate database and I've got it scheduled to run in Windows every minute. What I would like to do is have a button or on event set of code that forces that sync pairing to run and I'm not exactly sure how to do that.

View 3 Replies View Related

General :: Sync Tables When Connect To LAN

Nov 24, 2012

I want to make a database on my company server. There will be two tables. "Customers", and "Visit to customers".

There are 5 sales managers in my company and i want them to collect information about customers on the field.

My question is:

How to sync Customers and Visit tables from laptops with Customers and Visit tables on the server?

Can i do it over internet or i can make a button that will sync tables when sales managers come to the office and connect to lan?

View 10 Replies View Related

General :: Background Sync Of Data

Dec 11, 2014

I am creating an application that is using Access as the front-end for data entry, some manipulation, etc. In the example, my guys will get a ticket and then stamp that ticket with times of when things are done. The way I'm doing it now is that I have a second Access application that is working as the synchronizer. It just sits in the background and syncs the data.

The issue I'm having is that the guys are on mobile devices so if/when they lose connection to the database (they are constantly moving in trucks), Access doesn't do a great job of reconnecting to the tables, even if you drop the tables and re-add them. I've attempted to close the sync app from the main app and then re-open it but this just results in the sync app being in the foreground and I need something that sits in the background and is hidden.

View 8 Replies View Related

Modules & VBA :: Sync Between Recordset And Access Table

Oct 15, 2014

I have a normal Access table. The first column is ID and is the primary key. The second column is a text. The table consists of two records and is sorted in ascending order. First comes the data set with the ID 1.

Sub test()
Set rs_access = CurrentDb.OpenRecordset("tab1")
rs_access.MoveFirst
MsgBox (rs_access.Fields("id").Value)
End Sub

The message box shows 1. So everything is fine. Now I sort the table descending. But I get the same message. Why? Appearently the recordset doesn't know that the table was modified. The recordset should register that the table is modified.

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved