Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. RTKarkivi

    Ranking cell values in Excel

    Thanks a lot mintjulep, as for your question SkipVought. Column D must be 2 because it means that column A is in the 2nth position comparing with column B and C.
  2. RTKarkivi

    Ranking cell values in Excel

    Hello, my situation is like this: I have four columns in Excel (A, B, C and D). The first three ones contain some values, and in the fourth column, column D, I would like to have the ranking (positioning) of the first column, column A. For example: A=10, B=20, C=7 and column D must be 2 (which...
  3. RTKarkivi

    Parallel texts in word

    when you past a larger texts (more than one page) the columns are not the solution. However, i found another solution (Tables). Thanks a lot.
  4. RTKarkivi

    Parallel texts in word

    Hello, I want to put two parallel text (translated subtitles) in a single word document, so I could see them in the same pages as I need to do some comparisons. Regards, Tonny-pr
  5. RTKarkivi

    changing the case

    thanks a lot
  6. RTKarkivi

    changing the case

    Hi, can anyone help me on changing the case of a whole table or just a particular field. I am interested to have all the existing data in uppercase, and to make it as a rule that coming entries to enter the database in uppercase no matter whether the capslock is on or not. Thanks in advance...
  7. RTKarkivi

    exctracting characters from a field

    thanks a lot, it helped me a lot
  8. RTKarkivi

    exctracting characters from a field

    hi to all, my case is like this: I want to exctract some characters from field1 and some from field2 in order to create another field based on that. I try this; Left([field1],3)& left([field2],3} but it takes all the all 3 characters from left. I am interested to take just the third one, not...
  9. RTKarkivi

    problem with reports

    Thank you very much. Best regards, Hysen
  10. RTKarkivi

    problem with reports

    hi guys, I have a problem with my reports. When I want to open a report this message appears : " There was a problem retrieving printer information. The object may have been sent to a printer that is unavailable". I checked with my printer and i can print documents without problems. But I...
  11. RTKarkivi

    Generating a barcode number in the table and form

    Hello, I fixed that as you proposed me. The problem now is that I want to create a report based on this barcode number. How could I do that? regards, Hysen
  12. RTKarkivi

    Generating a barcode number in the table and form

    Thanks PHV, that helped me, but partially, as in my form I have just a asset category ID item and that appears in my barcode text box and not the three character asset category description. I have another question, how is this possible to be done in access tables as well. Because when I open...
  13. RTKarkivi

    Generating a barcode number in the table and form

    Hello, I have a form based on the table with these fields: 1. Fixed asset number (ex. 354) 2. Asset category (three characters, ex.107) 3. Location of the asset (two options: Television or Radio) 4. Origin of the asset (two options: Donation or Investment) 5. Barcode number What I want, is...
  14. RTKarkivi

    Generating a barcode number in a table and form

    Hello, I have a form based on the table with these fields: 1. Fixed asset number (ex. 354) 2. Asset category (three characters, ex.107) 3. Location of the asset (two options: Television or Radio) 4. Origin of the asset (two options: Donation or Investment) 5. Barcode number What I want, is...
  15. RTKarkivi

    Replacement of characters within a field

    Thanks jrbarnett
  16. RTKarkivi

    Replacement of characters within a field

    Hi, is there a possibility of replacing order of the characters within a field, for ex: 11-22-33 to be like 33-22-11 Thanks in advance, Hysen
  17. RTKarkivi

    data from several fields in one field

    Jeremy, it worked great. Thanks again. If u don't mind, I have another question regarding to this. Well, the form is ok. But the form is based upon a table, where I the new field stays blank. So, the results does not affect the table. What could be the problem?
  18. RTKarkivi

    data from several fields in one field

    Thanks Jeremy, thanks indeed. Could I also, have them separated with commas? Hysen
  19. RTKarkivi

    data from several fields in one field

    Hello, how can i have all the data from two ore more different fields in one new field, ex: "names" in the namefield and the "surname" in the surnamefield. thanks in advance, Hysen
  20. RTKarkivi

    Problem with dates....

    thanks jrbarnett, i tried what u told me, but no success.:( Hysen

Part and Inventory Search

Back
Top