Search results

Hi i am trying to do a query where i can search for a part using more than one criteria i.e. Material description or Part ID. Does anyone know how i could do this. Many thanks I was thinking of using the Apply filter button but i reckon there must be a better way of doing this task thank you...

cheers mate works fine thank you

Hi on my database i have a order amendment form where if any changes are made to an order, the order amendment check box ticks it self. This works fine, and is very useful when printing a order change report as the query just looks for all "yes" for order amendment but i have been told that a...

Hi i am trying to do a function on my database where when an order is placed and it is then required for the order to be amended it can be done however the reason why, person authrised it etc must all be recorded. I have been using the tables (check attached pic) and can not link the Order...

Hi i am doing a access database and this may sound stupid but does anyone know how many people can use an access database at any one time. I would like to use the database in a network and just wanted to know how it works as i am not too sure many thanks kabir

hi many thanks for the reply, the dialog form is opened with no openform method. if i was to do the way u said how would i do it as i have no idea thank you for help

Hi i am trying to do a dialog box version form(look at the attachment will explain) however when i adjust the size it works fine when i exit the database and reopen it. But when i click on another form that is set to maximse on load and then close that and try open the dialog box the form...

Hi i am using the following VB code as a afterupdate. but once i save it and then try select something from the field i get the following error messages(please refer to attached documents) any idea why this is doing this. luckly i have a backup copy but when i delete the damaged copy and do...

hi many thanks for the reply, the reason i did not link the lowest price on to the price on the main form is because i have to change the control source and because the control source is changed. it does not save onto the table. The only way i have managed to get past this problem is to have...

Hi thanks for the reply. Im not sure if i have explained my self properly. The price and price to sell on the main form should update it self once the subform has chosen the cheapest price. however this does not work. if i edit the pencentage increase field on the main form then tab it the...

hi the subform is refering tot he parent form. Sorry for the delay in replying. here is a screen shot

Hi i have a form and a subform. the subform has prices and the then the main form shows the lowest price and totals that against a percentage increase to sell to customers. what i have done is done a after update code on the subform but keep getting an error on the code. here is the code im...

HI i am doing this form which in linked to a subform. the sunform contains values for items. The lowest price for an item is shown on the main form as the price to sell. However as the price to sell field is controlled by the subform when i save it. It is not saved on the table. I was wondering...

Hi im a bit confused as to what you mean, If you look at the attachment on the first post, I am trying to do a form where users type in data into the main form and sub form and then based on the four rows on the sub form i can work out the cheapest value of an item Hope this help, thank you...

cheers mate thanks for trying

Hi what do you mean in the query for your form select top...4 the form i am using is used for data entry and the submenu is related to the main menu. the sub menu is a table of data and i was trying to make the table only show the first four colums and no more. I do not want users to type in...

Hi i am doing a form which has a submenu in it. The submenu consist of a table and i was wondering if there is any way you can limit the list of the submenu to only four rows. Many thanks i have added a screen shot kabir

Problem Hi i have tried what you said and i have looked at the help sheets and i still am no closer to trying to get a query to give me a total sum. At present the query i have done only calcualtes two fields from one item and this is then the result is shown. Here is my SQL SELECT...

How do i do a total query.

Hi i have attached a screen shot of the four tables i am trying to calculate. At present when i do a query for one of the tables. i get a list of all the items and the total for each item. However i am trying to do a query where i get a overall total for each table. If you know what i mean...