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 97 Query Advise by John
Hi I need to use a query as follows; SELECT * FROM (SELECT * From Table1 staff WHERE Table1.Field2 = "A") AS T1 WHERE T1.Field1 = "X" The problem is that I...
(Multi-page thread 1 2)
August 23rd, 2007 03:01 AM
by John W. Vinson Go to last post
10 113
Access 97 Query Field Name Truncation by Kevin Seerup
I am having a problem that only occurs on one PC. On this PC, when one of the queries is run it complains about a duplicate field name. In the query design...
August 18th, 2004 07:40 AM
by Kevin Seerup Go to last post
3 408
Access 97 Query Involving Selecting Distinct Field Values by James Simpson
Hello, I currently have an Access 97 database and would like to accomplish the following in a query : I would like to select records from a table called...
August 6th, 2006 04:56 PM
by tina Go to last post
3 106
Access 97 query to show previous 7 days data by Dan Kelly
I am trying to create a query that will show data for the the previous 7 days, but not the current day.
November 1st, 2004 07:42 PM
by Rick Brandt Go to last post
6 157
Access 97 Sub Query Error by [email protected]
Hi All Was wondering if anyone is able to help on the below query: dbC.Execute "INSERT INTO dt_local " & _ "SELECT TOP 1 * " & _ ...
November 16th, 2006 12:00 PM
by [email protected] Go to last post
0 72
Access 97 to Access 2002 conversion by KK
Hi all, I have an app in VB which contains Acc97 as backend. I need to convert this to Acc2002. I think there are some data type differences in the two...
July 28th, 2004 05:31 AM
by Chris Mills Go to last post
3 128
Access 97 using a saved query in MS Query by Eric
Hello all, I am hoping someone can shead some light here. I am using the ODBC Client Access driver to access some information from the iSeries. I have set up...
June 1st, 2005 09:52 PM
by Eric Go to last post
0 195
Access 97, unbound form, ODBC query criteria by Mr B
Hi I was wondering if somebody could help with this rather awkward problem. I am using Access 97 and am basically trying to use 2 date values entered into two...
May 17th, 2006 07:30 PM
by Mr B Go to last post
0 56
Access a query without opening Access by Tired and Confused
I have a db with several dozen queries. I need a non-technical person, who is also not authorized to see all the info in the db, to run one query each...
January 10th, 2010 04:47 AM
by VWP1 Go to last post
3 223
Access a subform in a query by Nigel
What is the sysntax to refer to a subform in the conditions statement of a query I tried the following !!.! but that doesn't work thanks
June 20th, 2008 12:41 PM
by John Spencer Go to last post
2 143
Access act like spreedsheet by George
Hi, I have problem in query and I am not sure if it is possible. My query has a column for...
June 14th, 2007 03:59 PM
by Michel Walsh Go to last post
3 56
ACCESS ADDITION by gambler
I have a number of fields in my query that i would like to add up and put that total in my report. My friend said i would first have to write IIF statements...
May 4th, 2010 12:52 AM
by gambler Go to last post
3 318
Access ADO parameter query by michael971
I have a form with a text box and button and want to run an Access query that takes an input parameter. I have the following code for the button: I get an...
February 2nd, 2007 09:54 AM
by giorgio rancati Go to last post
1 98
Access ADP Form and Stored Procedure as RecordSource by chrise
This may be common knowledge but I could not find any posts. My ADP form allows the user to input search criteria into textboxes, checkboxes, and listboxes in...
July 29th, 2009 07:21 PM
by chrise Go to last post
0 114
Access Advisor Summit (Miami) by Dale Fye
Is anyone attending that Advisor Magazine Conference the week of 30 Sept - 4 Oct? If so, I'm looking for someone to share a ride (limo, cab, whatever) from...
September 14th, 2007 07:51 PM
by Tony Toews [MVP] Go to last post
4 187
Access almost freeses aftera pass-through query by iq
I have a few pass-through queries which execute SQL Server stored proc. After I run these queries, Access slows down and become unresponsive - the only way to...
September 20th, 2005 12:57 PM
by iq Go to last post
2 93
Access and equiv of Transact-SQL's Nolock hint? by Darrell Grissen
Hi, I am working on a project and plan to use Access to connect to SQL server. The developers are worried about time-outs... so my question is - Does Access...
July 10th, 2004 04:15 AM
by MGFoster Go to last post
4 145
Access and Excel 2007 - 65000 rows limitation trouble by Lucson
I had an Access 2003 query. When I ran it and exported into Excel, the total number of rows got truncated to 65000 (a limitation well known with MS Excel...
March 24th, 2009 10:58 PM
by Lucson Go to last post
4 145
Access and ODBC Drivers by TheBea
I just installed Office 2007. I have ODBC links to FoxPro 6.0. After I installed 2007 my queries that are linked to Foxpro will fail in the design mode if I...
July 10th, 2007 03:14 PM
by TheBea Go to last post
0 57
Access and servers question by Dupatt
I am getting resistance to using Access databases at work because some people who I believe don't know what they are talking about. I am told that when...
May 10th, 2008 07:43 AM
by dddddddd Go to last post
9 148
Post New Thread


Display Options
Showing threads 961 to 980 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 01:23 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.