Search results

Hi Access Expert, I updated my MS Access 64 Bit via the Office Update Method (See attached Screenshot) and now my environment is slightly corrupted. 1) Now when I reboot my machine 2 Instances of MS Access load on Startup. 2) When I close an MS Access file and then open another MS Access file...

Microsoft now installs Office 2019 in 64 Bit by Default. My new machine from Dell came installed with Office 64 Bit and this will be the trend going forward. I personally don't need any of the 64 Bit features.

I've been doing more research on making VBA 64 Bit compliant. I downloaded the Win32API_PtrSafe text file from: https://docs.microsoft.com/en-us/office/troubleshoot/office-suite-issues/win32api_ptrsafe-with-64-bit-support Below is one Declaration I'm using in my code. The above document...

Hello MS Access Expert, My new machine came with Office 2019 64 Bit, hence, I have MS Access 2019 64 Bit installed. My application no longer compiles due to the Declare statements. I have been reading how to make the VBA 64 Bit compliant and it seems to be pretty straight forward if there...

Hi isladogs, Yes I have had the license for a while. Good to know there are some alternatives if I encounter any issues. Thank you.

I installed it on my machine. It appears to work well with my initial testing. Fingers Crossed. I installed the 64 Bit version as I am using the 64-Bit version of MS Access 2019.

Hello MS Access Expert, I have been using Rick's tool in prior versions. Does it still work effectively with Access 2019? I wanted to get the communities feedback prior to installing it. Thank you.

Thanks for everyone's responses. I was able to solve the problem with Excel's Solver Add-in and using Automation in MS Access. Excel's Solver is extremely powerful. Excel's solver can solve the optimization with 10 buckets and 7 constraints extremely fast and efficiently.

Hi Gizmo, Thanks for your response. You are correct the problem outlined is the base case. The actual problem involves 5-8 buckets, and additional restrictions on the final blend such as > Y %, < Z %, on top of the 100 L volume and <= 25 % water restrictions. Also please note that Dollar...

Hello Access Expert. I would like to know if the below is possible in Access / VBA and if so can I leverage something on the internet to get me started? Thank you, Suppose you have three buckets A, B, C Bucket Capacity % Water $ A 70L 10% $1 B 80L 30% $2 C...

vbaInet, Adding <!-- saved from url=(0014)about:internet --> "Mark of the Web" to the top of the HTML file resolved the issue on another user's machine in a completely different organization as well. I confirmed this user had Access 2010 installed on their machine. It appears the cause and...

vbaInet, Adding <!-- saved from url=(0014)about:internet --> resolved the issue on one problematic machine according to the IT Department and based on their detailed response I am fairly confident it will work on the rest. If not, I will follow up here again. Thank you again.

vbaInet, Thank you again for directing me to the Group Policies. That got the conversation going with the IT department and didn't make me sound like a complete amateur. I am happy this is resolved and yes "Mark of the Web" sounds ridiculously funny. The solution according to the IT...

Yes. This is an off the shelf Access software product I own.

vbaInet. This customer had an outsourced IT Department. I paid a decent sum for this answer.

vbaInet, The IT Department figured out the cause. MSACCESS.exe is added to the LOCAL MACHINE ZONE LOCKDOWN feature of Internet Explorer through the installation of Microsoft Access 2010 or higher. The machines that generated the error had Access 2010 without my knowledge. This error does not...

That is True Access Blaster. "Within every problem or difficulty lies the seed of an equal or greater benefit or opportunity" Napolean Hill.

I just thought of something else that may be easier. From the above second URL I gave you it appears that you can make SubDatasheets with Queries as well. I didn't know this. If you can create SubDataSheets with Queries (I am not certain as I have never done this, I typically create...

My understanding is that at the table level you can only link one child table to the parent table. What you can do is create multiple forms with SubDatasheets. Below is an example of SubDataSheets in forms. You can make several of these forms and link them to different child tables achieving...

AccessBlaster, It's my understanding that the Dell Direct USB Key does bring your machine to the OEM state and allows you to choose if MS office 2013 trial is installed. http://www.dell.com/support/troubleshooting/ca/en/cabsdt1/KCS/KcsArticles/ArticleView?c=ca&l=en&s=bsd&docid=615851 Dell...