Query Tables Lost
I have a situation where after an upgrade from Office XP to Office 2003, an error message occurs when I open an Excel file created in Excel XP which has a Query Table attached.
The error messages syas something like: Some data may be lost. - Query Table
Is this expected behaviour and is there a way to convert the Query Table so that it will work in Excel 2003?
I found out why this was occurring.
The file had an external data source which had been deleted by the customer!
> I have a situation where after an upgrade from Office XP to Office 2003, an error messa...Collections-Query pulls all information by Customer ID vs query
Currently the query in collections limits the functionality of the module
All the o/s transactions are selected in the query for the customer ID in
the query. Therefore all other selection critieria is irrelevant - ie. date
The customer cannot send out specific letters for 30-60, 60-90, 90-120, >120
as the customer will receive multiple letters if they have invoices o/s in
each of these periods.
Also, emails invoices cannot be selected by date range or any other
parameters. The client must send all o/s invoices vs sending out just the
monthly invoices by email.
It would b...Filter by Query
I have a form with 2 subforms. The main form has data from 1 table while the
other 2 subforms are from 2 other tables. When the client wants to only see
certain records, I have a Macro running to execute a query to populate the
screen with just the records needed. Due to some re-designing, I now have
part of the criteria on one table and part on another table and it is getting
weird pop up boxes. I have tried having one query feed a second query but
that does not work either. When I just execute the queries without trying to
show the screen, it works perfectly. Ideas?
Thank you f...Make textbox visible based on checkbox???
I have a textbox named txtTitle that is bound to a hyperlink field in my
table. I also have a checkbox named check65 bound to a yes/no field in my
What I want is the textbox, txtTitle, to be invisible unitl the checkbox is
selected, then visible. I have tried this:
Me.txtTitle.Visible = Me.Check65
in the AfterUpdate Event of my checkbox and it gives me the message,
"Microsoft Access cannot find the Macro 'Me'"
What am I doing wrong?
Me!txtTitle.Visible = Me!Check65
Microsoft Office/Access MVP
"This Guy" <...Update Query
I have three tables: tblVendors, tblForecast and tblTemp
VENDOR_NAME, SERVICESUITE_NAME, Q1, Q2, Q3, Q4, REGION_NAME
VENDOR_ID, FHIST, SERVICESUITE_ID, REGION_NAME, Q1, Q2, Q3, Q4
VENDOR_ID, VENDOR_NAME, VENDOR_DESC, REGION_NAME
I am trying to populate (append) records into the tblForecast from tblTemp
by matching VENDOR_NAME in tblVendors with the VENDOR_NAME in tblTemp. If a
match occurs I want to write the entire tblTemp record to the tblForecast and
add the VENDOR_ID from tblVendors to tblForecast.
PK in tblVendors = [VENDOR_ID]
PKin tblForecast =...Web Query #2
I am currently running a macro that initiates a web query on a https site
that contains mixed content (both secure and non secure items) the query
keeps failing because the warning message "This site contains both secure
and non secure items. Do you want to display the non secure items?" prevents
the query from proceeding.
Any ideas on a work around? Is there a way to turn the warning messages off
I have tried adjusting settings in IE however this does not appear to turn
the warning message off in excel. Could a command be written into the macro
to click yes at the point of the warn...Query Based Distribuiton list
Please let me know if we can use query based distribution list for sending
mails. I heard that it affects the exchange server performance, is that true?
Also let me know how the Query based distribution list works?
Thanks & Regards
Query-based Distribution Lists do not have static membership - unlike
Distribution (and Security) groups that store list of members in the
"member" attribute. Membership is determined based on an LDAP query/filter,
similar to the ones used for Address Lists and Recipient Policy.
Depending on environment, yes - there will be...Calculating time in query
I'm searching for some help with my query. I'm making access to be my
administration program for my freelance job. I've made a table with a row
'starttime' and a row 'endtime'. Now in my query I want to calculate the
difference between these two rows. And then I want to make another query to
calculate the totals of these differences. Is this a logic way to do this?
And I'm trying to make a expression to calculate the difference but with no
luck. The result is something like this: 3,2515785. I've found a kb article
but I still can't figu...Count items based on two criteria
Hi, can anyone help with this please
I have a table that lists articles published over a month.
I have two (relevant) columns:
Column A (Pulications)
Sydney Morning Herald
(etc - the list runs for hundreds - each represents an article and a
publication may appear more than once)
Column B (Day of the week) [Btw originally the data for this was in
date format, but I am just using the days of the week as text -
because I want to count the days of the week]
(etc - each represents the day of the week an...Query Using Time
My table name is Master. I would like to create a query that uses the field
[Login] from the Master table. I would like for the query to display any
entry that comes after 8:05:59 AM. I have tried using >#8:05:59 AM#, but
this does not work. Please offer any suggestions.
Nevermind...fixed the issue.
> My table name is Master. I would like to create a query that uses the field
> [Login] from the Master table. I would like for the query to display any
> entry that comes after 8:05:59 AM. I have tried using >#8...CheckBox
Huston we have a problem!
Is there some quick way of binding CheckBox to bool variable? it's
really annoying to create lot's of onButtonPressed methods...
> Huston we have a problem!
> Is there some quick way of binding CheckBox to bool variable? it's
> really annoying to create lot's of onButtonPressed methods...
Mapping to a bool is easy but you would still have to create the
OnButtonPressed method to update the bool. I.e., the bool mapping is
Scott McPhillips [VC++ MVP]
Why? Either the buttons are all different, in which cas...building a query with variables
I have a combo box that is based on a group box. Here's the code
120 Select Case grpDept.Value
130 strDept = "Administrative"
140 Case 2
150 strDept = "Food Service"
160 Case 3
170 strDept = "Maintenance"
180 Case 4
190 strDept = "Ops. A-Days"
200 Case 5
210 strDept = "Ops. A-Nights"
220 Case 6
230 strDept = "Ops. B-Days"
240 Case 7
250 strcnt = "Ops. B-Nights"
260 Case 8
270 strDept = "Programs"
280 ...I have a query with 10,000 records but I only want to see the first 1,000 records...
I have a query with 10,000 records but I only want to see the first 1,000
How can I get an Access Querie to only return a specified number of records?
Add TOP 20 into the SQL statement like this --
SELECT TOP 20
Build a little - Test a little
"Kelvin Beaton" wrote:
> I have a query with 10,000 records but I only want to see the first 1,000
> How can I get an Access Querie to only return a specified number of records?
S...Same Columns Different Queries
I have 2 different queries that I need to combine (perhaps) into one. The
problem is I need to have the data go to the same columns. Such as...
ID Name Account Number
As you can see they both have the same field names but different info.
Any help is appreciated.
Unless you need to be able to update the resultant query, use a UNION query:
SELECT ID, [Name], Account
SELECT ID, [Name], Account
If you need to know from which query the value came, try:
SELECT ID, [Name], Account, "Query1&...Query of an SQL Database
I have a query made to pull information in from a SQL database. Fro
time to time, this query exceeds the the 65,000 row limitation. So th
question is kind of two part.
1. How can I limit the query to only pull 65,536 rows of data?
2. How can I force the query to start dumping to a new worksheet onc
the first one has reached it's capacity?
brewabelPosted from http://www.pcreview.co.uk/ newsgroup acces
Use this clause in the sql of the query (go to the SQL window)
Select Field1, Field2 from table A;
Select top (x) field1, field2 from table A.
As for the secon...Union Query between 2 or more Queries
Is it possilbe to create a Union between two or more queries? I have created
Union query between multiple Tables but haven't had any luck creating a union
between other queries. If yes, could someone please share an example of the
SQL that would be used to make such a query?
It should be as simple as something like below IF all the fields in both
queries match up. If they don't match up, you will need to specify the field
names in the correct order.
SELECT * FROM qryA
SELECT * FROM qryB ;
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keit...Funny characters in my query results
Why do I get what looks like Wingding characters in some columns of my query
You may have a corrupt database.
Tony Toews has an excellent web page on database corruption.
Allen Brown also has excellent info on corruption.
I have a white paper in a Word document named Fix Corrupt Access Database.
Click on "Whittle, Jerry" on this page:
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bont...More Query Questions
This one is very detailed. I am trying to run a query that gives me results
that contain the distribution center's name, the total number of parked
trailers there, and then the total cost that those trailers have accrued for
that destribution center. The following is the Rates table that I am pulling
Carrier Rate/Day WKEND Free Days
Triple Crown $50.00 None 2
Alliance $50.00 Included 4
B&W $50.00 None 0
Fourteenth Avenue $35.00 None 3
Tom Donahue $25.00 None 0
JDC Logistics $25.00 None 5
Schneider ...Generate string from selected checkboxes on continuous form
I have a continuous form with a bound checkbox ("ExportSelect") on
each line. I would like to have a command button on the form footer
with an onClick event that finds all the records with checked
checkboxes. Each time a checkbox is true I'd like the string to add to
itself the value of another field on that record....
I've used the "count(iif([ExportSelect]=true,1,null))" on an unbound
field in the footer to successfully count the checked records, but I
can't apply this to create a string I want.
Example of my continuous form:
[ ] dog
...Storage Limit Query
If I set a storage limit for mailboxes in ESM, will it over-ride those I set
for individual users in ADUC?
Basically, I want to set a mailbox limit for users, but let Directors have a
slightly higher limit. Also, if I just set accounts or the overall limit in
ESM to just issue a warning and nothing in the other two options, will it
literally do nothing but issue a warning? Sometimes I think that might be
all I need to badger users into deleting old/unnecessary emails.
We are using Win2k clients, Outlook2000+2003, Win2003 server and Exchange2003.
Your help, as always, is very much a...Running delete query from Excel
From Excel I use ADO to export the Excel data to an Access table.
Before the new data may be imported, this Access table needs to be cleared,
To accomplish this I have created a delete query that deletes all records
from the table.
Currently I have to run this query manually before executing the ADO from
Is it possible to run the delete query from Excel using VBA?
�.............. CHARLIE ..............�
I assume you have already opened a Connection object on your databas...Multiple If statements in the criteria of a query
I'm trying to instert the following in the criteria section of a query in
query builder; the itself is the record source for a list box
If Forms!frmPtDemographicNew.frmVisitNewEdit.Form!fldVisitType = "Ablation"
Me.lstRNnotesLU.RowSource = "SELECT * FROM tblRNnotesLU " & _
"WHERE fldRNnotesCode = 'A'" & "ORDER BY [fld.order]"
Else: If Forms!frmPtDemographicNew.frmVisitNewEdit.Form!fldVisitType
= &quo...Querying cells across cells
I'm wanting to create a basic kind of calculator for
tracking my finances.
What I am wanting to do (and apologies if it's really
simple, but I'm just missing it), is :
I have 4 columns one of which is named : Payments
This column is set to calculate the total at the end of
I also have another column named 'Paid?'
What I'm looking to do is find a formulae that will add
the payments column together (easy enough), but when I add
the word 'Yes' into the Paid column, that amount is
deducted from the total at the end.
Does that make sense?...Checkboxes
I have a workbook with 12 spreadsheets, each with 54
lines. One column in every spreadsheet will have a
checkbox in EVERY row.
1. Every time I enter a checkbox it is entered as
Checkbox 1548 or 941 etc. It's some random high
number. Shouldn't the first checkbox be named Checkbox
2. Twice I have added a checkbox and copied it to every
other cell in the spreadsheet that requires it.
a. Is there a faster way to copy a checkbox 600x
rather than going from cell to cell?
b. I need each checkbox to be associated with the
cell next to it in the next column (B1 ...Need help with multiple queries
I have a table with fields - Annual, Semi Annual and Two year. The user can
check appropriate one (Yes/no boxes). (I thought I need a separate table
with this info so the database would be normalized)
I am trying to create a query that will create a new field and add 1 year to
Annual, 6 Months to Semi-annual, and two years to 2 years. I have three
tables and queries with the part number data as one table, another table is
the last calibration date, the third is the frequency as described above.
How and when do I get the fields to calculate. This is the code I was going
to use, but d...