Search results

  1. C

    Exporting to Excel what am I missing?

    User was edited out to maintain my anonymity :p
  2. C

    Exporting to Excel what am I missing?

    It's possible, but I've used the same code for a | delimited text file I put together earlier and it worked.
  3. C

    Exporting to Excel what am I missing?

    You again >.> Lol Private Sub BSLR_Report_Click() Dim Identity As Variant Dim Location As String Dim Extension As String Dim Identity1 As String Dim stDocName As String On Error Resume Next Extension = ".csv" Identity = Format(Now()...
  4. C

    Exporting to Excel what am I missing?

    DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "tblBSLR", Location, True, "", "" I append the table just prior to exporting, there are no errors in the code but there's not brand new spreadsheet on my desktop.
  5. C

    Excel Macro to Access Query

    Sub Remove_NoStock() Dim i As Long Application.ScreenUpdating = False For i = Cells(Rows.Count, 1).End(xlUp).Row To 2 Step -1 If Cells(i, 3) = "D" And _ Application.WorksheetFunction.SumIf(Range("A:A"), Cells(i, 1), Range("G:G")) = 0 Then Cells(i, 1).EntireRow.Delete End If...
  6. C

    Custom Delimiter?

    Works like a charm :D
  7. C

    Custom Delimiter?

    I'll look into that :) I'm beginning to get the impression you're following me!
  8. C

    "Query is too complex"

    Thanks, I'll give it a shot :)
  9. C

    Custom Delimiter?

    I need to export a table to a | delimited file. Is there a syntax for this in TransferText action? Or do I need to look for another way to go about this?
  10. C

    "Query is too complex"

    I was not aware of that, learning as I go lol :) Is there a limit the the number variables using an IN statement?
  11. C

    "Query is too complex"

    Figured out why it wasn't appending any records now just curious to the length of my sql statement, for the moment I've written 4 different queries and just appended one onto the next.
  12. C

    "Query is too complex"

    INSERT INTO tblCSN ( [UPC Number], Available, Description, Type ) SELECT tblInventory.[UPC Number], tblInventory.Available, tblDescription.Description, tblInventory.Type FROM (tblInventory INNER JOIN tblCSN ON tblInventory.[UPC Number] = tblCSN.[UPC Number]) INNER JOIN tblDescription ON...
  13. C

    "Query is too complex"

    I am running a simple query to that appends data to a table by ItemNumber, unfortunately I have about 300 ItemNumbers to run against my Inventory table. The error I'm getting is "The Query is too complex", other than creating multiple queries and appending the data each time is there a way...
  14. C

    Export Only Certain fields within a table

    Figured it out :)
  15. C

    Export Only Certain fields within a table

    I thought I might have to go that route but was hoping I could spare myself an additional dozen queries if I could just export the table -one. :( Supposing I want to save it with the current date? DoCmd.TransferSpreadsheet acExportDelim, "qryName", ???
  16. C

    Export Only Certain fields within a table

    I need to create a CSV from a table I have, however, I have an extra field that contains data our vendors do not need to see. The only method I'm familiar with is DoCmd.TransferText acExportDelim Any thoughts on this one?
  17. C

    Setting default value in a column

    Inventory table: (imported from Excel) UPC Item# Type Size Width Price Available Customer specific table: UPC MerchantSKU Price ItemAttrib table (Might need to add UPC) Item# Description Report table: (final output needs to have all of these) Filetype (Always "IN" for Inventory) UPC...
  18. C

    Setting default value in a column

    The query is run against the Inventory file which doesn't contain half of the information I need, I've attempted running a report but it has come up empty.
  19. C

    Setting default value in a column

    So I have three tables now. Inventory Prices&SKUS and the blank report with all the report specific fields. At this point, stop me if I'm wrong :D, I need to run a query to select the styles I need from the Inventory report and make a seperate table. Then I need to update the blank report with...
  20. C

    Setting default value in a column

    Well, it was recreate the tables OR delete all the data stored in the table and then update it.
Back
Top Bottom