Search results

I'm using Access 2003, and I've got a form button that appends criteria to an existing table and exports it using the DoCmd.TransferSpreadsheet.

Had a thought I'm going to run with, but I figured I'd post it and possibly get some input. The problem with the Excel file is it contains blank fields in the UPC column which just so happens to be the primary key. Rather than brwse -> open said spreadsheet, I'm going to assume I can vba a link...

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

Even by dropping the Header syntax (default is false I think) I can't seem to remove them I'll give the link a shot.

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 see, I need all fields in the table returned on both queries. That's my inexperience showing =)

Both queries are applied to the same table, so this shouldn't be a problem, correct?

I have a lengthy list of criteria was hoping to cirumvent a long OR statement using a LIKE/IN. As far as the UNION you referring to the fields addressed in the statement or in the table? I'll have to check up on this.

Trying to combine to queries using the union statement. I think for the most part that's working; however, now I am running into an issue using LIKE IN in a NOT IN subquery. Any thoughts? SELECT tbl.tblfield, * FROM tbl WHERE tbl.tblfield In (select tbl.tblfield from tbl where tbl.tblfield1 =...

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

It's done in such a manner, DefaultValue is Date(), Format is YYYYMMDD and the field type is text.

I guess what I'm asking is if there's a way to force the same format to be carried over so it doesn't change.

Bump for good measure, anyone?

Atm the moment it is just set in the table field properties as I'm exporting the table.

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

Yeah, it's working now that I changed the .csv to .xls. I didn't even look that far up I was so intent on the export code. I changed up a couple of things that you suggested SOS but if I remove the OpenQuery for some reason it doesn't append any data back into the table. Thanks a bunch guys. :D

Silly question, the Extension is predefined as a .csv, I'm betting that's it?

It's got to be something to do with the export line. The data is removed, query is run, table is re-populated, even the F's have been replaced with N's, D's with Y's. Its running as it should up until the export line upon which nothing happens.