Recent content by JTregear

I am working for an organisation who is in the process of moving a large number of people who are using a variety of versions of MS Office to a new unified infrastructure, using Office 2003. One of the problems that they know they will have is when users try to run macros which used to work on...

If you set paramaeters in the crosstab in the subreport for all possible years then the report will work, but you will then need to hide those years that you are not interested in

Here is the code I have previously used to create emails from within Access. I hope that answers your question. [Code] Public Sub CreateEmail() Dim Db As Database Dim rst As Variant Dim strSQL As String Dim intContactID As Integer Dim strContact As String Dim strFirstName As String Dim...

In previous applications, I have used the Outlook library to create emails which can be sent via MS Outlook. I would now like to be able to send emails via Outlook Web Access (OWA). What library should I use or how else should I create such emails within MS Access.

If you are opening the second form each time that you press the Process button, an alternative would be to pass the client ID as an OpenArgs option so the calling line would be: DoCmd.OpenForm stDocName,,,,,,strClientID In the Form - Activate event for the receiving form you can then test for...

The report is output to Excel by using a command such as: DoCmd.OutputTo acReport, stDocName, acFormatXLS The Excel spreadsheet is therefore created when exporting to Excel, so unfortunately it cannot be pre-formatted.

I have a number of Access reports which display data in the format #.#.# When I export any such Access report to Excel, Excel thinks that such information is a time, and automatically converts it a time and then displays the information as a number, so for example, a field which was originally...

I developed an Access Database some time ago which links to a number of tables in an SQL database as a series of linked tables. After linking to each table my Access Database then runs a series of Data Definition Queries, such as: CREATE UNIQUE INDEX _uniqueindex ON ASSET(CLASS_ID ASC...

Try this link http://www.mvps.org/access/resources/downloads.htm Look down the long list of useful downloads, and you will find one called ProgressBar. I have not used this one myself, but I have used some of the other utilities and found them helpful.

One alternative I have used and found works extremely well is a ActiveX control which can be bought from http://www.zealsoftstudio.com/. It is not free but it does improve look of the resuliting applications significantly.

If you want to see how to implement SHA 256 you could take a look at http://www.cr0.net:8040/code/crypto/sha256/ Regards JT

This behaviour is by design. See Microsoft KB 825765 The easiest way around it is to turn on the display alerts, by including: wrdApp.displayAlert=wdAlertsAll before you open the document. The user is then prompted to link to the data.

Debbie Why not try using a Tab Control. You should be able to put some of the controls on one tab, and further controls on the next tab. It is a neat way of getting a large amount of information on to a single form, and so no need to synchronize the forms. JTregear

Luckire Please see the following thread. http://www.tek-tips.com/viewthread.cfm?SQID=442005&SPID=702&newpid=702&page=1 It gives details about how to secure Access Databases. It also includes references to external sites which show you how to look-up a the user ID of someone using the...

Try SetFocus property In the OnCurrent event include: Me.txtField.SetFocus