Search results for query: *

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...

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...

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...

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...

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...

One other thing I am trying to do, is when I run a report which includes a first name of someone from a record, I would like the report to autmatically format it so the first letter is capitalzed, but the rest isn't. I also would like to add a comman "," at the end of the name. I know this may...

I created a query and saved it as a report. Basically, it prints out a packing list for me. But what I would like to see, is there are 12 line items on this report, I would like to add a simple line at the bottom of the report saying "Total Line Items" and have a 12 next to it. I tried playing...

I have a command button that I click on a record, which prints out a report with this record's information. What I would also like to do, is after I select that command button and the report prints, I also wish to have a text box on this record to automatically fill in with today's date. This...

I am sure it can be done <G>. I was trying to create a query which will look at a specific text field and show on the query those records. Is there a simple way that this can be done?? Also, this tex field is always an 11 digit number, if that matters. Thanks in advance, Richard

I have a database with one form. And what I would like to do is this: 1) Have the form open up to the very last record entered before the program was closed. Not the last saved, but the last record. 2) When adding a new record, to have the cursor automatically start on the very first text...

I have a report, where there is an unbound checkbox. I would like the report, when run, to autmatically place a check mark in ths bax (i.e. be true) IF the record on the form has a specific text box set to one specific value. My form has a text box called "Location" on it that has a two-item...

I apologize for posting this message twice, but I wasnt sure which forum to do this in. I am taking an 11 digit number , in a text box, and trying to convert it and palce that number into the enxt unbounded text box. A typical number would be something like 06701542003. And the =Hex option in...

Hello, Unfortunately I am very much a novice at Access so I am hoping if someone can give me some help, or point me in the right direction. I have a text box which is set up to enter an 11 digit number. An example would be 06701330450. I am trying to get the next field to autmatically populate...