Hello,
I am trying to track when employees do to clients to do service jobs at the clients' workplaces. How can I track an employee's clock in and clock out times when there there is no internet at the remote location?
wirejp
Last Activity: Sep 12 '24, 09:53 PM
Joined: Jun 23 '14
Location:
-
wirejp started a topic How can you track an employee's clock in and clock out times when there there is no internet at the remote location?in GeneralHow can you track an employee's clock in and clock out times when there there is no internet at the remote location?
-
wirejp started a topic Store different groups of multivalue lists in a field of a table in MS Access 2013in AccessStore different groups of multivalue lists in a field of a table in MS Access 2013
Hi Everyone,
I am working on a MS Access 2013 database. I have a field called "Manual" which contain some values 1,2,3,7, Is it possible for a user to populate this 'Manual" field with different groups of multivalue lists at the same time e.g. the user can choose 1 and 7 or 1,2 or 1,3?
Thanks,
wire_jp -
Hi All,
I got the issue resolved:
1st query: -
2nd query:Code:WorkHoursPerMin: Sum(DateDiff("n",[timeIn],[timeOut])-60)
Code:WorkMths: [WorkHoursPerMin]\60 & Format([WorkHoursPerMin] Mod 60,"\:00")
-
How to calculate the number of working hours each month in a Access query?
Hi All,
I am using MS Access 2010. I am working out each member of staffs working hours for the month in a MS Access query.
[WorkDate]
[TimeIn]
[TimeOut]
minus a 1 hour lunch.
I would like to display the total hours worked for the month in a hours:minutes format.
I tried this approach: -
Call a field WorkHoursPerMin in a query:-.
...Code:WorkHoursPerMin: Sum
-
Hi zmbd, thank you for the clarification about the terms called "controls" and "fields". I updated my post#2 to say "I had to add the country name and sportscentre name controls to the trainers form". Yes, there were more steps involved in fixing the problem.
As the SportsCentre, Trainers and Customers are in the same country, the field called [CountryCode_pk] in the tblCountry table is linked to the respective...Leave a comment:
-
I have managed to resolve the issue with the database. I had to add the country name and sportscentre name controls to the trainers form.Leave a comment:
-
Access 2010 run-time error 3201 cannot add or change record
When the user opens the Orders form he can manually update the 2 controls:- CustomerFirstNa me (textbox), CustomerLastNam e (textbox) and he can also select one of the options of the following 3 combo box controls:- CustomerCountry (combo box), TrainerName (combo box), SportsCentreNam e (combo box). The user can also add new Trainers and new SportCentres using the following 2 command buttons: Add cmdNewTrainer and Add cmdNewSportsCen tre.
Updating... -
Instead of using the approach described above, I used this query instead: -
Code:SELECT qryPaymentPremiums.PremiumInvoiceNumber, qryPaymentPremiums.[ClientID], Sum(qryPaymentPremiums.NetPremiumAmt) AS SumOfNetPremiumAmt, Sum(qryPaymentPremiums.PremiumPmt) AS SumOfPremiumPmt, Sum([NetPremiumAmt]-[PremiumPmt]) AS PmtPrem FROM qryPaymentPremiums GROUP BY qryPaymentPremiums.PremiumInvoiceNumber, qryPaymentPremiums.[ClientID];
Leave a comment:
-
I got the issue resolved. ThanksLeave a comment:
-
Sum of balances for a repeating Invoice Number
Referencing post: -http://bytes.com/topic/access/answer...eating-invoice
I need some help with the calculation of invoice amounts on a Microsoft Access 2010 report. My report shows the following fields; -invoice#, invoice amount, payment amount, and payment due (i.e. payment due = payment amount - invoice amount). There are some invoice numbers have balances for their different regional offices:
for example:... -
add a specific record value to a concataneted query in expression builder
I am using Microsoft access 2010 and I am wondering if it is possible to add a specific record value called "credit" to a concatenated expression. When I run the query, a pop-up parameter box appears and I have input the word "Credit" in order to complete the query expression. Is it possible to modify to the parameterized query so that the user do not have to enter the word "Credit" in a parameter?
...Code:Expression
-
Hi jforbes, I neither had a function named PremiumInvoiceN umber() nor it is defined as a Public variable. There was not anything in the task variable. I am not very good at VBA coding. I am now trying a different approach to accomplish my goal. Instead, I am now using one combo box to search for the Premium Invoice numbers using the following code:
...Code:Private Sub CboPremiumInvoiceNumber_AfterUpdate() 'Moves to PremiumInvoiceNumberLeave a comment:
-
hi jforbes, referring to the code in post #3 and following your explanation in post #6, when I enter for example ?PremiumInvoice Number("PBM13-01") in the Immediate window and Press Enter, I receive a Compile error: Sub or Function not definedLeave a comment:
-
Hi jforbes,
I added a breakpoint at line 18 and no errors occurred.
I followed your suggestion to type "?task' in the Immediate Window and press Enter. No result/SQL was returned in the immediate window.
I rebuilt a new form and I added the two search combo boxes. I tried the revised code below but no result returned: -
...Code:Function SearchCriterica() Dim myClientName As String Dim myBillingID As
Leave a comment:
-
Thanks, jforbes, but the no result is returned after selecting the two combo boxes. I have changed the field name from ClientID to ClientName.
Some more background: the subform called frmInvoicePremi umsSub,is set as a continuous form and it is referencing a query called queryBillingsPr emium.
The code is shown below: -
...Code:Function SearchCriterica() Dim strClientName, strPremiumInvoiceNumber As String
Leave a comment:
-
Searching on a form using two combo boxes
I am using Microsoft Access 2010.I am trying to perform a search in a form (this form is a continuous form) using two combo boxes: a combo box called ClientID and another combo box called PremiumInvoiceN umber. No result is returned after selecting the two combo boxes. Can you tell me what I am doing wrong? Thank you in advance for your help.
...Code:Function SearchCriterica() Dim ClientID, PremiumInvoiceNumber As String Dim task,
-
thank you, jforbes. You have solved the problem.Leave a comment:
-
Round a currency value to 2 decimal places in a query
I am using Microsoft Access 2010 and I am trying to round a round a currency value to 2 decimal places in a query. The currency amount is still showing up as a whole number. Any help will be appreciated.
Code:AdminFeeInitalZmC: CCur(Nz(Round(([InitialPrem]*[FeeInitialZm])*-0.015,0),2))
-
Invoice Premiums and invoice fees billed to different clients
Hi Everyone,
This is a follow-up question from a previous link: -
http://bytes.com/showthread.php?p=3781769}
Usually most of the insurance policy premiums and fronting fee invoices are billed to same client. However for one policy (i.e. the marine policy), the premium invoices are billed to a client A, while the fronting fee invoices are billed to a client B. I reworked my original database structure from version 1...Last edited by zmbd; Apr 18 '15, 07:10 PM. Reason: [z{please note: Many of our experts will open unrequested attachments. Please pull your code and post inline properly formatted using the [CODE/] button. Images can be attached as native image files.}
No activity results to display
Leave a comment: