Search results for query: *

I need some help linking some reports using the URL commands in CE10. Specifically I wanted some help with regards to using this approach with Active Directory. I have successfully done this with WindowsNT (see URL properties below) and setting the security to secWindowsNT. Can this be done...

Hi Malcolm, I have just discovered an issue similar to this as I am upgrading a CE9 environment to BOXI. Note that my SQL server has not moved as in your case - rather I have created a new BOXI deployment and migrated reports. On the new BOXI server I defined an ODBC DSN in exactly the same...

vaneagle, below is some code that I have used in the past, however I have modified the original code to make it more generic for you. I have used this to consolidate an organisations budget files (over 500) This method assumes you have one WB in which you store the code. A template file...

I want to flag whether a sheet in a workbook has been printed or not. Whilst Excel has a BeforePrint event, I don't believe it has an AfterPrint event. I have a procedure invoked from a button that displays the Excel Print Preview dialog. A user can Print or Close from this dialog. Is anyone...

Does a function exist, or can one be defined that determines the date of the last Friday in a Month?

I have a sales transaction database (SQL Server 2K) with invoices all having an invoice date. Our Financial Year runs 1 October YYYY thru 30 September YYYY+1. I have the following code for Oracle DB, but seek assistance in modifying this for SQL Server. Code is: TABLE_NAME.INVOICE_DATE >= ...

The following code allows you to send a mail message via Outlook, however I want to know if it is possible to send an email via Outlook Express? Does anyone have code samples? Sub SendMail(strMsg as String) Dim OlkApp As Object 'Outlook Application Dim NewMail As Object 'Mail Item Set OlkApp =...

I am creating a mailing label from an orders table. Within the orders table there is a field "Quantity" and amongst others "Customer". A customer may order a quantity of say 3. This results in the need to print out 3 labels (to go on a box for mail-out) and on each label...

Thanks Terry and Rob for your advice, I actually inherited the db (and the particular form in question) from a colleage. The code for the exit button on the form was not closing it properly. When fixed, my code worked every time. :-)

I have been having a problem with a modal form. The form is activated via a module, which in turn is activated via a button on another form. The form itself collects file name and directory locations used by the DIR statement in order to check the existence of input files necessary for the...