Browse by Tags

Modify Values in Array and pass back to format Excel Spreadsheet

I am passing a recordset to an array and that part is working fine. Code I am using to do that is below. Based on the values in the array I want to change the value to correspond with the appropriate color from the color index. I am using a function to but when I run the code I get a type mismatch error...

Posted to Visual Interdev (Forum) by microsoft on 05-15-2010
Update table using vba recordset

I am creating a string that pulls data from another table that lists all the available sizes for a product, which will be written to a field in my products table, using an update query. I have code to update this field for a particular product that works, but I would like this to happen for each record...

Posted to Access Coding/Macros (Forum) by microsoft on 04-24-2010
How to copy FoxPro recordset into existing Access Table using VBA

I want to query FoxPro using a DSN-less connection and insert the recordset retrieved into an existing Access table using the best way possible in VBA in Access. Suggestions? Thanks!

Posted to Access (Forum) by microsoft on 03-30-2010
Access VBA, Excel, Copy Recordset, Column Headings

I have a recordset that I copy into an excel file. Is it possible when I copy the recordset that I can also copy the column names from tbl_Quote_Equipment into the excel file? strSQL = "Select * from tbl_Quote_Equipment where QuoteNo = '" & Me.txtQuoteNo & "';" Set...

Posted to Access (Forum) by microsoft on 12-06-2009
Access- How do I LOOP Through records in a form?

Help! I can't figure out how to use the loop codes, though I have come across a few. In Microsoft Access 2003, USING: Table1 WidgetID WidgetNumber Form1 Continuous based on Table1 I want the On_Click to loop through the form or just the tables records, and if WidgetNumber is = 1 then do something...

Posted to Access (Forum) by microsoft on 08-31-2009
VBA Code to copy to new record from recordset

I have a recordset that I need to create a new record and copy the data from the recordset into the new record(s) - with new id and Job #. Note: that the recordsource is also the table I want to update. I don't see a copy option for rs.addnew, rs.copy? Dim rs As Recordset Dim strSQL As String strSQL...

Posted to Access (Forum) by microsoft on 08-12-2009
VBA Recordset returns zero records but same SQL statement in query has records

Hello, I'm creating a recordset in VBA, but it is constructed with no records. If I copy paste the strSQL used to create the recordset into a query, I get 9 records. Any ideas why this is happening? I've made sure there are explicit references to the query being used in the SELECT statement....

Posted to Access (Forum) by microsoft on 08-04-2009
Access vba search recordset for value

I have a table that has a recordsource with 3 tables in it. This form has a button on it and the button creates records in another table. I am having a problem searching through the recordset for the record I am currently editing. Please see code below and tell me where im going wrong. Thanks Code Snippet...

Posted to Access (Forum) by microsoft on 07-27-2009
Access VBA DAO recordset for use as table in additional DAO recordset

What I would like to do is use 2 DAO recordset2, as below, Dim db1 As DAO.Database Dim rs1 As DAO.Recordset Dim qdf1 As QueryDef Set db1 = CurrentDb() Set qdf1 = db1.CreateQueryDef("") qdf1.SQL = "SELECT Table1.* " & _ "FROM Table1;" Set rs1 = qdf1.OpenRecordset() Dim...

Posted to Access (Forum) by microsoft on 07-25-2009
MS Access VBA - Run Executable Query Based Upon VBA Recordset

I have the following: strSQL = "Select a ton of stuff" Set rstTonOfStuff = db.OpenRecordset(strSQL) db.Execute "Insert Into table (field, field...) Select " & rstTonOfStuff!Field & " , " & rstTonOfStuff!Field & " , " & rstTonOfStuff!Field &...

Posted to Access Coding/Macros (Forum) by microsoft on 07-14-2009

Page 1 of 2 (19 items) 1 2 Next >