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 : Using Forms Forum Tools Search this Forum Feed Icon
  Thread Reverse Sort Order / Thread Starter Last Post Replies Views
#Div/0! Message Driving me mad!!! by SG
I have a text box on my form and I keep getting the above error I understand why I am getting this and that is not a problem, I just need to stop it from...
November 29th, 2006 02:38 PM
by SG Go to last post
5 165
#Error by Frank Dulk
I have that it formulates in a control in the form, because when doesn't have records appears #Error. =DSoma("";"";" is null")
June 17th, 2004 12:22 PM
by Al Borges Go to last post
3 102
#Error by Jahlu
I am trying to use a switch function on my form that reads as follows... =Switch(="1","Yes",="2","No") However, the results to this function always...
September 11th, 2007 06:20 PM
by Jahlu Go to last post
4 124
#Error by phuser
Main Form has a control box that gets a running total from the subform but if you navigate to a unit in the Main Form that contains no data the Subform, the...
April 17th, 2006 06:37 PM
by phuser Go to last post
3 106
#Error by Karina501
I have a mulituser database and when text is typed into a subform text box it is replaced by #Error as soon as you move from the box. It seems to save...
May 5th, 2005 10:16 PM
by jl5000 Go to last post
1 69
#Error - Bookmark Invalid by Thomas Kroljic
Over the last few months I've been receiving the #ERROR error in all my data entry fields within a subform along with a message box stating that the "Bookmark...
November 28th, 2005 05:26 AM
by Thomas Kroljic Go to last post
2 140
#error ???? by Dave Elliott
In a report I have this syntax which calculates the total Net Profit If the value IsNull (no Data) then it gives me the #error in the field How can I eliminate...
March 13th, 2005 06:52 AM
by Allen Browne Go to last post
2 106
#Error appears on subform residing on a tab control by John
I have two synchronized subforms on an unbound main form and everything worked great. As you move to each record on sub1, sub2 shows the corresponding...
March 10th, 2006 08:11 AM
by david epsom dot com dot au Go to last post
1 89
#Error error in Form 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 5th, 2008 02:03 PM
by Allen Browne Go to last post
1 119
#error for Sum on calculated subform detail row total by [email protected]
Hi, I have a subform with a number of rows with combo box lookups. Hidden fields of the combo box lookups are used to perform a row calculation, for...
April 19th, 2007 01:56 PM
by SusanV Go to last post
3 82
#Error if no value by Dave Elliott
The below code is my control source for an unbound textbox. if there is no value or o****, then I get the error; #Error How can I eliminate this...
August 4th, 2005 09:38 PM
by Krizhek Go to last post
4 106
#error in calculated textbox that references subform by Very Rusty User
Hi. In Access 2007 I have an unbound textbox (called txtTotal) on the main form that calculates a value. The ControlSource of txtTotal is an expression...
July 25th, 2008 07:20 AM
by Very Rusty User[_2_] Go to last post
2 86
#Error in field by SG
I have one field in one of the many entries in my table that has #Error. When I go into the field a popup comes up with "more than one person has tried to...
August 22nd, 2005 04:44 PM
by Allen Browne Go to last post
1 81
#Error In Sub-Form by Jeff G[_3_]
All - I have an interesting one... I'm running Access 2003 (SP2). I have a form that has a sub-form on it. Normally, everything works fine. Where I run...
October 7th, 2008 04:14 PM
by vbasean Go to last post
1 77
#error in subform field by PHisaw
I have a datasheet subform "MaintenanceSubform" based on the following query: SELECT Maintenance.MaintenanceID, Maintenance.AssetID, Maintenance.ComponentID,...
May 10th, 2007 08:46 PM
by PHisaw Go to last post
2 94
#error in textbox by seeker
I have a textbox in a subform which is bound to text(255) in a table. At times when the user opens the form #error is in the box and does not allow change...
May 7th, 2009 03:57 PM
by seeker Go to last post
0 77
#ERROR in textbox by Alan
I have this code in a text box = dsum("", "", " = " & & " AND Format(, ""yyyymm"") = '" & Format(, "yyyymm") & "'") i keep getting #error in my text...
(Multi-page thread 1 2 3)
March 26th, 2010 03:36 PM
by BruceM via AccessMonster.com Go to last post
28 277
#error in the calculated field by Frank Situmorang[_2_]
Hello, I locked the data entered for some users, because their role is just to input the date of invoice for approval by Prj.Manager. My qeustion is, is it...
January 16th, 2008 09:05 PM
by John W. Vinson Go to last post
1 92
#Error message by IowaHawkeye
My problem is this. I am trying to create a field that counts the number of "Yes" responses in a text field. I enter the following in the Control Source of a...
October 17th, 2009 04:59 PM
by Beetle Go to last post
2 189
#Error on calculated control in a form by Sarai
Hi there. I created a form to visualise a crosstab query with data referring to several categories along 12 months, and then did a sum for each month without...
April 16th, 2009 11:50 PM
by Sarai Go to last post
2 93
Post New Thread


Display Options
Showing threads 61 to 80 of 43162
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:30 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.