I must be missing something.....I have a check box whose data source is a field in a table. Problem is, the check box will not reflect the value of the field. Here is my code
=Case![Appeal Closed]
The only thing I can think of is the table containing the data is a LINKED table. Does that make a difference???
dryjeans
Last Activity: Jul 22 '09, 10:31 PM
Joined: Mar 20 '08
Location:
-
Check Box Will Not Update
-
Thanks for the offer, NeoPa, but I took your advice and abandoned the idea of using a crosstab query as the source of the report....All is well now. -
I get #ERROR on the report where the value is null....Is this normal??Leave a comment:
-
Let me clarify. I created a report that shows the age of unfilled orders. I have it grouped by region and age (in days) The data for the report comes from a crosstab query that groups by REGION and AGE IN DAYS. The grouping values for AGE IN DAYS are <=30, 31-90, and 90+. It is possible for one of the AGE IN DAYS values in the query results to be null or blank. When this occurs, there is no corresponding value in the query results to pass...Leave a comment:
-
Yes, one of the fields in the report is tied to its value is a crosstab query. If the value is the crosstab is null or empty, I get the error. Is there a way to suppress the field on the report if its corresponding value in the crosstab query is null????Leave a comment:
-
NeoPa,
The message reads:
The Microsoft Jet database engine does not recognize "my report field" as a valid field name or expression.
Presumably this is about a field which IS defined in the report but is simply missing (Null) in the data? YESLeave a comment:
-
Need Help With Report
I have a report that uses a crosstab query as its data source. The problem is not all of the crosstab values are present every time the report is generated. As a result, I get an error when the report is run. Access is looking for the value of the missing crosstab value. How do I supress the crosstab value from the report when the value is null???? -
THANKS, Mr Expert!!!!!!!!! !!!Leave a comment:
-
DateDiff - Do You See The Problem??
Access chokes on this.....Anyone see the problem??
Code:AgeInDays: DateDiff("d"[now()],[date recvd]) -
You say something???...Leave a comment:
-
[code=vb]' Name: mod_display_men u
' Function : display the switchboard after checking the access and password and password expiry date
' Date: 23/09/2007
Option Compare Database
Option Explicit
Public RptFlag As Integer
Public adminflag As Integer
Public operator As String
Public rptnumber As Integer
Sub display_menu()
On Error...Last edited by Stewart Ross; Apr 15 '08, 08:22 AM. Reason: Please use Code Tags on code segments - helps make your post more readable.Leave a comment:
-
The app works FINE for everyone else. But, she is the only one who has to map a drive. The others have the application on their server.
Are you using the runtime or the full Access?? Not sure what you mean by that. By my guess is full Access...Leave a comment:
-
Object doesn't support this property or method
Hello Access Experts....
One of my staff members gets this message when she tries to log into a database I created. The DB is housed on a server that she maps to (mapped network drive). Also, I split the DB. Is that the reason for the error?? Any ideas? -
Thanks, Stewart. I think this is EXACTLY what I needed!!...Leave a comment:
-
Stewart,
I added one additional criteria...a UNIT ......So in my final table I have band, band name, number of orders, and unit...obviousl y, unit name (i.e. Unit 3) will appear multiple times in the table. In the report, how would I reference Unit 3's number of orders that are <=30, the number that are 31-59, etc, etc???...Leave a comment:
-
Stewart,
I think I got it....One last question...On the report, how would I reference the count of the number of orders in the <=30 bucket??...Leave a comment:
-
Stewart,
Thanks for helping me to get the ball rolling...I'll study this example and try to encorporate your suggestion....Leave a comment:
-
Report Howto Needed
I'm desiging a report to show the age of orders. Part of the report is shown below:
Age of Order
<30 | 31-59 | 60-89|
Unit 3
------------------------------------------------------------------------------------
Unit 4
I need a hand in devising a method to... -
Query Not Updating....asking for a parameter value
Hi,
I'm trying to use the results of a query to set the value of a yes/no field...Here is the code I have, but it still asks for a parameter value...If I type in a correct value, it will update the yes/no box...but why is it not autmatically updating???
"UPDATE [order] SET [order].[oversea order] = True WHERE [order].[order ID] = [Find duplicates for order].[order ID Field]"
orderID = Text... -
OK...I'm going in a different direction....I would like to use the results of a query to set the value of a yes/no field...Here is the code I have, but it still asks for a parameter value...If I type in a correct value, it will update the yes/no box...but why is it not autmatically updating???
Code:strSQL10 = "UPDATE [order] SET [order].[oversea order] = True WHERE [order].[order ID] = [Find duplicates for order].[order ID Field]"
Leave a comment:
No activity results to display
Leave a comment: