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 derfloh 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: icoxy
  • Order by date
  1. icoxy

    Query to identify new records

    Hi PHV, It would be good if I had, but unfortuneately I have no control over the source data. The table has an autonumber ID with related data in other tables, so I can't do a complete new import or I would create orphan records in the other tables. I could loop through the new and old...
  2. icoxy

    Query to identify new records

    Hi, I have a table that is updated from an excel import. The problem is to identify any new records that have been added since the last update. It is easy to identify records that have the same key value, but how do you identify the new ones? Thanks Ian
  3. icoxy

    View Subforms

    Thanks folks, works a treat. Ian
  4. icoxy

    View Subforms

    Aceman, I have a form that stays on the screen all of the time (this is the static screen). The form has some buttons that control what is displayed in the subform. I change the contents by equating RecordSource with a form name or some SQL. As you suggest I could save each form with the...
  5. icoxy

    View Subforms

    PHV, I tried that but, CurrentView is read only except in DesignView. Thanks Ian
  6. icoxy

    View Subforms

    Thanks Aceman. I wanted to do this at runtime using vba. Doing it this way will mean I have to duplicate every form - one saved as single form and another saved as datasheet. Thanks, Ian
  7. icoxy

    View Subforms

    Is it possible to change the default view of a subform at runtime. I want to toggle from form view to Datasheet view? I know this can be done using DoCmd.ViewForm, but I want a static view rather than have different windows popping up. Is there a better way to achieve this? Thanks
  8. icoxy

    Using Outlook from Access

    bencar, Have you solved your problem? If not let me know and I will assist.
  9. icoxy

    Accessing Outlook from Access

    Thanks very much.
  10. icoxy

    Accessing Outlook from Access

    Hi, I am new to vba programming and I am using Office 2003. I want to store emails on a network drive using Access. I found a useful start in these forums, but I am having problems. The code contains the following: Dim olApp As Outlook.Application Dim olExp As Outlook.Explorer Dim...
  11. icoxy

    Using Outlook from Access

    Hi, I am new to vba programming and I am using Office 2003. I want to store emails on a network drive using Access. I found a useful start in these forums, but I am having problems. The code contains the following: Dim olApp As Outlook.Application Dim olExp As Outlook.Explorer Dim...

Part and Inventory Search

Back
Top