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 / Thread Starter Last Post Replies Views Reverse Sort Order
Combo Box Query Help by Scott_66701 via AccessMonster.com
I have a combo box with hospital names in it. I am wanting to select a hospital from the combo box and have the the address text box automatically fill in...
May 30th, 2010 08:33 PM
by Tom van Stiphout[_2_] Go to last post
1 989
using the results of a SQL SELECT(COUNT) statement in VBA by Paul James
I'd like to run a SQL statement which will return a single number, and assign this number to a variable. Here's the SQL statement: "SELECT COUNT(ReceiptID)...
September 24th, 2004 09:44 PM
by Paul James Go to last post
7 985
Hold it, we found SQL view.... by 1.156
Fred, we now can see the code -- don't know how we didn't run into it earlier. The SQL code looks understandable for the original simple query with no drop...
May 28th, 2004 03:20 PM
by 1.156 Go to last post
2 984
Need help with concatenation function by EllenM
Hello, I've found a wonderful concatenation function at http://www.mvps.org/access/modules/mdl0008.htm. It, however, separates the concatenated values with...
May 21st, 2010 08:34 PM
by EllenM Go to last post
4 979
Problem with a report by
Hello: I'm attempting to produce a report in Access. The report will have page breaks when the header info changes. The problem is that the pages will break...
June 16th, 2004 09:50 PM
by Duane Hookom Go to last post
3 976
Query based on multiple parameters - Access 2003 by Pam
I would like to create a query where the user can input 2 or more parameters (part numbers), separated by comma and/or space and return information about...
May 24th, 2010 07:21 PM
by Bob Barrows Go to last post
1 971
Adding info to query by mjj4golf
I have a table with a date field that the user left blank sometimes. Now I need to use it to find out how many monts between todays date and the date in the...
(Multi-page thread 1 2 3)
January 9th, 2006 03:29 AM
by mjj4golf Go to last post
20 971
Using a query with a replaceable parameter as the source of a control by Hoo
I'm stuck, trying to base the contents of a listbox upon a query with a variable parameter. The trouble lies in the fact that if I set the listbox control to...
May 30th, 2004 07:07 AM
by tina Go to last post
1 969
Change colour of a field by DontKnow
Hi Guys, Are you able to change the colour of a field dependant on the fields current value in datasheet view. When the output from a query is opened, I...
May 30th, 2010 09:47 AM
by DontKnow Go to last post
6 969
Can't see existing table in Design view for a QBE by DontKnow
Hi Guys, I can't see a table in QBE even when I have the scroll bar as far left as I possibly can. I have joineed another table to the query and I can see...
May 20th, 2010 12:03 AM
by DontKnow Go to last post
6 968
Text field causing trouble in query (continued) by KaiRich
Hi, This is a continuation of a post a few days ago. Apologies about the time lag, but the question is from a contract I am working on only 1 day per week,...
May 28th, 2004 01:03 PM
by Gary Walter Go to last post
2 965
Display record based on current date by John H
I would like to select records that are valid based on todays date. In this case the records startdate and enddate need to be between todays date. My table...
May 24th, 2004 11:07 AM
by Douglas J. Steele Go to last post
2 964
Action queries changing when reopened in design view by Kendra
Hello, I am rephrasing/simplifying a question I posted earlier so that somebody might know what's going wrong. I am using two action queries in a form. A...
August 31st, 2004 12:34 AM
by Ted Allen Go to last post
2 964
Cumulative Change by r. howell
I am trying to create a query that will give me a cumulative change in contract amounts for each change order that is issued. Each Contract can be identified...
August 23rd, 2004 01:41 PM
by r. howell Go to last post
3 964
Please help with access expression by joe_G
Hello, I was hoping someone could assist with the following expression in access that combines the Left function and Len function: I have column called ID,...
June 2nd, 2010 05:13 PM
by John W. Vinson Go to last post
2 963
Query on SQL Server is fast, while Access is crawling by Mike G[raser]
I have a query that executes a Table-Valued Function in SQL server. If I execute it withing Query Analyzer in SQL server, it completes in 40 seconds. If I...
May 19th, 2010 07:04 PM
by AG[_3_] Go to last post
2 962
Problem with Update Query Returning Message Re Single Row Update by Charles Allen
I've got a table I'm trying to update with data from another table. The table to be updated has multiple columns but I'm concerned with two: DEPT ...
December 6th, 2006 07:14 AM
by John Vinson Go to last post
1 955
Please help me fix this flawed query formula by circuit slave
Okay, first let me say, I didn't create this query, but I'm trying to fix it or write it better. Now here's the deal, and then I'll tell you the problem. We...
February 7th, 2006 04:44 AM
by circuit slave Go to last post
7 955
How to find text that is surrounded by a wild card, specificly an by Dan
I am looking for a way to query for the following: *T* The problem is the T is surrounded by an * which is a wild card. It pulls all the records with a T...
May 28th, 2010 04:14 PM
by Dan Go to last post
4 954
Query By Form by Craig
I have a query by form whereby the form has a Command Button to run a module which checks to see if the query has records. If the record count is 0 it opens...
June 1st, 2004 01:10 AM
by Craig Go to last post
2 952
Post New Thread


Display Options
Showing threads 181 to 200 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:44 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.