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 2007 distinct queries on unicode text - bug? by JC, Fredericksburg, VA
I have a table with unicode (Greek) text in it which I imported from a text file. When I view the data I can see all the correct unicode characters...
October 23rd, 2006 04:50 PM
by Allen Browne Go to last post
1 61
Access 2007 does not prompt for action query by Song Su[_5_]
I started Access 2007, run (open) delete query manually. It just did without warning. What happens?
January 19th, 2009 06:22 AM
by AccessVandal via AccessMonster.com Go to last post
1 68
access 2007 how to fill a field in every record with a certain val by dennist685
It was easy in access 2003 Much obliged dennist
May 10th, 2007 07:59 AM
by dennist685 Go to last post
2 95
Access 2007 LIKE Expression by kpick4
I am converting an Oracle database to Access. When recreating my queries I cannot figure out the syntax for the LIKE expression. Oracle: SELECT ORDNUM,...
May 29th, 2007 05:35 PM
by KARL DEWEY Go to last post
1 73
Access 2007 LIKE Expression by kpick4
I am converting an Oracle database to Access. When recreating my queries I cannot figure out the syntax for the LIKE expression. Oracle: SELECT ORDNUM,...
May 29th, 2007 04:12 PM
by kpick4 Go to last post
0 56
Access 2007 LIKE Expression by kpick4
I am converting an Oracle database to Access. When recreating my queries I cannot figure out the syntax for the LIKE expression. Oracle: SELECT ORDNUM,...
May 29th, 2007 06:00 PM
by kpick4 Go to last post
4 78
Access 2007 Lock Violation by JudeD
On Vista machine, in Access 2007 with a linked SQL Server database... Append queries work just fine, but attempts to do an Update query result in Lock...
September 9th, 2007 10:54 PM
by JudeD Go to last post
5 86
Access 2007 Navigation View by CHKMSTrainer
Is there a way to get the Navigation Pane to view Queries across the screen instead of up and down? If not does anyone know where I can get an addin for my...
September 23rd, 2008 04:48 PM
by Allen Browne Go to last post
1 117
Access 2007 new Odbcjt32.dll not fully compatible ? by jdupre
Hello, I experienced a change of behavior of the new OBDC dll for JET engine included in Windows VISTA (ODBCJT32.dll version 6.00.xxxx) or ACCESS 2007 trial...
September 3rd, 2007 11:16 AM
by jdupre Go to last post
0 85
Access 2007 Pass-Through Query problem by zilzala
My problem is this: I have an Access 2007 database (converted to *.accdb from an XP database) on a virtual terminal server machine. It uses third party...
August 1st, 2008 04:02 PM
by zilzala Go to last post
0 92
Access 2007 provider for windows 2000 by [email protected]
I wish to connect Excel 2007, Access 2007 and was getting provider error. I tried to install Microsoft patch AccessDatabaseEngine.exe, but it is not supporting...
October 6th, 2008 08:38 PM
by Lord Kelvan Go to last post
1 86
Access 2007 Queries by Breeze123
I have 2 queries I am trying to run, The first is to get all Units on the fourth floor only in the query and the first number is 4. How do I do this...
December 15th, 2008 01:45 AM
by John W. Vinson Go to last post
3 90
Access 2007 queries will not open in design view by alanwf
Yes, I have tried the suggestions in thread "Can't access design view". I get the error message (" is not a valid name. Make sure that it does not include...
October 29th, 2008 03:29 PM
by emc Go to last post
5 137
Access 2007 Query by twalsh
Im trying to do an update query in Access 2007. Real simple dividing one number by another to get a ratio. When i run the query it only returns 0s and the...
January 14th, 2009 02:41 PM
by twalsh Go to last post
2 87
Access 2007 Query by Dave B
I just uipdated to Access 2007. I created a test database with two tables in it. One table has ID, date, company ID, name, miles and hours. 2nd table has...
October 14th, 2008 02:50 AM
by Bob Barrows [MVP] Go to last post
1 72
Access 2007 Query - "Do I wnat to Save"? by Ron
Is there a way to Exit an Access Query without being asked "Do I wnat to Save"? I do not want other users saving changes to my query, i.e. Sort Order,...
May 27th, 2008 01:49 AM
by Ron Go to last post
2 80
Access 2007 Query Designer Problem by connomar
Hi, One of my rather old databases that originated on Office 97 has a weird problem. I cannot use the query designer on most, but not all of the queries. I...
May 23rd, 2007 04:19 PM
by connomar Go to last post
0 75
Access 2007 Query of unique values by Norm
I am working with an ODBC connection to an SQL database. In attempting to create a simple query for unique values in a field, I would expect to right click...
December 5th, 2007 10:07 PM
by Norm Go to last post
2 58
Access 2007 query performance by CMG
Last week I upgraded from access 2003 to access 2007 and a query I've run successfully for 5 months in under 10 minutes now just hangs. Are there certain...
August 25th, 2009 06:28 AM
by Allen Browne Go to last post
1 164
Access 2007 query returning field names rather than alias by Dale Fye
I posted a similar message about a month ago, but got no suggestions that helped. I've got several queries which I have designed for export to Excel. As...
March 29th, 2009 04:02 PM
by Itzy Go to last post
5 95
Post New Thread


Display Options
Showing threads 901 to 920 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 10:39 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.