Search results

I have a table with the following fields: format region rarity they are all set to lookup value lists: format: tape; dvd region: 0;1;2;3;4;5;6;7;8;pal;ntsc rarity: 1;2;3;4;5 I have a check that makes sure (format, rarity, region) is unique. It works fine until i set region to either "pal"...

I need an event for when a text box is updated. Not by the user typing into it, but when VB code or something like Dsum() changes its value automatically. What event can I use? Does one exist for this?

I have posted about this before andhave done some reading, but cant get it working no matter what I do. I have the following forms: SuppierOrderCreateNew SupplierOrderCreateNewSubForm Obviously "SupplierOrderCreateNewSubForm" is a sub forms on "SupplierOrderCreateNew". There is a text box on...

How can i control what happens when a form is closed. Say for example if no order lines have been entered on a sub form, the record is not saved. Also how do you remove the default access error messages about null fields, and replace it with something more user friendly.

Im after some free images for buttons, for my stock control database system. Can anyone recommend me some ood site to look at? Ive searched but have been unable to find anything really suitable. Thanks.

Is there anyway to set differentbutton images for each section of a switch board. Say I have a main switch board with "Customers", "Orders" and "Products". I want each one of these buttons to have an image. However, when you click on "Customers" you go to the customers swicthboard, which then...

I need to trigger an event for when a text box is updated. However, I cantuse on_update() because the text box is updated by dlookup (and on some of my other ones by vb code), and on_update() only works when the user physically enters a value. Which event should I use. If there isnt one, is...

I have this code: Private Sub calcOrderStatus() Dim numLinesAwaitingStock As Integer Dim numLinesComplete As Integer Dim qryResult As DAO.Recordset If Not IsNull(Me.sup_order_number) Then Set qryResult = CurrentDb.OpenRecordset("SELECT...

I cant look at this code any longer. Why doesnt this work: (In a buttons on click event) DoCmd.RunSQL "SELECT product_name FROM Product;" When I enter it in sql view of a new query, it runs perfectly.

In Oracle, you can set up table constraints which constrain data accross mutliple attributes/fields. Can you do this in Access? For example. I have: OrderLine(orderNum,orderLineNum,[productNum],date) I dont want to allow for the same product to be put on one order twice. Therefore...

NEW PROBLEM! :) Sorry for the double post.

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)...

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...

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...

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...

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...