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
#Error on form by CS
I have a calculated field on a form that requires input from another field to perform the calculation. If the input is blank, the calculated field shows...
June 7th, 2004 05:12 PM
by CS Go to last post
3 221
#Error on form by David
I have hit a wall in my thinking – just can not figure out why I am getting an #Error on my subtotal box. I have an Invoice form. Recent tax changes...
January 19th, 2006 04:30 PM
by David Go to last post
2 160
#Error on Subform by phuser
Main Form contains Unit Information and Totals in text boxes brought down from the Subform. The subform filters by UnitID and I am trying to calculate total...
August 14th, 2006 11:32 PM
by phuser Go to last post
1 151
#Error on Sum by benj
Good day! am getting #Error on my unbound field with a control source: =Sum(IIf(FL_billing_ext.Form!Paid=Yes,FL_billing_ext.Form!SubTotal,0)). The form...
September 14th, 2007 02:58 AM
by bhipwell via AccessMonster.com Go to last post
1 172
#Error on Sum Formula from Subform by JavyD
Hello, I have this formula on the subform =IIf(=True,Nz(),0). Now, on the main form, I want to sum the result of this condition. I keep getting a #Error,...
April 26th, 2006 11:27 PM
by JavyD Go to last post
6 134
#Error on when ther is no data for Calculation by robboll
I have an Access 2003 form where the on some records the calculation works fine when all elements of the calculation have values. When there are no values in...
August 1st, 2005 01:58 PM
by Klatuu Go to last post
2 166
#error propogation by JimS
On a subform, I have a textbox that sums a column. I don't display it, just reference it. When the subform recordset is empty, it propogates "#error" to all...
April 24th, 2008 10:49 PM
by Jeanette Cunningham Go to last post
3 316
#error sintax when trying to add sum+iif by thread
hi all, i'm trying to make a sum calculation in the form and im getting error,the starting sintax is as follow: =sum(IIF(...,1,0)) what should be the problem?
June 30th, 2006 06:43 AM
by strive4peace Go to last post
3 147
#Error Textbox by Alan
=DSum("","Billings Analysis"," = '" & & "' AND = '" & & "'") Right i used this code in the source code of my textbox and the textbox keeps flashing, i...
March 26th, 2010 02:53 PM
by Daryl S[_2_] Go to last post
3 141
#Error when summing in Form by iamnu
I add a NEW control to the Footer of a Subform with a Control Source as follows: =(). This will give me a value from a record of the Detail section of the...
January 22nd, 2010 12:06 AM
by Linq Adams via AccessMonster.com Go to last post
2 146
#Error with the IIF function by fcmedina78
I am creating a form that provides criteria to a query for a report. I have one combo box for the user to select a year, another text box that adds one for...
June 16th, 2008 01:17 AM
by fcmedina78 Go to last post
3 172
#Name error by julief
I am trying to put a total from a sub form onto another form but keep getting the #name error message, any pointers would be most welcolm. I have a form...
August 8th, 2008 04:54 PM
by Jeff Boyce Go to last post
6 359
#Name in fields by Design by Sue
I have two Access files given to me by a client. In the "Old" version all fields work correctly, but in the "New" version, some of the fields have the dredded...
(Multi-page thread 1 2)
August 18th, 2004 02:43 PM
by Design by Sue Go to last post
15 314
#Name in subform controls ---- KRISH by KRISH
Hi! I would like to set new recordsource to my subform on changing a combobox in the main form. My code is as below: If Me.txtLett = "Interview" Or Me.txtLett...
April 27th, 2006 04:12 AM
by Duane Hookom Go to last post
3 98
#NAME Issue with Cross Tab sub form by mattc66 via AccessMonster.com
Hi All, I have a form with a sub form that is based on a cross tab query. This is a month order report for all models. Depending on the time of the month...
February 11th, 2007 12:16 PM
by strive4peace Go to last post
2 154
#name ocurring on clients PC but not the development PCs by stevehaley
I am suddenly getting problems with an application generating #Name? errors in some forms on the clients desktop but not on any of my development PCs. The...
October 14th, 2008 10:23 PM
by Douglas J. Steele[_3_] Go to last post
3 106
#name? by marzij
when i set the control source of a text box with a mid function , experssion #name? is show in form view
August 9th, 2004 09:46 AM
by Allen Browne Go to last post
1 152
#Name? by margaret
I have a qryCash and a frmCash. I would like the default for the control "cashdate" to use information from a table ... tblControlfile (Be aware that this...
September 11th, 2008 09:50 PM
by Dennis Go to last post
2 90
#Name? by Volta
I have a typical order entry form which has underlying tables: Order, OrderDetail and Product. I want the form to display the default price from the Product...
October 10th, 2004 05:21 AM
by Volta Go to last post
1 134
#Name? by Sham_on_air
hi i just modified an existing access database which i downloaded from the internet and everything works fine except one FORM: i have a form which has a...
January 31st, 2007 08:56 AM
by strive4peace Go to last post
1 92
Post New Thread


Display Options
Showing threads 81 to 100 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 11:14 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.