Recent content by Knobbie

Hi Thanks for the correction on EBCDIC - Extended Binary Coded Decimal Interchange Code. Until a week ago I've never heard of EBCDIC (and never want to hear it again!) Anyway, I have almost finished my little application, I was busy all day with it and got it to work - almost. Just a little...

One way to do this is through code (of course). In the Form you have the textbox (we'll call it txtbox1). The code should probably be something like this: dim strTableName as string dim strSQL as string 'This will get the string name of the table strTableName = me.txtbox1.value 'This is...

Hi Thanks for responding, The reason I had the same question in 2 forums is that the problem kind of hit in both sides (queries and vba). Anyway I'll give you a little background on what my situation that I have: My company is a health care management Co. That manages and runs claims for...

well I did some research and found the following code in the help files (finally!) I figured I'd post it here if anyone else has had the same problem: DoCmd.TransferText [transfertype][, specificationname], tablename, filename[, hasfieldnames][, HTMLtablename][, codepage] unfortuneatley dont...

you go into the design view of the table, hi-light both columns, then press the primary key button and you get a multi column primary key for that table.

I have a situation where I need to export a query into a text file to match ASCII standards. I have the query created and I have the code to loop through the query one row at a time and make the appropriate adjustments to each row (needing to add '|' and '~' delimiters for labels and data so...

I have a situation where I need to export a query into a text file to match ASCII standards. I have the query created and I have the code to loop through the query one row at a time and make the appropriate adjustments to each row (needing to add '|' and '~' delimiters for labels and data so...