Search results

I have a table that has debits and credits in two different columns along with other info. as you can see from the attached Excel there is one debit for each credit. in some cases though there is one debit and 2 or more credits that sum up that ammount. the common thing that Debits and...

i think Access will be more efficient for you... i can give you some book titles that will guide you easily to create what you want.

thanks Bob... it worked like a charm... thanks again

I edited my previous post ...

The Sum Formula doesnt work well i didnt put my whole code... this is the whole code... Dim xlApp As Excel.Application Dim xlwkbk As Excel.Workbook Dim xlsheet As Excel.Worksheet Dim objRST As Recordset Dim rec As Recordset Dim RsCntry As Recordset Dim RsProj As Recordset Dim RsDebits As...

xlApp.Sheets("Sheet2").Select xlApp.ActiveSheet.Range("A1").Select xlApp.ActiveCell.Offset(2, 0).Cells.Select xlApp.ActiveCell.CopyFromRecordset RsProj xlApp.ActiveSheet.Range("N1").Select xlApp.ActiveCell.Offset(2, 0).Cells.Select xlApp.ActiveCell.CopyFromRecordset...

when should i set it to zero? how? i close the first workbook, set to zero, open new excel? how?

it is one worksheet and then am saving it closing it and i open a new one.. i want the same thing done there.. can you check at my code please? thanks for the help!

this is my code.. Sub Debit_Notes() Dim xlApp As Excel.Application Dim xlwkbk As Excel.Workbook Dim xlsheet As Excel.Worksheet Dim objRST As Recordset Dim rec As Recordset Dim RsCntry As Recordset Dim lvlColumn As Integer Dim i As Integer Dim f As Variant Dim startrange As Excel.Range Dim...

it works but i save it and open up again my template to do the same thing in the next record of the recordset it stucks. basically i am creating new workbook for every record in my recordset. i think i need to set the group of that... in order to be ok any idea? xlapp.activesheet.???? thanks man

I need to locate using VB the last row that contains data go down 3 rows and start adding a recordset.. i have the recordeset but not the location? any ideas how can i locate it? any ideas where can i find help about the Excel Object? thanks guys

I want to write a line that will check a table. if that table is empty i want to execute the following line DoCmd.CopyObject , RDebit, acTable, "Generic" i open the recordset like this.... Set RsDebit = CurrentDb.OpenRecordset("SELECT SOBP FROM RFGDebitNotes;") RDebit = RsDebit!SOBP &...

i dont have any forms... its the table i want to search for empty fields.....

I have a table and i want to add a control that will give me a message box if there is an empty field. i am running a process that fills a table.. after this is finished i want to add this control? can i indicate which lines are empty? any ideas? if i run an sql from vba for is null then what...

i counted the with and the end and are correct? if it was one more end with it would give me an error anyway.... my syntax on the recordeset is ok? how do i save the worksheet?

i did the changes.. it loops to create the sheets but it doesnt copy the records from the recordsets.. u think i have a syntax error? Set xlApp = CreateObject("Excel.Application") xlApp.Visible = True Set xlWorkbook = xlApp.Workbooks.Add xlWorkbook.Worksheets("Sheet1").Delete...

i have th following code that runs for one of my tables... the thing is that i need to get the name of the table every time and loop the code. all the tables are listed in one table so i have RFGWORKING (it lists all my working tables) the code for the one table is... 'Table RN00144GE3RFG...

I was using an update query but had the wrong criteria.. i corrected it and it works just fine.. thanks for the pointer!

I have a table that is static. it has listed the following things. let me call it table A Table A Code Rate Org 123 e rf 234 t rg 125 g lk then i run a query for another table to get the working codes.. these that the only codes am going to use...

I am building a utility that imports data in a big table. from that table i have to go and look at one column that will give me the names of the tables that need to be created. this is done the firs time. Second thing i have to run to that column again. get the names of the tables again and...