If you use Microsoft Data Reports, there is an option that allows you to autmatically drop and drag a field which contains either page totals/ or the current page being displayed.
1, When in design time at report view, right click and select which field you would like to add to the page, ex CURRENT PAGE OR TOTAL PAGES or BOTH
2, Alternatively you can also add this statement to the end of a data caption %p this shows...
vbsourcer
Last Activity: Sep 13 '06, 01:40 AM
Joined: Aug 21 '06
Location:
-
The best place to find information about VB5 Controls and VB6 Controls is the MSDN Microsoft Web Site.
Here is the link
http://msdn.microsoft. com/vbasic/...Leave a comment:
-
Could you post the code you are using, that might help clear things up a little. Also, is the a function that activates on form click ? It sounds like a function is active on form click.. Please post your code and I will be in a better position to help.Leave a comment:
-
I agree ronald. HERE HERE..
Please enlighten us a bit more.Leave a comment:
-
Hey there try this ,
1. in project menu>refference s> select .. microsoft word 9.0 object library
Private Sub Command1_Click( )
Dim objWord As Word.Applicatio n
' this would be faster with a "with objWord" but for clarity I use the explicit
Set objWord = New Word.Applicatio n
objWord.Visible = True
objWord.Documen ts.Open "c:\sql performance tips.doc",...Leave a comment:
-
Listing Two Access Fields in VB
Hello all could anybody tell me how I would be able to list information from a database using Two Fields from the Database ? I have this code which will populate the listbox with exactly what I want by when the user clicks the listbox to view the customers information an error message returns "No Current Record"
here's the code I am using to list the two fields from the DB
Private Function list()
If... -
I am using VB Directly. I created the database files using Access and am connecting to the database using VB.Leave a comment:
-
It's the standard listbox that comes with Visual Basic 6.0Leave a comment:
-
Hey thanks again I have inserted your code in the List function but when I try running the program I get the error message "Compile Error - Method or Datamember not found" and VB Points to this code
lstdata.RowSour ceType = "Value List"
Am not sure if the listbox I am using supports rowsources? Yes I am trying to list two field values in the list box as this is one way I know of that will list customers...Leave a comment:
-
Listing Two Fields
Listing two fields
--------------------------------------------------------------------------------
Hello all could anybody tell me how I would be able to list information from a database using Two Fields from the Database ? I have this code which will populate the listbox with exactly what I want by when the user clicks the listbox to view the customers information an error message returns "No Current Record" ... -
P.S. You may need to reference Microsoft DAO 3.51 Object LibraryLeave a comment:
-
If you have visual basic 6.0 You can download my sample project which visually shows you where I am going wrong. If you could PLEASE send me back your alterations to sharp2_nz@yahoo .com or just e-mail me the project with your alterations.
To download the source code please visit
http://vbsource.phpnet.us/DBProject.zip
Thanks Again
VBSourcer...Leave a comment:
-
Listing two fields
Hello all could anybody tell me how I would be able to list information from a database using Two Fields from the Database ? I have this code which will populate the listbox with exactly what I want by when the user clicks the listbox to view the customers information an error message returns "No Current Record"
here's the code I am using to list the two fields from the DB
Private Function list()
If... -
Thank You again for your help,
I will try your code asap.
Will post reply to let you know how it goes.Leave a comment:
-
P.S. I am not that advanced at programming but I do know a bit to get me around.Leave a comment:
-
Thank You for your prompt response.
We attain the value "Edwards" from our Last Name Search box and this works fine. But the problem is when we have 2 customers both with the last name Edwards
Example Sam Edwards and Mike Edwards
This works fine as the listbox displays all records with whatever last name we tried to search for in this example "Edwards"
But when we click...Leave a comment:
-
Duplicate Values
Hi All,
Could anybody please help me.. Not sure if this was the right forum to post in but this has got to do with Databases so here goes..
Here's the scenario.
We are developing a program In Visual Basic which uses a Microsoft Access Database file to store information of our customers. We have enabled the Allow Duplicates value in the CustomerLastNam e field as we may have 2 customers with the same last name....
No activity results to display
Leave a comment: