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!

  • Congratulations Mike Lewis 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: *

  • Users: ANDYM
  • Order by date
  1. ANDYM

    Embedding Objects

    Not hyperlinking. I actually want to be able to view the object from within my form as a viewer so that I can cut and paste into my form.
  2. ANDYM

    Configuring Database options

    Thanks for the reply. I didn't make myself clear. I want to do this in code not thru the dialogue box. If this is what you are suggesting then I do not understand what you mean so would appreciate expansion
  3. ANDYM

    Configuring Database options

    I would like to set the value of the "Replace text as you type" tick box in the Tools>AutoCorrect dialogue box. Can't seem to find a property to do this. Would appreciate any feedbacl/solution from anyone Thanks
  4. ANDYM

    Embedding Objects

    I want to be able to view an external object on my form. For example, a WORD or WordPerfect document or Excel sheet Any suggestions would be more than appreciated.
  5. ANDYM

    New Record in a form

    Have tried your suggestion as in the following with no success. Private Function RefreshEmployee(EmployeeID As Long) On Error GoTo ERROR_HANDLER Dim stLinkCriteria As String stLinkCriteria = "SELECT * from Employee WHERE [Employee id]= " & EmployeeID & ";" ' the following...
  6. ANDYM

    Automatic record insert

    I have since found that the CuurentRecord becomes available in the On_Current event. I still have concerns as to why in some instances currentrecord is set to 1 when no record is selected with the form. Loading a form with an empty dataset seems to have a setting of 0. More info later
  7. ANDYM

    New Record in a form

    Thanks I will give this a try later. Did try setting Me.Filter with new criteria string and then Me.Requery but this did not work.
  8. ANDYM

    Automatic record insert

    When a form is opened and the object recordset contains no records, a new record instance is created. It becomes real as soon as a field is initialized either thru a default value defined in the table or direct setting. As a result blank records can be left in a table in the event of Exitting...
  9. ANDYM

    New Record in a form

    I open a form with a criteria which selects a record. When in this form I want to change the current record Is there a way of changing the record without closing the form and reopening. e.g In form then strlinkcriteria = NewEmployee Docmd.close Docmd.open "Employee", , ...
  10. ANDYM

    Automatic Email using Groupwise and MS Access

    email is andy@mtechnologies.co.uk No problems at our end so try again.
  11. ANDYM

    Automatic Email using Groupwise and MS Access

    I have not tried what you are doing however we have integrated Groupwise Mail and tasks into our recruitment system without any problems. A bit of a pain but if you want the code for this please e-mail me at andy@mtechnologies.co.uk and I will happily send you the VB module that you can...
  12. ANDYM

    Access and Outlook integration

    Drew If you wish to send me (andy@mtechnologies.co.uk) your e-mail address I will return you some code which will allow you to do exactly what you want. Andy
  13. ANDYM

    Error 3167 Record is Deleted

    We have a multi-user database, where users are encountering Error 3167. After acknowledging the error the system continues as expected. No delete facility is available to the users. The error is occurring when a search is done OR a save and even the print option is taken. There are NO deleted...
  14. ANDYM

    E mail attachments in Access

    Does anyone have a solution which will allow a non Access Object, say a Word Document, to be e-mailed from within an Access/VB application.
  15. ANDYM

    background color of a table row

    On a continuous form, if you select a field in an given row, is there a way you can set the backcolour of that row to a different colour than the other rows.<br>

Part and Inventory Search

Back
Top