Search results for query: *

My Team generates PDF's in bulk. Fundamentally we have code that does things but at the core loops over recipients, constructs appropriate queries for the data, sets those in Tempvars which reports subsequently use on Open to set recordordsource property to run for the correct data. Then the...

SELECT FROM Table in Another Access File It has been a long while but I've seen syntax to directly select from files in Access SQL. I think for my purpose that will be the easiest solution although yes I can technically use docmd.transferDatabase to link the table first. This may be a...

I feel absolutely crazy and silly as I know I have seen a solution before but I lost track of it before fixing and adjusting... In Outlook, I understand that some events sometimes don't always reliably work on processing received messages... I have some commented out code and some other code...

I did not find this in a quick search and was hoping someone could save me from digging. Can trusted locations be managed effectively within Group Policy for Office 365 for individual office applications. For instance Access has its own settings and each other app has its own settings? I want...

I think the answer is no but.. Does anyone know a way to have a URL not be made blue and underlined if the text format is Rich Text? I tried using an A tag with the URL in both the href attribute and display text and it still does it. But if you do not use a URL for the display text you can...

This one has me dumbfounded... I have a report (cover page) that is used for various databases. The varying or database specific report sub report is placed on this Main report. Yhe main report can be print previewed look fine, manually exported to PDF and still look fine but when exported...

Does anybody have a working example of using an ADO Recordset to batch update SQL Server? - I am wondering about my connection string, recordset properties order things are set etc. One record at a time performance is killing performance... I am simply missing something in the initial...

An update on this thread181-1806156 The default font and size I reference can be set on a table by selecting all rows and columns and then specifying the font and size. This does not change font and size in data. Noteworthy using a subset of HTML 1, Rich Text Format only supports font sizes...

My company is moving to Office 365. And I have it... Hate it so far too over Office 2016. That aside it seems that large datasets involving update queries in particular are causing database file corruption. Has anyone experienced similar or not with 365? As usual with a large corporate...

I have a Read only ACCDB on a network share. It is multiuser and I am running out of ideas. First the only novel thing I know that has been done is to compact it in Access from a machine with Office 365 where most machines are running access 2016. This is new to me so if someone can confirm...

I / We are missing a nuance on how the font specification is used in data. It seems that the table has a default font of sorts (my out of the air nomenclature) and if your column is in that font, it is not embedded in the data in the font tag. When you use some other font, it seems to specify...

I have some code the manages versions of some objects centrally. One assumption I have is that every module I have as a public procedure that that gives the version back to a passed variable as called by fnModuleVersion below. It works well. However I want to do the same with Class...

Does code signing work in Access 2016. I saw an MS article detailing how to do it. However I am getting what would make sense to be an older message as it says to use the Publish option for ACCDB's under file which is not present? Does my organization have a messed up install or is this still...

I am using Long Text Rich text is fields in a table that appear on a report. Usually Can grow just works. However I do have this case where the font is Calibri. The control does not grow. It just stops at what lands as the first line of text. We have tried inserting a line break, ensuring...

I have been working on enhancing a system that sends letters. There is enough customization between tasks that each project is implemented as it's own split application. Some business rules are common about what headers and footers to use. So I implemented these as a common main report. Then...

My general thinking is to add procedures to all my module / class module objects (forms and reports) so that return the version... That way I can check each object's version and then check to see if it is the latest copy. Long story short we end up with a customized front end and backend from a...

I received the Error 2501 The output action is cancelled by the user on a seemingly correct DoCmd.OutputTo line. I was dumbfounded and never found any solution that seemed to fit with Google. The issue was my variable value had an invalid file name. To make me even crazier the bad file...

I am trying to write my own version control code to manage ensuring I have the latest module in each instance of databases... To that end I would like a generic way to call the version out of each module. I was thinking something like the below using application.run but it does not like that...

It seems that using OutputTo PDF format is giving some inconsistent results as far as positioning of elements like address across systems for us. This matters for printing mail pieces for windowed envelopes. To be fair, I think each system is consistent just can't have the controls in the...

I want to pass a report object to a function, and get a field I parse out of a string and pull it's value as if it is a value in the record source for the current record... Basically substituting a value for a field value... I am passing report as .... ByRef rpt As Access.Report I can't...