Search results for query: *

Hello all, I have gleaned measures from this site, and haven't had to post very often. Unfortunately, I am stumped at this phase in my project. Setup: Old COBOL dos program feeds info into my spreadsheet. Commands include arcaic random key presses (i.e. 13 = main menu. 24 = print F2 = exit...

I have searched through the forum for anthing related to user defined objects, or user created objects. What I'm looking for is a basic set of code to create an object and attach methods and variables to it. Something like: <Define UserObject> Dim MyObject as new UserObject MyObject.MyName =...

Hello all, I am trying to link a sheet from an excel spreadsheet to my database via code. The code looks like this: DoCmd.TransferSpreadsheet acLink, 8, &quot;Exports-ASN&quot;, MyLocation + &quot;Account Status Notebook\Account Status Notebook.xls&quot;, False, &quot;Exports!Print Area&quot...

I've searched and searched the forum but have come up with nothing. I'm sure it is simple and I just missed something basic. I have a table. In this table is a record. I know what record it is by field name and row. Using ADODB I want to update that single record. i.e. NameTable...

I have followed the threads on this forum for some time with great success. Now I am trying to open up a recordset from a precreated table, delete all records in that table, and read in the new ones. Here is the important part of the code: The problem is trying to DELETE the rows without...

I'm using the ADO database object model so the DAO/ADO issue shouldn't be a problem. I'm trying to select all records in a column of a table and display them. here is the code Sub SelectAllFields() Dim strSQL As String 'Query, selecting all fields from the ClientList table strSQL =...