Recent content by Cassiopeia

The data is in just one table. And what comes to outer join I also tried that but I only got something like this: The wanted "empty" line is missing (Production for Product2) and all I got was the extra rows in the beginning. And as I mentioned, I want all of the four keys to be listed for...

Hi, I am wondering if someone here is able to help me in this matter. To the point: I have a table with some "missing" lines and I want to produce an output that always have the same rows (the missing rows should be included). E.g. As you can see the production for product2 is missing, no...

Thank you, that did the ting. Actually it worked with (if anybody later would be interested): select col1, col2, col3, Standard from Customers1 union select col1, col2, col3, NULL from customers2 /Cassio

Hi everybody, I have this problem: I am using MS Access as a frontend for entering and managing data. The data is stored in a SQL db. In the SQL db i got two separate customer tables which I try to union in a query (view). The problem is that tblCustomer1 has a field called Standard which is of...

Hi, I am trying to customize the toolbars in access reports. I have done a toolbar named User which contains 2 buttons: page setup and print... (opens the print dialogue). (The latter button must be dragged from file-menu, otherwise it is only print to default printer without dialoque, which is...

Does anyone know the answer? Thanx, Cassio

The form itself (the one I wish to open in two different ways) has a button which sets the Is_Delivered field in the tbl_order_head to true. It's a Yes/No field. This field, of course, is the criteria (<> true) when opening the form showing only undelivered orders. It is this criteria I wish to...

Hi! Is there any &quot;open arguments&quot; or similar to run a query? What I want to do is to open a form based on a query in two different ways. One button opens records showing all orders there is and another button opens only the &quot;undelivered orders&quot;. I would like to use the...

I have a Form based on a query which consists of data from Orderhead and customer. I also have a button for adding new customers into the customers table. This is done with an another form. When I close the &quot;addCustomer&quot;-form it returns the customer number to the original form...