Search results

Ok after alot of reading about normalisation and data models I seem to be none the wiser about implementing my idea. So my question is how do you handle receipt of goods from suppliers if the goods are sent in in multiple orders but they all relate to one purchase order that you have created...

Thanks for the input NigelShaw. Problem is I`m not sure which way to do it now. Just reading up on normalization and I am more confused than ever so I will leave that decision till later once I have this problem sorted. Thanks Gareth

Here is the db Thanks Gareth

ok after implementing the changes you suggested I am still stuck on my original question so maybe if I put it a different way maybe it will make more sense to others rather than just myself. To create a purchase order I open the main form and enter the supplier name(the document no and date are...

sorry jdraw I should have said that some of the suppliers are customers or vice versa so I put them all into in table and had a yes no check box to say wether they are just suppliers or just customers or both. I put them all in one table so i would not have duplicate data. sorry if I didn`t...

Sorry jdraw here it is in mdb format

Im no expert but i think you need to change the openform to open your main form first and then use Forms!FormName!Fieldname for the where clause bit. Gareth

Thanks for the reply jdraw. I have to apologise for not telling the whole story. I do have a products table and an accounts table( containing both supliers and customers ). I have had a look at the data model and I think I have all of the tables but under different names as follows Customers...

Sorry if this is in the wrong forum. I need a little help with the design of the following. I have a two tables setup like the so TABLE 1 (TblDocument) DocumentID (AutoNumber) - Primary key DocumentNo AccountID DocumentType TABLE 2 (TblTransactions) TransactionID (AutoNumber) - Primary...

sorry for the late reply vbaInet. The combo box is in the detail section of the form. I have attached a screenshot of the form which i hope makes sense.

Thanks for the reply vbaInet The decription textbox is a field in the products table that is one of the tables that is in the query that the continuous form is based on. Basically when I select a product from the combobox the description should automatically fill in. The continuous form is a...

Hope someone can help with a strange problem. I have a form setup as a continuous form with 2 combobox and 5 textboxes on it.The form is bound to a query. The combobox is used to select the partno from TblProducts and one of the textboxes is bound to the description field of this table. When...

Hope this is the right forum. I have a worksheet that i use to import a report to and then i run the following code to remove the unwanted lines : Dim x As Integer Dim LastRow As Long LastRow = Range("a65535").End(xlUp).Row Range(Cells(LastRow, 11), (Cells(1, 11))).FormulaR1C1 = _...

Need some help with moving data in excel. I have a report that is imported into excel. I then have the following code runningto bring the data into the right columns : Do If VBA.IsEmpty(Columns(LastCol).Value) Then MsgBox "No data in this column" Else Set...

Hope someone can help with a problem that i cant seem to find a solution too. I have a continuous form for adding products for a certain supplier to a table.(sounds easy) I have a combo box in the form header which is used for selecting the supplier(this works). Once i select the supplier...

Ok i have typed out all the tables i think i need and think i have normalised them but am a little unsure if they are fully normalised could someone just take a quick look and tell me if they are or not. I have uploaded the screenshots. I would also like to know if they are normalised to...

Thanks for the info John. I have attached an updated pic with the changes(ish) that you have suggested i think. If you dont mind can you take a look and see if it is more normalised than it was before. Thanks Gareth P.S I think i understand normalisation but i struggle to implement it...

I have been reading up on database normalisation and just need someone to check my table structure to see if i understood what i read properly. I have attached an image of my tables which i think is right but would like an expert to see if ive done it right or tell me where i am going wrong...

Bob you are a superstar. you are the expert and i am the newbie asking questions that you have probably been asked a million times so you are not getting down on me. I finally got it working with the following code Private Sub TxtSelect1_AfterUpdate() Dim account As Integer If Me.TxtSelect1...

Thanks for the help so far Bob. I am uploading a revised version of the first db that sort of does what i want but it doesnt find the whole record. I can get the second form to open up with only the DocumentNo text bo filled in but cant figure out how to get the whole record. When you get...