Search results

Thanks, I will try that.

All the code in Access is written including a Form where you can select a date range and have it run a query along with a few other unrelated things. The code in Excel is also already written where it creates a couple of pivot tables and a few charts. All I am looking for is a way to connect the...

To be clear. I'm not trying to get Access to do everything without Excel. I'm trying to get Access to open Excel and paste the table and then tell Excel to do its thing.

Hello, We have a database that runs a query. The displayed table from that query is then copied and pasted into an excel file and an excel macro is run that creates charts making the information more useful. My question is can we do this (Run Query/Open Excel/Paste query results/Run Excel...

I'm using this to export data from a table to a cvs file: Private Sub SaveAndClose_Click() Dim PartNumber3 As String PartNumber3 = Me.[Order Name] DoCmd.TransferText acExportDelim, , "Rough Order", "C:\Cardinal Order\Rough Orders" + PartNumber3 + ".csv", True The data in the table has 3...

Variables would be start length, blade thickness, starting offcut, minimal ending offcut. And of course all the desired cuts.

Yes, MajP, I am still interested. It looks like my column headers were missing from my post showing the output. The first column is quantity, the next is length of starting peice, then leftover, and finally the individual cuts.

Thank you to everyone for trying to help!

I believe I did try that and my leading 0s were dropped. So 05/18/2018 became 5/18/2018. But now it's moot. I've changed the dates to text.

The date is formatted in the Format line in the design view of the table. I have chosen "Short Date" but the time is still being displayed "0:00:00". So this is not working at all. And if it was working I'm guessing that June 2nd would show up like this: "6/2/2018" rather than the required...

What I am doing is importing data that other software creates and manipulating it in access code making a table “Rough Order” with about 20 fields to be exported at a later date in a comma delimited format for easy viewing later because it has been manipulated and it may or may not be finished...

This is what I'm using: POD = Format(Forms![Create Order 2]![OrderDate], "mm/dd/yyyy")

Thanks CJ_London, That worked as well as changing it to a text. However I'm still getting this: ,”5/17/2018”, But wanting this: ,”05/17/2018”, The company that I'm sending it to said that the leading 0 is important.

Thanks guys however still not working. I'm still getting the time 0:00:00 with the date. I am getting closer though. The date comes from a Form where it looks fine. Then in the code I assign the fields after changing them to strings like so: Dim POD As String Dim SD As String...

Actually I caught the missing "y" but I was entering "mm/dd/yyyy" in the format line in the properties of the query. I won't have access to Access until tomorrow. Can I use that in the Visual Basic code that loads that data into the field? And it does look right in the table that has been...

Thanks Cronk but that did not work. I’m still getting “5/16/2018 0:00:00” instead of “05/16/2018”. I’m starting to think that this is an issue with my computer settings and that I should be passing this along in text format instead of date. Any Thoughts? I’m guessing that extracting a day...

This should be simple but I'm stuck. I have a table that is exported to a csv with one of these: DoCmd.TransferText acExportDelim, , "Standard IG Order", "C:\Cardinal Order\Exports ready for Cardinal" + PartNumber3 + ".csv", True The problem is that one of the fields is a date and must be in...

Minty, The input is: Piece Size Q'ty 18 5 19 4 24 17 25 2 27 6 29 2 33 2 34 3 41 2 43 1 54 7 Output is: Mult Stock Offcut Pieces to cut out 2 188 4 27 24 24 24 24 24 18 18 2 188 4.25 41 34 33 29 27 19 1 188 4.25 54 43...

I have database that will spit out frame sizes for cutting. We then manually enter this information into another software tool that will optimize the cut order to minimize the number of 14 foot boards used. It would be beneficial to do the optimizing in the database and eliminate the extra...

Thanks June7. That worked!