Search results for query: *

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

...record intContactID = Eval("[Forms]![Contacts]![ContactID]") txtAction = Me.Contact_Name strSQL = "SELECT Contacts.* " & _ " FROM Contacts" & _ " where (((Conacts.ContactID) = " & intContactID & "))" Set Db = CurrentDb Set rst =...

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

May6 I have just got a similar function to work correctly in Access 2002! The only significant difference to your code was that I used a popup form rather than a popup menu and used the Click event of the treeview to record which was the currently selected node. Regards JT

May6 Is it as simple as a minor mistake in your If expression. Try changing it to 'If Button = acRightButton Then' Regards JT

Assuming your report has three levels of grouping (Section, SubSection and Detail) then: - In the Section Header include a text box with a name 'txtSectionNo', and has as its control source '=1', and set the Running Sum property to 'Over Group' - In the SubSection Header include a text box...

This message is for BLBurden If you have set up the database as suggested in my earlier post so that it can look up the user's validated account name, it is now longer necessary to store the password in your database at all because they have been validated by the network log-on. Your Access...

One alternative not mentioned in the discussion so far, is for the Access Application to look up the authenticated user ID that the user has already logged on as. This avoids the need for having a second level of authentication, and means that all the issues about setting password policy...