Search results

Base the report on the Query used in the Query Def. If you use one generic name for the query and then put this in the Report RecordSource, as long as each report version contains the same fields, when the report runs, it will pick up the latest QueryDef. I have not checked your syntax but the...

1 query and 1 report was what I was referring to when I mentioned using DAO.Recordset. and QueryDef. You will need to create each Query using SQL and recordsource the one report to this query. Using the Recordset, put the Query Def within the DAO loop so that it creates the appropriate query...

Ok good so design/write down a workflow for one report using the appropriate variables and then loop through the variable changes you need and within each query to output the report using a derivation of the code below. Your Report will need to be based on the Query. In this example you would...

An immediate problem might be that the tbl-SubjectList does not have the StudentID field.

To achieve the level of automation you describe, will require VBA coding. Are you able to do this? For example, the code MkDir "M:\MOR Reports\2005\January\" will create the monthly folder you require and if you replace the word January with a string expression linked to the current...

Does this link help <LINK> http://www.slipstick.com/developer/code-samples/set-flag-follow-up-using-vba/ </LINK>

Not that I am aware of BUT if you use a Macro to create your .pdf then using the code below might do the trick for you DoCmd.OutputTo acOutputReport, "R-Report", acFormatPDF, "c:\temp\Report.pdf", False, , acExportQualityPrint

I think the answer is going to be 'No' but it always worth asking. I have two (or more) text boxes, set side by side (aka columns) and I would like the contents to flow from the first text box into the second. In WORD you do this by linking the two text boxes and as the content fills the...

This will do it for you. (put the code into your app and then use the intellisense to understand the syntax. I have copied my code exactly from a working app. Firstly output the report as a .PDF DoCmd.OutputTo acOutputReport, "R-Property Brochure", acFormatPDF, conBrochures & lngRef &...

If you are using a query that is fine to get the one line of code. I was suggesting you use a form with a command button or check box on each record. The click event (button) or change event (check box) would initiate the code I gave you. The separator is a semi colon NOT colon. If you...

The code I wrote will insert the semi colon for you. You will need some way to Select the row of eMail addresses so a check box should do the trick. You may decide to put this as a field on the table, in which case it will need clearing back to clear as some stage. You can write a simple...

You are going to need to concatenate all 3 eMails addys together, separated by a semi-colon and then using some code, send this string to Outlook. On a Form, you could do this with a button or check box and using the On-Click event this should work. I can't see how you can do this on a table...

Yes; that's it Gina - Thank you. So if I want to mess with the menu structure in 2007/2010 I will have to find another way.

I am opening a Blank database in Access 2007 (have also done same on a 2010 version) with the same problem. In the Options/Current Database/Ribbon and Toolbars Option, the Menu Bar and Allow Built-in Toolbars are not showing. Simple as that. My intention is to create a new application and...

In Access Options, Current database, Ribbon and Toolbar Options, Menu Bar and Allow Built-in Toolbars are not showing. I want to customize the Ribbon Toolbar etc but it seems I need these two options and they are now shown. Any thoughts how to get them would be appreciated. Thanks

Each user on a network will have a username and in access this is called through the Function Environ("Username") A macro called Autoexec only runs when the db opens so use this piece of code to write the information to a table which we can call LogIns with the fields User; DateandTimeIN...

When something like this is happening it os often useful to think logically what you would need to do manually to havethe view you require. For example, after the requery, do you need to move down/up (say) 6 records. Do it manually to decide and then write a some code to do what you did...

You need an APPEND query but in the CRITERIA use this to filter to the correct records on tblquoteparts into tblinvparts Criteria the Quoteid [Forms]![tblquoteparts form]!

Try the On Close event of Form B or if you are using a Close button on Form B, then put this in the Button's On Click event.

Yes but by using the Outlook Object model you can use for example objMail.bcc = Your addy and then loop it in your code inserting a semicolon between each addy. objmail = objmail & ";" & next addy