Search results

  1. Stafford

    Number checking Code insure user input is honest

    Number checking Code to ensure user input is honest I have a Form that my users enter data into that essentially tells me how much work they have done. The Data (PWRA Number) is a 10 Digit number that is always generated from a 3rd Party Program. It is generated with Zeros 1st. These PWRAs...
  2. Stafford

    Calendar search by Month

    I've got a Calendar form that works well enough when I need to run Report/Queries based on the StartDate and EndDate parameters in my query. What I would really Like to do is run a Report/Query where the User simply Selects the Month and Year. I've got my query to display my data in the Month...
  3. Stafford

    Checking a record before entry!

    I've grabbed some code in these forums and have been trying to get this one to work to my liking. I have a form with a combo box and a txt box, I need values in both before the record is added. Here is the code I've used to check for values Private Sub cmdAddRecord_Click() On Error GoTo...
  4. Stafford

    The Calendar, the query the thief and his Lover?

    I've got a form with a Calendar some unbound date boxes and some Command buttons that are to run reports. Now 2 of the Reports are based on queries that require date parameters and a site parameter (BranchNumber) The Problem is when I run this through the form I keep getting #error where data...
  5. Stafford

    Code in a form that finds a Record

    Don't whether to Post in Forms or VBA, here goes. I have a Text box that is a key field, it requires 6 Alpha Numerics. What I would like, is for the User to enter the Key Field in Add Record mode, in The AfterUpdate event (Or any such event that will work) I would like code to search for a...
Back
Top Bottom