Search results

  1. K

    Force input into form's fields

    Thanks for your reply Jeff, but I don't think you caught onto my question. I figured out how to tackle my first post, about canceling the closure of the form if a field is blank. Now I am trying to do a similar thing to another form, where I want the user to have to fill in certain fields...
  2. K

    Force input into form's fields

    Anyone? I just need help with the last post of mine!! I'm up for any suggestions!
  3. K

    Force input into form's fields

    Ok I have this problem solved.... Nateobot Thanks!!! But, then I went to one of other forms, where I have basically the same code (with different field names) in the BeforeUpate event, and I can't seem to get it to do what I want. I want the user to have to fill in these fields too, before...
  4. K

    Force input into form's fields

    I know my code for the empty field works fine......except for the fact that it doesn't cancel the form 'closing'. Do I need to put this code in an Unload or OnExit event?....so that the user can go back and fill in the blank field before the form closes? Is there something I need to have in my...
  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

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

    I'm sorry it isn't convincing for you. Let me clarify..... the Equipment table has the following: Equipment ID, Description, Location, Area Code, Plant, and Position fields, but the Clearance table only has the Equipment ID field (and none of the other Equipment fields on it) along with other...
  7. K

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

    These are bound controls (on the first form). And yes I know this would duplicate data, but it is for a good reason. I have a table set up for just the "Equipment", this data cannot be changed. Here there is the equipment ID, the description, the location, etc.... And this is where the query...
  8. K

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

    Old post....I know....but I still need some direction or ideas!! Does anyone have any suggestions? Simply I want to pick an 'equipment ID' from the second form to populate the first form's 'equipment ID field'. ?????? :confused:
  9. K

    Query to print report

    That is just what I needed. I was trying to make it more complicated than it really was.....to tell you the truth I was attempting to make it impossible!!!! I knew it was something simple.... my brain just isn't working in the 'simple' mode today! Thanks for your help! :D
  10. 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...
  11. K

    option button to print reports

    Give me enough time and I'll figure it out....something simple of course, but I thought I would post an answer! I forgot to change 'Dim stDocName As String' to 'Dim stDocName1, stDocName2, stDocName3 As String' I knew it was something simple!
  12. 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...
  13. K

    custom number format

    AHHHHHHHHHHHHHHHHHHHHHHHHHHHHH! You don't know how happy I am that it works!!! I made some adjustments such as: with the unbounded 'txtSerial' text box so that it displays "00-00000" (it was dropping the leading zeros on the autonumber field) I changed the control source to =[txtYear] & "-" &...
  14. K

    number populate for a recordset

    I know everyone is sick of seeing this, and so am I! This question is for Pat.... Your suggestion still didn't do the trick. I'm sure it is something simple that I'm missing. I currently have this in the OnOpen of the form...should it be somewhere else? I've tried changing all parts of the...
  15. K

    custom number format

    Alexandre, your English is great, and I am learning so much more than I would have on my own. I also understand why I have to make two separate fields to achieve what I want. My only concern is when I input the old data into the system. Right now, I am just making a temporary database, with...
  16. K

    custom number format

    I just feel like I'm making a fool of myself over this stupid question! And both of you have been wonderful in trying to help me, so I thought I would rack your brain some more. Ok....I think this might work. Let me give you a run down of what I've done: In the table: *two fields- 'Clearance...
  17. K

    number populate for a recordset

    No it is not. Any ideas?
  18. K

    number populate for a recordset

    I'm not sure what you mean?? Let me do some looking....
  19. K

    number populate for a recordset

    Hey thanks for your reply Pat, but I changed the 'Me.Tag' line according to your suggestion and now it won't let me open the form from another form. I know there is something wrong with the code, but everytime I look at it and make changes to it, nothing happens! Do you see anything else that...
  20. K

    custom number format

    Thanks Pat and Alexandre. I will tackle your suggestions in the morning! Alexandre- I do now understand why, but in my mind, and of course I'm naive about things, there should be a simpler way!!! I think having an ID this way is stupid too, but as Pat has mentioned, I really have no other...
Back
Top Bottom