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 2003 Datasheet as a Subform by Bud
I have created a subform from a query however, I'm not allowed to add or edit records on the subform. I have the add, edit, and delete properties set to...
May 20th, 2009 06:26 PM
by Dale_Fye via AccessMonster.com Go to last post
1 162
Access 2003 DCount Syntax Rookie by knowshowrosegrows
I am self-taught on this silly software - have lots of idiot books and I'm taking a Intro to VB course and just beginning to understand syntax. I am trying...
March 28th, 2007 08:32 PM
by knowshowrosegrows Go to last post
4 116
Access 2003 driving me mad!!! by [email protected]
Hi - really "new bloke - knows nothing" question so apologies before I start.......... All i'm trying to do is run a query in Access 2003 that returns a...
February 11th, 2007 11:40 PM
by John W. Vinson Go to last post
9 214
Access 2003 eliminating duplicates by nalgal
I have created an action item database. An action item can be repeated in the database since it may belong to different projects & are tracked by ecah...
August 5th, 2008 11:20 PM
by Lord Kelvan Go to last post
6 73
Access 2003 Email a query by Tanya
Hi all, I have created a query, that produces a list of people that have received welfare within the current financial Year. I would like to set this up so...
July 3rd, 2006 04:21 AM
by [MVP] S.Clark Go to last post
1 107
Access 2003 has a bug. It renames my field caption like number by Kraiwit
I set my field caption in a query in Access 2003 like this: 2006/07:July 2006 Data (I want to change the field name from another table to be 2006/07) ,but it...
August 25th, 2006 05:00 AM
by Allen Browne Go to last post
1 85
Access 2003 help says you can do full outer join, but user interf. by John Irwin
Help seems not to match Access 2003. What I want to do is a full outer join. Does Access 2003 support this? How is it done, if so?
October 30th, 2004 02:56 PM
by Michel Walsh Go to last post
1 259
Access 2003 Help!!! by Shirley
I have a table that consists of the following Start Date End Date Amount 1 12 50,000 1 3 ...
October 2nd, 2008 03:45 PM
by KARL DEWEY Go to last post
5 116
Access 2003 Holding Shared locks on tables until exit by Snake
I am a Sql Server DBA who does not know Access at all, but my users are complaining that when they run their Access application under Access 2003, shared locks...
October 5th, 2004 12:37 AM
by Snake Go to last post
0 365
Access 2003 INNER JOIN by KC_Cheer_Coach[_2_]
My Inner Join is not working correctly. I have changed it so many times to what should make sense, but my results now fluctuate from 18M records to 0...
July 7th, 2008 07:08 AM
by KC_Cheer_Coach[_2_] Go to last post
5 290
access 2003 join not returning expected records by dbnoodler
I have a table of records of lead contact info and another that has territory numbers assigned to zip codes. I have joined the tables at their zip code...
July 18th, 2008 07:51 PM
by dbnoodler Go to last post
5 180
Access 2003 keeps corrupting query definitions by Nick O
Trying to query on a subquery. Text works fine but when I return to it, the query designer tries replace the parentheses () with around the subquery and...
August 23rd, 2005 03:06 PM
by Nick O Go to last post
4 60
Access 2003 merge to Word 2003 - multiple questions by [email protected]
Hello, I've been searching the newsgroups for these answers for days but have run out of time. Any help would be appreciated. How can I merge a query based...
June 9th, 2006 04:26 AM
by [email protected] Go to last post
0 84
Access 2003 modifies (corrupts) query when saved... by Bpfh
Hi, I have a query built in the Access query builder and I have noticed some strange happenings. My query has 2 sets of criteria separated by an OR...
April 12th, 2007 06:07 PM
by Marshall Barton Go to last post
4 108
Access 2003 multiple if then statement help by JAV
Hello, I am having a problem constructing the proper clause for querying my database. I have multiple values used in computing daily averages of constituent...
July 27th, 2007 05:52 AM
by John W. Vinson Go to last post
1 50
Access 2003 not promting to save changes to queries by r0adh0g
I open a query in design view in Access and make some modifications. When I close the query, it does not prompt me to save the changes. It does save the...
August 27th, 2004 04:06 PM
by Ken Snell [MVP] Go to last post
1 143
Access 2003 on Terminal Server 2008 by KPR
Hi, I have 15 people Terminal Serving in to our office to enter data into an Access 2003 database, each with their own TS login account. What database...
February 20th, 2009 05:38 AM
by Tom van Stiphout[_2_] Go to last post
3 82
Access 2003 pivot table view problem by Terrell Miller
We are having a strange problem running queries that used to run just fine. We have VBA code that opens the queries from a form in pivot table view. The new...
December 12th, 2006 06:59 PM
by Terrell Miller Go to last post
0 172
access 2003 pivot view by SaveTheMonarchButterflies
I have an access 2003 query that looks at our general ledger data and crosstabs it into rows by account number, columns by month. Everything ties out perfectly...
(Multi-page thread 1 2)
August 22nd, 2005 02:38 PM
by SaveTheMonarchButterflies Go to last post
10 152
Access 2003 Problem by John H
Hi, I am new to access and am trying to create a simple database which does the following: Record Serial numbers against users and locations. Once the...
May 29th, 2007 11:43 AM
by John H Go to last post
4 100
Post New Thread


Display Options
Showing threads 821 to 840 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:08 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.