Search results

So I'm hacking and slashing my way to learn VBA and I've come across something that no clue to figure out. I have a Msgbox that prompts the user to import a file ("Yes") or opens the file to be edited ("No") and then (hopefully) upon saving and closing the Excel spreadsheet I'd then like it to...

I've noticed lately doing some exporting to Excel any text field seems to yield an apostrophe. I've tried to find more on this and it seems to be the norm. Anyone know of a way to prevent this? The table I'm exporting is being used to update inventory via an upload and the system is reading the...

I'm pretty sure I've seen this one but for some reason the forum search isn't returning what I'm looking for. Just looking for a simple msgbox. I have a button that runs a query and exports it. I'd like to insert a Yes/No msg box, if the user clicks yes the query is run and exported, if the...

Private Sub Cust_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 = ".xls" Identity = Format(Date, "mmddyy")...

I'm still tinkering through a project I've tasked myself with and I've come into a small issue with running a query. The SQL state below removes all ItemNumbers from discontinued stock that have 0 available quantity in any of its sizes. INSERT INTO tblBSLR ( ItemNumber ) SELECT...

I'm exporting a table from access to an Excel spreadsheet, the date format within the table is YYYYMMDD, however, when exported and opened in Excel it converts the date to MM/DD/YYYY. Normally this wouldn't be a problem except I'm uploading it via FTP and it requires YYYYMMDD, I'd like to make...

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.

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

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?

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

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?

Using a DoCmd.RunSQL to create a column in a table, now I need to set the default value and I'm unsure how to do that. Is it in the syntax? What I've found thus far hasn't worked for me. DoCmd.RunSQL "ALTER TABLE tblSears ADD COLUMN [FileType] Text;" Thanks in advance,

It's been a long time since I've had anything to do with Access, but I'm back at it again. I am currently using Excel to do a number of inventory reports on a daily basis. I would like to condense these into Access. There is a daily report of all of our stock in Excel. I would like to be able...