Recent content by Danick

WOW - that's perfect!! I had just about given up on this one. Thank you so much for dedicating your time to this request. Of all the posts I've seen on the web asking for this functionality of wrapping the access window around the form, your code is the only one that actually works. I'm...

Using tabbed documents display wouldn't work for me as there are multiple forms and sub-forms being displayed. And the request hadn't really shifted, I just tried using different examples in order to try to provide a better picture of what I was trying to do. But that obviously didn't work...

Hi isladogs, There isn’t anything wrong with what you wrote in post #12. But that only gets me halfway. More importantly, I’m trying to wrap the access window around the form (not the other way around) to make it appear like a popup. Plus, there are quite a few web sites where users have asked...

I suppose the answer to that question is esthetics - trying to make it look better. Using a button in this example was an attempt in simplifying my request. In any case and regardless of the reasons, the real question is, can it be done.

That was an example. I'd like to press the button to resize without it moving.

Yes I looked at the examples provided and found the one in post #7 to do just about everything that I want. But, it's not "exactly" what I'd like it to do. I also looked at your Control Application Interface, but I'm not using pop up forms. So rather than a screenshot, I made a simple...

Yes - I'm actually using the SizeAccess() code in post #7 to resize the access window and it's working very well. But this code requires that the access window be set to some location (cx and cy). It can't be set to wherever the access window is currently located. I thought maybe of...

What I'm trying to do is very well explained in all the post links in this thread regarding "Access Main Window Resize" and "Hiding access window faster". In fact govuser1 never received a response to the question on modifying the code to "...the access window size but allow the window to open...

Hello Doc I'm trying to do exactly what the DoCmd.MoveSize for a form does, but for the Access Window. If you use DoCmd.MoveSize , , 800, 1000 The form will not reposition itself from the top LH corner but just change its size to 800 by 1000. So I'd like to be able to do that same thing to...

There are a lot of examples of resizing the Main Access window using the Application object, Application.hWndAccessApp But I can not find a way to use this property without repositioning it. It would be great if it could be made to work like DoCmd.MoveSize for a form. Basically, I'm trying...

Hello @isladogs, I couldn't get IMEX to work on that one file and then when it failed on another SAP import, I figured I had to find another way. So thinking outside the box, I went the other way and just imported all my forms, tables, modules, queries, etc into your IMEX database just to see...

Hello ebs17 Please understand that the discrepancy in this thread are ONLY related to the task in the IMEX form. There are no other issues importing the files once the path is set.

Hello @isladogs. Yes I saw your post 12 which is why I uploaded just the one spreadsheet (export1.xlsx) for others to try. Forget about the first spreadsheet (export.xlsx) with the name errors. I am able to get (export1.xlsx) to fail by itself using the IMEX form on two separate computers...

Just to alleviate the possibility of the problem being a computer issue, I copied the database onto my home computer for testing. My work computer uses Office 365 while my home computer has a older standalone version of Office 2016. However I'm still getting the error 31602 in line 20 when...

Hello @isladogs. Yes the spreadsheets are totally different but that's because they are going to two different tables. And there is a common field [order] between the two that links them. My database has two separate import DoCmd.RunSavedImportExport buttons. One for each and both work...