Search results

@The_Doc_Man Actually, pbaldy's code worked, but when I tried the code you posted, it still wasn't recognizing that field as blank, which is weird. Nz is new to me, but does it have the ability to check for a ZLS? Doesn't it just check for a null value, since it's essentially saying, Nz(If this...

I want to change the backcolor and fontweight properties of a listbox depending on if it's displaying a record or not, but I'm getting a mismatch error. What should I set my variable as if I'm trying to manipulate these properties? Private Sub Form_Current() Dim stBackColor As String...

@pbaldy That worked. Why would it be a 0 length string instead of null? @The_Doc_Man I think your original code had one too many closing parenthesis, so I tried: Nz( Me![lboMainSearchResults].Column(4, Me![lboMainSearchResults].ListIndex), 0 ) = 0 THEN For some reason it didn't work though...

While I'm still in this stage, it's not pedantic at all. Thanks for the info :)

The record doesn't exist, so it should be null, right? The listbox is seeing if there is a case linked to that property and if there is, it displays the case number.

I'm having trouble with figuring out how to check if a column in a listbox is null or not. Private Sub butOpenServiceChart_Click() If gEnableErrorHandling Then On Error GoTo Errhandle Dim stDocName As String Dim stQTRecord As String stDocName = "frmServiceChart"...

@ The_Doc_Man Aahhh. I see now. Very cool. I can see the benefits of that. Even though the outcome is the same, the way I have it currently, even when I don't want the error handling to happen, VBA is still compiling that code. I guess saving VBA from compiling that code makes it just that much...

@Galaxiom I don't think I'm quite understanding the uses of that code. How I currently understand it, it would be written something like this: Const conErrorHandling = 1 Private Sub butNewProperty_Click() If conErrorHandling = 1 Then On Error GoTo Errhandle If Me.Dirty Then...

If I had variables that I declared earlier in the sub, should I set those to nothing before ending? Do they continue to take up space, even after the sub has ended?

Is there a way I can improve this error handling or do I not really need much else for such simple procedures? Private Sub butNewProperty_Click() If gEnableErrorHandling Then On Error GoTo Errhandle If Me.Dirty Then Me.Dirty = False End If DoCmd.OpenForm...

By more control over the highlight color, I meant that you can't change the highlight color of a selected row on a listbox by itself. You have to change other things about the listbox to change the highlighted row color.

Crosspost that went unanswered on another forum, so I thought I would pick your all's brain a little bit. Just wanting some input on the best way to go about designing my homescreen form. Right now I have it so that all my navigation buttons are on the left with multiple list boxes in the body...

Interesting point to think about. Thanks for your help.

Isn't Enforced Referential Integrity good to have though? I may just go ahead and make a new table for it. That will have the added benefit that jjuuussttt in case one property is apart of two cases at the same time, the database will already be able to handle it. However, I still want to...

So in creating a new case, I have the new case flow as follows: frmClientInfo ---> frmNewProperty ---> frmNewCase This is how the work flows naturally as well, since we do stuff with properties that never become cases. So, basically I'm creating a new property, then I'm creating a new case...

Good to know, and done. I'm still getting that error though.

I keep getting the "Control can't be edited, it is bound to an Autonumber field" error whenever I try to link a PropertyID to a new case. I have a main form where I'm creating a new case for my Quiet Title table (tblQuietTitle). The user inputs the new case number and assigns an attorney and...

I have two sub reports in a main report. One sub report is for different sources of revenue and the other sub report is different sources of expenses for any given investment fund. So for example: Republic Holdings, LLC Revenue Sub Report Rent Income: $ 4,800.00 Sold Income...

@missingling Thanks for help. I updated my code based off your suggestions, but it's still acting very weird. It works great for the first few clients I have listed, but when it gets down to client 13, 14, or 18 (some missing numbers there) it starts acting weird. It changes the client 1's name...

I've used OpenArgs of DoCmd.OpenForm to go to a specific record on the next form, but I don't see how it works if I just want to pass on a value of one box to the value of another box in another form. So here, I have the user selecting/creating a new client. After which, they have a new record...