Search results

  1. O

    Link Outlook AddressBook

    Hi I tried other forms and got no help. I want to give the users to choose an e-mail address from Outlook AddressBook. This table can be linked only to the local Outlook, and when the user get the .mde the connection fails. Is there another way to do it? Or - how can i link this table...
  2. O

    Question Combo Box Question

    Like That Add The third combo to your query . see the pic
  3. O

    Save a form field back to the table on update

    DoCmd.RunCommand acCmdSaveRecord
  4. O

    snapshot viewer?

    Snapshot Viewer is installed with Access. Check your references if any 'MISSING'
  5. O

    Insert Into

    You might want to update date field Update tblStockbook set SalesDate= #" & me!salesdate & "# where stocknumber = me.stocknumber
  6. O

    Front End and Back End

    Check: Tools -> Options -> Advance -> Default Open Mode *Shared*
  7. O

    Dmax question

    Me!WorkOrderNumb = DMax("[WorkOrderNumb]" , "WorkOrders", "left([WorkOrderNumb],4)='" & YourYear & "'") You can write it On the exit button/save button
  8. O

    Code to run at DB Startup

    Insert the code in the first form
  9. O

    Distribute Access

    You need the Access RunTime. In 2002 it is in The Developer Addition
  10. O

    Subfrom text box field size

    On the BeforeUpdate event of YourField: If Len(Me!YourFieldName) > 400 Then MsgBox "Your Message" Cancel = True End If
  11. O

    Access 2002 runtime install asking for Windows NT SP6 installing on Vista RC2 5840

    Change the language on the computer to english before the installation
  12. O

    Date Validation

    Anybody?????????????
  13. O

    Date Validation

    Just for display, usually its a date control
  14. O

    Date Validation

    I'm sure its a problem for a many of us, but couldnt find an answer. Try to prevent from the user to enter a wrong date like "29/02/07" and since Access knows better what it means it turns it to "07/02/29". this expression: IsDate(format("29/02/07","dd/mm/yy")) gives true. Now to the question...
    • orna
    • Thread
    • Replies: 4
    • Forum: Forms
  15. O

    Run macro if table exists

    Dim tbd As TableDef For Each tbd In CurrentDb.TableDefs If tbd.Name = "tblONE" Then DoCmd.RunMacro ("macONE") Exit For Else DoCmd.RunMacro ("macTWO") Exit For End If Next
  16. O

    Disable form design?

    Make MDE file for the users and keep the MDB in secured dir.
  17. O

    Count separate items in report

    Make a query with group by like: Select Name, Count(Size) from YourTable Group By Name
  18. O

    One page report with more than one column of detail

    File -> Page Setup -> Columns Set Number of culumns as 3 and make sure the column size is fit
  19. O

    Import Excel

    DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, "tblWISLR", "c:\paser\wislr.xls ", True,"A2:G300"
  20. O

    runtime error

    Send us your code.
Back
Top Bottom