Recent content by Myvee

Hello - I'm definitely no expert with this stuff but have you tried opening your tables up in design view and looking at the field size allowed? I'm assuming you are talking about text fields. I think I had a similar problem like this before and it was because field size was set too small to...

You are going to be so proud of your newbie dbperson here! I got it! Can you believe it? I tried IsNull and it works perfectly (fingers are crossed). I feel like I just won a prize LOL. Thank you again for all your help! Here is a summary of the code just so you can see Private Sub...

Hello! Well thank you PHV - that reference took care of my syntax problem and thank you ItIsHardToProgram for the tip - I did look at that too - nothing wrong there.. BUT... I'm back at square one! I no longer get my error that it doesn't recognize my form thanks to the proper syntax, but when...

Oh I wish I could say that things worked out - and it is something really really stupid.... the error returned is "Inspection Manager V2 (that's the name of my db) cannot find the form "data collection subform" referred to in a macro expression or a visual basic code. I've checked and...

Thanks ItIsHardToProgram - you are like a knight in shining armour here! I'm going to try out that code now and see if it will do the trick. I REALLY like your idea of adding an input box for the empty field - but I'm not even going to ask how to do that yet! I must master this field data...

Yes! - that sounds exactly right - but I'm sorry - I'm not a programmer, just someone with a little bit of db knowledge and a lot of trial and error experience! so...and I'm really sorry to bother you...could you possibly give me an example of that code? I understand most of what you mean, but...

Hi - I appreciate your help - maybe I could explain a little more because the code doesn't work... the main form has no close button - it forces the user to complete the transaction they have started and enter the information - that is why I need to close the form with a button - to finish...

Hi ItIsHardtoProgram: Thanks for your quick response - are you referring to the main form or the subform's before update etc? I've tried both - but without success because I'm sure my code is incomplete or I get an error... could you possibly write a complete example of your event procedure...

Hello - I'm hoping someone will be able to answer the following question I have regarding a form I am working on. I have been trying for days, with varying success to get this to work - I've tried everything I can think of but I'm missing something.... Here is a description of what I'm working...

Hello Again! I am wondering if anyone happens to know how to use an option group with a command button to open and close forms. I would like to do the following, but I'm not 100% sure how to do this. The option group has three options - 1. Perform another inspection, 2. Return to Main Menu and...

Hi - thanks for responding so quickly - but I'm afraid it's not quite what i need to do here - i already have code for what you are describing. What I need to do is kind of like a signature authentication. When the person clicks the button, they are prompted for their password and if correct...

Hello - this is my first post and it is going to be a long one! I have been creating a database to perform product inspections for work. So far everything is working very well. The auditor enters the information he/she is prompted for during the inspection. Once completed, here is what I would...