Search results

  1. T

    Password Protect Backend

    Protect You can put a form in the BE with a password protected Command Button that either opens the Database Window or closes Access. Ofcourse you have to hide the Database Window when Access opens. In addition you can hide/unhide the toolbars.
  2. T

    open report with record from form

    Current Check this link: http://www.access-programmers.co.uk/forums/showthread.php?t=87064&highlight=print+current+record Or search the Forum, this is a frequently asked question.
  3. T

    Access Quick Learning

    Learn Check this link: http://www.microsoft-accesssolutions.co.uk/index.htm
  4. T

    Lost-How to search forms

    Search There are some nice example db's around containing search functions. Please search the Forum.
  5. T

    2 forms ; one table?

    Forms I don't know why you want to do this, but it does not seem logical to me. Please explain further what you are trying to accomplish. Most likely you need only one form.
  6. T

    Sub Form problem

    Tab Try something like this: Forms![Mainform]![subform]![Control].Visible = true
  7. T

    find record

    find Search the Forum, there are several excellent examples for searching records.
  8. T

    two problems with mandatory fields in forms

    Mandatory I think it's better to put some code in the Before Update Event of the Form to check for empty fields. There are several ways to do this, please search the Forum, there are several examples available. Or check this link: http://www.microsoft-accesssolutions.co.uk/required_data.htm
  9. T

    YesNo on Form

    message Dim strMsg As String strMsg = "An e-mail has already been sent to this customer.& vbCrLf & Are you sure you want to send it again?" If MsgBox(strMsg, vbQuestion + vbYesNo, "") = vbYes Then type here what you want to do Else 'do nothing End If
  10. T

    Populating forms

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

    Automatic Date

    Date Double post!
  12. T

    Automatic Date

    Date Use a Date/Time Field and set the default value to: =Date()
  13. T

    Limiting text in a memo field

    Memo You're welcome. :)
  14. T

    Limiting text in a memo field

    Limit Text I assume you are using a form. In the On Change Event of the Memo Field put something like this: ****** If Len(Me.Memo.Text) > 10 Then Me.Memo.Text = Left(Me.Memo.Text, 10) MsgBox " You reached the Limit!", vbOKOnly, "" Exit Sub Else End If ****** Replace '10' with the...
  15. T

    Week number of the current Month

    Week Number Try this code in the After Update Event of the Date TextBox or the On Click Event of a Command Button: ****** Dim t_Day As Double t_Day = Day(InputDate) Select Case t_Day Case 1, 2, 3, 4, 5, 6, 7, 8 Me.txtboxweeknumber = 1 Case 9, 10, 11, 12, 13, 14, 15, 16...
  16. T

    Re: Syntax for textalign property

    Align You're welcome. :)
  17. T

    Re: Syntax for textalign property

    Align Try this: Me.myField.TextAlign = 3
  18. T

    Please help with window order

    Report I just tested it with your db, and it works. I changed the changed the setting for you, here's the db.
  19. T

    Please help with window order

    Report Open the report in Design View. Go to Properties, on the Other Tab set Popup to 'Yes' That will do it. If you also set Modal to 'Yes' on the same Tab, the Report will keep the Focus until it is closed.
  20. T

    Dynamically Generate Customized Report

    Report May be this will help: http://www.fontstuff.com/access/acctut19.htm
Back
Top Bottom