Search results

I resolved this issue. Here's the syntax I used, works great. Thanks again everyone. ="C:\Data_Reports\Report" & [Forms]![MAIN MENU]![BrokerID] & ".pdf"

I retested the syntax noted in my previous reply, it works fine. Thanks again everyone for your help.

I'm trying to do similar task, exporting a report to a pdf via a exportwithformatting action. The output filename is shown below. The macro exports the file but ignores all the concatenated sytnax. "C:\Data_Reports\" & Forms![BROKERS WITH POLICIES GT5]![Sub_gt5] & ".pdf"

I am simply using the standard exportwithformatting action in a macro and using the output filename shown in my earlier thread. Ideally I would like the filename to include a unique identifier such as a field value from the report.

I'm trying to export a report to a pdf file so the filename varies with the date. I'm using the following syntax: "C:\Data_Reports\FileName" & Format(Date(), "yyyymmdd") & ".pdf" The report was exported, but the filename is missing the date and pdf extension.

I'm using the exportwithformating macro action to export a report to a pdf file. The report data source is a query that reads a table of 100 brokers. The macro is repeated 100 times so that 100 unique reports are generated for each broker. How can I code the output filename so that it varies...

I now see that it may be more efficient to create a report instead of a form. I do see a page number icon in the design view for reports. I think this issue has been resolved.

I want to add a page number to a form in MS Access 2010. How do I do this ? There is no page number icon in the control group when I'm in design view.

I think I resolved my own issue. I should be using the ImportExportSpreadsheet action instead.

I'm using the MS Access 2010 ExportwithFormating action to export three tables to a single MS Excel 2010 workbook. The action overwrites the first excel worksheet each time instead of saving all three worksheets in a single excel workbook. How can I export three tables into a single excel...

CDbl and Val do not work. Query reads a table, where Field is in text format like 28.0%.

I have a text percentage that reads 28.0%. I want to convert to a numeric percentage that reads either 0.28 or 28.0%, preferably the latter. The Val function returns an error. How do I do this in a query ?

Thanks Paul, this should resolve the issue.

I have a POLEFFDATE field with dates in date/time format. A single record has POLEFFDATE equal to 12/15/2013. I calculated a simple field called EVALUATE as follows: IIF([POLEFFDATE]< 1/1/2014,1,0). EVALUATE should equal 1 for this record, but it equals 0. Why ?

I did exactly what you recommended. When I open the query I can see the correct fixed 2 decimal format, but when the table is created it loses the decimals. This is a make table query.

How can a reformat a number from 23 to 23.00 in a query. The format functions reformats it correctly but converts the number to text. I need to format the number as 23.00 and maintain the value as a number, not as a text. How can I do this ?

That's exactly what I needed. Thank you so much. Your help is greatly appreciated !!!:)

I think we are saying the same thing. My form already has a checkbox linked to Field 1, but field 1 has true/false property. So when I select a check in the form checkbox, it stores True in Field 1. I was expecting to see a check in field 1.

I don't need to store null. I created field 1 in the table with a data type of yes no. The form check box has data source field 1 and stores values of true or false in field 1. This was the only way I know. I didn't see a data type of check box when choosing the data type for field 1.

Is it possible to create a field in a table that stores only two possible data choices: a check or null value ?