Search results

The data type is text, its too late to change the way it is set up.

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?

Works great thanks. Only problem I have now is when the user clicks on the button to put the data into "productNumber". Every time the button is clicked on I want a newrow to be created in the sub form. Thesub form is in tabular form. Every time the button is clicked I want the value to be put...

Ok, ill give it a try and see what happens. Thanks.

It is a subform within the "SuppierOrderCreateNew" form yes, if thats what you mean. Im a little confused by the question. "SupplierOrderCreateNewSubForm" is a sub form on "SuppierOrderCreateNew". Yes. :)

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.

Right, I see what your saying. Thanks. Ill try it.

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

Can anyone help with this please?

I have a more complex query which returns one value. I simplified it to try and work out why it wasnt working. Is there no way to exectue a query and save the result in a variable in vb? Im so used to doing this in pl/sql, that its very frustrating not being able to just do it in access and...

Right I now understand why it doesnt work. I can see how docmd.openquery works, however, my query returns a single value. How can i store the result of the query into a variable in vb?

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

Why doesnt this work: =CCur(DLookUp("[Supply_link]!supply_price","[Supply_link]","[Supply_link]!sup_number=[Forms]![SuppierOrderCreateNew]!sup_number_combo And [Supply_link]!product_number=[product_number_combo]")) If this does...

NEW PROBLEM! :) Sorry for the double post.