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
"The field is too small..." error coming up on Select query. by Mayhew
I have a SELECT SQL query in Access 2003 that throws the error "The field is too small to accept the amount of data you attempted to add. Try inserting or...
August 28th, 2006 04:32 PM
by cal Go to last post
6 88
"The Microsoft Office Access database engine does not recognize... by ant1983
I have a query and one of the fiels is numLevel. Then i have a form wirh an unbound combo called txtLevel. then in that query in criteria under numLevel i...
January 24th, 2010 10:29 PM
by John W. Vinson Go to last post
3 116
"The setting for the ListRows property must be from 1 through 255" by Nick Pullar
Hi there First question, so please be gentle. I have created a database in Access 2007, which all works really well. However, for some of my queries, when...
January 9th, 2007 05:46 PM
by Klatuu Go to last post
4 482
"the specified field could refer to more than one table" error by Drew
OK...here is my query: INSERT INTO OutsourceRecording_Baseline ( OrderMasterID, OrderNum, ApplicationNum, BorrowerLastName, BorrowerFirstName, PropCounty,...
November 19th, 2008 05:50 PM
by Golfinray Go to last post
1 52
"Too Few Paramters"? by [email protected]
What's wrong with this? It gives me: "Too few parameters. Expected 1." and the debugger points to the currentDB.Execute(query) -- snip...
March 15th, 2006 03:53 PM
by Duane Hookom Go to last post
2 86
"too many crosstab column headers" error - IN DESIGN VIEW!@!?!?!? by Bob
running access 2k; I have a query that uses a crosstab query as one of the tables in this query. I cannot even open this query in DESIGN view without getting...
August 10th, 2007 07:44 PM
by Bob Go to last post
2 115
"Too many fields defined" Error 3190 by AccessIM
I keep receiving an error message when trying to run a query. The query pulls from two tables: Sheet 1 which is information imported from an Excel...
February 19th, 2009 06:56 PM
by KARL DEWEY Go to last post
1 91
"Too Many Rows to Output" message by cjlars
I ran a query with 42,000 records (rows) I'm trying to output to (analyze in) Microsoft Excel 2000 running Windows XP. However, I get the following message:...
January 5th, 2006 07:23 AM
by Van T. Dinh Go to last post
2 74
"Totals" button in query - what is it used for? by George Matthew Dareos
While trying to figure out a vacationing coworker's query, I find that he's got a "Total" row in the quey grid, and I discovered that by clicking on what looks...
September 14th, 2007 08:35 PM
by George Matthew Dareos Go to last post
4 55
"type conversion error" by Jillian
I keep getting a "type conversion error" while using the dsum function in an update query. My sytax is correct and the two tables are linked
November 12th, 2005 04:38 PM
by Jeff Boyce Go to last post
1 73
"Ungültiges Argument" beim Kopieren von DS by Björn Benatzky
Ich habe ein Problem mit der A03 Datenbank eines Kollegen, für den ich einen Fehler beheben soll: Es sollen über eine Abfrage alle Datensätze der Tabelle...
October 13th, 2009 03:37 PM
by Stefan Hoffmann Go to last post
4 111
"Unnormalize" table by [email protected]
Hello I have a table which looks like this: DRG Patient Costs ================== A a 10 A b 20 A c ...
February 12th, 2008 01:19 PM
by Gary Walter Go to last post
1 128
"update ta set ta.ra=1 from tablename ta" how can pass in Access by lll-j
is it can be pass in the Access? how to change? thanks! update ta set col = t.col from ta,(select id,max(col) ...
November 1st, 2007 04:38 PM
by Michel Walsh Go to last post
1 85
"Use of OR condition in UPDATE Query" by Shaukat
I have a table that lists a set of diseases in several columns (say 2 columns, Disease1, Disease2). I want to create a new column (let us say, Diabetes)...
March 8th, 2008 07:03 PM
by John W. Vinson Go to last post
2 128
"variable" column name by K Dales
I have a table (Table1) with questions: each row has a question number (1,2,3,4...) and the text (e.g. "Date of Procedure", "Procedure", "MD Name", "Start...
April 13th, 2006 01:55 PM
by K Dales Go to last post
4 83
"You cannot add or change a record": HELP please by scubadiver
I have the following relationships: tble_query - 1:n - tble_Ccode - n:1 - lkup_CcodeS - n:1 - lkup_CCodeT I have a form which holds "query" information...
March 19th, 2007 04:49 PM
by Özcan ELMALI Go to last post
1 105
"[Oracle][ODBC][Ora]ORA-01008: not all variables bound" Error by Harvey
Hello: I am trying to submit the following to Oracle from VBA code through a conn.Execute(sql), where sql is: DECLARE v_existing_reccount NUMBER; BEGIN...
April 11th, 2009 12:13 AM
by John W. Vinson Go to last post
1 258
'Cannot delete from specified table' message by Dorian
Why does this query work fine, yet when I replace 'SELECT C.ID' WITH 'DELETE C.*', I get 'cannot delete from specified table'. I clicked on Help and none of...
January 22nd, 2009 04:54 PM
by John Spencer (MVP) Go to last post
1 122
'Count' query not working by PayeDoc
Hello All Why isn't this working: SELECT .practice, ., Count(.) AS FROM months INNER JOIN ON months. = . WHERE (((months.year)=!!)) GROUP BY .practice,...
March 30th, 2010 01:00 PM
by John Spencer Go to last post
5 185
'count' query question by tlyczko
Hello, I hope someone may help shed light on setting up this query. I have two tables: Incidents, with fields IncidentID (PK), IncidentDate, other...
June 27th, 2006 09:06 PM
by tlyczko Go to last post
2 108
Post New Thread


Display Options
Showing threads 261 to 280 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 08:26 PM.


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