I have a button that opens up an excel sheet, and prompts them with an input box asking which row of data they want to import. Problem is, once the excel sheet is opened, the input box gets hidden behind the sheet. Is there any way that anyone knows of to bring that input box to the front so that the user doesnt have to click back on access in order to see it?
Thanks in advance!
4 5471
Access, by default, fires off code as it comes to it, not waiting for the previous command to be completed before executing the next command. Obviously an InputBox is going to be displayed before an Excel file is going to load and display, thus covering up the Input Box. What usually works in this sort of thing is using the DoEvents() function. This, in essence, returns control to Windoes, allows one task to be completed, before returning control to Access, to carry out the next command. So, something like this
Code to Load and display Excel file DoEvent
Invoke InputBox
Linq ;0)>
Thank you for your help, however, that did not solve my problem. I was able to figure this out though - and just used the excel.application.inputbox instead of using access's!
Glad you got it working!
Linq ;0)>
Hi Neekos, I realize this post is from 2 years ago, but I was wondering if you still have and could share the code to call the excel inputbox from Access. I am trying something similar myself.
Thanks
Sign in to post your reply or Sign up for a free account.
Similar topics
by: tom |
last post by:
Hi,
I want a listbox below a hidden calendar control. The
problem is that the listbox will shadow the calendar when
the calendar is visible. How can I bring the calendar from
back to front?
...
|
by: ACaunter |
last post by:
HI there..
I have a dropdown menu for my asp.net website (not a combo box with the down
arrow).. its for Home, Compant, ... , Contact Us... and then when the mouse
goes over it, the sub menus are...
|
by: DraguVaso |
last post by:
Hi,
I want my application to bring another application to the Front.
I thought best way to do this was by the Process-model:
Dim c As Process = Process.GetCurrentProcess()
Dim p As Process...
|
by: Don |
last post by:
I have two programs. One is supposed to bring the other (which is already
running either minimized or at the bottom of the window z-order) to the
front so that it becomes the foremost application....
|
by: M O J O |
last post by:
Hi,
I have an application where I've implemented a global hotkey, so no matter
what other application is in front (have focus), my app will react when the
key combination is pressed. This works...
|
by: Iain Bishop |
last post by:
I have a simple form with 4 command buttons and 1 label. The label is
sometimes visible and sometimes not. When it is visible I want it to be in
front of the buttons.
I've tried bringing the label...
|
by: Marcel Brekelmans |
last post by:
Hello,
I have an application with a notifyIcon. When my application's main form is
hidden by some other window I would like to bring it in front by
single-clicking the NotifyIcon. However, I...
|
by: Dakrat |
last post by:
Allow me to preface this post by saying that this is my first database project, and while I have learned a lot, any concepts I have learned are hit and miss as I have found new requirements and...
|
by: =?Utf-8?B?R2lkaQ==?= |
last post by:
Hi,
I asked here yesterday about bringing a form to front with hotkey while
using different application then mine (meaning, when i'm using outlook, and
pressing ALT+T it will bring a form from...
|
by: DolphinDB |
last post by:
Tired of spending countless mintues downsampling your data? Look no further!
In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
|
by: isladogs |
last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM).
In this month's session, we are pleased to welcome back...
|
by: isladogs |
last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM).
In this month's session, we are pleased to welcome back...
|
by: Vimpel783 |
last post by:
Hello!
Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
|
by: PapaRatzi |
last post by:
Hello,
I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
|
by: Shællîpôpï 09 |
last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
|
by: af34tf |
last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
|
by: Faith0G |
last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome former...
| |