Recent content by Nangasaur

Thanks :) I'm learning, slowly but surely. I'm not a young kid anymore, so it takes me a bit to just dive head first into this and pick stuff up. If I can't read it and see the exact logic in what the code is doing, I'm totally lost in the sauce. So things like "len$" makes no sense to me at...

:o I ended up fixing it just a moment ago due to a syntax error that strangely wasn't giving any error message. A little help from the mvps.org Forms reference card got me the correct syntax I needed in switching between several subforms on a mainform. I also had to add...

Was my first thought to check the tab order, and it was all correct. Let me try and describe better what is happening: My MainForm is "Quick Updater" Subform1 is "Vest_Dates_Quick_Updater" Subform2 is "Helmet_Dates_Quick_Updater" A record is selected via the MainForm. Subform1 and Subform2...

I still highly suggest your form is linked to your data via a query, and not directly to the table itself. I see in your screenshot that you have all your customer data in the top portion of your form, and in the bottom, you have all your product data and order info below. If you have your...

You're still making sense to me :) But I'm about to make little to no sense to you, so hold on to your lugnuts! I was in the same position as you just a couple months ago, when I received the advice of "Bob" from these forums, to NORMALIZE my tables. Google "MS Access"+Normalization, and...

Makes perfect sense. First, you need a query, based on the table "Products". Let's call it "ProductsQuery" Your recordsource of your form "Orders" needs to be "ProductsQuery" On your form Orders, you'll have a textbox labeled "txtItem" and and textbox labeled "txtCost". The control...

Hey, neither am I. I've done all my learning by looking at templates, how they work, and playing with it from there. A few Google searches later, and some questions asked here, I've slowly learned a bit here and there. Good luck!

Have you tried looking at the "Customer Service" template downloadable from microsoft? In it, there's a form called "Customer Details", with a combobox labeled "cboGoToCustomer". By looking at it's code, I think you should be able to figure this out. edit: I forgot that it's in macro format...

Access 07 Windows 7 I've trapped the SHIFT+TAB and TAB keystrokes within the keydown event of a subform to behave appropriately (switch back and forth between subform1 and subform2). However, my current problem is this: Subform1 and Subform2 have 3 textbox controls each. If I am on control2...

Bah, I got it :) Changed If Me("DC" & I) = Null Then To If IsNull(Me("DC" & I)) Then I'm baffled as to why this works, but the other way did not.

Well, I have tried If Me("DC" & I) = Null Then Which didn't work, sadly. The form's recordsource is a query, which of course has every instance of the fields DC1 thru DC32. A combo box selects the current record from the record source. After selecting the record I want, I need the...

Those are the names of the fields from my table, which I need to check if those fields are null. Like I said, any advice on how to make my code work would be helpful. Thanks.

Access 2007 Windows 7 So I'm somewhat back to my original problem I posted about several weeks ago, where I am attempting to set the control source of a text box based on very simple criteria: Is a field from a set of fields in my table null? If yes, set the control source to that field...

There's two kinds of folks in my line of work in the Army: those that drink to improve our attitude, and those that get fired from our job. With that being said, I wish I could simply move my project to a trusted location and have that be the solution, but unfortunately every time I make an...

Using Access 2007, Windows 7. Just looking for general advice and opinions on which is a more efficient and preferred method, programmatically, to run commands and execute functions within forms: Macros, or VBA Event Procedures? I am clearly getting into the learning curve that there is far...