Search results for query: *

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

Your code reads as though you are looping over employers, you say agency but you say you get a report for each employee? Are Agency and Employer the same thing? I'm guessing not with a table name like AgencyEmployer suggesting an cross reference between the two. Based on that assumption I...

You need to build the available schedule somehow which it seems you can do. From a pragmatic point of view I would do just as you suggest build a table / schedule based on available slots. Anything else is just going to be a lot of extra work to achieve the same result so directionally you are...

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

I prefer this methodology in general to Andy's... Turning 'SetWarnings' on and off will suppress all errors from being seen. Which is ok for static queries and you could use docmd.openquery to open a saved query too. But if you were building your SQL statement programmatically... Then the...

Office 365 / Access 19 from what I can tell is just horrible. I have to use it. I have not experienced this issue. My hunch is that some security product is scanning the database file... maybe even access itself. I use trusted locations to keep 'macro / vba / module' warnings at bay and while...