Right now at work, I get forms e-mailed to me in an Excel chart with a
serial number in one column and a new expiration date for a device's
trial period in another column.
For a while, when people only sent forms with one or two lines, I
didn't mind making a simple parameter query that searched for a serial
number (ESN) and showed me the relevant line of my office's tracking
database so I could change the date, etc.
Here's how it looks: http://klg.cps.com/temp/googlegroups/accesscurrent1.gif http://klg.cps.com/temp/googlegroups/accesscurrent2.gif
However, when I get 6-20 requests on the same form, it would be really
nice to just hilight the serial number column from the Excel form I
received... http://klg.cps.com/temp/googlegroups...ionrequest.gif
....paste it into a form or something in Access, and have a query pop up
that shows the relevant lines of my database for all of those serial
numbers.
I have searched every keyword on Google Groups and Google that I can
think of. I've looked in reference manuals. I'm just plain stuck and
can't figure out how to do this.
If I'm asking in the wrong place, please redirect me. Thank you.
-KitKat 5 1362
KitKat wrote: Right now at work, I get forms e-mailed to me in an Excel chart with a serial number in one column and a new expiration date for a device's trial period in another column.
For a while, when people only sent forms with one or two lines, I didn't mind making a simple parameter query that searched for a serial number (ESN) and showed me the relevant line of my office's tracking database so I could change the date, etc.
Here's how it looks: http://klg.cps.com/temp/googlegroups/accesscurrent1.gif http://klg.cps.com/temp/googlegroups/accesscurrent2.gif
However, when I get 6-20 requests on the same form, it would be really nice to just hilight the serial number column from the Excel form I received... http://klg.cps.com/temp/googlegroups...ionrequest.gif ...paste it into a form or something in Access, and have a query pop up that shows the relevant lines of my database for all of those serial numbers.
I have searched every keyword on Google Groups and Google that I can think of. I've looked in reference manuals. I'm just plain stuck and can't figure out how to do this.
If I'm asking in the wrong place, please redirect me. Thank you.
-KitKat
I think I were to automate your process, I'd link the Excel spreadsheet
to the table. (Look at the Connect property in help plus Google for
linking objects like a spreadsheet to the database). You can
temporarily link the spreadsheet, then remove the link at your
discretion. Or take a look at TransferSpreads heet
Since the spreadsheet is now available for use as a table, you can write
a query on the fly to use it as the rowsource for a combo or listbox.
This way you let the user select which serial number to use.
This method would be much more professional that cutting/copying/pasting
stuff between the two apps or even using an input box to prompt for
entry into it.
Ok, lets say the table in the database is tData. Create a new table,
for the example we'll call it tSerial. It looks like you really only
need one column in tSerial: SerialNumber. Create e query where the
SerialNumber column in tData is linked to the SerialNumber column in
tSerial. Paste your list of serial numbers into tSerial, and open your
query.
Hope that helps
Well, it almost does--when you say "linked," ummm...well, I'm not sure
how to do that. I assume it's something I type into the criteria
field.
I'll go look it up while I wait for a response.
Also, I hate clicking around. It's simply one of my computer pet
peeves. I suppose I was looking to do it with a form because I know
how to open a query upon closing a form--I found some VBA code to do
that.
I'll look this up, too, but just in case I don't find it, can you tell
me: can I set the table to open that query every time I close the
table? Oh, and maybe the query to empty out the table every time I
close it?
Also, I tried this. It shows my records, just like I'd hoped, but I
can't edit any data in them.
To find out why Access is not letting you edit the data, start taking
apart your query piece by piece until you find which part is holding
you up.
A couple places to look are: The relationship between the tables, the
number of tables (Access will let you edit with one left join but not
two), whether or not one of the tables are linked, subqueries.
As far as automation, you can take this to the point where with a push
of a button, Access will import your data from excel, make any needed
changes and print your report. It's a little involved, but not that
hard. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Jon |
last post by:
Hi all,
I am trying to create a page that contains a number of div elements,
with links on the left side of the page allowing the user to select
which div to display. Some of the pages contain tables with border
styles used to block off the columns and the headers, but not the
individual rows. The pages will be displayed using IE 5.5 and later
in the finished app. Now to the problem, which is a little awkward to
describe:
|
by: doomx |
last post by:
I'm using SQL scripts to create and alter tables in my DB
I want to know if it's possible to fill the description(like in the
Create table UI) using these scripts.
EX:
CREATE TABLE(
Pk_myPrimaryKey INTEGER CONSTRAINT pk PRIMARY KEY DESCRIPTION 'This
is the primary key of the table',
|
by: Susan |
last post by:
AccessXP
When I use the wizard to create a form, all the textboxes are created with
the Enter Key Behaviour of "New Line In Field". When I create the form
manually the Enter Key Behaviour is "Default". "New Line In Field" is
undesirable because when I go to enter data in the field and then ptess
<Enter>, rather than go to the next field, a carriage return is entered in
the textbox and as the property says, Access goes to a new line in...
|
by: Brian |
last post by:
Hello all..
Am working on an Air Hockey game... have an table loaded into a
picture box. The borders of the table are slightly slanted. Am using
hit testing lines with GDI+ to manipulate the puck moving around. I
want the puck is bounce when it hits a border (specified by the
hitlines).
Retreieved some info on hit testing lines from Bob Powell's GDI+ FAQ
(very useful!) but i'm fairly new at the idea of hit testing and am
|
by: Steve |
last post by:
Hi,
Is it possible to make hitting the enter key in an ASP
textbox run the code behind an ASP button on a form?
I have a search page which users tend to type in the
query then just hit enter rather than actually clicking
the search button, but this does not run the search code
behind the button.
| |
by: markaelkins |
last post by:
Hi. I am trying to enter a variable in the treenodesrc of a treenode. I am
basically trying to send an ID variable into sql to return different records.
I've searched everywhere and cannot find the answer. I'd appreciate and help.
Thanks.
What I'm doing is creating a treeview with the structure as follows (this is
the expanded view):
- Item Status
- Item Status Details
|
by: sugard |
last post by:
Abstract Class, Inheritance, Polymorphism, File Handling, Exception Handing
A program is to be devised for a university to work out whether or not, a student or a professor, is
outstanding. The criterion for a professor to be outstanding is to have over 120 publications. The
criterion for a student to be outstanding is to have a Grade Point Average of 3.3.
For a professor, the three class data members would be name, number of publications...
|
by: KalariaNitya |
last post by:
Hello,
could anybody help me?
i have gridview, inside gridview i have one Update button & textbox
update button update the quantity entered in textbox.
i want to update the quantity on textbox on ENTER event.
i had done below code:
page_load()
|
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: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
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: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
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: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |