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

Thank Geoff, rownumber may be the way forward as I have detailed data in the query and not summarised. Regards Tony

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

Thank you all for your valuable posts, they have been most useful.

Thanks Hans8823 but again this version returns a decimal value of 37.08333333 instead of 37:05 which is whats required. I need the user to see how many hours and minutes they have worked without them having to work out what .083333 is in minutes. Thanks anyway. Tony

Hi Crowley16 Thanks for the post. While I was just replying to you I had a flash in inspiration and I have just written this bit of code and it seems to do exactly what I require. Hopefully this may help others as well. I haven't tested this fully but it seems to be ok. Instead of using the...

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 You could also have a form running as hidden in the back ground of your application which has a timer event checking every minute for values that meet your criteria and then popping up a message box. Cheers Tony

try a text box which looks at the staff table JOBTITLE is the field you wish to display STAFF is the table that holds the information STAFFCODE is the staff code reference in the ref table ME.STAFFCODE is the value held against the combo box on your current form...

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 Sorry for the slow replies but don't ave much chance to view the forums at the moment. Not sure about where to check for thisngs like that, this was just something I had to do myself, the details on baud rates etc were actually with the till drawer I was working with. If you need any help...

Hi I use a Macro and use the RunApp command and point it to the batch file. Regards Tony

Hi I have done something similar, which is to create a batch file on the pc which will open the drawer containing the following 2 lines mode com1:9600,n,8,1 echo PleaseOpenMe > com1 The first line set up the com port so the till can communicate with the PC, the second line sends any sequence...

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

Superb Thanks, lots of toys to play with :)

Hi gizmo1973, thanks for the post but I am afraid i cannot seem to find it. If you have a more direct link it would be greatly appreciated. Regards Tony

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

ssecca is right, if you open the report you can Export it to the filetype of .SNP This can then be opened by any machine that has the Microsoft Snapshot viewer installed.

Hi I wrote something similar which you may be able to work with that adds seconds onto a time, if it goes over 24 hours it displays it correctly. Hope it helps Function Time_Add(Time1 As Date, Dur_Secs As Double) As Variant 'Written by TS 20/12/2004 On Error Resume Next Dim ds1 As Double Dim...