Recent content by RnRExpress

Ok, here is what I tried. Ovbiously I am a novice at this kind of stuff. If Reason = "Agent Repair" then Me.DueDate = DateLoaner + 45 else If reason = "Waiting For Inv." then Me.DueDate = DateLoaned + 30 else Me.DueDate = DateLoaner + 15 End If

Here is what I have been trying to do. I have a "reason" field, whioch you can select a reason for issuing a loaned piece of equipment. There are six, such as Claim, Lost, Waiting for Parts, borrowing, DOA, and Agent. Then there is a date field, which you enter the date the loaned equipment...

Thanks again!! that did the trick!

I have this code which I did to convert Callphone ESN's in Hex to Decimal. Private Sub Hex2Dec_Click() left2 = Left([Customer ESN Hex], 2) right6 = Right([Customer ESN Hex], 6) dleft = "&H" & left2 dright = "&H" & right6 valleft = Val(dleft) valright = Val(dright) dec_number = "0" & valleft...

Not sure if I will be able to explain this without getting all confusing, but here it goes. I have one table called Loaner_Reg. This table has 4 pieces of data: LNumber; LMake; LModel; LSerial. A typical piece of data would be: 1; Nokia; 5165; 12345678901 2; Motorola; 343; 05000000000 and...

never mind guys, I found out how to do it. Happy Holidays!!

With the help of a great FAQ here, I made myself a search form which allows me to input the text I want to search for, and list the results in a text box. The output in this list box shows: Decimal ESN, Hex ESN, Last Name, Phone Number. For example, a decimal ESN is set to 11 numbers only...

Thank you Zion7.. that worked awesome. Much apreciated! Richard

Howdy folks. I have been messing around with a report, and have frield If Then's, and IIF as well, without any luck. So, its time to ask all your fine experts. On a report, I have a Currency field, called "Charge". I also have a unbound text box set to show a medium date, which represents the...

PHV, Tried it out and worked like a charm. Thanks a million! Richard

I will definately give that a try tomorrow and see if that works the magic. Thanks again for the awesome help, as always! Richard

PHV, For example, I have these locations: U066, U182, W331, W345, and W715. And the five reports I have are named: 2nd_U066, 2nd_u182, 2nd_W331, 2nd_W345, and 2nd_W715. As you can see, its a one to one correlation that will not vary. Now, when entering data on my form, I have a text box...

Ok, I'm back and in need of more wonderful help from you folks. I have a command button that automatically selects the record I am on, and prints out a specific report. Here is what I have. I have a database where I have a field called "Location ID". There are 5 options in this text box's...

Ginger, I can appreciate that. I even have a Intro to Access book. I did eventually find the info, but as you saw above, no matter what I put in, I always got the error until PHV told me to use the "3" instead of vbProperCase. Luckily, there are forums like this, when you have tried and could...

PHV, Dont know why, but that last one worked like a charm. mucho appreciato!! Richard