Hello,
I have a database at work that keeps an inventory of cameras by
location. Every week I get a repair estimate sheet that lists cameras
by serial number that need to be repaired. This list is sent to me in
excel. I am trying to make it where I can just copy the column of
serial numbers from the excel list sent to me and paste it directly
into the database to return my information for those cameras. I would
like to do this in a datasheet view where I paste the column, it looks
them up and returns the information I need(warranty dates) by serial
number. Any help would be greatly appreciated. Thanks.
Blake 8 3322
How about if you just link to the excel workbook and Access will treat it as
a table.
Then do a query against the linked table and your warrantee table something
in the vein of:
SELECT Repairs.SerialN umber, Camera.Warranty Period, Camera.Purchase Date,
Camera.CameraMo del
FROM Camera INNER JOIN Repairs ON Camera.SerialNu mber =
Repairs.SerialN umber;
Kevin C
"Blake" <bg**********@y ahoo.comwrote in message
news:11******** **************@ e64g2000cwd.goo glegroups.com.. .
Hello,
I have a database at work that keeps an inventory of cameras by
location. Every week I get a repair estimate sheet that lists cameras
by serial number that need to be repaired. This list is sent to me in
excel. I am trying to make it where I can just copy the column of
serial numbers from the excel list sent to me and paste it directly
into the database to return my information for those cameras. I would
like to do this in a datasheet view where I paste the column, it looks
them up and returns the information I need(warranty dates) by serial
number. Any help would be greatly appreciated. Thanks.
Blake
"Kc-Mass" <co********@com cast.netwrote in message
news:1c******** *************** *******@comcast .com...
How about if you just link to the excel workbook and Access will treat it
as
a table.
Not after SP2 is applied to Office 2003!
Keith.
Keith
What else does SP2 take away? Do you have a website that details changes?
"Keith Wilby" <he**@there.com wrote in message >How about if you just
link to the excel workbook and Access will treat it
>as a table.
Not after SP2 is applied to Office 2003!
Keith.
Hello,
Thanks for the information. Isnt there a way though to do this through
a querry, All I really want to do is copy like 15 camera serial numbers
from a column in a spreadsheet and paste it in a query. Isnt there a
way to query or filter to show only those without having to do them one
at a time? Thanks.
On Oct 31, 12:00 pm, "Kc-Mass" <connear...@com cast.netwrote:
Keith
What else does SP2 take away? Do you have a website that details changes?
"Keith Wilby" <h...@there.com wrote in message >How about if you justlink to the excel workbook and Access will treat it
as
a table.
Not after SP2 is applied to Office 2003!
Keith.- Hide quoted text -- Show quoted text -
Blake wrote:
Hello,
Thanks for the information. Isnt there a way though to do this through
a querry, All I really want to do is copy like 15 camera serial numbers
from a column in a spreadsheet and paste it in a query. Isnt there a
way to query or filter to show only those without having to do them one
at a time? Thanks.
How much easier could it get than running a single query? If you link
the tables, then you're there. Did you actually TRY it yet?
Keith
What I read on the MS site suggests the problem is with or
occurs with editing or adding data not simply querying and viewing.
Yes? No?
"Keith Wilby" <he**@there.com wrote in message
news:45******** @glkas0286.gree nlnk.net...
"Kc-Mass" <co********@com cast.netwrote in message
news:1c******** *************** *******@comcast .com...
>How about if you just link to the excel workbook and Access will treat it as a table.
Not after SP2 is applied to Office 2003!
Keith.
Hello,
Thanks again... I am still new to Access and that just looked more
difficult. I had enough trouble figuring out the query. I will look up
how to do that. Thanks.
On Oct 31, 1:43 pm, "Kc-Mass" <connear...@com cast.netwrote:
Keith
What I read on the MS site suggests the problem is with or
occurs with editing or adding data not simply querying and viewing.
Yes? No?
"Keith Wilby" <h...@there.com wrote in messagenews:45* *******@glkas02 86.greenlnk.net ...
"Kc-Mass" <connear...@com cast.netwrote in message
news:1c******** *************** *******@comcast .com...
How about if you just link to the excel workbook and Access will treat it
as
a table.
Not after SP2 is applied to Office 2003!
Keith.- Hide quoted text -- Show quoted text -
Thanks for the help. I made a table for lookup values and linked it to
my main table. I then made a query to search out that data. It works
like a charm... each week I just paste the column from the email into
that lookup table and then run the query and it pulls up the info I
need. Thanks again for your help.
Blake
On Oct 31, 2:01 pm, "Blake" <bgriffin0...@y ahoo.comwrote:
Hello,
Thanks again... I am still new to Access and that just looked more
difficult. I had enough trouble figuring out the query. I will look up
how to do that. Thanks.
On Oct 31, 1:43 pm, "Kc-Mass" <connear...@com cast.netwrote:
Keith
What I read on the MS site suggests the problem is with or
occurs with editing or adding data not simply querying and viewing.
Yes? No?
"Keith Wilby" <h...@there.com wrote in messagenews:45* *******@glkas02 86.greenlnk.net ...
"Kc-Mass" <connear...@com cast.netwrote in message
>news:1c******* *************** ********@comcas t.com...
>How about if you just link to the excel workbook and Access will treat it
>as
>a table.
Not after SP2 is applied to Office 2003!
Keith.- Hide quoted text -- Show quoted text -- Hide quoted text -- Show quoted text -
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Dave |
last post by:
Hi all,
I have a problem with a query. (well, I actually have a few problems...)
Here is my query.
select FOCUS.SiteName, FOCUS.URL, OTWAdCars.* , REGION.SiteName as
RegionSite, REGION.URL as RegionUrl
from OTWSite as FOCUS
right join OTWSite as REGION
|
by: Hammy Hammy |
last post by:
Hi all, I have an invoice table query that returns 10 records. ie. there
are 10 invoices.
When I try to join a subjects table to retrieve the subject name
associated with an invoice it returns 11 records.
I know this is because for each invoice, there might be multiple
subjects. So when I join the subject table to get the subject's name, it
will add an extra record.
|
by: Andy |
last post by:
Hello,
I am having many problems with setting up a parameter query that
searches by the criteria entered or returns all records if nothing is
entered.
I have designed an unbound form with 3 fields on it: Date (DateSpan1
and DateSpan2), Originator, and GroupName. I have added a button that
triggers a query and uses those fields as its parameter criteria to
populate a form. The user must be allowed to either enter all of the
|
by: Robert |
last post by:
I am trying to create a db for service providers by county. I'm relatively
new to db programming, but I have done quite a bit of programming ranging
from the old basic days up to doing some programming in the HotDocs
software. I've kind of accomplished my goal in access, but I'm not quite
there yet and figure I've really screwed something up.
The db consists of 5 tables I believe. T1 is the main contact info, with an
autonumber ID...
|
by: teddysnips |
last post by:
I have to write an application to do some data cleansing. It's a
Contact database, but over a number of years there are multiple
companies which are all essentially the same entity. For each company
there are also multiple contacts, some of which may be congruent.
It's a very simple app. with only two forms. The first form shows two
lists. The left-hand list is a Single-Select showing all the companies.
The user chooses one company -...
| |
by: shorti |
last post by:
db2 v 8.2 on AIX 5.3
I will try to explain as brief as I can what it is I need. I am
building a function that will be called multiple times where I will
need to return x amount of records each time for the same basic
query. I will be basically get passed in where I had left off the
last call but it is two fields that make up this unique index.
The main rule is that I cannot hold open a cursor on the record I last
read because it...
|
by: jennwilson |
last post by:
Using Access 2000 - I have a query that is suppose to return the records from table within specified time range and find matching data from another table .
Table houses Clinician name, location and rate information
Table houses Clinician name, location and number of units for each type of service rendered on each day. The two tables are connected by field
Please see the code below
SELECT .Clinician, .Location, .Date,...
|
by: tjm0713 |
last post by:
Not sure this can be done but here is my current situation. I have a table containing millions of records. Each record has 28 fields. One of the fields I am trying to return the single record for is Res_code. There can be multiple records with the same Res_code. Some of the matching Res_code records can have different values in any of the 28 fields and some may have exactly the same value in each field.
Example:
Res_Id ...
|
by: Wildster |
last post by:
Hi,
I’ve setup a table which contains records with multiple duplicated time fields (tblTime_Slots)
i.e.
ID Time_Slot
1 08:00
2 08:00
3 09:00
4 09:00
etc…
|
by: dizzydangler |
last post by:
Hi all,
I am a new Access user and just starting to get my head around some of the basic concepts, so please take it easy on me :) My company has been managing client records on excel, and I’m in the process of migrating the data over to Access 2007 (Windows XP), kind of learning as I go. I’ve managed to import the client records into a single table, and set up a “single view” form that streamlines how we input new client data. Now I’m...
|
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: 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: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
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: 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: 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
| |