I don't actually need the code for this...yet. Essentially I need to know if what I want to do can be done.
I have two work books. One is a report the other contains the data that the report is formulated from.
The work book with the data has 21 sheets, one for each day of the week, three shifts a day. This is a planning tool for one of the departments I work for. The planner enters whether the job has been planned,...
Christina123
Last Activity: Jun 3 '08, 07:01 PM
Joined: Aug 3 '07
Location: Windsor, ON
-
Save Template With New Name Off User Defined Entry
-
I did not enter the expressions, I used the report wizard to create the report and I think it does all of that for me.... -
I haven't the foggiest, that's what populates into the group/sort thing when I click on the button....Leave a comment:
-
In the Group/sort tool dialog box there are two fields that say MaxofOrderDate, but neither of them say =Max(OrderDate) . If I attempt to input that manually, I get an error that says "Cannot have aggregate function in ORDER BYclause (Int(Max([OrderDate]))\1). I don't know.. :( ... I don't get paid enought to do this......Leave a comment:
-
Yup even when I do not group by employee, it still shows each time the item was taken out. Even if I remove the employee field and/or the supervisor field from the report it shows all of the times the item was taken out.
If I enter in an order today and use a date from last week, it won't use today's date as the order date, it will use the date that I enter in the order date field, won't it?...Leave a comment:
-
I tried all of the grouping options, by date then serial, by serial then date etc...., but in each case I was shown the last time the item was taken out by each employee....Leave a comment:
-
Too much info showing in a report run off of a query...part 2
I have a report that runs off of a query. The report is supposed to show the items that are currently withdrawn. I had an issue with it showing every time an item had been withdrawn, even though it had been returned. So I grouped the date by max. This solves the issue if the item had only ever been withdrawn by one person. However if more than one person over 'history' has removed the item it shows the last date (max) that the item was withdrawn... -
Same problem, different twist.
In the database each person who can remove a tool has a unique ID number. My earlier issue that showed every time an item was removed has been fixed if it is only one person who has ever removed the item.
Now if I take the item out and then someone else takes the item out after I bring it back, it shows the last time I took it out and the last time anyone else took it out.
This...Leave a comment:
-
The SQL in my current query is:
SELECT tblOrder.GID, tblEmployee.Emp loyeeFirst, tblEmployee.Emp loyeeLast, tblOrder.OrderD ate, tblOrder.Superv isor, tblItemSpecific s.Description, tblItemSpecific s.Serial_Number
FROM ((tblEmployee INNER JOIN tblOrder ON tblEmployee.Glo balID = tblOrder.GID) INNER JOIN tblReturn ON tblEmployee.Glo balID = tblReturn.GID) INNER JOIN ((tblItemSpecif ics INNER JOIN tblOrderInfo ON tblItemSpecific s.Serial_Number...Leave a comment:
-
Christina123 started a topic Too much info showing in a report need to better define query...help!?!in AccessToo much info showing in a report need to better define query...help!?!
I have a database that tracks the withdrawls and returns of shared assets.
I have a query that a report runs off of that is supposed to only show the most current withdrawl (based off of a yes/no check box in the order form and return forms). However, the report shows every time the item has ever been removed, any time the check box has been checked.
I think that if I set it so that if the return date is less than the order... -
Search orders based on user defined dates
All:
I have a database that tracks the withdraws and returns of shared tools.
It has been requested that the datablase is made able to show all orders based on a date range.
My orders only have one date, the order date. I have made a form that has two drop down boxes that reference a query which returns a list of all dates that have been entered.
So what I need this to do is when they click on... -
Well that kind of worked, it now shows a report of all items that have been returned. Which makes no sense as returned and ordered have no direct relationships.
I am going to assume that I have made an error somewhere else in my database because the code should work....Leave a comment:
-
OrderNumber is an auto number as it is the primary key and serves no purpose other than to give a number to the order.
What would need to be changed since it is numeric data?Leave a comment:
-
Well I did all of that. What happens now is it opens the report but is still showing what has been ordered. It is not recognizing the Link Criteria, that I only want the current form to print.
This is what I have on my button thus far (this is for OnClick):
...Code:Private Sub cmdOrder_Click() Dim strDocName As String Dim StrLinkCriteria As String strDocName = "rptOrder" StrLinkCriteria = "OrderNumber=Forms![Order![OrderNumber]]"
Leave a comment:
-
Christina123 started a topic Getting Current Form & Subform Info To Either Print Or Dump Into a Recordin AccessGetting Current Form & Subform Info To Either Print Or Dump Into a Record
Currently working with Microsoft Office 2000 and whatever version of Access came with that.
I am developing a database to track the comings and goings of shared tools.
Everything works splendidly except I have printing issues, primarily I have no idea what I am doing.
I have a form that contains the date and the info of the person doing the ordering as well as a subform that has the serial number of the part,...
No activity results to display
Leave a comment: