Search results

I figured it out. I mistook the "Saved" name for the actual Spec. It was actually there, but I was not referring to the spec but the saved procedure name.

I think I have a better understanding how the "spec" file works now, but my do.cmd line is still because of the error "The Text file specification "RMUploadExp" does not exist. HEre is my Do.CMD line: DoCmd.TransferText acExportDelim, "RMUploadExp", "qryRFIDEIDLocation", "p:\rental...

I have an module that exports data to a CSV. My problem is that the data comes out with double-quotes around all the fields. what parameter can I use to eliminate this from happening? Below is my code: DoCmd.TransferText acExportDelim, , "qryRFIDEIDLocation", "p:\rental man\FTPRM\RMUpload.csv", 1

In my form, I have a combobox (cboFind) that I use to lookup records and it works like it should. I needed to add another field to allow our users enter the Contract# and on my inquiry screen, I added another field allowing the user to look up records (in the same table) based on the Contract#...

I figured out a solution. below is the code: =DateDiff("d",[txtStart],[txtEnd])-([txtMonth]*30) (Because I had already determined months, I referred to that text box.) Not glamorous, but pretty functional

I see what you say... however... I am as concerned about the year as I am getting the “days” I am trying to get the result that Excel gives me. If I enter “12/1/2015” and “1/18/2016”, Excel’s DateDif gives me the results I need. 0 for year (=DATEDIF(C$19,D$19,"y")) 1 for month...

i am just trying to get the difference between the numbers in the given date fields. (9 (sept) - July (7) = 2), "/20/ - /2/" = 18. Datediff seems to handle the year fine. (12/15/2015 - 1/30/2016) will show "0" for year and report 1 for month. If the starting year was 2014, it would show 1 year...

"Yes", exactly. Like 0 year, 2 month and 18 days

I am working a "form" that will allow our users to do some simple onscreen calculations. (I am using Textboxes - I know, i know - for now this is the route I want to take) I have a Start Date = 7/2/2016 I have an End Date = 9/20/2016 Using =DateDiff("yyyy",[txtStart],[txtEnd]) - I get the...

I have a report that is based on a query. This query pull records that have been marked at "completed" Is there a way to show the date range of the resulting records.

i closed this question and the "thumbs up" is now present.

how do I "thumbs up" the answers? I do not see that option anywhere on the individual responses

I have a form into which I enter the number of minutes I spend supporting my users. On the report, I have a "total" field that I sum the time spent. Below is the formular I am using: =Round((Sum([TimeSpent])/60),2) Presently the result is showing 16.83 hours. How can I best show the .83 in...

+++++ It seems the only thing you changed was the variable "acNormal". This makes the report print rather than preview right? I went down and talked with my user and the report only crashes from the routine when a new entry is made.

In my database, I have a screen that users enter data into and once complete, they click a button to do a Print Preview. If all is good, they can click the print button and the report will print. It works fine on my computer, but all my users that are using the Access 2013 R/T and when they...

Never mind.... I spoke to early..... I just needed to add field names (which I did) it works!!!!! Thank you.

This is the Module1 Option Compare Database Public Function ExportRM() DoCmd.TransferText acExportDelim, , "qryRFIDEIDLocation", "p:\rental man\FTPRM\RMUpload.csv" End Function I open the DB (which triggers the Autoexec) and I am not getting any data out.

"ExportWithFormatting" Object Type Query Object Name qryName Output Format Text Files (*.txt) Out File p:\foldername\RMPUpload.csv Auto Start No Template File Encoding Output Quality Print

no code, just used the functions within the autoexec.

I have an export that I am running through Autoexec and while it is working really well coming out as an xls formatted file, I actually need it to come out as CSV. Being exported as a text file makes the file come out with "|" and "-" and "+". Ideas?