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  5522 
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.applicati on.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?
Thanks in advance.
|
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 displayed for each one...
Those sub menus are written as tables..
The menu i can set to Bring to front before i run the program.. which is
fine.. but when the sub menus come out.. then are at the back, so i can't see
them..
How can i bring them...
|
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
For Each p In Process.GetProcessesByName("EXTRA")
If Left(p.MainWindowTitle, 4) = "Appl" Then
'Here I should be able to Bring the Process to the Front!!!
|
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. How do you do this?
I've tried using the API functions BringWindowToTop, SetForegroundWindow,
and SetWindowPos and can't get any of them to work reliably.
BringWindowToTop and SetForegroundWindow don't do anything, and SetWindowPos
only seems...
|
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 fine.
My problem is now that the form I want to show, does not come to the front.
I've tried to set Topmost to true, but then the form doesn't recieve focus.
| | |
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 to the front and sending the buttons to the
back. In design view the form looks fine, but whenever I open the form the
label is behind the buttons.
Has anyone else experienced this and know the solution? Is this a known
fault? I wouldn't think...
|
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 can't get it done. In the Click
event I've used all sorts of methods:
this.SetTopLevel(true);
this.Show();
this.Focus();
|
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 researched solutions.
That said, I have a "training" database with PowerPoint briefings which I have users access and complete training. The form then records the date and time they completed training in a relevant field. I have a separate "master"...
|
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 my application to front), my problem
was that after i press the hotkey, the window stays in minimize state instead
of being in the front. i fount an article in google explaining (i think) how
to solve this problem, but i couldn't understand what...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| | |
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 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 a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| | |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
