Search results

  1. S

    Output to Excel (over 65535)

    Howdy: I know little-to-nothing regarding VBA, syntaxwise, so bear with me. Here's what I need to do. I'm running Access 2000, first off. I've got a file that's processed and needs to be exported to Excel for report purposes). In certain cases, the file may be larger than the 65535 record...
  2. S

    Recommend a Reference Book(s)

    I'd like to learn VBA for use in both Excel (majority) and Access (a little). I'm familiar with SQL, took C++/C# a couple years back, and am currently learning SAS, so I don't need a 'Teach yourself in 24 hours' or 'Weekend Crash Course' type. Reference book series that I currently have that I...
  3. S

    Insert Query Result into an Existing Column

    Hello again. I've got a query that takes a part number, strips off the un-needed prefixes and suffixes, and gives me just the meat & potatoes of what I need. I'd like to insert these results into a particular column in an existing table. Say the column name is Part_Number and the table name is...
  4. S

    Delete Results from Append Query

    Sorry, I really couldn't think of a solid title for this. I'll try and explain and provide some code as well. I've got a series of tables, one of which is linked to a Mobile Device. I have a query (herein called Query A) that queries a masterfile, named MasterFileEdit, based on selections the...
Back
Top Bottom