Search results

  1. K

    Need to close form, but unload event causing problems!

    This is in reference to some of my previous post, but different, so here I am posting something new! I have a form set up so that the user has to fill in fields before they can exit the form. I have this in the unload event and it worked great until something was brought to my attention...
  2. K

    Set Focus to Previous Form

    I currently have two forms where you enter info into them. You first have to fill out the first form, before you can proceed to the second form. I want a button on this second form that the user can select if they decide that the want to "exit without saving"..... I have code currently set up as...
  3. K

    Duplicate records from different forms!

    I've been reading other posts that are similar to my problem, but I'm still left with a few questions to get me started. This is the post where you can find my source of information so far..... http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=17031 I have three forms...
  4. K

    Value Not in List- Twist!

    This might sound kind of strange, but I was wondering if there was a way to check if an item is "Not in List" without using a combo-box. Here is my situation: I have a field 'Employee ID' on a form, where the employee enters in their own ID number. My problem is that I need something that...
  5. K

    Force input into form's fields

    I thought I had this one solved but I need some advice! I have the following code placed in on my form: Private Sub Form_BeforeUpdate(Cancel As Integer) Dim strMsg As String, strTitle As String strMsg = "Please enter a " strTitle = " Missing Entry" If IsNull(Me![Reason for...
  6. K

    Query to print report

    I've been searching and cannot find an answer to my question! So I guess I'll go ahead and post it. I have a query set up to search for all the 'tags' associated to it's primary key the 'Clearance ID', and these results are displayed on a form where the user can scroll through the different...
  7. K

    option button to print reports

    I have two forms. The first one displays a record and the second one is a 'print page'. On this second form I have five option buttons and another command button at the bottom. I want the user to select which option they want, and click on the command button 'Print', to print whatever...
  8. K

    custom number format

    OK. Here is my problem. I need a number/text (I'm pretty sure I need a text) format that does the following: 02-00000. The first two digits are the last two digits of the year and the last five digits are incremented by one each time a new one is needed. This is what I've worked on so far...
  9. K

    Select record on 2nd form to display in 1st form

    Ok...this is kind of confusing, but I can't seem to find any other helpful posts, so maybe someone will be able to help me! I have two forms. The first form allows user to input information into the database. On this form, there is a button, 'Equip. ?', that opens up another form. This...
  10. K

    number populate for a recordset

    I am very new to all of this, but I need some help! Currently I have two forms. These forms are for entering new data into the database. The first form's primary key is the 'Clearance ID' field which has an autonumber format. After all info is filled into the first form then the user is...
Back
Top Bottom