Search results for query: *

Docmd belongs to the application object model so in order to use it, you need the database open in the application or do as you did round trip it through the current session. In short to do it more directly you would need to automate Access from within Access. In the back of my mind is...

Not sure how you are installing it. However MSACCESS.EXE has bloated in size over the years and the bigger it gets the less left over memory in a 2 GB addressable 32 bit memory space there is. For me running 64 bit office is the only thing to reliably solve memory issues. There are things...

Build / Version 2410 corrected the issue. 2411 from 2410 introduces an overall slowdown of about 26% running the same data but does not suffer from increasing slow down. Apparently 2408 included a Sales Force ODBC driver that caused database engine level problems either when you have any...

This has been confirmed to be an Office 365 issue. Build 2406 is last known to work correctly and Builds 2408 and 2409 are known to definitely have the issue. We have an active case with Microsoft.

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...

In general you run an access frontend locally. Generally the website should download the file locally and open it and the method for that will vary by the technology used and whether you are talking about an internal website and your own machines or outside on the internet machines. There...

Ultimately this comes down to what is deprecated in each version and whether or not you use a deprecated feature. Generally Access is very backward compatible even if it is behavior that is broken... It tends to do the same things wrong and little is fixed. From that POV, I would go with the...

jedraw that looks like the kind of SQL I was looking for. Thank you. I thought it was a thing.

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...

Coming in late here... You have a working solution, so it is up to you whether you want to explore these alternative investigations. I am a big fan of if it is not broke don't fix it. On the other hand there are often things that can be made better when (if) you have the time. But others with...

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...

Access ACCDB fundamentally are not secure. Put your data in an RDBMS (e.g. SQL Server) and manage security there. Do not embed passwords in your connection string. You can use DSNLESS connections via code, set the password for sign on at startup and use an ACCDE file to keep the password...

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...

Printout would print it though... I'd still have to name the file using the Adobe Printer. No the report is not taking longer to open.

Access Databases are what is known as File Server databases. This means the database engine is run on the client and all database operations are run as file edits to the operating system. So no there is no file access savings by one option or the other. It is possible that you are...

You reference OLE objects in the subject. Is the data an OLE embedded file meaning it is stored in the database? In design view of the table is the data type where it is stored OLE Object? In this case you literally need to just copy the database file to the new server and use it from there...

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...

To somewhat answer the question... Yes API calls for 64 bit are a hassle... If you were to search around I have seen entire lists of ways to declare api calls for 64 and 32 bit. Becomes an issue if you have to support systems older than VBA 7 and then you need a compiler directive but I doubt...

Does it run run for one employer for each PDF or is it doing something else... Is your strWhere correct? Is Employer a numeric field or some other datatype? Only Numeric fields do not need delimiters of some sort around the value. Text needs either single or double quotes ( ' or " ) around...