Search results for query: *

Thanks for the code. Can we do it in one step because it is a big table?

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 =...

It is in access database. I try to use this code in Excel VBA.

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 PHV, I'm not sure how to put these codes together.

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 =...

Hi PHV, Thanks for your quick response. The code works but it takes a few minutes to upload the whole data (>14,000 rows) by looping through every rows and columns. Can/How I just write the code to copy the whole matrix in excel and paste that to the table in access to reduce the time?

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 back. I changed MySheet to Sheets("Fact") then it worked. I though I did not have to define MySheet. I still get the error stated from above: "Acrobat coult not open.." ----------- Sub Macro5() ' Dim PDFFileName As String ' PDFFileName = "E:\myPDF.pdf"...

Hi PH, I have 5 different ranges names in the spread sheet and they all have different setting for printing. My goal is trying to create a single pdf file containing all 5 print pages. So far I'm having problem with just one page. Hope you can help.

The MySheet is a range name and defined in the spread sheet. It is created by Insert-Name-Define-MySheet.

Hi PH, I got the run-time error '424' --- Object required. Thanks. Sub Macro5() ' Dim PDFFileName As String ' PDFFileName = "E:\myPDF.pdf" MySheet.Range("MyRange").PrintOut copies:=1, preview:=False, ActivePrinter:="Adobe PDF", PrintToFile:=True, Collate:=True...

Thanks, Swi for your quick response. Yes, I did. It required to have the pdfcreator installed from sourceforge.net. I was hoping that I can do it without the pdfcreator. Otherwise, it will require other my users to install it as well before they can use the macros.

I use the below marco to create the myPDF.pdf. I get this message when trying to open it. The error said: "Acrobat coult not open 'myPDF.pdf' because it is either not a supported file type or because the file has been damaged (for example, it was sent as an email attachment and wasn't...

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.

Hi Phil, I guess mine is SQL 2000. Could you post your pivot scripts for us? Thanks.

Hi, I'm not sure the questions, but this is the codes I used: Sqt = " SELECT Year" - & " Sum( Case Month when 1 then Loss else 0 end), " _ ....... & " Sum( Case Month when 12 then Loss else 0 end), " _ & " FROM " & iTable _ & " GROUP BY Year" cnt.Open strconn I just wonder...