Hi,
Can someone please help me with my calendar function? I'm using access 2003 by the way.
Here is my problem: I have a receiver database that user will enter date of items received in a text box. It is set up as today's date, but user can change it to a back date. Now I want to create a function that check if today's date fall in whatever financial calendar month then user can't back dated later than that month financial...
Bay0519
Last Activity: May 9 '12, 07:10 PM
Joined: Jun 16 '09
Location:
-
financial calendar date function
-
Hi Neopa,
Thank you for your quick reply,
here is the code that I have so far (to avoid confusion)
...Code:Private Sub TestAction_AfterUpdate() Dim strMessage As String Dim StrSubject As String Dim email As String StrSubject = "Test action has been entered/changed for the " & " productID " & Me.productid & " test No " & Me.testno
-
Hi Narender,
Thank you for your quick reply, unfortunately, we don't use sharepoint. we only use ms office. Can I accomplish this project only by using access and outlook?
Thank you.Leave a comment:
-
Hi Neopa,
sorry for the confusion, the database is in the server. It's only 1 database and it's shared for the test specialist and the manager.
and I would like the link to be in the outlook email. so for example if the test specialist created a product test for product Id 11 (using access form, testaction field, after update), then an email will be sent to the manager with a link that open the access form to that specific test....Leave a comment:
-
Create link from access to outlook to open a specific form and record
Hi,
I'm using access and outlook 2003. I have a form in access that show product test information (test #, action, etc) using product ID as PK. what I need to accomplish is once, the test specialist creates a new test for a specific product, then the database creates an email to the manager with link to this database and open the form for that specific test.
I know how to create the email, but don't know how to link the database... -
Hi Neopa,
sorry for the confusion,
basically, I'm working on attendance report that will show all clock ins and outs for each employee daily. so employee can clock in but forgot to clock out or they can clock out but forgot to clock in. and they can clock in and out as many as they want like break, lunch, etc
the way the data stored in sql are employeeID as text, Status (in/out), timestamp (date and time)....Leave a comment:
-
thank you Gershwyn for your quick response
But when I tried your code, I get the correct row numbers only for the first group. here is my query:
...Code:SELECT DCount(1,"test_in","EmployeeID = '" & [EmployeeID] & "' and Date <= #" & [Date] & "# and time <= #" & [time] & "#") AS Row, test_in.EmployeeID, test_in.Date, test_in.Time, test_in.Status
Leave a comment:
-
Numbering rows based on group by
Hi,
I'm using access 2003 as front-end and sql 2000 as back-end. I have a query with the result like
EmpID Date Time In/Out
1111 3/1/11 7:00:00 AM In
1211 3/1/11 7:11:00 AM In
1111 3/1/11 12:00:00 PM Out
1211 3/1/11 1:00:00 PM Out
What I want is the result like
RowNumber EmpID Date Time In/Out
1 ... -
Thank you for your quick response...
the scanner that we purchased came with SDK and they said that the fingerprint data type is offered as a text type only but didn't say where they stored the data. Is there a way for me to use the scanner and using just the SDK? if yes, how can I use it or add it to my access?
Thank youLeave a comment:
-
Fingerprint in Access database
Hi,
I'm currently working on creating a touch screen for time and attendance using access 2010 as front-end and SQL server 2000 as the back-end.
I created the touch screen form for the time and attendance already and it worked fine, now I want to add a fingerprinting module. I have the finger print scanner from secugen but don't know how to connect it to my form and make it work. Can anyone please point me to a right direction?... -
How to hide/unhide textboxes and combo boxes
Hi,
I really need someone help..
I'm using access 2003 by the way.
I have a form where users enter their time card. right now I have 15 lines (including textboxes and combo boxes in each line). When users load the form I want to show just 7 lines and if users need to enter more time, then they just need to click add more lines button to show the rest of 8 lines. I can just do this with hide and unhide method. But the... -
Never mind... I figured it out.. thanks.. :)Leave a comment:
-
Calculate Overtime for Saturday and Sunday
Hi,
I need your help again... :) I'm working on access 2003. I have a query that calculate overtime daily using:
but how can I add saturday and sunday in this criteria? if someone worked on saturday or sunday, it'll calculate as overtime.Code:IIf([totalhours]<=8,0,[totalhours]-8)
Could someone please help?
Thank you. -
exclude holidays
Hi,
Could someone help me on how to create a function for exclude schedule date for holiday?
currently here is my code and it seems not working properly.
...Code:Public Function AddWorkDays(OriginalDate As Date, DaysToAdd As Long) As Date Dim lngAdd As Long Dim lngDayCount As Long On Error GoTo AddWorkDays_Error If DaysToAdd <0 Then lngAdd = -
Nevermind I found the answer. Basically I just need to create a function that showed 1, 2, 3 as a new field. then from that I just create another query that showed data with number < 4
Thank you for all your help.Leave a comment:
-
Thank you Neopa for your quick response.
But now the result only showed my top 3 value on the query. But my query have all items that we receipt from beginning FY up to now. I need for all that items to show on the report, but for the date, I just need the last 3 receipts date for each items. If there's an item only have 2 dates, then the 3rd date will be blank. Can you help me please? I'm sorry for not givinng you a clear picture...Leave a comment:
-
Showing last 3 dates
Hi,
I'm working on a query using MS Access 2003. Right now on my query it showed all receipt dates for items from the beginning up to now. On the report, I just want to show the last 3 receipt dates. How can I do this? Could someone help? I know for the last date I can just use max, but what about the last 2?
Thank you in advance. -
It worked... Thank you so much.... :)Leave a comment:
-
Hi Neopa,
Thank you for your quick response. My project is to know what kind of workload in the schedule for the next 6 months group by month. So I created a query to that show all the remaining hours based on indate
...Code:SELECT (Format([INDATE],"YYYY - mm")) AS [month], Sum(resource_report.RemaininHours) AS SumOfRemaininHours, resource_report.RESOURCE_ID FROM resource_report GROUP BY (Format([INDATE],"YYYY
Leave a comment:
-
6 months from now question
Hi,
Could someone help me with this problem? I can't seem to figure it out. I have a query that showed all total schedule hours based on month. But what I want is when user run the report, it will only show all hours within the next 6 months. For example, if I run the report today, then the report will show oct total, nov total, dec total, jan total, feb total, and mar total. How can I accomplish this task?
Thank ...
No activity results to display
Leave a comment: