Search results for query: *

If I have a table as such: Prov Num Field 123 aaa 123 bbb 123 ccc 456 xxx 456 zzz How would I go about getting: Prov Num Field1 Field2 Field3 123 aaa bbb ccc 456 xxx zzz

The recommendation from Alex Dybenkos is where I originally started. I modified the code from there to get to where I am now. The other references seem to all create an Excel object. Thinking in another direction is there code I can use to extract the data from the Excel spreadsheet without...

Without creating the Excel and workbook objects how do I pass along the password for the file? Running it as you posted I get an error stating it "Could not decrypt file."

I'm using VBA in Access 2003 to open an Excel spreadsheet and dump data from two worksheets into two tables. The code does not work if Excel is already open, and once the code ends the Excel process is left running. To further complicate things even with just the process open the code does not...

>>And what is wrong with it? BTW why not use default value for Stamp to be GETDATE() and change this:<< Actually it looks like it does work. I guess I was just second guessing myself since I'm not really that familair with SQL Server, I work in VBA in Access (and will be accessing these tables...

CREATE TRIGGER tr_InvoiceHistoried_INSERT ON RM30101 FOR INSERT AS INSERT INTO stmClosedInvoices (CustomerNumber, DocNumber, Stamp) SELECT CUSTNMBR, DOCNUMBR, { fn NOW() } AS Expr1 FROM inserted WHERE (LEFT(DOCNUMBR, 3) = 'INV')

I currently have a table with many fields and want to add a record (with only some data) to a second table when a record is added to the first. When a record is added to the first table if the DOCNUMBR field of the record added starts with 'INV' I want to add a record to my second table. Fields...

I'm having the same exact problem as the original poster but the answer given doesn't apply to my case. Here is the SQL I'm using in Access to try to append to an SQL Server table. INSERT INTO dbo_FRCBILLD ( Bill_ID, TrackingID, ChargeType, ChargeAmount ) SELECT tblBillDetail.Bill_ID...

I seem to be resurrecting a long dead thread here but my problem seems identical and the solution isn't working for me. I was trying to use MSQuery to get data from Access into Excel. The query in question combines a crosstab and a union query. After having no luck there I searched here and...

I tried changing the height of the detail section of a report using code in the open event of a form based on a option group on a form (i.e. selecting first option would have the section height .1667 and the second option would have the height .5). This didn't seem to work then I came across...