Recent content by Endojoe

Well, putting a default value in the column for NULL would end up putting bogus information on my form as far as I can tell, unless I'm missing something. Here's some more information. This is a pretty complicated DB, more of a mess than complicated, really, but I inherited it with the job. I...

Jdraw, thank you for your response. I think I follow you, but the problem with that solution is that it eliminates records I need from the query. In the Query, I put 'Is Not Null' in the criteria box of column 5 and it eliminated all records that were not Null in Column 5, but I need those in...

Good Day All, I have a table sourced Combo Box on a Form and it populates several Text Boxes and Option Groups using the following code: Private Sub cbo_CUSTOMER_NAME_AfterUpdate() Me.Txt_Country = Me.cbo_CUSTOMER_NAME.Column(1) Me.opt_Cert_Type = Me.cbo_CUSTOMER_NAME.Column(2)...

Bob thanks a million!! I can't believe I couldn't figure that out in my research leading up to my post....but for some reason I just couldn't seem to find a clear explanation of how to achieve such a simple thing anywhere I looked. You are a Saint among mortals. :D

I have 5 option groups, several of them populate text box controls with standard verbiage in my form using the After Update event. There are a couple circumstances I want to create Command Buttons for that will select certain options in all the option groups in with a single click...

Well....that was simple enough. :cool: Thanks a ton missinglinq!!! :D I have no idea why I couldn't find something so clear and concise on my own. :o Thanks a bunch again. :) Worked like a charm.

I have two tables, 'table1' has around 4500 records but is no longer being added to because I have created 'table2' to take it's place due to the fact that I couldn't set a couple fields in 'table1' to be indexed with no duplicates (over the years many duplicates had already been carelessly...

That looks like it will make for much cleaner code! And after some research on it, it would appear to be a very powerful tool for many other things too, thank you for the suggestion!

:D From your lips to gods ears...I wish I was the boss. I'm just trying to make my data entry job easier...and I'm lucky I have been given the OK to do even that much :-) Things are done the way they have always been done and it has always worked... LOL Everything I'm entering is in at least...

Mr. B thanks a million!! Put me on the right track. I took my Dim declarations out of the ElseIf and moved them all up to before I even began the If/Then statement and everything worked as I had wanted/expected it to. My complete working code for anyone interested in the future: Private Sub...

I'm trying to use an If/Then statement to get a command button to create a new record with certain information carried over from an existing record, but just exactly what information is carried over is dependent upon the selection present in an Option Group...each half of the code works fine by...

Ok, so the default value on the option group I want the user to select from initially is actually set to 0 (so that I can use that value to trigger a reminder box to pop up if no selection is made on newly created records), although on records created before the option group was added to the...

Missinglinq that nailed it! Thank you so much...I'm pretty new to VB stuff, so sometimes I forget that 0 is really Null (and nothing can = Null :D) It's amazing to me that that oversight on my part made the option groups behave the way they did though. :rolleyes: And right on with the...

I have a form with 4 Option Groups, and I need to guide the user through the selection process in a step by step manner. I have tried using some VB code to set the Option Groups to invisible, then make them visable again after a selection is made in each group, in the order they need to be...

Well...In Access 2007 anyways, I went into Table Design, selected Date/Time as Field type, then manually keyed in mmm/dd/yyyy for the field format, and did the same in the control on the form I needed it in. This is unique to this particular table and form within the database, the table/form...