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
"Query is too complex" - limit to number of parameters in query? by Scott
I have a form with eight (8) text boxes whose values are passed to a query. The query ran fine a few times but now when I try to run it, I get a message box...
January 29th, 2005 02:29 PM
by Chris2 Go to last post
3 133
"Scaling of decimal value resulted in data truncation" by jeremy nickels
I got this message when I ran a select query. What does it mean? What do I do about it? I notice that some of my records have a #error.
July 7th, 2005 12:10 AM
by John Vinson Go to last post
1 130
"Screen Scrape" by PC Datasheet
Does anyone know how to do a "screen scrape" to get data off a website and enter it into an Access table? Thanks for all help? Steve PC Datasheet
(Multi-page thread 1 2 3 ... Last Page)
January 27th, 2005 12:15 PM
by Darryl Kerkeslager Go to last post
64 2,281
"Select Distinct ..." or something else? by Min
Hi: I have a table that has an auto number field as the key, and two columns (say col1 and col2) that will have duplicated rows and other columns that...
October 12th, 2004 05:39 AM
by Min Go to last post
2 174
"Square boxes" by Blaze
I have a query that seperates the fields by "square boxes". I am pretty sure that these are from an unknown character, but how can I find out what it is? Here...
(Multi-page thread 1 2)
September 3rd, 2005 05:08 AM
by Blaze Go to last post
14 288
"Stacking Queries" by T1 Red Alarm
Let's suppost that I have a table with the fields "Employee", "Date of 1st appt", and "Date of 2nd appt". I have a query that returns "Employee", and "Date of...
July 6th, 2005 06:15 AM
by tina Go to last post
4 172
"Top Values=X" where "X" is passed from form to the Query Property by Eric @ SEASH, Evansville
I have a query that I am using to randomly select employees from our employee database for drug screening, and would like to allow the manager to make...
May 19th, 2005 11:46 PM
by Van T. Dinh Go to last post
1 83
"Triggers" by web time
Does Access support "triggers"? In other words, I want Access to generate a "report" when a certain date in a certain field is reached. Or at least notify me...
June 3rd, 2005 03:32 PM
by Rick B Go to last post
1 83
"UNION" Query with different fields in the two tables by Dkline
I have two tables. The tables have different fields and number of fields. They each have one field in common "PolicyNumber". What we want to do is to have a...
July 30th, 2004 09:05 PM
by Dkline Go to last post
5 1,219
"Update To" in update query by Lambi000
If I have two tables in an update query, why can't I update one field with the corresponding field in another table? It just moves to the next available...
May 10th, 2005 08:10 PM
by Michel Walsh Go to last post
1 102
"validation rules violation" by Jeff25550
Why do I get an "validation rules violation" error when I have no rules set when trying to run an append query?
November 30th, 2004 03:00 AM
by John Spencer (MVP) Go to last post
2 234
"You canceled the previous operation." by Steven L via AccessMonster.com
I've got a form with some comboboxes, five checkboxs and a command button on it. The command button simply launches a query. I'm getting some very strange...
(Multi-page thread 1 2)
September 1st, 2005 01:26 PM
by Steven L via AccessMonster.com Go to last post
17 267
# character as text by Kevin
I want to create a query to search for all records where a particular field begins with the # character. My query criteria for this field is Like "#*" but...
April 19th, 2007 02:34 AM
by Kevin Go to last post
2 94
# character in queries by Hal Pratt
I need to edit mailing lists which contain # characters in their address fields (e.g., 123 Easy St #567). The problem is # is a wild character. How can I write...
August 19th, 2004 03:29 AM
by Ken Snell [MVP] Go to last post
1 122
# Deleted by SHIPP
I work for a Fortune 50 company. We upgraded to Access 2003 approximately 1 year ago. We are now upgrading our ODBC drivers. The new driver is Informix 3.82....
March 30th, 2007 07:22 PM
by SHIPP Go to last post
0 88
# Deleted in memo fields by JJ[_5_]
I have an Access 2000 DB which has been in continuous use for six years. It has a front/back configuration, I use a Linux box as a back end file server, the DB...
January 9th, 2008 06:25 AM
by Armen Stein Go to last post
1 92
# Error by needing help please
Hi there, I cannot find the post on converting # error to zero. In a query, my field is: % staff processed: (nz(,0))/(nz(,0)) if the client value is zero,...
October 17th, 2005 06:29 PM
by John Spencer Go to last post
2 106
# in select queries by Hal Pratt
I want to find address records with # in the street field (i.e., 123 Easy St #123). The problem is # is a wild character for numeric values. How can I write an...
August 19th, 2004 06:42 AM
by John Vinson Go to last post
1 119
# in table by instereo911 via AccessMonster.com
Hi, I have a table w/ multiple values on one column seperated out by a ";#" sign. Example: State Number ;#Central;#COVA;# ...
November 25th, 2009 10:32 PM
by John W. Vinson Go to last post
1 173
# of days between two dates by Jim[_49_]
Is there an expression that I can use in a query to determine the number of days between two dates?
August 21st, 2009 08:27 PM
by Krzysztof Naworyta Go to last post
4 135
Post New Thread


Display Options
Showing threads 41 to 60 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 03:28 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.