Current User Report With Hold And Open Ended Dates
Jul 10, 2012
I manage a fleet of vehicles at work with drivers assigned to these vehicles. Each driver may opt to pay a contribution for private use of these vehicles.
This can normally be done on an excel database, however, the drivers sometimes go on leave, so I need to put their payments on hold. At this time, other drivers may take over for that period or the vehicle is left at the office. Also, the drivers change their level of contribution from time to time, so I need to adjust that accordingly too.
When the driver takes over a vehicle they complete a form that has the contribution level (there are 4 to chose from) and the dates they will have it from. They always provide a start date, however, sometimes the end date is left open.
Sometimes, driver A will say something like 'From 1 Jan 2012 To Open' then driver B may take it for a week and say 'From 1 July 2012 To 1 August 2012'.
I want to know if Access is the right tool to produce the report with the current driver, and that it will revert back to the Driver A after 1 August?
View Replies
ADVERTISEMENT
Oct 3, 2006
HI,
I have a query [CustomerOrdersByDate] that requests user input for [CustomerID], a 'Start Date' and an 'End Date' for the [OrderDate] field.
the Report works fine, however I'd like it to be able to take the Start & End dates the user has inputted when running the report, and make it appear in the Report header
e.g. Orders Received from [CustomerID], Between {user defined}[Enter Start Date] And {user defined}[Enter End Date].
I have added a text box to display the results and played around with a few different expressions, etc... unsuccessfully so far, and as I'm not up to working with VBA code, I would appreciate some help!
View 2 Replies
View Related
Feb 26, 2014
I would like my user to be able to enter dates on a report.
I have entered unbound fields on the report; but it doesn't keep any of the information (dates) for printing or otherwise. (I don't need to save these dates since they change monthly.)
View 1 Replies
View Related
Mar 5, 2013
I managed to create a report by user using a combo box. When an user selects a name from the combo box, it generates a report showing all the records by that name.
However, now I need to be able to generate a report as above but between 2 dates. How??
I am having two sets of criteria.
1) by user
2) between 2 dates
Can this be done?
View 7 Replies
View Related
May 11, 2012
I have a bunch of reports that need to be printed, but only if they include a certain date. I want all of the dates to show up though.
For example:
There are 3 reports with a bunch of different dates in the bill date column.
Reports A and B include the date 04/30/2012, along with a bunch of other dates.
Report C does not include the date 04/30/2012.
i want reports A and B to open since they include the date 04/30/2012, and I want all of the other records with other dates to show up on the reports along with records with a date of 04/30/2012. I do not want Report C to open at all.
View 2 Replies
View Related
Oct 23, 2014
I am trying to filter a report based on two user inputted dates, but can't seem to figure it out. I've played around with quotation marks, and # but can't seem to figure the syntax out.
Code:
Me.OrderBy = "Date Submitted"
Me.OrderByOn = True
Dim Date1 As Date
Dim Date2 As Date
Date1 = UserInput
Date2 = UserInput
DoCmd.ApplyFilter WhereCondition:="[Date Submitted] > Date1 and < Date2"
View 11 Replies
View Related
Aug 27, 2013
What I really need is for when the form opens, it looks at todays date, then matches current user and then goes to that record for today, if no current user there, then will goto new record..
i know, sounds complicated, and probably is really easy, but my heads not with it today, as about to get drunk as its my 40th, and got people ringing and texting and still trying to get this done....
I've included a copy of this database, named Timecards..
View 1 Replies
View Related
Jan 30, 2014
I have a [Time Job Started] field that is auto populated with now(). which has input of 1/29/2014 11:02:02 am. Then I have a [Time Job Ended], typed in by user that has input of 6:00 pm, no date value. Cant really do the date() + Time Job Ended, because the date can range since times can go through midnight.
I am trying to calculate time duration. DateDiff("n",[Hot Calls]![Time Job started],[hot Calls]![Time Job Ended]) if this formatted as "Short time" it returns 0:00.
I want to report this as HH:MM. so the result should be 6:58.
View 5 Replies
View Related
Sep 20, 2006
OK,
I have a form, that allows the users to enter time off for staff. It has a start date and end date fields. When they hit submit, it will enter records for all the days within this timespan into the table.
Here is the code I have on my button onclick
StartD = txtbegdate.Value
EndD = txtenddate.Value
FN = cboEmployeeName.Value
RC = cboReasonCode.Value
TM = txtteam.Value
TC = cboComments.Value
For Counter = StartD To EndD Step 1
txtbegdate.Value = Counter
Datefound = Nz(DLookup("[ExcludedDates]", "qryDateExcluded"), 0)
If Datefound = 0 Then
'Found no excluded date
txtDateOff.Value = Counter
cboEmployeeName.Value = FN
cboReasonCode.Value = RC
txtteam.Value = TM
cboComments.Value = TC
DoCmd.GoToRecord , , acNewRec
End If
Next Counter
txtbegdate.Value = ""
txtenddate.Value = ""
MsgBox "Dates added, click OK to continue!", vbOKOnly
End Sub
What I want to do next is, after it enters the data. It popups another form, that is based on a query that checks for duplicate entries for that person.
I thought using something like this right after the msg box alert, would do the trick.
Dim stDocName As String
Dim stLinkCriteria As String
stDocName = "f_findduplicates"
stLinkCriteria = "[Employee_Name]=" & "'" & Me![Text0] & "'"
DoCmd.OpenForm stDocName, , , stLinkCriteria
but, what happens is after the data is entered. The main form clears so the user can make the next entry. So when the popup form is generated, there is no 'employee_name' data to base the query on. so the form opens blank.
Is there a way to keep the 'employee_name' field data in a temp memory or something so the form has something to run with?
Or does anyone have a better solution? I would prefer that the data never gets entered in the first place, but I can't get anything like that to work with my current form.
thanks in advance.
Chris
View 14 Replies
View Related
May 21, 2007
Hi,
I have an arrival date and a departure date and I need to work out if the current date is within the two dates. It's a criteria for one of my fields on the query I'm using as the backbone for a list box. Any help greatly appreciated :D
Thanks,
Adzi
View 2 Replies
View Related
Mar 21, 2015
I am probably quite wrong but I am trying to apply a filter that returns all dates within the current month
The bulk of the filter is from Microsoft Access examples.
Private Sub MonthB_Click()
DoCmd.ApplyFilter , "DueDate Year([DueDate]) = Year(Now()) And Month([DueDate]) = Month(Now())"
End Sub
It is not working??
View 3 Replies
View Related
Apr 18, 2006
I'm creating a database for a college assignment, and for this database, I need to record the current user ID when a record is created/updated. But I dont know the function (like, Now() returns the current date/time) that gives me the user ID. The help files are awful and I cant find the function I need =(
View 2 Replies
View Related
Sep 22, 2005
I need to mine the Proper Name of the current user and automatically populate a field on a form. I've tried default value = currentname() and all I get returned is Admin. How can I retrieve the Proper Name of the network username and auto populate a field? Any help is appreciated.
View 6 Replies
View Related
Jul 30, 2014
I'm trying to make it so I could filter a subform from the main form and it will hold those results and allow them to be edited in the subform without it refiltering it. I want it to still be able to update the table by whats edited in the subform, but I don't want it to "disappear" from the subform when the filtered "matching" criteria is changed on a record.
How could I go about accomplishing this?
Here is my code for the filter of my subform:
Private Sub Form_Load()
strFilter = "[Rep Number] = " & "RepNumberField" & _
" AND " & "[UserName] = " & "UserNameField" & ""
RepReassignmentSubform.Form.Filter = strFilter
RepReassignmentSubform.Form.FilterOn = True
End Sub
View 14 Replies
View Related
Mar 14, 2005
I know i have read this before, and i have been searching for a hour now.
can someone tell me how set a variable = the beginning date ofthe month and another variable2 = the ending date of the month?
Thanks for your help!
View 1 Replies
View Related
May 7, 2013
My first question is how to set a column to be the current date read by the computer.
Example: It will automatically say 5/8/2013 tomorrow without needing updating.
Question 2: How to add a number of days to the current date.
Example:
Add 7 days to the current date.
on 5/8/2013 it will read 5/15/2013, then automatically update to 5/16/2013 on 5/9.
View 1 Replies
View Related
Oct 23, 2005
Hi
I have designed a MS Access tool accessed by multiple user. The first screen asks for badge number which is unique for each user. I wanted to do away with that screen. Instead wanted to get the username of the currently logged in user, may be from registry or somewhere. We have Windows XP here. Is there any VBA script for that....Need help!!
View 5 Replies
View Related
Aug 17, 2014
In my DB there is a set of company-running rules that are addressed to different groups within the company, like drivers, bookkeeping, warehouse, electricians etc. Both groups and workers scope and number might change from time to time. I need to make a table that holds which worker belongs to which of these groups (one worker to one or more groups). The easiest way of setting this for the user would be kind of a matrix-look form where lines would hold the name of workers, columns would hold the groups and at the cross points there would be check boxes to set or unset membership. However I can't find the way in what table sturcture this could be utilized.
View 4 Replies
View Related
Apr 18, 2015
I am preparing a database to track the daily activities of my team. This is a real time database wherein the users will add their daily ongoing task and submit.
The action for me is, I need to capture the time required for each task.
Also, there is a possibility that the user will have to hold a task for a while/days due to some issue and will start another task. Once they have a feedback on the issue they will resume the pending/holded task.
Here, I need to capture only the time they have invested in performing the task and ignore the time spent to receive feedback on the issue. Hence the time should start when they start the activity and pause when they hold the activity. Again, the time should continue where they had paused, when they re-start the holded activvity and finally ends when the submit.
View 4 Replies
View Related
Nov 16, 2014
The aim of what I am doing is to create a monthly statement to give to our intermediaries that shows the commission they will receive each month for the deals they have referred. I have managed to create this report, HOWEVER I can't figure out how to filter out which month I need, so I a report for Jan, Feb Mar etc... The idea is that at the end of each month I need to run the report so only the latest month shows...
View 3 Replies
View Related
Mar 14, 2008
i have a database that users log into before they can do anything, after they log in, when they open up a form, i want the username that was used to log in to be displayed and stored in a field. how would i do that?
Here are the relevant fields and tables
Name ---------------------- Description
USERS --------------------- contains username/password/success/date time for login
Login ---------------------- Login form
Username ------------------ Username field in 'Login'
Password ------------------ Password field in 'Login'
EXPOSURE_REPORT --------- Table that contains information for form VV
EXPOSURE_REPORT --------- Form
REPORTRECIEVEDBY -------- field that needs the current user stored in it
there are 6 or 7 users total, if that's at all relevant,
thanks!
View 1 Replies
View Related
Jul 18, 2013
all using access 2010. I have a date field. I need to write a query to pull out dates with current year only. ex data: 1/1/10, 1/1/11, 2/1/12, 2/1/13. Need to pull all dates with current year which would be 2/1/13. Tried in query criteria of the date field: =Format(Now(),"yyyy") I received data mismatch. this is a date/time field.
View 4 Replies
View Related
Mar 8, 2006
Hi Guys, my first post hereim making a database for work and need to figure out the followingi have two people that uses a ms access db, each entering data.i made a custom macro in the vb editor:Public Function cUsername() cUsername = Environ("USERNAME")End Functionwhat i want to do now is, everytime a new entry is added in the table, it should add that username to the "user" cell... it should only do this once, so for example, when i enter data it will show "albert" and if i was to close it, login as "steve" it should still show "albert" under the ones i added, and not steve...this needs to be in the table not a query or form...thanks for your timeAG
View 2 Replies
View Related
Feb 22, 2005
If I have a field in a table called "AddedBy", is there a way for this to default to the CurrentUser that's logged in to the database when a record is added to the table? I know you can use "Application.CurrentUser" both in the VB code and within SQL queries, but it doesn't seem to work if I put it in the "Default Value" box with the table editor. Any thoughts on this would be appreciated. Thanks!
View 2 Replies
View Related
Aug 10, 2007
I am setting up a call log for an application. Once a message has been entered, I need to restrict access to the person who created it AND to managers (who have admin privelages to the database). Since the user who created a message needs to be able to go back in and edit it if necessary, I can NOT simply restrict access to the edit form to admins.
The command that opens this form looks like this so far:Code:If ((Me.[Transaction] = "Status Call") And _ (Me.[TransactionBy] = CurrentUser())) THEN DoCmd.OpenForm "frmEditMessage" ...Else MsgBox("Blah blah blah, etc etc.")End IfI need to add something to the initial If statement like this:Code:Or (CurrentUser.isMemberOfGroup("Admins"))but I don't know the correct Access syntax for it.
Any help anyone can give me would be appreciated!
View 1 Replies
View Related
Sep 21, 2014
I have a report based on a query that has data for many dates. At the moment I have put a specific date in the criteria of the query so that I could build the report format. So it now displays all the data for the date i have in the criteria section. I will need to run this report several times per week so the specified date (and corresponding data in the report) will need to be changed to a new date when I open the report i.e. when I open my report I want to show data in the report only for a specified date.
Can I create a date parameter box open up when I open the report? Can I create a form with a button that when I click will open the report displaying data for that date? What would be the best way?I also need to display the specified date on the report.
View 5 Replies
View Related
