Search results

Hi I have a database (access 97) of training sessions which each has a date field called "Duration" (this field is in short time format HH:MM). I'm trying to and create a crosstab query which has the locations on the left and a total duration time for each month. If I try to sum the date...

Hi This may be a no brainer, sorry in advance if it is, but I've just searched this site and the net and access help with no luck so far. I've just recently upgraded to access 2007 a few days ago and want to hide the filter button (and possibly the search field) next to the navigation buttons...

Hi I'm trying to configure the prtDevMode to do duplex which I have got working in the MDB, but from what I've read so far (Link ) it appears you have to open the report in design view to get at these settings which I cannot do when the database is compiled into an MDE. So microsofts work...

Hi I'm trying to lock a cell on an excel template, but from access. The Excel template is not my own and has 2 buttons which lock the upper and lower half of each sheet prompting the user to enter a password. I want to populate the upper half from access and lock those cells automatically...

Hi, I'm trying to update some Checkboxes which are in an Excel sheet, but I'm trying to do it from VBA in a public sub I have created in an Access Module. I have linked the Excel sheet and can change the cells using queries, but this will not change the checkboxes. I'm running Access 97 and...