Search results for query: *

I have a table that need to import into access. The problem is that the minus (-) sign in the amount field causing the issue. The data looks like this: #####- A 1.20- B 505 B 61.5- How can I import this into Access correctly? I'd like the data field to look like this: A -1.20 B 505 B...

Hi, I have this problem and I don't know how to write a query in MS access. I'd like to create the cumulative sales for every following month based on the table below: Year Mos Sales 2000 1 55 2000 3 78 2000 6 62 2000 10 45 2001 2 36 2001 12 59 ---------------------- mos1 = 55 mos2 =...

Hi, I have this problem and I don't know how to write a query in MS access. I'd like to create the cumulative sales for every following month based on the table below: Year Mos Sales 2000 1 55 2000 3 78 2000 6 62 2000 10 45 2001 2 36 2001 12 59 ---------------------- mos1 = 55 mos2 =...

Hi, I have two test tables. One is, SALE, contained State, Yr, Month, Paid. Some data might be missing or null. SALE: State Yr Mos Paid AK 2000 1 150 AK 2002 3 250 CT 2008 1 444 ... The other table, Table0, contains all the states, Yrs, Months and 0. Table0: State Yr Mos Paid AK 2000 1 0 AK...

Hi, I would like to set the RowSource for the ComboBox in the form in Excel in one of the two ways: ------------------------------------------- 1) using the result from the query in access. With frmData STRquery = " SELECT Acct FROM myTable GROUP BY Acct" Set rstData =...

I try to upload the data from excel to the table in access database using this long vba code. How can I simplify this code: Set rstData = dbName.OpenRecordset(iTable, dbOpenTable) Range("Upload").Cells(1, 0).Select For iRow = 0 To Range("Upload").Rows.Count - 1 rstData.AddNew...

Hi, I'm using the code from this thread below: http://www.tek-tips.com/viewthread.cfm?qid=416330 I'm able to create a pdf file from a specific excel range name, but I need help to write code in order to merge the all distiller files into one single pdf file. Thanks. Dim PSFileName As...

Hi, I have macro in VBA that would print different range area selections from a worksheet in Excel. With ActiveSheet.PageSetup .PrintArea = "My_Print_Sel" ActiveSheet.PrintOut End with I'd like to save My_Print_Sel into a pdf file. Please help. Thanks.

In Access database, the below query should run: TRANSFORM sum(Loss) SELECT Year FROM iTable GROUP BY Year PIVOT Month; How should I write the code in MS SQL servers?

Hi, When I view the macro from a design mode in an access database, there are multiple queries which I can't find in the queries pin. The macro runs to append data to a master table, delete the zero record and set the null value to zero. Is there a way to read these hidden queries? Thanks.

Hi, I have MyFirstFile.xls open and I'd like to execute the Marco "Update_Data" in the module "mUpdate" from the MySecondFile.xls. I get "Application-defined or object-defined error" at the .Application.Run "Update_Data". Set MyXL = GetObject("MySecondFile.xls") With MyXL...

Hi, I want to save the current Excel workbook to a new location with a new name by using this code: ActiveWorkbook.SaveAs FileName:= FilePath & FileName, _ FileFormat:=xlNormal, Password:="", riteResPassword:="", _ ReadOnlyRecommended:=False, CreateBackup:=False What I would like to do is...

Hi, After I run the application using VBA in excel, all the columns were converted to numbers instead of alphabet letters. I don't know what code in the marco to change the setting. Even when I close out the Excel and come back in, the spread sheet still shows in the format R[1]C[1] instead...

Hi, I need help to write the value of a matrix, mtrxA(rows, columns), from vba into excel...Thanks. Dim mtrxA(1 To Rows, 1 To Cols) mtrxA(1, 1) = 1 mtrxA(1, 2) = 2 ............ mtrxA(Rows, Cols) = ### Select Case Range("A1") Case "" Range("A1:C" & Cols) =...

Hi, I need help to write the code to set the value of a matrix, mtrxA(rows, columns), from vba into excel...Thanks. Dim mtrxA(1 To Rows, 1 To Cols) mtrxA(1, 1) = 1 mtrxA(1, 2) = 2 ............ mtrxA(Rows, Cols) = ### Select Case Range("A1") Case ""...

Hi, When I closed my Excel file after I made changed or uploaded the data to the server, the screen "File now available - YourFile.xls is now available for editing. Choose Read-Write to open it for editing" keeps opening up. It causes the table on the server still opened and would not allow...

Hi, I have set the height of the listbox (my_table) at 190. but its size always changed everytime the form is openned. How do I keep the table appeared at a constant size? Thanks. With frm_Test .Year.Caption = UCase(Range("Year")) .My_Table.Top = 20 .My_Table.Height...

Hi All, I'm having a problem of trying to update a table in access XP. I received the "error 3027 - cannot update. Database or object is read-only". Please advice. Thanks, ------------------- Sub Update_To_Database() Dim dbName As Database, Dim Strquery As String Dim rstData As Recordset...

Hi, I'm having a problem of understanding how the .BAS file work and running a macro that I obtained from the Exceltip.com. What I try to do is to copy a module1 from Book2.xls to Book1.xls. I get a "Subscript out of range" when I try to run this macro from the Book1.xls. sub Sub...