Search results

So glad you asked! No, it's OK Bob. I know they are not normalized. This entire project is becoming a nightmare! Allow me to explain... There is a high visibility workflow database that is designed around a VERY old MS Excel template. Years ago, not everyone in the company had Access...

Thanks Fellas - now for an array problem Thanks to both of you. I used a combination of both responses - i used "Me." instead of Forms(frm) and used Bob's code technique and am no longer getting the error. Now for a new challenge if you can help. I have never used an array because I just...

That looks much more logical, but i tried it and got error 2186: "This property isn't available in design view" on: ... If Not IsNull(ctl.Value) Then ... :confused:

See below and let me know if you have any ideas. Thanks! ________________________________ Hello fellow VBA programmers, I have the code below in one database to do stuff to all the textboxes on a form. I've copied it into another DB to disable some combo boxes on a form, but it doesn't want...

No answer but... I don't have an answer for you, sorry. But I wanted to say I feel your pain with arrays. I've been programming Access for 3 years now and I still don't understand arrays and have never used one. I know they are powerful but I just can't figure them out. :(

I appreciate your time and don't mean to be rude, but you kind of offended me. I did not ask you to tell me if my code makes sense to you. I needed one simple line of code to return the value of the text box, within the loop. 'My String = ctl.Value' is the very first thing I tried in this...

I didn't define it yet in the actual code. I just wanted to give it a name for now. See code below with MyString declared. MyString needs to be set somewhere to equal the value in the text box - where/how do I actually set the value of MyString? Thanks again! Private Sub Form_Load() Dim ctl...

Code I want to return the value that is in the text box to 'MyString'. I am assuming the line 'If IsNull(ctl.Value)-false then' is where I've gone wrong. I want to evaluate the value that is contained in the text box on that line to do the rest after it. Private Sub Form_Load() Dim ctl As...

Ahhh, that would help :) Dim ctl As Control Dim txt As String Dim i As Integer Dim msg As String For Each ctl In Me.Controls If TypeOf ctl Is TextBox Then txt = ctl.Name If IsNull(txt) = False Then ctl.Visible = True If Left(txt, 3) = "App" Then...

Hello everyone! I have the following code that loops through controls on my form to find out who the 'approver' is. It is missing one link that I cannot seem to get right. I need to find out if the textbox's VALUE is null or not. The 'txt' variable contains the control name, but I'm need to...

Does anyone know how to insert an OLE object into a bound OLE object field on a form using VBA rather than the "Insert Object" command from the Insert Menu? Pretty plllleeaaaasssseee??? :o

you too Keith! :D

Cool! I knew it was a no-brainer. Thanks for your help Bob!

I've been programming Access Dbs for a long time (I used to be XLEAccessGuru on this forum, but I totally lost my login info and can't get it back cause I forgot my old email address!), but I'm having a brain train wreck right now and can't remember how to do this. I searched and searched but...