Search results

  1. T

    Missing data on forms

    Visible Perhaps you can post your db (without sensitive data) so someone can have a look at it.
  2. T

    Auto Complete!

    Complete Check this link: http://www.access-programmers.co.uk/forums/showthread.php?t=68985
  3. T

    How to get beginning and ending dates of current month

    Date Check this link: http://www.access-programmers.co.uk/forums/showthread.php?t=62570
  4. T

    Date Stamp Problem

    Great You're welcome.
  5. T

    Date Stamp Problem

    Approve I think the control source of the Approved Date Field should be the field in the table or query you want the date to be stored in. Then, in the After Update Event of the ComboBox put something like this: If Transaction Status = "Approved" then Me.Approved Date Field = Date() Else...
  6. T

    Linked form fields

    Fill Check this link: http://www.access-programmers.co.uk/forums/showthread.php?t=68985 Or search the forum, there are so many posts (and answers) regarding this topic.
  7. T

    Resizing database to fit different monitor sizes

    Size Check this link: http://peterssoftware.com/
  8. T

    using Combo box selection to fill other fields

    Search Please search the forum, there are so many posts on this topic.
  9. T

    Dialog box to save data changes?

    Great You're welcome.
  10. T

    Dialog box to save data changes?

    Save Try this in the Before Update Event of the form: Private Sub Form_BeforeUpdate(Cancel As Integer) Dim strMsg As String strMsg = "Data has been changed." strMsg = strMsg & " Save this record?" If MsgBox(strMsg, vbYesNo, "") = vbNo Then DoCmd.RunCommand acCmdUndo...
  11. T

    Combo box to select text box data

    Combo Check out this link: http://www.access-programmers.co.uk/forums/showthread.php?t=68985
  12. T

    TAB -> follow my own order

    Great You're welcome.
  13. T

    how do i set focus

    Focus In the On Open Event Put: Me.TextBox.SetFocus (replace 'TextBox' with the actual name.
  14. T

    TAB -> follow my own order

    Tab In Design View, go to View/Tab Order, or right click on the form and go to Tab Order.
  15. T

    Fields that start highlighted

    Fields Ad a unbound field to the form, set width and height to the smallest size, so you really can't see it. In the On Open Event of the form put something like this. Me.Startfield.SetFocus (replace Startfield with the actual name of the field)
  16. T

    conditional view

    View Use a a Select Query, in which you can specify the division you want to display the records for.
  17. T

    Form open!

    Form Check this link: http://www.mvps.org/access/forms/frm0002.htm
  18. T

    drop down box

    Combo Perhaps you can post the db (without sensitive data), so we can have a look at it.
  19. T

    How to minimizing database window using code

    Window To hide the database window: Private Sub cmdHide_Click() DoCmd.SelectObject acTable, , True DoCmd.RunCommand acCmdWindowHide End Sub To show the database window: Private Sub cmdShow_Click() DoCmd.SelectObject acTable, , True DoCmd.SelectObject acForm, Me.Name End Sub
  20. T

    Help changing default Sort Code

    Sort The proper way is to base forms and reports on queries and sort the records in the query. In the query grid you can sort one or more fields ascending or descending. You can also ad a column (for instance combine two or more fields, or format a field) and sort on that.
Back
Top Bottom