Search results

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...

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

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...

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...

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...

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...

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...

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:

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

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...

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!

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...

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] & "-" &...

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...

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...

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...

No it is not. Any ideas?

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

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...

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...