Recent content by ccs2

I have recently upgraded to Access 2010. Previously when using 2003 and I wanted to SUM items in a list on a report I created a Group Footer and applied a formula in a text box like this: =sum([Price]*[Quantity]) Try as I might I cannot find a way of inserting a Group Footer in Access 2010...

Thanks oldnewbie - it works! Cavan

Don't know how to set the autoplay properties. Perhaps that's where I'm going wrong! Cavan

No I have not set to autoplay property in the player's parameters. To be honest I don't know how! Cavan

In answer to your question I am not using a custom netStream player. The player is a Flash component. I have emailed the .fla file to your hotmail address. Otherwise check out the site at: www.jackalcreative.co.uk .....and click on 'Music Video' thanks Cavanhttp://www.jackalcreative.co.uk

I have a website done in Flash and one of the pages has a Flash FLV player which I put in using Flash. I want the player to be paused when the page loads so that the user is given the option of clicking the play button on the player (if you see what I mean!). Cavan

I have set a field as OLE and got the bitmaps. I have a form and subform based on a select query. The OLE field is part of the subform. I want the photo to appear on the main form each time a record is selected in the subform. In an attempt to do this I have put the OLE field in the footer of...

I seem to have cracked this by setting up a SwimTotal field in the Selection table with a Data Type, Number/Long Integer. Then I set up an Update query as follows: Field: SwimTotal Table: tblSlection Update to: DateDiff("s",[SwimStart],[SwimEnd]) This calculates the time in seconds (s). You...

I want to use the DateDiff function to work out the time interval between a start time (e.g.10am) and an end time (e.g. 10.35) in a race. Can anyone help?

Thanks Ian, I will give this a go. Cavan Stewart (UK)

I do have a form based on a select query with the following: From tblLoanID: LoanID, Date, CustomerID (foreign to tblCustomer) From tblCustomer: FName, LName From tblLoanList: LoanListID, Product (foreign to tblProduct) From tblProduct: Title, Quantity, Price How do I do the ‘no matches’? CCS

If I have a dbase that issues items for loan such as DVD's or books how can I prevent the same item being loaned out more than once. I have four tables: tblCustomer, tblLoans, tblLoanList and tblDVD's Do I need something to delete these records after they have been assigned? CCS

It works!! Thanks for your help. Cavan

Thanks, I had already suspected Dlookup from random searches but was unsure how to implement. Do I put this coding into the Properties for the text box on my form? Cavan

I have a DVD rental dbase which has four related tables: tblCustomer, tblCustomerLoan, tblLoanBatch and tblDVD. The main data entry form (frmCustomerLoan) is based on a select query (qryLoans) using a subform (frmLoanBatch Subform) for DVD's taken out by a customer. I have created a query...