Search results

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

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?

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

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

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 heres the situation, I have one form(frmBikes) that i use to filter the results in a subform(frmSubBikes). From the main form i have a button which opens another form(frmSell) which allows me to enter the sold price and when "cmdSell" is pressed many delete and append queries are run on the...

Ok heres the problem, i seem to have a little bit of a mind block at the moment so help would be greratly appreciated. Basically there are two tables involved, tblBikes (which contains all information on the bikes) and tblHires (which contains all the information about hired bikes) these are...

I have two tables linked in this query. The tblStaffHours and tblStaffDetails The tblstaffhours contains the hours worked and the date in which those hours are worked and tblStaffDetails containg all the staffs information including Hourly Rate . I tried to run a query that would add display the...

Can you work out whats wrong with this I used the sample database password system and tried to add a button to enable the user to change their own password. The problem was at the time that the change password form must open displaying only their own username, this is where the complication...

Ok here goes I have a database containing many used ATVs (ive gone over what ATVs are alot to certain ppl **cough**Mile-O-Phile**cough**:) it is 4wheeled off road bike with an engine) what I want to do is post on the website many columbs of the database includinc a picture file. The web site...

Heres the situation, im making a web site (one that is layed out like the columnar report from the wizard) using data stored in an access database including a photo of the item I need to sell, would it be easier to store the picture as an OLE object in the database or save the picture location...

I have two databases for the running of a ATV shop, the stock lists and the sold items. Each Database contains the following fields. Stock info: Ledger refrence Stock No Location Make Model 2wd/4wd Frame no Gears Year Hours Kilometres Cost Price Repairs Hire income Actual cost...