Search results

After having a think, ive realised what i need to do. Instead of using SubB as a parent on SubC I need to make SubA the parent. So if I have [frmInvoiceSub].Form![InvoiceID] as link master field on SubB to link it to InvoiceID on SubA and SubC is a subform within SubB how would i link SubC...

I have a Subform (SubB) on my main form sourcing its Parent ID from another subform(SubA) on the main form.SubB contains a Subform(SubC) displaying records with related information to SubA.i am doing this by using a Parent Child link between SubB and SubC.On SubB there are text boxes to add new...

Makes so much sence now,BOM really solves the problem makes it so easy to find the data i require. If anyone else has a similar problem this is the link to what helped me understand http://www.mvps.org/access/queries/qry0023.htm Thanks for your help

I looked into what you pointed me towards very breifly.but that didnt seem to be the easiest way to do it, i may be wrong but i thought that there would be a more simple way. Stock ID Item name Type # in stock Cost Sell Price Picture location 5 Clubman Link rods 1 5 £15.00 £18.00 6 Rose joints...

Hi, i got back to working on databases again for the first time in years and ive got confused on the offset.I went to set about desigining my tables and cant figure out how to do it.most of its simple stuff however this one bit stumps me. Im designing a database to hold stock information in...

Ok my main form shows like this when i close down any other form that has been maximised over it any ideas why?

I didnt notice that must have forgoten to type it in, you were right :)

Ok ive got one subform displaying details on bikes and i have 3 other subforms displaying well information on the bikes.Repairs,Hires,Other info(All calculated fields The BreakevenPrice when the bike is sold etc)these forms are identicle but ive just added frmBreakevenPrice Subform I cannot...

Ok ive been having this sort of problem for a while. Ive been trying to display updatable and non updatable data in a datasheet form. The problem is that i couldnt update any of the details with a calculated field in the table. Therefore i have put the calculated field in a subform thanks to...

If I switch my form to form view to display the records referencing the subfomr field works fine but then when i put it to datasheet view i get #Error maybe as the subform does not get displayed. But basically it doesnt work.

Ok my fault didnt understand the explionation ive tried it now. im having problems refrencing the field of the linked subform. As everythikng is grouped by BikeID its confused me. I didnt thing i could use the footer to calculate the information because of the grouping.

My problem has now moved on to a form issue which means no one has been able to answer is in the queries section of the forum as there is no way around it using queries so i hope you can help. All information is available on this thread. Thanks, Sci...

I dont see how i can do that as the information is already stored in a subform and the calculation is more complicated than just the sum Ive posted all the relevant forms. so that i can show you what i mean and what end result im trying to get. Thanks again, sci

Thanks for your responce.Im calculating the total hire income and repair cost on each bike + the cost of the bike. Take a look at the database i posted for the calculation, its in Bike Parameters. All this is displayed in a subform in datasheet view the hope is that i would have one non...

I have a query which performs a calculation calculating totals of many fields linked by BikeID This is not updatable due to the calculated field. Now i want to join this query to the BikeDetails table to create a form. So this means that i would have all the data from the table which i can...

Yer i didnt think of that for some reason. Works like a charm now. Thanks for all your help. Private Sub cmdSell_Click() Dim stDocName As String Dim stLinkCriteria As String stDocName = "frmSubSell" stLinkCriteria = "[BikeID] = " &...

I tried that, well i tested that the openargs part worked by putting it into a textbox worked no problem. When i press debug when the error comes up it highlights (Me.FilterOn = True) I doesnt make sence really :(

Ok heres the situation, Ive had to edit a piece of code that worked fine filtering but wouldnt allow me to refresh a subform on the main search form. Now im using OpenArgs to pass the Selected bike ID to a popup form. This bike ID should then be used to filter the pop up form. But i get error...

Ok as far as i know that doesnt work heres the code for the button that opens up (frmSell) Private Sub cmdSell_Click() Dim SearchStr2 As String SearchStr2 = "[BikeID] = " & Forms![frmBikes]![frmSubBikes].Form![BikeID] DoCmd.OpenForm "frmSubSell", , , stLinkCriteria, , acDialog...

frmSell has the button on it, it is the form that pops up to enter the sold price