A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Post New Thread
Threads in Forum : Running & Setting Up Queries Forum Tools Search this Forum Feed Icon
  Thread Reverse Sort Order / Thread Starter Last Post Replies Views
"No Record Found" Message by Keri
The previous owner of this database created a query that would allow people to choose a "Unit" and a "Region (this can be entered or left blank for...
February 2nd, 2006 09:17 PM
by Jeff Boyce Go to last post
1 71
"Not a valid password" message by !pro-progammer:)
When I coding "DoCMD.RunSQL 'Select Some Field FROM A Table IN Another Database' " but that database is password protected, I always get "Not a valid...
November 9th, 2007 03:46 PM
by Klatuu Go to last post
4 97
"Not enough space on temporary disk" what does it mean? by Ron.William
I've been running queries off of OBDC databases and I am receiving the following error which does not allow the query to complete. Does anyone know what...
October 10th, 2008 11:37 PM
by John W. Vinson Go to last post
1 76
"Not Equal" inside an IIf statement by jas580
Hi, I have the following expression in the criteria of . field in a query: IIf(!!=1,.,IIf(!!=2,3,3)) is a combo box on a form with the following 3...
November 12th, 2007 09:21 PM
by John Spencer Go to last post
8 102
"Not Like" by SthOzNewbie
I have a totals query which looks for records that contain an "S" in a particular field via a WHERE clause - WHERE...
June 29th, 2006 11:37 PM
by SthOzNewbie Go to last post
2 85
"not like" query by Brad Hotlz
I need to filter a query with something on the order of: not like "R*" and not like "T*" and not null unfortunately, I believe there is no "not like" command...
March 16th, 2006 07:07 PM
by Brad Hotlz Go to last post
3 91
"Not Updateable query" error.. by nycdon
Trying to update a table based on another. Getting messsage "Operation must use an Updateable query. Anyone see anything wrong with this? Business unit is on...
March 27th, 2006 06:11 PM
by Duane Hookom Go to last post
3 104
"Not" Query by ThomP
Ok, having a case of "vapor lock" here. I have a query tracking sites on the body, (ie, brain, arm, ear, etc) How can I make a query to track those which...
May 5th, 2009 02:04 PM
by ThomP Go to last post
2 138
"Numeric Field Overflow" by Don
I am importing data from a txt file into table using a import specification "OpenOrders Import Specification1". When I import using the specification and the...
August 31st, 2006 06:12 AM
by Don Go to last post
0 80
"Numeric field overflow." by G Lykos
Am regularly running into a problem where something snaps and an append query stops running with the captioned error message. I'm not doing any math...
May 20th, 2006 07:22 AM
by Allen Browne Go to last post
4 77
"Operation Must use a updatable query" message by mscertified
Trying to run: UPDATE tblActivityQuestions AS A SET A.QuestionID = (SELECT Q.ID FROM tblQuestions As Q WHERE A.ChecklistID = Q.ChecklistID AND A.Sequence =...
August 3rd, 2006 11:49 PM
by John Vinson Go to last post
2 108
"Operation must use an updateable query" by Anthony
what does this error mean: "Operation must use an updateable query"
November 29th, 2006 11:36 PM
by Anthony Go to last post
2 106
"OR" trouble. by Brad Granath[_2_]
I have two tables. One, "Units," contains an inventory of units (primary key is a "Unit ID") and the other, "Inspections," is a record of inspections...
October 9th, 2007 07:01 PM
by Brad Granath[_2_] Go to last post
7 113
"order by" issue after compact database by [email protected]
Hi, I have a Access 2003 database. I run SQL querries via a homegrown application that uses ADO. The database contains 20 tables, each with the same schema,...
(Multi-page thread 1 2)
February 7th, 2007 07:56 PM
by Marshall Barton Go to last post
11 150
"Other people working..." by Robert Norton
Hi all! Hope you can solve my mystery guests! If I put my pc on standby when I later go to turn it off it tells me other people are using the pc and they will...
August 15th, 2007 10:17 PM
by Douglas J. Steele Go to last post
1 161
"Overflow" error in an Access 20003 query by Harry
When I run a select query that links two tables that should result in 83,000 records I get an "Overflow" error message. No other information about the error...
March 20th, 2007 08:51 PM
by Jason Lepack Go to last post
3 98
"Overflow" message in UNION query by Mark Wickett[_2_]
Hi, I have a UNION query that has started to generate an "Overflow" error message when I execute it. The SQL is "select * from query1 union select * from...
January 3rd, 2008 04:04 AM
by Mark Wickett Go to last post
3 237
"Preparing Data" stalls in Pivot Chart by Guitarzan
Greetings, I have a simple pivot chart that are reporting 30 rows of records with 15 field headers where the chart opens however not all the data will be...
September 4th, 2009 07:25 PM
by Guitarzan Go to last post
0 147
"query is too complex" error message by Dale Fye
This is crazy. I have a union query that brings together data from 4 other tables. This query runs great. I'm now trying to use that query as the source...
December 19th, 2006 02:29 AM
by Allen Browne Go to last post
1 68
"Query is too complex" Problem by AccessIM
Hello All- I have the following query: SELECT qryReceivingDateRange.ItemCode, Min(qryReceivingDateRange.LeadTimeEndDate) AS FirstLeadTimeEndDate FROM...
August 18th, 2009 06:33 PM
by AccessIM Go to last post
3 119
Post New Thread


Display Options
Showing threads 221 to 240 of 43289
Sorted By Sort Order
From The
Forum Tools Search this Forum
Search this Forum :

Advanced Search

New posts New posts More than 15 replies or 150 views Hot thread with new posts
No new posts No new posts More than 15 replies or 150 views Hot thread with no new posts
Closed Thread Thread is closed  
 
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 11:51 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.