Recent content by rgreene

Thank You Sooo much that worked perfectly!!

I have little to no programming ability so any advice (and details) is appreciated. I have a field called PHLevel. And I want to click a button and based on the results in the PHLevel field open 1 of 3 forms (with just words on it). So basically I want something like this If PHLevel is < 7.2...

Oh Ok Thanks and sorry about that!

Gizmo, Yes that is the database I'm using. but unless I'm missing something that doesn't have what I would like to do.

I'm currently using the access sample inventory control database http://office.microsoft.com/en-gb/te...001018458.aspx but I need some assistance in modifying it. I'm working on a database where I can track my swimming pool chemicals on hand quantity and costs. Like I said I have the sample...

Thank You SOOOOOO much that was it. I changed to the row source of my lookup table and that did it.. Can't thank you enough!!

Yes the Fee_Label is a ComboBox. I originally had it set with the AfterUpdate event but that didn't work either. So I was trying it on the On Change just to see if that made a difference. But I will put it back to the AfterUpdate.

Can any one tell me why this wouldn't/doesn't work? Private Sub fee_label_Change() If Me.fee_label = "Adult Registration: No t-shirt (Early)" Then Me.fee = 10 ElseIf Me.fee_label = "Adult Registration with t-shirt (Early)" Then Me.fee = 20...

Works PERFECT thank you!

Where does the other ) go? Else If (Me.Family = "4" Then Me.FamPoints = "0" MeFamOther.Visible=True Else... I am definatley open for suggestion but I'm not following what you are saying with the suggestion. I'm not very good at this coding stuff.

Is there a way for in the else part of the code to have 2 things happen? I have this: If Me.Family = "1" Then Me.FamPoints = "3" ElseIf Me.Family = "2" Then Me.FamPoints = "2" ElseIf Me.Family = "3" Then Me.FamPoints = "1" ElseIf Me.Family = "4" Then...

MR B, THANK YOU so much that is it. I really appreciate it!!! Rick

I understand what that is saying and I'm definately open to other suggestions. Our account numbers are like 123-4-5-678-9023 so there is a LOT of opportunity for error. The export file I create gets imported into the auditors software so those numbers have to be correct. The look up field was a...

I have a simple database that we use that we put our payables in and then I export the report to a txt file. In the db I have a lookup field that has all our accounts and information in, I did this to eliminate fat fingering and errors. Anyway when I view the export txt file it is showing the...

vabInet, THANK YOU so much for putting up with me and my lack of knowledge. I finally got it. I tired it with the Claims Export but that didn't work so I put the ClaimsExports in "" and that did it. So I have DoCmd.TransferText acExportFixed, "ClaimsExport", "qryExport"...