Is It Possible To Pass Parameters to A Pass Through Query
My assumption is that's it's not. At work I use ODBC to connect to our
oracle database with Access 2003. There are cases where using a pass through
query runs much much faster and I then use it in a make table query to make
a local table. In access you can use brackets  to have it ask for input.
May I assume there is no way to do anything like that in a pass through
Create a PassThrough query and use code to assign the SQL to this query
filtering it with a parameter, and then run it
Dim MyVariable As Integer
MyVariable = InputBox("Please select a Number&quo...pack money data?
Is it possible to pack and/or otherwise clean up Money's data file? I'm sure
I don't have 12MB of data in that file, despite its size. It's probably a
jumble in there, just waiting for a chance to get corrupted.
In microsoft.public.money, Paul Pedersen wrote:
>Is it possible to pack and/or otherwise clean up Money's data file? I'm sure
>I don't have 12MB of data in that file, despite its size. It's probably a
>jumble in there, just waiting for a chance to get corrupted.
12 MB is below average I suspect. I recommend you minimize getting
s...Pass multiple selected values from list box to table
How do I pass multiple selected values from a list box to a table?
I've found code to use the values as criteria in a query but would now
like to store the values in a table (at least temporarily)
thanks in advance.
Pass selected values from a list box to a table? I don't really think you
want to do this. Can you describe more about what you are trying to
You just store raw data in a table. You don't store manipulated data in a
table. Maybe you need a query to do what you want to do...
If this information was helpful, please indi...accessing data from another document or tab
Is there any way to run functions with a range from a seperate page o
tab in the same document
Message posted from http://www.ExcelForum.com
Just enter the foormula name and select the range with your mouse (also
on a different worksheet)
> Is there any way to run functions with a range from a seperate page
> tab in the same document?
> Message posted from http://www.ExcelForum.com/
...Lookup Wizard changing Data Type
I am trying to make Lookups from Table Field to Table Field and generally it
However the LookupWizard is changing the Data Type from Text to Number (I
guess it's looking at the ID?)
Data picked from Combo Box 'looks' OK in Table view
A Query view is asking for a number but displays the Text field value when a
valid ID number is added.
Viewing Results in FrontPage Database Wizard, and using hand coded .asp
querie, it's showing the ID field value.
I can see why...
Yes, the wizard isn't the problem it's the use of Lookup Fields in ...How do I sum numbers based on other data
I have a spreadsheet with several thousand entries. On one sheet, call it
sheet 1, there is One column with about 100 names, another column has number
amounts. My other sheet, call it sheet 2, has a list of names. What I would
like to do is for each name on sheet 2, sum up the number values from sheet
one for that particular name. So the end result would be a column on sheet
two that shows the totals taken from sheet 1 for each name. I keep adding new
entries on sheet one, so the totals on sheet 2 must always show the updated
totals. Any help would be greatly appreciated. I am...How to pass an object from C++
We have a C# asp.net web application that is using a COM dll
We use the tlbimp to be able to use the COM dll from C# asp.net web
The method InitRules shown below is located in the COM dll.
It can be seen below the text Original.
Method InitRules below is called from C# but we want to pass an object of
type Handle_DS in addition
to all the other parameters. You can see the modified InitRules below marked
Note the object of type Handle_DS is a C++ object that is created from C#
asp.net application and pass
into the InitRules
I have also copied the whole idl fil...Report with buttons to open specific form for each record
Is it possible to have a report that is based on a query (which is based on
numerous other queries) to have a button that opens a specific form for each
record on the report?
I would like for the user to be able to select an appropriate button which
corresponds to a form based on the results showing on the report.
...Importing Data from Access into Excel
I have a spreadsheet that has mutiple tabs that I want to import data from an
Access table into a specific cell everytime I refresh.
That's not a lot of information to go on, but....in general, you could start
1)Select the cell where the data pull will begin to store the Access data
2)Data>Import External Data>New database Query
3)Select the MS Access data source
4)Select the table(s) you need to use and progress through the MS Query
5)At the end, you can either select to edit the query or just send the data
back to Excel.
6)Repeat for each sheet that is to re...use data on excel sheet to input data on web page
I don't know if you can do this but here's the question. I would like to
take some data on a spread sheet (example: division # and item code) and have
this placed on a web page in the correct spots (division is a drop down box)
so the site will find the correct information and then have excel import the
found data onto a separate work sheet. Any insight into this would be very
...Why does linked data from blank cells become a zero?
When linking data within the same workbook (to different tabs) any cell that
is empty - shows up in the new tab as a ZERO (0).....what am I doing wrong? I
want those cells to remain blank.
That's just the way it is ..
Instead of : =Sheet2!A1
you could use an error trap: =IF(Sheet2!A1="","",Sheet2!A1)
Alternatively, we could suppress the display of extraneous zeros
in the entire sheet via:
Click Tools > Options > View tab > Uncheck "Zero values" > OK
GMT+8, 1� 22' N 103� 45' E
xdemechanik <at>yahoo<dot&g...Downloading data into Excel
I am interested in purchasing business leads from several
different companies. These leads would contain name,
address, phone, etc. The autoresponder system I would like
to use accepts data from Excel. I would like to know what
data format leads can I use that could be downloaded into
Excel. Also, since I am familiar with computers and Excel
but not an expert, I would like to get information on
EXACTLY how to download the data from the acceptable
formats into Excel. Any help you folks can provide would
be greatly appreciated. Thanks in advance!
...Outlook 2003 data recovery other than .pst/.ost
Recently my old PC got crashed & now I am trying to transfer all the
relevant data to new m/c but I am not able to recover emails from the
outlook 2003. As I dont see any .pst/.ost files on that m/c. Is there
any other format those emails would be stored ? How do I restore it on
my new pc.
Thanks for your help
venkat <firstname.lastname@example.org> typed:
> HI Guys,
> Recently my old PC got crashed & now I am trying to transfer all the
> relevant data to new m/c but I am not able to re...Data moving 2
I have following code:
Dim x As Long, y As Long
x = Range("X" & Rows.Count).End(xlUp).Row
y = InputBox("enter the row number to paste")
Range("A2:BK2" & x).Copy
Range("A" & y).PasteSpecial
I want to cut data of range(A2:BK2 to end row related) and then paste to row
number which determine in Box. when i run above code on some of sheets, error
message appear(Run Time error 1004). please note that, this code with cut
command not run, only with copy command.
any help will be gre...Filter Report by Form
I have a report with both text, date and Yes/No fields and I am trying to
filter the report data with a pop-up form. I have fields I want to filter
the data by. I have code that works with 'Text' fields; it is
For intCounter = 1 To 5
If Me("Filter" & intCounter) <> "" Then
strSQL = strSQL & "[" & Me("Filter" & intCounter).Tag & "] " & " =
" & Chr(34) & Me("Filter" & intCounter) & Chr(34) & " And "
If i take out ...Summing a years worth of data
If data is entered every month in one tab. How would i then sum thi
data by year into another tab? if necessary i dont want to kee
changing the formula from year to year
eg Col A Col B
Jan 04 20
Feb 04 25
Then another tab that sums data by year
col A Col
Message posted from http://www.ExcelForum.com
if column A on your second sheet contains the year try the following in
"david72 >" <<david72.149hr...Making form using Excell Help ASAP!
I've made a form. This needs to be filled out online. I can freeze cells
so the user cannot mess with them, but how do I form lines.? Say, a line
above 'Customer Name' in order to answer that question. This is really
getting to me b/c it seems like it should be so easy...
not really sure what you're after but if you click in a cell and choose
format / cells and click on the border tab and then the top line icon does
this give you what you want?
"~Amanda~" <~Amandaemail@example.com> wrote in message
news:26819D...100% Passing Guaranteed in All I.T. Exams/Certifications at 1st Attempt Hi Friends, To pass all types of I.T Exams/Certifications with mind blowing results in 1st attempt just visit http://www.itreal
100% Passing Guaranteed in All I.T. Exams/Certifications at 1st
To pass all types of I.T Exams/Certifications with mind blowing
results in 1st attempt just visit
http://www.itrealexams.com/ and get real time Q&As, Brain Dumps, Real
Exams, Study material, E-Books, Video Exams and Labs for your all type
of I.T Certification Exams.
...Charting more than 255 bits of data
Is there a way to chart more than 255 bits of data; which is Excel's limit?
If yes, is there a limit to that amount of data?
That's the limit to the number of series in a chart. Each series can hold up
to 32000 points, subject to a maximum of 256000 points in the chart.
I suspect you have 255 series each with one point. Could you select the data
all at once and make a single series with 255 points?
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
"PVakerling" <PVa...Data Access Page
I am quite a novice with Access, but I have managed to create a basic
database. Previously when entering reference numbers on a data access page,
when I used "tab", the rest of the corresponding information would show up.
For whatever reason, I can now only see this information when I "save".
I haven't a clue what I have pressed or unticked. Can anybody help me please?
...blank data field shows quote in formula, how to delete it?
In a data file I just received, many blank fields show a single-quotation
mark in the formula. The <<if>> statement does not recognize these fields as
blank. I have tried to 'find and replace' the marks using a search for <<'>>
and also for <<~'>> both without success. How can I fix these fields, in
bulk, so they behave like blanks?
"wdanner" <firstname.lastname@example.org> wrote in message
news:4084C819-F2FF-4E8...OWA, forms based authentication and cached logins
When using forms based authentication on a OWA front-end server can a user
save their login / password information? If so, how? On my server, users
have to enter domain\username, password and select the Priviate computer.
(I'd settle for saving the domain\username and Private computer options).
Another question, is it possible to use the Spell Checker if you don't use
Form based authentication? If so, how?
One of the main reasons for Forms Based is to they don't get the option to
save passwords - adding security.
Spelling Checker Requirements - Server Requirements...Independent Forms
Is it possible to "externalize" forms form Access, so they can be used to
edit tables without launching MSAccess itself? Maybe give them a shortcut to
be placed on the desktop, so they would launch as an independent program?
Thanks for your answer in advance-
I was about to ask exactly the same question.
The last time I used Access was in 98 with Windows NT. I ran an Online
Access (no relationship) in Tasmania. When we had new members in we clicked
on an icon on the desktop, which opened up a form where we put in their
This form was completely independent to th...exporting data to access #2
I'm trying to export data from excel to access, but I'm having some
The layout of my sheet is the following:
A B C D
6 0701 0702
7 10*** salary 100 101 102
8 20 others 50 51
Layout of the table in access:
automatic numbering / accounting_code / profi...Passing arguments to procedures
There is something fundamental that I have failed to grasp about passing
arguments to procedures.
I have a form featuring a set of unbound controls displaying dates and the
corresponding days of the week. (For some reason, the long-date format, on
my computer, does not include the latter, as the documentation suggests it
might, so it has to be separately calculated and displayed.)
A default date is displayed in each control, on Form_Open. This can then be
manually adjusted by a pair of ‘up’ and ‘down’ buttons associated with each
day/date control pair. In the case of the control ‘St...