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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by javanic

  1. javanic

    Excel Com port communication

    Richard, Please do post detailed instructions on how to register MSComm. I've been searching for that info on and off for some time. Thanks, - javanic -
  2. javanic

    VBA help with opening and checking workbooks

    The macro recorder does produce nasty code, but I often use it to get me started with a particular task. If you got the macro to do what you want, then you may be able to generalize (and clean up) the code to accomplish your task. - javanic -
  3. javanic

    Excel Com port communication

    I noticed something strange about CheapComm. Has anyone else seen this: bool b = cheapcomm1.OpenCommPort("COM1", "9600,n,8,1") b is always true even if CheapComm displays a pop-up saying that the port could not be opened. This happens regardless of the port opened or the serial frame...
  4. javanic

    Excel Com port communication

    I've been looking through these posts on Tek-tips trying to find info on Com Port programming. I've since downloaded CheapComm and installed it. The help file refers C++ users to the CPTIComm32 class that supposedly comes in some source file. However, I can't find this file, nor any source code...
  5. javanic

    ANSI- query to Access query, Help.

    OK. Let's give it a shot. Let me know if this is more confusing; it is to me. I'm not very familiar with the database structure. tblTraces has information about metal ingots, TUBEs, and RODs, and probably other products as well. Each ingot, TUBE and ROD has a FROM_MATL_ID which refers to the...
  6. javanic

    ANSI- query to Access query, Help.

    Thanks for your responses. I've been doing some digging in an Oracle book although I still need to duplicate this somehow in Access. scriverb, Sorry. I couldn't have told you in plain words what 'connect by prior' meant when I posted because I had no idea myself. Cheerio is on to something...
  7. javanic

    ANSI- query to Access query, Help.

    Hi. I've got this Oracle query that I need to duplicate in Access (or Excel). Can someone tell me how to duplicate this functionality? SELECT DISTINCT A.SUB_TYPE, A.USAG_LOT_NUMBER FROM TBL.TRACES A WHERE A.SUB_TYPE='TUBE' START WITH A.TO_MATL_ID = (SELECT MATL_ID FROM TBL.PRODUCTS WHERE...
  8. javanic

    Entire record to string, not individual fields

    Hi. Is there a way to send an entire record to a string without having to reference each field in the record? I would like to loop through a recordset, sending each record to a string for display. I don't need to update the recordset ever, so I don't really want to mess with it. Hope this...
  9. javanic

    Form unload error: 361. Why?

    Thanks again, billpower. I'm learning more each time. When I first tried the code you gave me, Access still complained. I dug deeper and caught sight of the word "string" in help. I was using the actual form name, not a variable, as I would in Excel VBA. Apparently in Access, and with...
  10. javanic

    Form unload error: 361. Why?

    Thanks, billpower. With the addition of quotes around the form name, your code worked. Private Sub cmdExit_Click() Docmd.Close acForm, &quot;frmMyForm&quot; <--- quotes needed End Sub - javanic -
  11. javanic

    Form unload error: 361. Why?

    Hi. In Excel VBA, I have this code: Private Sub cmdExit_Click() Unload frmMyForm End Sub It works in Excel. But in Access, I have the identical code, and it doesn't work. It gives me Run Time Error 361 - Can't load or unload this object. Thanks for you help in advance, - javanic -
  12. javanic

    Listing column names in combo box. How??

    Man, some things sure are easy! I wish it were all like that. Thanks. javanic
  13. javanic

    Listing column names in combo box. How??

    Hi. I'm quite new to Access programming, so please bear with me. I would like to fill a combo box with the column names contained in a table. The user would select a column name and then fill in a text box to create a query. How can I fill the combo box with just the column names/headings of a...
See more

Part and Inventory Search

Back
Top