Recent content by obiron

I have not set the report on page 2 as a sub-form of the report on page 1. When I choose a record source for page 2, Access asks me for the relationship to the data on page 1, which I have supplied. when you select a record on page 1 then then move to page 2, the first record shown is the...

Hi guys, I'm just trying to get to grips with tabbed forms. I am trying to create a simple way for users to review related records. Lets say I have a tables for customers, orders and deliveries with 1:many relationships of C:O and O:D I want to create a tabbed form that allows the user to...

short of that, ahve you tried converting all of the numbers to strings? Not nice, but it should work.

Tables: Customer: CustomerID (unique) CustomerName Product: ProductID (unique) ProductName Price_per_case Shipment: ShipmentID (unique) ShipmentDate CustomerID ShipmentLines: LineID (unique) ShipmentID ShipmentLineNumber - used to determine the sort order for the shipment ProductID Cases...

hi guys, We have a pass through query (to MS SQL2005) which does 'select * from aView' - I know you should specify the fields.... It works fine until you change the columns that are returned by the view and then is broken - it either gives a message about binding or returns the old column...

Hi guys, I am sure this has probably been asked a thousand times but.. I have a simple access app that I have been using on my own and now I need to make functions availalble to less experienced users. I have a report that is built from a query (I learned long ago not to build reports on...