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 RepliesI am trying to update an Access 2000 Database used by our Shipping Dept. The Shipper currently runs 3 Queries to populate 3 local tables with data from a SQL Server 2000 database used by our production process, he then will run another query that populates another local table with the data from the 3 local tables. His next step is to open a form where he scans a barcode from a label on the finish material tote to field #1 that is a Select Query. This allows for minimal scanning in the load makeup routine. The problem is that the data is not realtime and he must periodically refresh the tables. I need to find a way to use the linked tables to provide near Realtime data.
(Existing Barcode field1)
SELECT DISTINCTROW ProductionTable.BatchNo, ProductionTable.CmpdNo, ProductionTable.Recipe, ProductionTable.CustomerID, ProductionTable.Gross, ProductionTable.Tare, ProductionTable.Net, ProductionTable.expires, ProductionTable.PartNo,
ProductionTable.PONo FROM ProductionTable ORDER BY ProductionTable.BatchNo;
(Trial 1 – It Works for 1 production line only)
SELECT DISTINCTROW Dbo_Mixed_Material_Batchoff1.BatchNo, Dbo_Mixed_Material_Batchoff1.CmpdNo, Dbo_Mixed_Material_Batchoff1.Recipe, Dbo_Mixed_Material_Batchoff1.CustomerID, Dbo_Mixed_Material_Batchoff1.Gross, Dbo_Mixed_Material_Batchoff1.Tare, Dbo_Mixed_Material_Batchoff1.Net, Dbo_Mixed_Material_Batchoff1.expires, Dbo_Mixed_Material_Batchoff1.PartNo, Dbo_Mixed_Material_Batchoff1.PONo FROM Dbo_Mixed_Material_Batchoff1 ORDER BY Dbo_Mixed_Material_Batchoff1.BatchNo;
(Trial 2 – Does Not Work)
SELECT DISTINCTROW
dbo_Mixed_Material_Batchoff1.BatchNo, dbo_Mixed_Material_Batchoff3.BatchNo,
dbo_Mixed_Material_Batchoff4.BatchNo, dbo_Mixed_Material_Batchoff1.CmpdNo,
dbo_Mixed_Material_Batchoff3.CmpdNo, dbo_Mixed_Material_Batchoff4.CmpdNo,
dbo_Mixed_Material_Batchoff1.Recipe, dbo_Mixed_Material_Batchoff3.Recipe,
dbo_Mixed_Material_Batchoff4.Recipe, dbo_Mixed_Material_Batchoff1.CustomerID,
dbo_Mixed_Material_Batchoff3.CustomerID, dbo_Mixed_Material_Batchoff4.CustomerID,
dbo_Mixed_Material_Batchoff1.Gross, dbo_Mixed_Material_Batchoff3.Gross, dbo_Mixed_Material_Batchoff4.Gross, dbo_Mixed_Material_Batchoff1.Tare, dbo_Mixed_Material_Batchoff3.Tare, dbo_Mixed_Material_Batchoff4.Tare,
dbo_Mixed_Material_Batchoff1.Net, dbo_Mixed_Material_Batchoff3.Net,
dbo_Mixed_Material_Batchoff4.Net, dbo_Mixed_Material_Batchoff1.expires, dbo_Mixed_Material_Batchoff3.expires, dbo_Mixed_Material_Batchoff4.expires,
dbo_Mixed_Material_Batchoff1.PartNo, dbo_Mixed_Material_Batchoff3.PartNo,
dbo_Mixed_Material_Batchoff4.PartNo, dbo_Mixed_Material_Batchoff1.PONo, dbo_Mixed_Material_Batchoff3.PONo, dbo_Mixed_Material_Batchoff4.PONo
FROM dbo_Mixed_Material_Batchoff1, dbo_Mixed_Material_Batchoff3, dbo_Mixed_Material_Batchoff4 ORDER BY dbo_Mixed_Material_Batchoff1.BatchNo, dbo_Mixed_Material_Batchoff3.BatchNo, dbo_Mixed_Material_Batchoff4.BatchNo;
(Trial 2 Does Not Work)
SELECT DISTINCTROW Dbo_Mixed_Material_Batchoff1.BatchNo, Dbo_Mixed_Material_Batchoff1.CmpdNo, Dbo_Mixed_Material_Batchoff1.Recipe, Dbo_Mixed_Material_Batchoff1.CustomerID, Dbo_Mixed_Material_Batchoff1.Gross, Dbo_Mixed_Material_Batchoff1.Tare, Dbo_Mixed_Material_Batchoff1.Net, Dbo_Mixed_Material_Batchoff1.expires, Dbo_Mixed_Material_Batchoff1.PartNo, Dbo_Mixed_Material_Batchoff1.PONo FROM Dbo_Mixed_Material_Batchoff1 ORDER BY Dbo_Mixed_Material_Batchoff1.BatchNo; SELECT DISTINCTROW Dbo_Mixed_Material_Batchoff3.BatchNo, Dbo_Mixed_Material_Batchoff3.CmpdNo, Dbo_Mixed_Material_Batchoff3.Recipe, Dbo_Mixed_Material_Batchoff3.CustomerID, Dbo_Mixed_Material_Batchoff3.Gross, Dbo_Mixed_Material_Batchoff3.Tare, Dbo_Mixed_Material_Batchoff3.Net, Dbo_Mixed_Material_Batchoff3.expires, Dbo_Mixed_Material_Batchoff3.PartNo, Dbo_Mixed_Material_Batchoff3.PONo FROM Dbo_Mixed_Material_Batchoff3 ORDER BY Dbo_Mixed_Material_Batchoff3.BatchNo; SELECT DISTINCTROW Dbo_Mixed_Material_Batchoff4.BatchNo, Dbo_Mixed_Material_Batchoff4.CmpdNo, Dbo_Mixed_Material_Batchoff4.Recipe, Dbo_Mixed_Material_Batchoff4.CustomerID, Dbo_Mixed_Material_Batchoff4.Gross, Dbo_Mixed_Material_Batchoff4.Tare, Dbo_Mixed_Material_Batchoff4.Net, Dbo_Mixed_Material_Batchoff4.expires, Dbo_Mixed_Material_Batchoff4.PartNo, Dbo_Mixed_Material_Batchoff4.PONo FROM Dbo_Mixed_Material_Batchoff4 ORDER BY Dbo_Mixed_Material_Batchoff4.BatchNo;
Anyone have any ideas?
Many thanks in advance to all responders
Bob
Hello!
The problem at hand for me is to be able to hide columns in a subform wherever "#Name?" appears. My VBA experience is minimal to non-existent, but if a not so complex sample code exists out there then I'd appreciate any suggestions you may have.
I have attached a print screen document that shows the result of a query in the subform I just talked about. My anticipated thanks for your help.
can you get an analoge clock on a form?
if so, how??
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
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
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
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 RelatedI'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 Relatedi'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 RelatedTrying 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.
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 RelatedCan we add windows gadgets like clock and calender to access form?
View 6 Replies View RelatedSince 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 RelatedI 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 ....
How do you grab a custom Fiscal Year's values based on the system clock's date?
I am building a query where I want to see the number of closed cases based on the current custom fiscal year with the system clocks date. The report that it feeds only cares about the current FY.
I need the System Clock's FY value in this query
Code:
SELECT shortname AS Station, NZ(TotalCount.TotalCases,0) AS [Cases Complete]
FROM StationList LEFT JOIN (SELECT station, count([Open Issues].ID) AS TotalCases FROM [Open Issues] WHERE [Status]="Closed" GROUP BY Station) AS TotalCount ON StationList.shortname =TotalCount.station;
Within the Query Open Issues I have the FY broken up
Code:
fiscalYear: IIf(Month([Issues].[Opened Date])>=10,"FY" & Year(DateAdd("yyyy",1,[Issues].[Opened Date])),"FY" & Year([Issues].[Opened Date]))
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