Recent content by darlingm

I have a text box that I want to be all uppercase, regardless of how the user types it in. I searched the forums, and found methods to use the event "After Update" to handle this, such as: Private Sub TextSomething_AfterUpdate() Me.TextSomething = UCase(Me.TextSomething) End Sub However, I...

I'll be the first to say shame on me, assuming the language/compiler made an optimization, and coding to that, but wow, I'm suprised. I've always been able to count on that.

Why in the world am I getting a message box saying "You should never see this message." followed by a message box saying "You should see this message." Am I missing something, or does this prove VBA in an "or" statement, keeps testing after it's found a true, rather than stopping where it...

Ahh, thanks for the help! Works now. :)

Very good point. My original code uses a different variable name than "RecordSet", but I shortened and changed the function and variable names to make my post more generic. I'll edit my original post to remove any confusion.

I'm using Access 2007. I'm trying to mimick functionality that I often use in C++ to simplify code that interacts with databases, but this is my first time using VBA and Access together. I'm getting an error that I'm not sure how to get around. I have a Table which I will call MyTable...

Thanks again for your very quick response! I probably should have mentioned that I'm calculating and using these large numbers purely in VBA, then only displaying them. The large numbers aren't getting stored in an actual table. I tried declaring a variable as type Decimal, and VBA asked what...

Thanks! Splitting it into a seperate query makes it act instantly, and updates the combined names header at the top as soon as a name is edited. I don't have to create on update events now, either. The size of my database is what was worrying me so much about NZ. There's a whopping 1-5 rows...

I need to be able to precisely handle nonnegative integers (in the math sense of integer, not the VBA sense, of course) between the values of 0 and 808,035,046,350,570,000. (Don't ask.) I'm wondering whether I should be handling these numbers in a string and do everything manually, or whether...

Yikes, that's embarrising. Thanks for all the responses. Microsoft wrote "=Nz([Employee Name],"Untitled")" at the top of one of their forms. I need the name to be split into first, middle, and last, so I changed the function and neglected the spaces causing "Untitled" to never be returned...

I'm hoping someone can comment on the code block below. I'm using Access 2007. I'm very familiar with C, C++, and C#, and using those languages to interact with databases in Unix, but this is my first time using VBA and Access together. I'm looking to basically learn if a seasoned VBA...

At the moment, I have a very simple Access 2007 database with 3 small tables, and 4 small forms. In two of the forms' headers, I have a text box with contents '=Nz([FirstName] & " " & [MiddleName] & " " & [LastName],"Untitled")' which I took from Microsoft's Marketing Projects sample database...

I'm using Access 2007. I created a table named TableStates which has four fields: StateID (AutoNumber), Abbreviation (Text), State (Text), Combined (Text). Yes, I'm in the US. :rolleyes: There is a row in TableStates for each State, such as: 1, "AL", "Alabama", "AL (Alabama"). In another...

I am developing an Access database, and using the Access 2007 Developer Extensions to "compile" it into an installable program which includes the freely distributable Access 2007 RunTime, for users who don't have it already installed. I am planning on charging a subscription fee to use my...