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 : General Discussion Forum Tools Search this Forum Feed Icon
  Thread Reverse Sort Order / Thread Starter Last Post Replies Views
#Error by Danie
I am getting this error #Error in one of my text boxes in a form. This is what I have in the source : =Nz(.!). It seems that I have a null in my subform...
October 6th, 2009 02:02 PM
by Danie Go to last post
2 132
#error by Sarah at DaVita
I have the formula Left(Mid(,InStr(,".1"),25),4) in a query some rows return what I want and some return #error. How do I get it to return a null if it is...
June 11th, 2009 10:35 PM
by Sarah at DaVita Go to last post
2 122
#error by srctr
I have a letter I am creating. I have something wrong and cannot figure it out. This gives me an #error =CanShrinkLines(Trim((StrConv(+,3)) & " " &...
(Multi-page thread 1 2)
January 22nd, 2009 08:34 PM
by Clifford Bass[_2_] Go to last post
14 298
#Error by Radhika
I am trying to caculate the difference in Dates between VP Insertion Date and VP Removal Date. There are some VP Removal Dates that are null. When I...
November 13th, 2008 05:20 PM
by John Spencer Go to last post
2 62
#Error by SF[_3_]
Hi I have a query contain 3 fields (Commune Code, FY07 and FY08) that provide data to my form. I want to display % between FY07 and FY08 by creating another...
October 5th, 2008 04:00 AM
by tina Go to last post
2 65
#Error by Brian
I have a query that is using a left join. About 5% of the records are #Error, which I expected. When I pull this query into another query, I am trying to...
May 15th, 2008 05:24 PM
by Brian Go to last post
5 89
#Error error corrupts records in a table by Suyash
Hi, I have a database in MS Access 97 which has a form consisting mainly of "Memo" fields. It is accessed by a number of people. Every now and then, if the...
February 7th, 2008 12:02 PM
by Larry Daugherty Go to last post
3 88
#Error from dlookup by Robert[_6_]
I have a dLookup in a report which returns a field value from a table. This works fine as long as there's a value in the field. But when a record has a...
October 5th, 2008 09:28 PM
by Robert[_6_] Go to last post
2 76
#ERROR in Access Table by Brad
While entering data from a form in our database somehow one of the table entries now has #ERROR in all of the fields. There doesn't appear to be any way to...
August 27th, 2005 02:47 PM
by Allen Browne Go to last post
1 58
#Error in all the fields in Access 2003 database by Venu Muddasani
Why this error is coming and how to trouble shoot? When this error record in table unable to serach and if you search you will get syntax error. Some times...
January 27th, 2009 07:12 PM
by hor vannara Go to last post
2 63
#Error in calculated field by redrover
I'm trying to put a calculated field in a report but I get a #Error message. If I display the fields I get a blank and a value. The 'Vacation Days Used'...
August 30th, 2007 05:34 PM
by redrover Go to last post
6 113
#Error in calculated field by TB
The following expression is what I am using to add scores from two different forms. It works if both fields have values in them, but if one field does not...
March 15th, 2006 06:20 PM
by TB Go to last post
3 58
#Error in calculated field by TB
I posted this question earlier, but still have not found a solution to my problem. The following expression is what I am using to add scores from...
March 16th, 2006 04:52 PM
by Douglas J Steele Go to last post
1 63
#error in calculated query field by Kate
I can't figure this one out: I have a text field that contains either: 1. a double 2. a string beginning with a comparison operator followed by a double 3....
May 3rd, 2007 05:27 PM
by Kate Go to last post
2 59
#ERROR in field on new record by Daniel Lees
Hi I have a peice of code that generates a number and from that and another field the month and yr is calculated. This works fine but the problem is that on...
November 1st, 2006 07:44 PM
by Jerry Whittle Go to last post
1 52
#Error in group footer by Duane
I have a text box in the group footer that does a count. =(Count() & " " & "Total key(s) added for" & " " & ) The problem I am having is that I get an #error...
May 3rd, 2007 12:36 AM
by Duane Go to last post
2 49
#error in my IIF statement (currency issue) by robert
I've had too much to drink tonight and my wife doesnt want to have sex with me :( but it's broken my concentration and I cant get my IIF statement to work. ...
July 15th, 2006 08:53 AM
by Go to last post
1 56
#Error in Query by J. Trucking
Hello, I have a query with calculates production for a machine in terms of tonnes/hr. A use will input the starting engine hours, starting tonnes, ending...
May 26th, 2007 05:30 AM
by J. Trucking Go to last post
2 62
#Error in query results using Public Function by sbowman
I have a very complex query with about 50 fields - 10 fields are results of different public functions. One in particular is giving me trouble by returning a...
November 8th, 2006 07:37 PM
by Brendan Reynolds Go to last post
2 42
#Error in report footer by JP[_12_]
I get a #Error value in the report footer when the query recordset is empty. The formula is =Sum(). How can I suppress the error?
May 13th, 2009 01:14 PM
by D.L Go to last post
3 84
Post New Thread


Display Options
Showing threads 281 to 300 of 92186
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 06:12 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.