The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.
One of a set of tools we're offering as a way of saying thank you for being a part of the community.
Solved
Add total of precentages complete
Posted on 2012-12-26
I have a unbound field called precentages. Which I got help from a expertm named flyster. (Thank you). Cant seem to find where he put the code.
I look in the properties of the unbound field.
I looked in the form maybe on current.
I clicked on view code. and it didnt showed up.
what i am trying to do is total up the percentage done for each unit based on check marks. each check mark is worth a certain percentage i need to change that. But I cant seem to find the code.
I look in the properties of the unbound field.
I looked in the form maybe on current.
I clicked on view code. and it didnt showed up.
what i am trying to do is total up the percentage done for each unit based on check marks. each check mark is worth a certain percentage i need to change that. But I cant seem to find the code.
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
4 Comments
here is the database with th unbound field percentages..the record source does not have a where clause
bingo3.accdb
bingo3.accdb
Active today
The code is the query used as the record source for the form. And Percentages is one field of the query.
the last portion of the query:
...
[OutDuction])/17),"00.0%")
The query refers to 17 but you have 18 check boxes.
Open form in design mode. From objects drop down list select form. Then Select Data Tab.
The query is set as the Record Source property.
the last portion of the query:
...
[OutDuction])/17),"00.0%")
The query refers to 17 but you have 18 check boxes.
Open form in design mode. From objects drop down list select form. Then Select Data Tab.
The query is set as the Record Source property.
<I have a unbound field called precentages. >
The Percentages field in the form is bound...
It is bound to a field called "percentages"
Percentages is a field in the form's recordsource/query, ...so there is no "Code":
Percentages: Format(Abs(([tblTempleFuel
Whenever you get a solution from an expert, please ask any questions at that time, if you are confused about something.
;-)
JeffCoachman
The Percentages field in the form is bound...
It is bound to a field called "percentages"
Percentages is a field in the form's recordsource/query, ...so there is no "Code":
Percentages: Format(Abs(([tblTempleFuel
Whenever you get a solution from an expert, please ask any questions at that time, if you are confused about something.
;-)
JeffCoachman
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
The Windows Phone Theme Colours is a tight, powerful, and well balanced palette.
This tiny Access application makes it a snap to select and pick a value. And it doubles as an intro to implementing WithEvents, one of Access' hidden gems.
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship.
Add the tables:
Create the relationship:
Decide if you’re going to set referential integrity:
Decide if you want cascade upda…
Suggested Courses
Course of the Month8 days, left to enroll
715 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.