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!

  • Congratulations strongm 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: *

  • Users: jgarry
  • Order by date
  1. jgarry

    Excel calculations in VB

    Thank you for your response, I am changing from the format to the round function. Thank you for your help Jim
  2. jgarry

    Excel calculations in VB

    Hey, thanks again I got some inside help from our expert at the office. this is how it was fixed format(dbl_temp2,"000.00000") now both calcs come out the same . Thank you again for your assistance. Jim
  3. jgarry

    Excel calculations in VB

    Hi, thanks in advance, I am moving some calculations from Excel to Vb, I am having a tough time with one of the calculations. 4.1886226531/360 this is the Excel Calculation(shortened) the answer in Excel is .011635062925495 in VB I am writing it to be dbl_temp1 = 4.1886191152...
  4. jgarry

    How to Retrieve serial port data from temperature sensor?

    fabmadre Good question! it is usualy easer in C++ then vb. what you need to do is set up communications with the serial port. you are more then likly using a plc I do it as a two step process. Communications from the sensor to the plc then using the interface supplied by the plc...
  5. jgarry

    how to 'select text' on current form

    Hypetia, I have been looking at the code, and am using it, but now can you attempt to explain what it is doing? I find it fasanating, just wish I understood it better. Thank you again Jim Garry
  6. jgarry

    how to 'select text' on current form

    Hypetia Why is the solution always so simple? I seem to always attempt to go about it the hard way. This wasn't my original post, but you help me with about 4 problems in one post. thanks Jim Garry
  7. jgarry

    Use string as the name of a text box on form

    Thanks Tedsmith, I will give it a try and let you know. Jim
  8. jgarry

    Use string as the name of a text box on form

    Hi, thanks in advance. on the form I have created I am useing a mdb table to store the field names that I want to populate. To populate the fields I have to connect to a PLC. this is no problem. what Is the problem is I have about 50 fields that I want to populate from the PLC I want...
  9. jgarry

    Display the current Module or Sub name?

    dglienna thanks for the info on the mz tools Also BobRodes, that is a good suggestion also. I had just learned about th # stuff a few weeks ago, but had not thought of using it that way. Thanks to all of you for your assistance Jim
  10. jgarry

    Display the current Module or Sub name?

    Thanks for the assistance. I will use your code. Jim Garry
  11. jgarry

    Display the current Module or Sub name?

    Thanks for the replay, I guess it can't be that easy. Jim
  12. jgarry

    Display the current Module or Sub name?

    Hi, thanks for your assistance. I am looking for a quick way to display the current sub or module name in my program. I want to export this to a text file (no problem) what I need is a way to grab the current module or sub name. I know that I could create a global var str_sub then in the...
  13. jgarry

    Save Addresses to Contact

    Thank you for your response, Sorry it has been so long for a reply, switching jobs, to answer your question yes I do know access, I did not think of doing it that way. That would also give me a backup of all address. thanks Jim garry
  14. jgarry

    Save Addresses to Contact

    Hi, thanks in advance. is there a way in outlook 2003 to save all the addresses and information on an e-mail that I recieved to my contacts other then going through each address one at a time? From: ssxxs@email.com to: asdfasdfasdf@124.com;asdfasdase@4rsdaf.com etc... I want to save the...
  15. jgarry

    Number Records Returned in Query

    Thanks for the answer. What Im seeing is almost( not sure of the terms) a double query in one. The first part is selecting each person and doing a count of the record placing that count into the RecNo field. the second is P2 is looking at the pramaters in the SQL statement. am I on track...
  16. jgarry

    Number Records Returned in Query

    Hi, thanks in advace, I have a simple access query showing last and first name with a simple where clause status and sex (Gender), this is not my table, I would like to show the number for each record. Not the Record Number but the number in the Querey. an example would be Smith, Paul...
  17. jgarry

    Installation Backup and delete Tables

    Ok I figured out the delete here is what i had to do, 1st fix some of my code then use the drop table statement in brackets. Brackest becase the person who put this mdb together use names like 90 day Review for table names. Function testdel() Dim db As DAO.Database Dim rs As...
  18. jgarry

    Installation Backup and delete Tables

    Thanks in advance, I am working on an update install program. Prior to begining the Installation/upgrade I want to backup the clients mdb, this backup will be kicked off from another mdb running the upgrade proceedurs. After the backup I want to remove certain tables in the clients mdb I...
  19. jgarry

    Create a table of - table names - fields- etc

    Oh yes I forgot to say Thank you. So Thank you Jim
  20. jgarry

    Create a table of - table names - fields- etc

    Wow PHV !!!!!!!!!!!! that is cool!

Part and Inventory Search

Back
Top