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 bkrike 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
  • Content: Threads
  • Order by date
  1. 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...
  2. 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...
  3. 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...
  4. 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...
  5. 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...
  6. 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...
  7. jgarry

    Create a table of - table names - fields- etc

    Hi, thanks in advance, I want to create a table of my current dbf that contains 1 the table name 2 fields within the table 3 Field Size, format, input mast caption etc. all the filed information. The reason is becase I am creating an upgrade to a product that has many versions. I want...
  8. jgarry

    Past Network+ on firt Try! Today!

    Wow! I did it! Passed on my first attempt. and Yes it was tough! I spent the last few weeks studying. I found that If I set the test date, I then get down and study. This is a test I needed to study for. Not that I did not know about networking, I've been working with them since novell...
  9. jgarry

    Past Core Hardware Test Today Now A+

    Hi folks, Its been a long time since I posted here but just overjoyed. I past the Core hardware part of A+ today! I passed the OS awhile ago!! Feels Great!!! Next is Net + in about 2 weeks. Score was 635, not great but not bad. Yes it is worth doing. I now know that I do know the...
  10. jgarry

    Project's Report Selection Layout

    Hi, thanks in advace. Im working on a project (as are many people), I have come to the point where I want to improve the way I present reports to the users. Currently I have 8 areas that the users selects with in each area their is a list box of reports that they can select. This is nice...
  11. jgarry

    Combo Box and Navagation Buttons

    Thanks in advace. I have a Combo Box with a Query in it. I want to be able to use buttons on the form to move to the next record instead of the combo box. the form is unbound. when I try to use the navagaion buttons I get the message "the object '5305' isn't open" on the click event of the...
  12. jgarry

    Array of a Form?

    Array or not to Array? Thanks in Advance! I want to create a module to process data on different forms. I’m thinking about making an array when a form is opened of the beginning data. Then if a specific button is pressed, create another array of form data and compare the two. Noting the...
  13. jgarry

    Error "Can't set the enabled property after printing has started"

    Thanks in advance the compelete message is: the Following error occured: you can't set the Enabled property after printing has started Try setting this property in the OnOpen event. I am running a access 97 application. This portion of the program occurs after the report is selected and run...
  14. jgarry

    Setting options in VBA or registry Access 97

    Hi, thanks in advance: Im having a problem with my access 97 system. I go into the tools/ options/ advanced tab. I want to change the Error trapping from break in class module to break on unhandled errors. I make the change then run my program but the error trapping goes back to break in...
  15. jgarry

    SQL Connection on the Fly

    Hi, thanks in advance. I am using vfp6 to attach to Sql 7/2000 databases. I can connect on my system using a connection string and do what I want. BUT What I need to do is to be able to have the users connect to different Sql databases. The structure and format of the databases will be the...
  16. jgarry

    Alias name is already in use ??

    Hi, thanks in advance. I am working with an array that contains tables that I want to clear out and then refill. It is working fine until I get to : Val_tier1. at this point I get the message: “Alias name is already in use” The file Val_tier1 is the 5th file processed. The only...
  17. jgarry

    Import Text file Numbers as characters

    Hi, Thanks for your assistance Im modifying a program that imports a lot of .txt files this is no problem. My problem is I have two fields in the text file that are numbers that need to be brought in as characters. I do not have access to the export that creates the .txt file so I cannot...
  18. jgarry

    Grab the sub name from within the sub ?

    Hi, Thanks in advance, I would like to be abel to grab the name of a text box from with inside the private sub. This would be use as a passing paramater an example would be text box: txt_PlanTotalCost Private sub txt_plan_beforeUpdate(cancel as integer) WAU "txt_Plan"...
  19. jgarry

    Oldvalue option not given on field

    Hi, thanks in advance. Im using oldvalue to check to see if changes have been made to a field. my problem is... I have a fields from a table that show up but do not have an oldvalue options to them. see below: Private Sub txt_PlanTotalCost_BeforeUpdate(Cancel As Integer) WAU...
  20. jgarry

    End of Module Procedures?

    Hi, thanks in advance. My question has to do with Recordsets and Database. Using DAO on the top of modules I set the record sets up with Dim rs as recordset Dim db as database Dim Tdf as Tabledef No problems. Now as I understand it I should at the end of my modules or when I am...

Part and Inventory Search

Back
Top