Recent content by orna

  1. O

    Mail Merge problem

    This piece of code do it: Set qdDAO = db.QueryDefs!qDependents 'Change qDependents with your query qdDAO.Parameters![EnterContactID] = Me.ContactID Set rsDAO = qdDAO.OpenRecordset Do While rsDAO.EOF = False sFamily = sFamily & rsDAO!FirstName & "; " rsDAO.MoveNext Loop If Len(sFamily) > 1 Then...
  2. O

    Mail Merge problem

    Look at Hartman's grate sample at http://www.access-programmers.co.uk/forums/showthread.php?t=153459
  3. O

    Append Query

    Thanks Bob & Galaxiom I found out that the autonumber is confused and fixed it as Bob suggest.
  4. O

    Append Query

    If I let it, some records can be appended and both ways it dosen't matter to the next time the query is activeted.
  5. O

    Append Query

    Sure not !
  6. O

    Append Query

    I have an append query to a table that has an autonumber as a primary key. Usually it works fine but sometimes it gives an error message says that X records could't be appended becouse of key violation, and evry time the X recordes is different number. After 10-20 attempts the query appends all...
  7. O

    Question Error Message RecordsetClone

    Check the References
  8. O

    Crosstab Query

    Khawar, Thanks!
  9. O

    Crosstab Query

    This is my table Date Shift Type Code -------- ----- ---- ---- 03/05/09 1 A 1 03/05/09 1 B 4 03/05/09 1 W 9 03/05/09 1 W 19 03/05/09 2 A 15 03/05/09 2 B 5 03/05/09 2 W 6 03/05/09 2 W 12 04/05/09 1 A 2 04/05/09 1 B 4 04/05/09 1 W 3 04/05/09 1 W 13 04/05/09 2 A 17 04/05/09 2 B...
  10. O

    Link Outlook AddressBook

    Hi Spaniard The Contacts library is a local . You need to link a global library.
  11. O

    Auto Update

    Use the Wondows' Scheduler. You can copy the queries and modul to a new file and activate it every night.
  12. O

    How to set startupproperties

    I hope it helps Dim prp As DAO.Property Dim bool_ As Boolean Set prp = CurrentDb.CreateProperty("AllowBuiltinToolbars", dbBoolean, bool_) CurrentDb.Properties.Append prp Set prp = Nothing
  13. O

    Question Link to Record in Email

    I took code from http://msdn.microsoft.com/en-us/library/aa163981(office.10).aspx#odc_offtips_topic2 and add to it a shell call with environment variable. Private Sub Application_NewMail() Dim olApp As Outlook.Application Dim olNS As Outlook.NameSpace Dim olFld As Outlook.MAPIFolder Dim oMail...
  14. O

    Active User List

    ldb file is not very helpful. If a user leaves the application and another still in, the first stays in the ldb untill everyone get out. If you want to know who is in the app now then write to a file when enter and when out or white to a table when in and remove when out.
  15. O

    Active User List

    You can write to a file when a user enter the application
See more
Top Bottom