Search results for query: *

Hi I am trying to get totals in Groups but can't seem to get the results I require ** I can't get the ** figure below to get the unique value for each Dept when creating the subtotals in the groups. Dept DeptMax Area AreaMax A 20 A1 5 A 20 A2 10 A...

Hi I am trying to add together the subtotals for a matrix but in the dataset the value appears for each line and I need to be able to drill down into the detail of the report so cannot just summarise in the query .... i hope this makes sense, I struggle to explain whats needed so here is a...

I am wanting to create a timetable in a grpahical format and I would appreciate some pointers on where I could start. To make it easier (hopefully) the periods of time are fixed so for example 9am till 10 am is defined as PERIODNO 1 10 till 11 is PERIODNO 2 etc. Days are 1 to 5 in a DAYS...

Hi I am using Access to create a Timesheet system and using VBA to perform the calcuations, on a daily basis I have managed to calculate the times and managed to get them to display in time format (eg 07:30) for 7 hours 30 mins instead of decimal format (eg 7.50), with a bit of help from some...

Hi, I have managed to link Outlook Calendars into Access but they do not seem to store information such as the date/time of the calendar entry, only the time it was added to outlook. What I am wanting to do is use Outlook as a central planning tool for peoples diaries (shared) but then...

Hi Using Access I am trying to print out documents from Word using wordobj. This works fine until there is a document where the margins are not set correctly and it prompts with an "Are You Sure" message, is it possible to supress these messages and print regardless. Any help will be much...

Hi Is there any way to test the colour of a cell within Excel. The colour of the cell not the text in the cell, suppose both would be handy though. Explanation: We have highlighted certain rows of a spreadsheet in different colours to help identify certain records, we would now like to sort...

Hi I am using an Oracle 9 database and various versions of Access 2000, XP & 2003. I cannot seem to find a way of displaying a JPG or BMP on a report or a form within Access that is held in a Blob field within the Oracle database. I get a blank white box with nothing appearing. I am using...

Hi I am using an Oracle 9 database and various versions of Access 2000, XP & 2003. I cannot seem to find a way of displaying a JPG or BMP on a report or a form within Access that is held in a Blob field within the Oracle database. I get a blank white box with nothing appearing. I am using...