Recent content by pernic80

Thanks for all your help! What should I send a copy of?

I am definitely hitting the next record button on the main form for the entire form.

I am having an issue with one of my forms. This issue just started. I have a Subform that shows product ordered, quantity, price, extended price, discount etc WITHIN a Form that lists vendor info, shipping info etc. When I want to go through the records I used to be able to hit the "next...

That worked! Thanks!!

Which joins need to be changed? Under the joint properties which # should be selected? Thanks again this is very helpful

Uploaded with ImageShack.us

Uploaded with ImageShack.us

opps I had to up my post count to attach image

ok here you go

Yes! Found it! You are right the 2 names that have been coming up are the only ones present in the query. Now how do I change it so it shows all names? THANK YOU SO MUCH

I do not have a query specifically for Weekly Order Status. I built the report off of tables. I'm not sure I know what you mean. Do I need to create a query?

SELECT [Employees].[EmployeeID], [Employees].[FirstName], [Employees].[LastName], [Order Details].[OrderID] AS [Order Details_OrderID], [Order Details].[ProductID], [Assets].ProductName, Orders.[EstimatedDeliveryDate], [Orders].[OrderID] AS Orders_OrderID, Orders.[Item Received]...

I know it is not in print preview mode. Plus the pages indicate that it is page 1 of 1. What I meant is that in design mode, all of the fields that I added when I created the report are as as they have been since I created the report. Normally when I would be/switch back to Report View mode...

I would select the appropriate filters after the report was generated. Then I would send out the version reflecting the filtering. There should be no filters in place otherwise. Any ideas? When I open the report in design mode the information appears as it always has, only now when I switch...

Hi All, I have a Weekly Order Status report that I send out every Monday. So far, the report has been showing all orders that have been placed (arranged by employee responsible for placing the order, etc) I then filter the report by a Yes/No Item Received Box and email to concerned employees...