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!

Recent content by noonan1

  1. noonan1

    Date query

    I have a project deliverables table with a field called due date, i need to query this table so that values appear were the due date equals todays date. I am unsure how to do this and would appreciate any help you could give me, thank you in advance.
  2. noonan1

    Logon form not closing after Password Authentictated

    When I placed the DoCmd.Close line in the code, I got the following error message "The action cant be carried out while processing a form or report event". The reason for this may be that when the user logs on they must select a department(from a field also on the log on form) and...
  3. noonan1

    Logon form not closing after Password Authentictated

    I have a logon form that checks user id and password, once you click the login button a new form should open called "frmWelcome" and the "logon" form should close.The problem is that when a users password is authenticated the welcome form opens but the logon form does not...
  4. noonan1

    lif function on reports

    I have three check boxes on my form called medium type, you can only choose one of the checkboxes. If email is checked the value of 1 is entered into the table. If meeting is checked the value of 2 is entered into the table. If phone call is checked the value of 3 is entered into the table...
  5. noonan1

    vbYesNo - values for Yes and No options

    Anyone know what the values are for the Yes option and the No option on a Msgbox using vbYesNo. Thanx in advance
  6. noonan1

    increment number with command button

    Thank you all for your help the problem has been resolved using Dmax as the default value for the issue item number.
  7. noonan1

    increment number with command button

    I have a project input form with project id as the primary key in the table where the values are stored.The id is a number and I would like to be able to add a new id by clicking on a command button that would automatically increment the last value entered.Id really appreciate it if you could...
  8. noonan1

    find record question

    I have a form with a combo box listing project ids (1,2,3 etc..).I want to be able to select an ID and then click on a command button to open a form called Action_Items with the specific record relating to the id selected showing.Eg if I select project id 1 and then press the command button to...
  9. noonan1

    Customised autonumber

    Ill try that straigh away Darrylles and let you know how I get on, thanks for your help.
  10. noonan1

    Customised autonumber

    I have a project id number field that must contain project codes begining with P and 5 characters in length (this has already been validated for in VBA).I have a button for new projects, when button is pressed I want the number to generate the next value eg:if first project number is P0001, once...
See more

Part and Inventory Search

Back
Top