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
access and sql server via odbc by
When writing a pass-thru query in Microsoft Access to access an sql server via an odbc system dsn, I can write a query like: select * from MyTable However,...
September 29th, 2005 05:08 PM
by Steve Jorgensen Go to last post
1 96
ACCESS AND TABLES by GG
How set query to compare records on two table in Access?
January 13th, 2005 10:51 PM
by John Vinson Go to last post
3 137
Access and Word Merge by DSmith
Trying to merge a query to a Word document. Same query and document used last year. The query has 888 records the merge shows 0 records. The only different is...
January 24th, 2006 06:25 PM
by DSmith Go to last post
3 89
access append querry by SimpleT
I am using Access to preform an Append Querry but no records will append.
September 23rd, 2005 05:01 PM
by PC Datasheet Go to last post
2 95
Access Append Query by clk[_2_]
I have two tables set up in Access. Main table is "tblCheck" which holds check number, check date, company that issued check and check amount. I have a...
February 23rd, 2009 10:46 PM
by KARL DEWEY Go to last post
2 99
Access Append Query by Kary
I have a table to register organization names (Org) and a related table (Area) to store the area's where these organizations operate. When a new...
May 25th, 2009 05:56 PM
by KenSheridan via AccessMonster.com Go to last post
2 94
access append query disabled mode by S Lee[_2_]
I created an Access 2007 append query. I try to run it but it tells me disable mode won't allow the query to run. What the heck is disabled mode? I...
February 14th, 2008 06:13 AM
by Allen Browne Go to last post
1 137
Access Append Query Failure by Leaders01
When I tried to append a table I (Insert Into), I get a get this error reading, "Microsoft Access can't append all records in the append query... Microsoft...
July 26th, 2009 02:36 AM
by Gina Whipp Go to last post
1 85
Access append query problem by bartheyvaert
I'm having a problem using a microsoft access append query : when appending the records to the destination table, the records are not sorted in the table the...
April 20th, 2005 06:30 PM
by John Vinson Go to last post
2 195
Access Append Query to update Sequence Generator in Oracle by Jim
I wrote an append query that successfully gets new Unique ID's, loads them as the append query runs, and appends to the Oracle tables just as expected (OBDC...
December 22nd, 2007 08:04 PM
by Jim Go to last post
9 114
Access automatically changes name of form in conditional query by jimati
I have a list box on a form that has information that changes based off of a field on my form. For example, in a text box if I put "RED", the list box shows...
July 10th, 2009 04:26 PM
by Jerry Whittle Go to last post
1 83
Access Automatically Moving Criteria Columns to End of Query (DesignView) by Mike
I have a query being run where the position of the criteria (in Design View) is important to pull the data correctly. However, I have to move this column to...
September 23rd, 2009 12:13 AM
by John Spencer Go to last post
3 177
access caluclated field query by [email protected]
Hi, I am entering height, weights and age into a database and I want to create a query which enables Access to automatically caluclate BMI (two kinds...
July 10th, 2007 06:15 PM
by [email protected] Go to last post
2 64
Access can not find a table in append query by Tom
Hi all, I have a table called MyCustomers. For some reason, when I try to create Append query, it doesnt show on the list of tables. I know the the table...
November 8th, 2007 09:06 PM
by boblarson Go to last post
7 109
Access Can't Append Message by faxylady
I am trying to append two large tables of contact data. One table has 10,000 entries, the other has 7,000 entries. This a simple append query. The Error...
November 20th, 2006 07:23 PM
by faxylady Go to last post
3 112
Access can't represent the join expression by Nicodemus
Hi all, working in MSAccess2003 & XP. I create joins between 2 or more tables in a query, I close and save this query, and when I want to open it again, I get...
(Multi-page thread 1 2)
June 20th, 2006 09:24 AM
by Nicodemus Go to last post
10 166
Access can't start because there is no license for it on this machine by Rosie
I have re-installed Office 97 Professional on my computer after upgrading to Windows XP. The other components are all OK but I get the above message each time...
August 18th, 2004 05:23 AM
by Spammastergrand Go to last post
3 350
Access changes bracketing of subqueries in joins causing syntax er by David Yanacek
See if anyone can get replicate this error: Make any query with a join in it. Go into SQL view and change on the tables in the JOIN to a subquery. Use ( and )...
June 25th, 2004 07:09 PM
by Ken Snell Go to last post
1 140
Access changes the characters '(', ')' into '[' and '].' . by SriM
Access changes the characters '(', ')' into '.' respectively. How to stop this from happening. Everytime the query is opened for editing, the above...
September 22nd, 2006 06:20 PM
by Ken Snell \(MVP\) Go to last post
1 55
access chart data table number format by Yolanda
I have problem in the number format when displaying the data table with the chart. My data is from a table, the format is in percentage with 2 dec. However,...
September 21st, 2004 06:59 PM
by MGFoster Go to last post
1 403
Post New Thread


Display Options
Showing threads 981 to 1000 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:53 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.