Search results

Hi there, I am trying to export a report of my current record of data. I have set up an output function, but I am not sure of the code of how to set it up so when I hit 'export' on my form, it only exports that one record into the report... Part of the current code is: stDocName = "Satellite...

Hi there, Probably a very easy answer for this... but anyway... :) I was just wanting to know how to close my switchboard after I've clicked on an item? I am sure it is really easy... cheers for the help... Thanks! Leah

Thanks so much Rich.. and so fast! I'll try it at work tomorrow... Cheers, Leah

Hi there, I have looked everywhere but cannot seem to find an answer to this, my apologies if it has been posted anywhere else. I have a database called 'Employees' with which I have the main form 'employees' on the first page and then have three tabs with several subforms on them. I have...

Thanks everyone for your help! Cheers, Leah

Hi there, I am just a little puzzled as to how I can show my field name in my group footer on my report. I have a report which shows Leave for employees, I have grouped it so it totals each leave catetory in its own footer, ie. overtime, annual leave, sick leave etc. I am trying to put an...

Thanks AncientOne, but I seem to be getting the error message 'The Expression you entered has a function containing the wrong number of arguments' Any ideas? Thanks! Leah

Hi there, I am sure there is an easy answer for this... but please bear with me... I have a hr database with a query called 'qrytotalleave', I have several fields on it, two of which are made up of expressions. As follows: Leave Total Hours: Sum(IIf([leave start time]>[leave end...

Thanks everyone for your help! I'll give it a go over the next few days... Cheers, Leah

Hi there, I am a newbie to VB, so there may a simple answer to this... But I will try and explain as well as I can.. I have a table called 'overtime' which I have put as a subform on a tab form after my 'employees' form, so each employee has a form with their employment details and a tab with...

Hi there, I'm a Newbie to programming, so the answer is probably quite straightforward... :) I've created a dialog box with three combo boxes, connected to one query... I wanted the user to be able to click on one selection taking them to a report. Can anyone help me with the code for this...