Search results for query: *

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

PHV, I tried to remove those brackets around vbProperCase, but after I click OK to save the expression, the program automatically puts the brackets back in. I can't get rid of them. I copied and pasted exactly what you had above, and Access is putting those [] back in so no matter what, I end...

Ok, I gave it one last shot. I checked out a couple of FAQ's and here is what I tried. See if you guys can see anything wrong here. On my report, I added the field "Customer First Name" and made it noon-visible. I then added a unbound text box, labeled Text25, and then added this for the...

hey guys, I got it to work. If you leave that code in the Page Footer, it fails. If you move it to the report footer, it works. thanks to all for your help and patience!!! Richard

Payback, I did cut and paste the code from your message as well as the ones from previous messages. Still get the #Error. But I think I might know why. If I move the unbound box into the Report's Detailed section, it works. But if I leave it in the Report Page Footer section, thats when I get...

PHV, Now it prompts me for the Customer Last Name when I place that code into the text box. Guess this just isn't my day doing this stuff <G> Richard