Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. cogivina

    How to import table into access?

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

    How to import table into access?

    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...
  3. cogivina

    Cumulative Data query in Access

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

    Cumulative Data query in Access

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

    Syntax error in FROM clause

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

    Syntax error in FROM clause

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

    Set RowSource for the combobox using the Query Result or values list

    Hi PHV, I'm not sure how to put these codes together.
  8. cogivina

    Set RowSource for the combobox using the Query Result or values list

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

    Simplify the vba code

    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?
  10. cogivina

    Simplify the vba code

    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...
  11. cogivina

    How to save a print range from Excel to pdf file?

    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"...
  12. cogivina

    How to save a print range from Excel to pdf file?

    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.
  13. cogivina

    How to save a print range from Excel to pdf file?

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

    How to save a print range from Excel to pdf file?

    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...
  15. cogivina

    How to save a print range from Excel to pdf file?

    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.
  16. cogivina

    How to save a print range from Excel to pdf file?

    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...
  17. cogivina

    Merge multiple pdf or ps (distiller) files into one single pdf in VBA?

    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...
  18. cogivina

    How to save a print range from Excel to pdf file?

    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.
  19. cogivina

    How to create a pivot table in SQL servers?

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

    How to create a pivot table in SQL servers?

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

Part and Inventory Search

Back
Top