Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. JTregear

    Finding and Updating Files containing VBA

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

    Column Headings/Report Setup

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

    Sending OWA Emails from Access

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

    Sending OWA Emails from Access

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

    Navigating between forms

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

    Exporting to Excel Automatically incorrectly formats some data

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

    Exporting to Excel Automatically incorrectly formats some data

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

    Invalid Index Definition

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

    Progress Meter possible?

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

    Tick (and cross) control

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

    storing sensitive information ie passwords

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

    access97 to access2003 conversion

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

    2 subforms need to synchronize

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

    MS Access Security

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

    Form query -positioning the cursor on a specific field.

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

    Popup Menu of Right Click on a Treeview

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

    Popup Menu of Right Click on a Treeview

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

    Outlined Formatted Access Report

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

    Using Form As User/Password Validation?

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

    Using Form As User/Password Validation?

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

Part and Inventory Search

Back
Top