Search results

many thanks for the advice, but how do i change the extentions form mdb to mde.

Hi i have done a database and was wondering if there is a way you can hide the forms and also dont allow people to click on design form. I want the users only to see the forms and prevent them from touching the back end of the database i.e. the tables etc many thanks

Hi thanks for the reply i have added a copy of my database. the form you should see is called frmaddpart. many thanks i have taken the code you gave me on that one. many many thanks for all your help

Hi RichO many thanks for the reply I have tried to use the code you gave me and all i got was an error# sign I have updated picture of the table and the form. Basically how it works is i have a subform on a part forms. the subform is basically a list of the prices different suppliers have...

Hi thank you for the reply. If you have a look at the picture it will explain what i mean. I have a table which has a unbound field on it which calculates the minimum price is there anyway based on the minimum price i can also show the lead week of the minimum price row. Sorry if it is a bit...

hi i am doing the following update query to update prices UPDATE PartTable SET PartTable.[Selling Price] = (([PartTable]![Mark Up]/100*[PartTable]![Guide Cost])+[PartTable]![Guide Cost]) WHERE (((PartTable.Category)=[Forms]![FrmCategoryEdit]![Sub Category])); but for some reason when i save...

many many thanks i just worked it out earlier but thank you for helping me.

Hi i have a form where i can search for parts in the database. However the form ( please check the attachement) is done using radio buttons which u click on to enable different searching methods. Is there any way when you click on another radio button the previous drop down box can be set to...

Hi thanks for the reply mate, what i am trying to do is at present i have a table with data on suppliers who can supplier a specific product. Each supplier has a price and lead week. I have a added a field just on the form and set the control to =min([price]), this works fine but i now need...

hi i have a form containing data from different suppliers. Each supplier has a supllier ID, Name, lead week, price. Based on the lowest price is there away i can send data to another field showing the lead week. The lead week is that of the best price I have tried endless amount of ways to do...

hi many thanks both the replies what i mean in order to put the code in to the field i changed the control source i have added a picture in design mode to explain what i mean as you notice because i have changed the control source the data no longers saves onto the table (rsms Part No)only...

Hi i asked a question couple of days ago where i wanted to know if there is a way you can get a primary key byt adding two different fields togeather. i was told to use the following code =[IdentifierCode] & "" & [item No] which worked fine but i have realsied that as i have changed the...

Hi many thanks for the reply, I have tried to do what you said using the following code Dim lead_week Me.text12 = text12(Me.SupplierChoiceNu, lead_week) Me.lead_week = lead_week End Sub but it come up with an error messgae. I have attached another screen shot this time...

Hello I have a query regarding data from a sub-form being transfered to a main form. At present i have a part list and a subform which holds prices from different suppliers. The cheapest price shown will automatcally be selected as the best price and will be shown on the main form. This part is...

To Mike many many thanks worked a treat kabir

Hi i was wondering is any way where you can add two fields up (chracters + numbers) to get a part No . i have attached a screen shot of the table i am trying to do. many many thanks kabir

Hi I have this problem where i have a part list and a category table, which are both linked. How the price of the part list is done is based on the category i choose, the category has a percentage value which is linked to the part table. This is then calculated by the price of the part and...

Hi many thanks for the reply, I realise the field is not bound to the table hence it does not save to the table when clicking in save. But the field gets its data from another field in the subform. I was wondering is there a way the field could save the data, so it can be used elsewhere. I...

thank you both for your help much appreciated

Hi i have three tables(see attachment) which help make the Part table list. The Supplier table gives the best price a item should be sold for, this is then defaulted to the Part table as the price to sell. The supplier table also has a percentage increase field where if the percentage is...