Display Count of records from subform on Main form

I need to show a count of records for doc on main form.  Doc info is on main 
form and list of pts is on subform.  I have entered an unbound text box on 
the main form and have tried DCount, ABSSum and Count all I get is 0.  This 
is what I have entered:  =DCount([ID]) or ABS(Sum([myfrom].[ID]) and 
=Count([ID]).  Thank you in advance for any help you can provide.  Thank you.
0
Utf
1/10/2008 8:01:02 AM
access.forms 6864 articles. 2 followers. Follow

7 Replies
1751 Views

Similar Articles

[PageSpeed] 24

Try it this way:

Create a query with the needed table. Add the id-field to the grid. Total it 
by Count. Save the query and on the form you place an unbound field.

In VBA you can do a Dlookup for the one field in the query like

Dlookup("id","name of your query")
This will display the amount of records.

hth
-- 
Maurice Ausum


"TotallyConfused" wrote:

> I need to show a count of records for doc on main form.  Doc info is on main 
> form and list of pts is on subform.  I have entered an unbound text box on 
> the main form and have tried DCount, ABSSum and Count all I get is 0.  This 
> is what I have entered:  =DCount([ID]) or ABS(Sum([myfrom].[ID]) and 
> =Count([ID]).  Thank you in advance for any help you can provide.  Thank you.
0
Utf
1/10/2008 8:27:02 AM
DLookup will not return a number of records.  As written, it will return the 
first value it finds in the ID field in the query.
The correct method would be

=DCount("*", "Query Name","[ID] = " & Me.txtID)
-- 
Dave Hargis, Microsoft Access MVP


"Maurice" wrote:

> Try it this way:
> 
> Create a query with the needed table. Add the id-field to the grid. Total it 
> by Count. Save the query and on the form you place an unbound field.
> 
> In VBA you can do a Dlookup for the one field in the query like
> 
> Dlookup("id","name of your query")
> This will display the amount of records.
> 
> hth
> -- 
> Maurice Ausum
> 
> 
> "TotallyConfused" wrote:
> 
> > I need to show a count of records for doc on main form.  Doc info is on main 
> > form and list of pts is on subform.  I have entered an unbound text box on 
> > the main form and have tried DCount, ABSSum and Count all I get is 0.  This 
> > is what I have entered:  =DCount([ID]) or ABS(Sum([myfrom].[ID]) and 
> > =Count([ID]).  Thank you in advance for any help you can provide.  Thank you.
0
Utf
1/10/2008 2:47:02 PM
I know what you mean but if you create a query as stated you would only get 
one field with a total count in it. Then when you use a dlookup you would 
only get one value returned being the total count of the records as created 
by the query...
-- 
Maurice Ausum


"Klatuu" wrote:

> DLookup will not return a number of records.  As written, it will return the 
> first value it finds in the ID field in the query.
> The correct method would be
> 
> =DCount("*", "Query Name","[ID] = " & Me.txtID)
> -- 
> Dave Hargis, Microsoft Access MVP
> 
> 
> "Maurice" wrote:
> 
> > Try it this way:
> > 
> > Create a query with the needed table. Add the id-field to the grid. Total it 
> > by Count. Save the query and on the form you place an unbound field.
> > 
> > In VBA you can do a Dlookup for the one field in the query like
> > 
> > Dlookup("id","name of your query")
> > This will display the amount of records.
> > 
> > hth
> > -- 
> > Maurice Ausum
> > 
> > 
> > "TotallyConfused" wrote:
> > 
> > > I need to show a count of records for doc on main form.  Doc info is on main 
> > > form and list of pts is on subform.  I have entered an unbound text box on 
> > > the main form and have tried DCount, ABSSum and Count all I get is 0.  This 
> > > is what I have entered:  =DCount([ID]) or ABS(Sum([myfrom].[ID]) and 
> > > =Count([ID]).  Thank you in advance for any help you can provide.  Thank you.
0
Utf
1/10/2008 3:04:04 PM
That is not correct.  DLook does not return a number of records, it returns 
one value from the field specified.

First sentence of DLookup in VBA Help:

You can use the DLookup function to get the value of a particular field from 
a specified set of records (a domain). 

And further on:
If more than one field meets criteria, the DLookup function returns the 
first occurrence. You should specify criteria that will ensure that the field 
value returned by the DLookup function is unique. You may want to use a 
primary key value for your criteria, such as [EmployeeID] in the following 
example, to ensure that the DLookup function returns a unique value

So how do you get a count from DLookup?
-- 
Dave Hargis, Microsoft Access MVP


"Maurice" wrote:

> I know what you mean but if you create a query as stated you would only get 
> one field with a total count in it. Then when you use a dlookup you would 
> only get one value returned being the total count of the records as created 
> by the query...
> -- 
> Maurice Ausum
> 
> 
> "Klatuu" wrote:
> 
> > DLookup will not return a number of records.  As written, it will return the 
> > first value it finds in the ID field in the query.
> > The correct method would be
> > 
> > =DCount("*", "Query Name","[ID] = " & Me.txtID)
> > -- 
> > Dave Hargis, Microsoft Access MVP
> > 
> > 
> > "Maurice" wrote:
> > 
> > > Try it this way:
> > > 
> > > Create a query with the needed table. Add the id-field to the grid. Total it 
> > > by Count. Save the query and on the form you place an unbound field.
> > > 
> > > In VBA you can do a Dlookup for the one field in the query like
> > > 
> > > Dlookup("id","name of your query")
> > > This will display the amount of records.
> > > 
> > > hth
> > > -- 
> > > Maurice Ausum
> > > 
> > > 
> > > "TotallyConfused" wrote:
> > > 
> > > > I need to show a count of records for doc on main form.  Doc info is on main 
> > > > form and list of pts is on subform.  I have entered an unbound text box on 
> > > > the main form and have tried DCount, ABSSum and Count all I get is 0.  This 
> > > > is what I have entered:  =DCount([ID]) or ABS(Sum([myfrom].[ID]) and 
> > > > =Count([ID]).  Thank you in advance for any help you can provide.  Thank you.
0
Utf
1/10/2008 3:13:00 PM
Ok, let me try to explain what I meant.

You can create a query from let's say table1 which contains 10 records with 
several fields.
When you drop the first field on the grid and then use a group by Count you 
would get one result in the query from just one field.

You can now perform a dlookup as follows:

dlookup ("field";"created query")

this will return the only field you have designated in your query. The field 
contains the total count of records thereby giving you a number (actually a 
fieldvalue).

Does that make sense?
-- 
Maurice Ausum


"Klatuu" wrote:

> That is not correct.  DLook does not return a number of records, it returns 
> one value from the field specified.
> 
> First sentence of DLookup in VBA Help:
> 
> You can use the DLookup function to get the value of a particular field from 
> a specified set of records (a domain). 
> 
> And further on:
> If more than one field meets criteria, the DLookup function returns the 
> first occurrence. You should specify criteria that will ensure that the field 
> value returned by the DLookup function is unique. You may want to use a 
> primary key value for your criteria, such as [EmployeeID] in the following 
> example, to ensure that the DLookup function returns a unique value
> 
> So how do you get a count from DLookup?
> -- 
> Dave Hargis, Microsoft Access MVP
> 
> 
> "Maurice" wrote:
> 
> > I know what you mean but if you create a query as stated you would only get 
> > one field with a total count in it. Then when you use a dlookup you would 
> > only get one value returned being the total count of the records as created 
> > by the query...
> > -- 
> > Maurice Ausum
> > 
> > 
> > "Klatuu" wrote:
> > 
> > > DLookup will not return a number of records.  As written, it will return the 
> > > first value it finds in the ID field in the query.
> > > The correct method would be
> > > 
> > > =DCount("*", "Query Name","[ID] = " & Me.txtID)
> > > -- 
> > > Dave Hargis, Microsoft Access MVP
> > > 
> > > 
> > > "Maurice" wrote:
> > > 
> > > > Try it this way:
> > > > 
> > > > Create a query with the needed table. Add the id-field to the grid. Total it 
> > > > by Count. Save the query and on the form you place an unbound field.
> > > > 
> > > > In VBA you can do a Dlookup for the one field in the query like
> > > > 
> > > > Dlookup("id","name of your query")
> > > > This will display the amount of records.
> > > > 
> > > > hth
> > > > -- 
> > > > Maurice Ausum
> > > > 
> > > > 
> > > > "TotallyConfused" wrote:
> > > > 
> > > > > I need to show a count of records for doc on main form.  Doc info is on main 
> > > > > form and list of pts is on subform.  I have entered an unbound text box on 
> > > > > the main form and have tried DCount, ABSSum and Count all I get is 0.  This 
> > > > > is what I have entered:  =DCount([ID]) or ABS(Sum([myfrom].[ID]) and 
> > > > > =Count([ID]).  Thank you in advance for any help you can provide.  Thank you.
0
Utf
1/10/2008 3:34:03 PM
I understand what you are saying, now, but does it make sense?

I don't think so.  It would add additional overhead.  The DCount, IMHO, is a 
better solution.
-- 
Dave Hargis, Microsoft Access MVP


"Maurice" wrote:

> Ok, let me try to explain what I meant.
> 
> You can create a query from let's say table1 which contains 10 records with 
> several fields.
> When you drop the first field on the grid and then use a group by Count you 
> would get one result in the query from just one field.
> 
> You can now perform a dlookup as follows:
> 
> dlookup ("field";"created query")
> 
> this will return the only field you have designated in your query. The field 
> contains the total count of records thereby giving you a number (actually a 
> fieldvalue).
> 
> Does that make sense?
> -- 
> Maurice Ausum
> 
> 
> "Klatuu" wrote:
> 
> > That is not correct.  DLook does not return a number of records, it returns 
> > one value from the field specified.
> > 
> > First sentence of DLookup in VBA Help:
> > 
> > You can use the DLookup function to get the value of a particular field from 
> > a specified set of records (a domain). 
> > 
> > And further on:
> > If more than one field meets criteria, the DLookup function returns the 
> > first occurrence. You should specify criteria that will ensure that the field 
> > value returned by the DLookup function is unique. You may want to use a 
> > primary key value for your criteria, such as [EmployeeID] in the following 
> > example, to ensure that the DLookup function returns a unique value
> > 
> > So how do you get a count from DLookup?
> > -- 
> > Dave Hargis, Microsoft Access MVP
> > 
> > 
> > "Maurice" wrote:
> > 
> > > I know what you mean but if you create a query as stated you would only get 
> > > one field with a total count in it. Then when you use a dlookup you would 
> > > only get one value returned being the total count of the records as created 
> > > by the query...
> > > -- 
> > > Maurice Ausum
> > > 
> > > 
> > > "Klatuu" wrote:
> > > 
> > > > DLookup will not return a number of records.  As written, it will return the 
> > > > first value it finds in the ID field in the query.
> > > > The correct method would be
> > > > 
> > > > =DCount("*", "Query Name","[ID] = " & Me.txtID)
> > > > -- 
> > > > Dave Hargis, Microsoft Access MVP
> > > > 
> > > > 
> > > > "Maurice" wrote:
> > > > 
> > > > > Try it this way:
> > > > > 
> > > > > Create a query with the needed table. Add the id-field to the grid. Total it 
> > > > > by Count. Save the query and on the form you place an unbound field.
> > > > > 
> > > > > In VBA you can do a Dlookup for the one field in the query like
> > > > > 
> > > > > Dlookup("id","name of your query")
> > > > > This will display the amount of records.
> > > > > 
> > > > > hth
> > > > > -- 
> > > > > Maurice Ausum
> > > > > 
> > > > > 
> > > > > "TotallyConfused" wrote:
> > > > > 
> > > > > > I need to show a count of records for doc on main form.  Doc info is on main 
> > > > > > form and list of pts is on subform.  I have entered an unbound text box on 
> > > > > > the main form and have tried DCount, ABSSum and Count all I get is 0.  This 
> > > > > > is what I have entered:  =DCount([ID]) or ABS(Sum([myfrom].[ID]) and 
> > > > > > =Count([ID]).  Thank you in advance for any help you can provide.  Thank you.
0
Utf
1/10/2008 3:57:01 PM
Ok, fair enough I think the additional overhead would consist of one query. 
However the dcount as it was originally meant for does the trick also..
-- 
Maurice Ausum


"Klatuu" wrote:

> I understand what you are saying, now, but does it make sense?
> 
> I don't think so.  It would add additional overhead.  The DCount, IMHO, is a 
> better solution.
> -- 
> Dave Hargis, Microsoft Access MVP
> 
> 
> "Maurice" wrote:
> 
> > Ok, let me try to explain what I meant.
> > 
> > You can create a query from let's say table1 which contains 10 records with 
> > several fields.
> > When you drop the first field on the grid and then use a group by Count you 
> > would get one result in the query from just one field.
> > 
> > You can now perform a dlookup as follows:
> > 
> > dlookup ("field";"created query")
> > 
> > this will return the only field you have designated in your query. The field 
> > contains the total count of records thereby giving you a number (actually a 
> > fieldvalue).
> > 
> > Does that make sense?
> > -- 
> > Maurice Ausum
> > 
> > 
> > "Klatuu" wrote:
> > 
> > > That is not correct.  DLook does not return a number of records, it returns 
> > > one value from the field specified.
> > > 
> > > First sentence of DLookup in VBA Help:
> > > 
> > > You can use the DLookup function to get the value of a particular field from 
> > > a specified set of records (a domain). 
> > > 
> > > And further on:
> > > If more than one field meets criteria, the DLookup function returns the 
> > > first occurrence. You should specify criteria that will ensure that the field 
> > > value returned by the DLookup function is unique. You may want to use a 
> > > primary key value for your criteria, such as [EmployeeID] in the following 
> > > example, to ensure that the DLookup function returns a unique value
> > > 
> > > So how do you get a count from DLookup?
> > > -- 
> > > Dave Hargis, Microsoft Access MVP
> > > 
> > > 
> > > "Maurice" wrote:
> > > 
> > > > I know what you mean but if you create a query as stated you would only get 
> > > > one field with a total count in it. Then when you use a dlookup you would 
> > > > only get one value returned being the total count of the records as created 
> > > > by the query...
> > > > -- 
> > > > Maurice Ausum
> > > > 
> > > > 
> > > > "Klatuu" wrote:
> > > > 
> > > > > DLookup will not return a number of records.  As written, it will return the 
> > > > > first value it finds in the ID field in the query.
> > > > > The correct method would be
> > > > > 
> > > > > =DCount("*", "Query Name","[ID] = " & Me.txtID)
> > > > > -- 
> > > > > Dave Hargis, Microsoft Access MVP
> > > > > 
> > > > > 
> > > > > "Maurice" wrote:
> > > > > 
> > > > > > Try it this way:
> > > > > > 
> > > > > > Create a query with the needed table. Add the id-field to the grid. Total it 
> > > > > > by Count. Save the query and on the form you place an unbound field.
> > > > > > 
> > > > > > In VBA you can do a Dlookup for the one field in the query like
> > > > > > 
> > > > > > Dlookup("id","name of your query")
> > > > > > This will display the amount of records.
> > > > > > 
> > > > > > hth
> > > > > > -- 
> > > > > > Maurice Ausum
> > > > > > 
> > > > > > 
> > > > > > "TotallyConfused" wrote:
> > > > > > 
> > > > > > > I need to show a count of records for doc on main form.  Doc info is on main 
> > > > > > > form and list of pts is on subform.  I have entered an unbound text box on 
> > > > > > > the main form and have tried DCount, ABSSum and Count all I get is 0.  This 
> > > > > > > is what I have entered:  =DCount([ID]) or ABS(Sum([myfrom].[ID]) and 
> > > > > > > =Count([ID]).  Thank you in advance for any help you can provide.  Thank you.
0
Utf
1/10/2008 4:12:08 PM
Reply:

Similar Artilces:

saving a copy of deleted records
I am writing a vb6 interface for an access database. I want to be able to delete records so they no longer register on the database but at the same time it would be good if all the deleted data was stored away somewhere - rather like the recycle bin in Windows. I would welcome suggestion on the best way to do this. Is there any standard way to do it? There are a number of related tables with 'Cascade Delete Related Records' set. Thanks Nod The easiest thing to do would be simply to add a checkbox to the table so that if you don't want people to see certain records tick it. D...

Sub Form
Hi, I need to have a subfrom from my main form which appears when the user presses a button. I have tried to add a subform using the subform button in the access toolbox - but this adds the subform within the main form, which I do not require. It makes the form look too busy. I have tried to add a subform using the form function button. This launches my child form, but the data does not connect to my parent form connecting this way. Any thoughts, please? Simplest solution is to put a tab control in your form. Put the existing controls in the first page of the tab control, and the...

Change rows to columns for similar records
Hi - am trying to change rows to columns for similar records. How do I do that? e.g. Staff A Cellular No. XXXXX Staff A Office No. XXXX Staff B Cellular No. XXXXX Staff B Office No. XXXXX Wld like for it be in the following row Staff Cellular No Office No A XXXXX XXXXX B XXXXX XXXXXX Do advise. Thanks. one way would be Would be to set up your "heading" as such Cell Phone Staff A 1 2 Staff B 3 4 Then assuming that Staff A is in B8 Staff B is in B9 Cell is in C7 Phone is in D7 In cell c8 enter ...

Counting the number of letters in a cell
Can Excel count the numbers of letters in a cell that has mixed letters and numbers? Can you restrict =LEN to only letters (or only numbers)? IE - ABC123 # of letters = 3 Thanks, Adam -- beefycj5 ------------------------------------------------------------------------ beefycj5's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=16353 View this thread: http://www.excelforum.com/showthread.php?threadid=375769 Are they always in the same format Adam? ie 3 letters, 3 numbers. I they are try a combination of the LEFT and LEN functions. ie *=LEN(LEFT(A1))* etc...

images on a form
Alright I have a db that is pretty basic. It has a First and Last Name field a Title Field and seven YES/NO fields. What I want is that when I run a query on a specific employee name it will pop up a form displaying a photo of the employee and another image or something displaying (basically pass or fail) whether they have completed all test requirements. Meaning that all of the seven YES/NO fields are checked yes. Again, if all of the seven YES/NO fields are check they pass and if not they fail and I would like something to display to say that. I have already figured out how to ...

Calculate sequential number in a protected form.
I have a protected form that users will fill in fields and then save it under a new name. This form replaces a 7 part carbon form that is sequentially numbered. I am looking for information on how to have the form open with the next number each time it is accessed. Any help would be greatly appreciated. See http://www.word.mvps.org/FAQs/MacrosVBA/NumberDocs.htm. -- Regards, Jay Freedman Microsoft Word MVP FAQ: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. gtc@idl wrote: > I have a protected ...

Newbie
I want to display the result of a query: SELECT EmployeeNumber, FirstName, LastName, DOB, Address FROM Employee What control I should put onto the detail band of the report? Use text boxes to display field values. Set your report's record source property to your query. -- Duane Hookom MS Access MVP "Alan T" <alanpltseNOSPAM@yahoo.com.au> wrote in message news:uatk$cCqHHA.4152@TK2MSFTNGP04.phx.gbl... >I want to display the result of a query: > SELECT EmployeeNumber, FirstName, LastName, DOB, Address FROM Employee > > What control I should put onto the ...

HTML mails with input boxes/form
I have an Internet application that sends HTML mails. These mails consist of input boxes: A receiver basically gets a webpage with a HTML form. However when I receive such a mail in Outlook 2000, type something in the input boxes and then try to forward the mail all input boxes are empty! As far as I can tell they are even no input boxes anymore but are converted to images: They look like input boxes but you can't enter anything anymore. Why isn't it possible to enter something in a HTML mail and then forward the mail? Is this a restriction of Outlook 2000? Or is there any option to ch...

Sales for Outlook Errors when creating new records
We have just installed MS CRM 1.2, and all seems well in the web client, and on the activities side of the Outlook client, but when any user attempts to create a new record of type Account or Competitor or Contact or Invoice etc, they get the following error in the popup window; Microsoft CRM Error An error has occurred, for more information, contact your system administrator Try Again | Close Can anyone shed any light? Seems pretty fundamental, but I'm drawing a blank. TIA Paul. is the users computer running antivirus software as we have seen issues like this with mcaffees an...

get data form cells sequentially #3
Thanks, it works a treat. Everything is running correctly now. Thanks again SW -- swmasso ----------------------------------------------------------------------- swmasson's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=838 View this thread: http://www.excelforum.com/showthread.php?threadid=26161 ...

Counting Text Within a Field
Hello, I have a table called “tblWorkLog”. Is there an expression that will count the number of times “Dry Run”, “M Dry Run”, “T Dry Run”, and “VA Dry Run“ appear in the “Types” field and display the total in a numerical value in a report textbox and also count the number of times “F Stand-by”, “LF Stand-by”, “OR Stand-by”, and “Stand-by” appear in the “Types” and display the total in numerical value in a separate textbox in the same report. Thank You -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access/200708/1 Your title wasn't entirely ac...

MSCRM record count
I have a SQL query that searched my products based on a product number. My goal is to see if the product exists, and set a BOOL value accordingly. My code (listed below) does work, but it seems a bit inefficient for what I want to accomplish. I’m looking for the equivalent to a COUNT statement. Any suggestions? QueryExpression query = new QueryExpression(); query.EntityName = EntityName.product.ToString(); ColumnSet productColumns = new ColumnSet(); productColumns.Attributes = new string[] { "productnumber" }; query.ColumnSet = productColumns; ConditionExpression newConditi...

Close and Inactive form
Hi, I am wanting to have an open form closed automatically if the form has been open for a specified period of time with no data added to it. We have a number of staff members who for whatever reason leave the office without closing open forms. Any Ideas would be appreciated. -- Jens On Sat, 13 Mar 2010 03:38:01 -0800, Jens <Jens@discussions.microsoft.com> wrote: Check these out: http://msdn.microsoft.com/en-us/library/bb243861.aspx http://support.microsoft.com/kb/259971 -Tom. Microsoft Access MVP >Hi, I am wanting to have an open form closed automatically...

Page Breaks within Records
Hello, Is there a way for forms to keep records in tact for printing purposes? At times, There are page breaks within records. Thanks, Ellen Ellen, Without more detail I would recommend looking at the reports *Keep Together* property OR under *Sorting and Grouping* under report design. -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "EllenM" <EllenM@discussions.microsoft.com> wrote in message news:8F14D717-63D1-4CDC-8941-D07AC829E855@mic...

Pop3 account not displaying in folders
I set up my comcast.net account in Outlook 2003. The test works perfectly and gives the "congratulations" message. However, the account does not show up anywhere. No email displays and no folders are created anywhere within Outlook. This is the whole purpose I bought Outlook 2003...so I could manage several email accounts in one place. No folders would be created. All mail from POP3 accounts would go into the Inbox folder, which should exist already, unless you create rules to move it elsewhere or turn on the Junk E-mail filter. "DianeM" <DianeM@discussions....

MsgBox and a pop up form
I have an application that pop up a form (vbModal) asking for password in order to proceed. It pops up after a period of idling. It works prettty well. The hassle comes when there is a MsgBox popping up and the user does not respond, then the modal form pop up. Now I got 2 modal things, and you cannot click anything to move on. I have been sidestepping the problem by disabling the modal form whenever I show msgbox. I am wondering if there is a better way to do this. "phil hunt" <a@abc.com> wrote in message news:i43f9i$k9b$1@speranza.aioe.org... >I have...

How do you count cells with background color yellow?
Can anyone tell me a formula that will count the number of yellow cells in a range. I used =countif(AV2:HM2,"interior.colorindex = 36"). I don't get a error message. I get "2", when it shoudl be 3 -- no matter how many yellow cells there are, I always get "2". What am I doing wrong? sd There is no built in function to count colours of cells, no formula will do it. It can be done though using code, have a look at this on Chip Pearsons site, http://www.cpearson.com/excel/colors.htm Regards, Alan, "Stephanie D" <Stephanie D@discussions.micro...

Partnertech CD7220-UN pole display
Hello, Has anyone had any luck with this display? I've tried just about every configuration combination I can find, but all I get is the "Line 1" and "Line 2" at POS startup and nothing else. Also, when I close POS I get an error "Store Operations has encountered a problem and needs to close". The details of the error are: AppName: soposuser.exe AppVer: 2.0.0.126 Mod Name: kernel32.dll Modver: 5.1.2600.5781 offset: 00009823 Im using Microsoft RMS v. 2.0.0.126 The pole display is a USB unit. Thanks in advance. Phil BTW, a posiflex P...

Sub forms?
I'm trying to create a CFormView derived form that contains some static labels (obviously), a drop-down list (CComboBox), a tab control (CTabCtrl or CPropertySheet doesn't matter) two embedded forms (selected by the tabs although one of these forms will be re-used multiple times), and a couple of buttons (Ok, Cancel). I've tried various and sundry things and I can get the sub form (embedded CFormView with a CTabCtrl or a CPropertyPage with the CPropertySheet) to display and I can even select them with the mouse. What I seem unable to do is to get the tab order to work "seaml...

Disabling the form assistant
Because of the lack of ability to customize form assistant, it sometimes confuses our users. Consequently for the time being I would like to disable it globally. Does anyone know how this can be done? ------=_NextPart_0001_0DD6300C Content-Type: text/plain Content-Transfer-Encoding: 7bit Hi Phil, We are considering adding a way to globally disable the form assistant in the next version of CRM. Until then you can disable it by updating the FormXml of the forms that use it. Here are some instructions that are being considered for the next release of the V3 documentation: 1. ...

Subtotal not displaying Grand Total
I have a list that i'm using the Subtotal command to sum a list of lengths. It is doing the subtotals just fine but it is not showing the Grand Total of all of the lengths. Any suggestions? Did you hit the 1 in the upper left-hand corner to the left of column A? <-*-><-*-><-*-><-*-><-*-><-*-><-*-><-*-> Hope this helps! Anne Troy (better known as Dreamboat) Author: Dreamboat on Word Email: Dreamboat*at*Piersontech.com Web: www.TheOfficeExperts.com "ToddG" <anonymous@discussions.microsoft.com> wrote in message news:18a4f0...

how do I scan a medical record into a word document?
how do I scan medical records into a Word document? You'll need OCR software that converts the scanned image into an editable format. -- Stefan Blom Microsoft Word MVP (Message posted via NNTP) "Concerned Mother" <Concerned Mother@discussions.microsoft.com> wrote in message news:C4F2669F-C240-43C7-A79F-545E8E19DFB4@microsoft.com... > how do I scan medical records into a Word document? See the following page of fellow MVP Graham Mayor's website: http://www.gmayor.com/scan_into_word_2007.htm -- Hope this helps. Please reply to the...

Custom number format displaying thousands
If anyone has any potential solutions to the custom number format below I would be very grateful. If the two number formats below are applied to the numbers displayed in the 'Actual number' column, the output as shown in the columns 'format #1' and 'format #2' are given by Excel. The output I want to achieve is shown in the final column. Has anyone got any suggestions how i might achieve this? format #1 = [>500]#,##0,_);[<-500](#,##0,); format #2 = [>500]#,##0,_);[<-500](#,##0,);- Actual Number Format #1 Format #2 What I want -501 (1) (1) (...

Displaying inline images
Hej, I have an html format email that contains one image. I have two versions of the email. The html is identical except for the way the image is referenced. This html works and the image is displayed correctly. <div class="adht6t2a2hjuo-1" nowrap="true" style="z-index:15;top:3388px;left:35px;width:699px;height:283px;"><img src="cid:image1" border="0" width="699px" height="283px"></div> However this does not work. Here the image is rendered using the AlphaImageLoader. <div class="adht6q...

Count or total a logocal field
Using Access 2k and XP, in Windows 2k and XP respectively I am struggling with generating a total count of two fields in a report footer. Both fields are "yes/No" type. I want to count the number of reported entries that have the TrxCompleted field checked(TRUE). I have set a text box in the footer and defined the source property using the following formula =Count([TrxCompleted]=True). I have tried various modifications to this, however results are either #error or -1. What am I missing here?? Thanks in advance for your ideas and pointers. JR Hester wrote: >Using Access...