Search results for query: *

In Access you can create a Cross tab query, which is basically a Pivot table in Excel. This si the code that Access generates fro one of my queries: TRANSFORM Sum([Summary 3].[ESC ADV BAL]) AS [The Value]" & _ "SELECT [Summary 3].[INV GROUP3], Sum([Summary 3].[ESC ADV BAL]) AS [Total Of ESC ADV...

I am soon going to be working with SQL Server, and not Access. Currently I do not have away to try this. So I was woundering if anyone knows if this can be done with SQL Server. Currently I use something like this to import an Excel sheet to an Access Database table: StrSQL = "SELECT...

Hi, I have code that opens Excel and inputs data, but some times it gets hung up because Excel is left runing in the backround. ANd my code has xl1.ActiveWorkbook.Save xl1.Quit which seems to do nothing. Is there any way to kill the the excel process, before I run my code, that may be left...

Hi, I have code that opens Excel and inputs data, but some times it gets hung up because Excel is left runing in the backround. ANd my code has xl1.ActiveWorkbook.Save xl1.Quit which seems to do nothing. Is there any way to kill the the excel process, before I run my code, that may be left...

Hi, I am writing out a sum of cells, in an Excel spread sheet, from my VBA in Access. It will go through a loop first summing C4:C11 and then D4:D11 and so on. Each time this will be different, the program figures out how far it will go. In any case I need to do something like this...

Hi, I tring to use an array the different catigories listed below. I got htis code work if I do it without loops, but that makes it really long, because I have a number of these. However, the problem that I am having is that it is not excepting the array in the sql statement. I know this...

Hi, This code part of a large program that I am developing and I have used this extensivly through out the program with success. However, here it is not working because I hve LOAN_TYPE = 11 FHA. I know this is the case because if I take out the where clause it works. If I set it to not Null it...

Hi, I am trying to put the data from the table tblPB_>_0_Crosstab_Counts and from the field 30 Days, and it just keeps running in a continues loop. If I hold the cursor over the connection it shows the right connection, but if I hold it over the Rs..EOF it say “ Operation is not allowed when...

Hi, Can you run an Access Report or a Crystal Report from a VB application? And if so can someone give me an idea how to code that or where AI can learn that. Thank You ITM

Hi, I am trying to get a SUB Query to Show only loans with the Max Date. Here are the loans woith the original data ( Sorry that htis is meesed up but I did not know how to get this in here other wise). LoanNum Date LoanBalance Borrower Name Bowwer Address BowwerCity Bowwer State...

Hi, I have records from a database going to a list box that looks as follows: Bill Edwards 3nm The service was good Customer Service KELLER CATHERINE L 4b63 They were good They were good. I woulds like to format htis some how to look like this: Bill Edwards 3nm The service was...

Hi, I tryig to show all the records from a select statement in a lstbox. In Access you can do something like this: Me!lstOPut.RowSource = "SELECT Customer,User, Name, [Q8 Verb], Department FROM testTable" but the only this that has a RowSource property is a Dblist control. But dooing the...

Hi, I am trying to take the records that are created in the first table, that I create here ( which does work), and enter the records into a listbox. With all the things I tryed I did once get the first rcord in, but that was it; and now I cannnot seem to gret that anymore. Any idesas on what I...

Hi, I have a list of names in Column A that look like this STEPHEN J DUNN and I ma looking for a way Through a formula or vba code, to copy just the last name to another column. Also, the name sometimes has a midle Intial (or otther names) and sometimes it don't; but the last name is always at...

Hi, I have an Excel file that I am trying ot import into an Access Table. I have been using a DoCmd.TransferSpreadsheet function to bring in the data, and it has worked up untill now. This one sheet it goes to about record 10001 and stops. does not give an error just stops bringing in anymore...

Hi, I am not sure what I need to do here, but I am trying to open a word Doc, which gives the user instructions, but it is not working. This is waht I use in Access VBA, do I need something different in VB6.? Shell ("WinWord.exe J:\APPSUPT\Procedure\MersMonthlyStats.doc") Thank you

Hi, I have been working mostly with SQL server, but now will be working this Oracle. I was wondering if someone can teel me waht VB6 Connection strings and select statements would look like for Oracle. For example how would I do the following in Oracle. Thank You Public adoConnect As...

Hi, I have been working mostly with SQL server, but now will be working this Oracle. I was wondering if someone can teel me waht VB6 Connection strings and select statements would look like for Oracle. For example how would I do the following in Oracle. Thank You Public adoConnect As...

I was wondering what are tipical RAM sises used on a giving SQL sever, and waht sise processors are used andd are dual processors tipically. I also, was wondering if there is a table or database. I am asking this because I worked with ACCESS and I know that at about the 300,000 mark you are...

Hi, I am trying to put the data from a table into an Excel spreadsheet. People I work with said that they have done something like the following, but are not quite sure of the systex. THey said this should create the spreadsheet and insert the data. However, no matteres how I do this it comes...