Recent content by AnOddExperiment

Hello again. Just trying to clean some things up in my forms to make them easier to use. One thing I need is a validation rule on my form such that it accepts no more than 10 characters, but fewer is OK. In the help files and on a website I found examples for Like "??????????" but that...

found it! Didn't even know about the DateAdd() function. Works like a charm. I'm shocked Date + 1 works also, it seems so simple. Thanks a ton!!

Hi everyone, hopefully this one is easy for you all. so if I have the follow code that works great... Dim strDate as String strDate = Date and I want tomorrow's date saved to a variable as a string, how do I do that? Dim strDate as String Dim strTomorrow as String strDate = Date...

Thanks Darth, The error is runtime error 424 object required, and it goes away if I remove the portion of "or ctl.Value is Null or ctl.Value is Nothing" from the if criteria. If I do that, however, the code does not fire the way I want it to. It simply executes the rest of the code as if...

Hi everyone, still a newbie coder, but I was wondering if you could look at this and tell me why it returns an error: Dim ctl As Control Dim bolComplete As Boolean bolComplete = True For Each ctl In Controls If TypeOf ctl Is TextBox Or TypeOf ctl Is ComboBox Then...

Maybe this is a really dumb question, but could it be attached to your other toolbars at the top of the screen (instead of floating independently) and that's why you don't see it?

Hi Jan, I'm new to this also, and sadly I couldn't tell you exactly how to accomplish what you want to do, but I do know where there is some information on what you need, which I believe are commonly called "cascading combo boxes." The moderator at this forum has a website at...

That works great! Your a godsend. I've been doing some reading on your website and looked at the example for requery, trying to use it to solve really the last roadblock between being able to get the lab started with a functional model of the database. If you notice on the database attached...

!! I swear 5 seconds ago it was returning an error. Oh, well, you touched it, it works now. What the proper syntax to close a form so I can add that at the end of the if statement? I want the frmPwdEntry to close after it accepts the password.

That still returns an error. Basically all I did was make the exact same tabels you listed, verbatum, and created a form (frmPwdEntry) with a combo box (Combo1) that looks up the field "UserName" (Row Source = SELECT tblUsers.UserID, which was entered by the combo-box wizard) and a totally...

Wow, that helps a ton! So, I think I almost have it, but I haven't entered the on click event in correctly, what did I miss? This is what I have so far. (I've signed up to take a VBA class for Access so I can code independently) Also, I don't know anything VBA specifically, but I did take...

Oh, nevermind, I just found it. If anyone searches this and wants to know what the answer is, you have to hold in the shift key when opening the database. X-)

Hi everyone! Well, I goofed... I was trying to figure out how cause access to launch a switchboard I made and NOT launch the regular shortcut bars or database window. Well, fortunately the help file told me I could change that in tools...startup options... I found it, and it worked great...

Hey, thank you very much for sharing all that. This is actually much more complex, but also more useful than what I had originally thought. I've spent some time playing with it, but what I'm having trouble implementing it properly as I've never worked with a module before, and I'm not entirely...

Actually, while I've got you on the line... I've created an action button for a switchboard I'm making from scratch that opens a form I would like to have password protected. It opens the form just fine, but is there an easy way to add to the "on click" macro to prompt for a password? I can't...