Search results

I have table with the functional dependencies shown above. I would like to know if it is in 3rd Normal Form. I think it is. The table stores data on DVDs and Tapes. Format = "Tape" or "DVD". Region is either "1","2","3" or "0" (If format is DVD) or "PAL" or "NTSC" (If format is Tape)...

Ok, ill try to work round it like that then. :) Thanks.

Great thanks. Ill give that a try. :)

Yeah, thats what I did. There is nothing there called "moveable". Yeah, I know you can do it this, way, look at my original post. However, i want to keep the title bar at the top of the form, so I can set the borders to "none". I was looking for another way to do it, but cant seem to use the...

You can open a form at the row you selected in the list box. By doing this: DoCmd.OpenForm "FORM_NAME", , , "[PK_OF_TABLE_TO_FIND_RECORD_IN] = " & Me.LISTBOX_NAME As for referencing a coloumn in the list box, and saving that into a variable, I dont know. I need to do a similar thing. I need...

I need to pass a value to a form, so that it knows what form opened it. Then I need the form to reopen the form that opened it. For example. Product Enquiry Product Edit Are both forms with buttons that open "Search form". Search form has a button, which opens a form, at a specified record...

I dont have that option on the format tab. Is it because I am using Access 2000? :(

I have a search form, that can be opened by both my "product_enquiry" and my "edit_product" form. When you select a value on the product search form, i want it to open another form at a specific record. Easy you might think, but what If i want it to work out which form to open. So if: A...

Is there anyway to stop the user from beng able to move a form. I.e. as in change its position on screen. I am aware that you can do this by setting the border type to "none". However, I want my form to have a title bar along the top, so I cant use this method. Is there another way to do this...

I have the following query, which I know works. The query is called "products_due_in_query" SELECT Sum([Supplier_order_line].[quantity]) AS [Due_in] FROM Supplier_order_line WHERE (((Supplier_order_line.order_line_status)="Awaiting delivery") AND...

I need to have a form which has a series of blank text boxes on it. I then need a subform, that has all of the text boxes as above, in datasheet layout. I then want to be able to type values into the text boxes on the main form, and have the user then click a button. If any records exist with...

OK, I basically now need to do exactly why Wayne helped me do, but I want to put the result in a text box, not in a combo box. How can I do this? I guess I need to change: Me.product_numbers_combo.RowSource But I cant find any information on what to change it to. Thanks in advance.

Yep got it working. Thanks a lot. Ive got a similar new question: I have an order details sub form. I want the price of the item on the order details line to be shown. The price is stored in the Products table. I allready have the product_number in the sub form, so ive made a query that...

OK, got it working. Thanks. Im not sure what event to put it on. click doesnt seem to work, and get_focus only works for focus change on the subform.

I have a form with a combo box (sup_numbers_combo), which has a list of supplier numbers in it. (on a master form). In a sub form, i then set the row source for a combo box (product_numbers_combo) to this: SELECT [product_number] FROM Supply_link WHERE...

For some reason, all of a sudden, my combo box wizard wont work. When ever I try to make a combo box that determines a forms record from the combo box choice, i get an sql syntax error. The wizard gets to the screen where you choose your fields, I choose them click ok then it tells me there has...

Ill give it a try.

I want to order the data on a tabular form. I realise I could do it by basing the form on a query like: Select * from table order by field But I have allready made andlaid out the form, after basing it just on the table. Is there a way I can now order the data on the form, after having...

SJ: That didnt work. Brian is right about the problem. However I dont understand why end_status needs to be a part of the aggregrate. I will try what you suggested Brian. EDIT: Do you mean like this: SELECT end_status FROM Order_status_history WHERE [order_number] = 39 AND EXISTS...

SELECT Max(date_of_status_change) as [date_change], end_status FROM Order_status_history WHERE order_number = 39; I cant get the above query to work. All I want it to do is pick out all the rows where the order_number is 39. Then select the one which has the most recent date_of_status_change...