Search results

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

Hello @isladogs. I couldn't find anything that would make one spreadsheet work and the other fail. I've even tried to just recreate a blank database with only one spreadsheet but that didn't help either. So I've sent you a couple of sanitized SAP downloads to your email for testing. The one...

Hello ebs17, I do use this code to import new data. It's actually just a button on a from. DoCmd.RunSavedImportExport SavedImportExportName The problem is that I'm providing this front end to other users. This is the reason for needing the IMEX form from isladogs. I want to make it...

Thanks for responding so quickly. I was running v2.2. Just downloaded v2.3 but unfortunately I'm still getting this error. I'm downloading 2 spreadsheets from SAP so they are always in the same format. When I use the IMEX to import on the first file, it works fine. But when I use IMEX on the...

I've been using isladogs IMEX form found here to import my data into my database quickly. https://www.access-programmers.co.uk/forums/threads/view-edit-imex-data-task-specifications.307897/ All was working till I created another import spec and tried running it or changing the file path using...

Thanks - I tried that before posting and couldn't get it to work. But seeing that you also suggested the same thing, I tried various ways of doing this and finally got it working by adding by just repeating the first line again. So in the end I got it work by doing this...

I'm trying to filter a combo box using a three way checkbox in a similar to the way of doing the cascading combo box by using something like this in the combo row source [Forms]![FormName]![CheckBoxName] This works when the checkbox is True or False, but not if it's Null. Anyway to show all...

Well he posted the code in the link provided in my post, so thought I kind of was asking @isladogs in an indirect way...

I'm using the View & Edit IMEX Data Task Specifications version 2.2 found here Is it possible to edit the import to allow two imports with one click of the "Execute Action" button? It would be essentially the exact same task but importing another spreadsheet from the same folder.

This wouldn't be a problem in my case. Users are only IMPORTING the file into their standalone database. The original file is never touched. I've used isladogs module wi5h the format he provided in the download. It's awesome!! Does exactly what I want. I can change the import file at will from...

I can't use my spec because the <UserName> will be different for every user. That's why I thought if I could replace the first part of the spec with something generic, than they wouldn't need to select their file because the same file name would always be in the same folder for each relative...