Search results for query: *

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

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

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

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

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

When you load excel the first thing you see is the excel graphic telling you what it is. Is there any way of substituting my own graphic?

How can I get Access to show the day of the week after selecting a date? CCS

I want to modify an input mask in an access form so that it only accepts dates between today and 3 months in advance. Please help. CCS

I have a dbase that records the loan of instruments to band members. Each instrument is recorded in the Instrument table and is, of course, unique. When one is loaned out and recorded in the loan table I want it to be automatically deleted from the Instrument table. I can live with having to...

Please can you help? I need a query expression that will return all record that are more than 3 years older than today. Cavan

I have a database on club members and I need to generate a report on their attendance at events. This is fine except that I want the report to show attendance of members at each event on a separate page. It did occur to me to run separate queries for each event and then base the report on these...

Can anyone help me with the code to insert one????

I need a little java script attached to 'Close Window' text on a web page which will do just that, rather than require the user to use the cross button in the window corner. Can anyone help? ccs

I recently converted a dbase which worked fine on Access XP but on conversion to 97 I found that my append query would not function. The error message told me that I had either typed the expression incorrectly that it may be too complex. The query is simple enough as it asks the dbase to...

Does anybody know how to restrict access to parts of the dbase by password protection on a button, best of all on the switchboard? Cavan Stewart

I'm using Access XP and have followed instructions for making mde file as follows: open tools / make .mde file option; in the dialogue box indicate the dbase you want to convert to mde...click make mde; in the next dialogue box enter a name for the new mde file and store. When I do all this...

I have a list in a tabular form showing bookings called frmEdit/Delete which I have set properties to prevent edits. I want the user to be able to select a record from the list then go to another form called ,frmBookingsEdit, in Columnar format to edit the individual record. At the moment when...

I have small database which is used for booking hire cars. It has a few append queries that run through macros to get rid of bookings that are now out of date. However, everytime I load the database I get a series of annoying messages asking me if |I really want to do this. Is there a way of...