Recent content by javanic

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 -

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 -

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

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

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

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

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

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

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

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 -

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 -

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

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