Dim Report As New CrystalReport7
Dim db As Database
Dim rs As Recordset
Private Sub Form_Load()
Screen.MousePointer = vbHourglass
Report.Application.OpenReport ("xxxxxx.rpt")
Report.PaperOrientation = crPortrait
CRViewer91.ReportSource = Report
CRViewer91.ViewReport...
I have an application which populates data from acces into a template excel file, which has a graph in it, through VB code. The user copies the graph into a power point slide for his presentation. Can I copy this graph straight into the power point slide with my VB coding?
Can anyone help ?
I am using the following code to send documents through mails.....
MAPISession1.LogonUI = True
MAPISession1.SignOn
MAPMess.SessionID = MAPISession1.SessionID
MAPMess.Compose
MAPMess.RecipAddress = "mailid@xxxxx.com"
MAPMess.ResolveName
MAPMess.MsgSubject = "Testing Email"...
I am creating few excel files from VB, the user is interested in having the excel files in .Pdf format.
Can we create .pdf files from VB ? If so can anyone help!!!
Thank your
My application is in VB. One of my option in the application is to create excel files in a required format.
The process takes more than 3minutes. I want to show a process bar on the screen. I tried with timer event..
but it is not working or I may not used in the right way..
The code is like...
I have a Cristal report to be opened in VB.
My application runs in a stand alone PC, which has no VB or Cristal report installed. I have copied the .rpt files.
How do I open these reports? The data is from MDB.
Please help
I am using a Access DB to create, say 50 Excel files, through a VB Application. I need to send this to 50 people by mail using lotus notes mailer..
Can anyone help
I added the project in sourcesafe in the same directory, all the forms in the project got locked.
Every time I open the project the forms are in locked mode only I could not do any changes....
How to unlock it?
Please help.
I am creating an excel sheet from VB6.
This is working fine. I need to change the font size and color of few cells, say sheet heading and column heading...
can anyone help..
In my VB project I read data from different tables as per the user input, I decide the table name from the user input, before my select statement I should know if the table exist in my database. Can anyone get me the command for this?
Thanks
I am doing a lengthy process, which creates few files and does some postings which may take more than a minute,
I want to keep flashing some messages to the user, or some process bar which tells the user some thing is happening,
How can I do this?
Can anyone help me....Thank you
I am using VA SPREAD a third party component in by VB form to capture data. I have specified column in the spread as type combobox, How to attach a datasource to that column? so that data can be selected from this dropdown.
How do I force a page break when the printing of detail line exceeds a particular number?
Example: I want to print lines not exceeding 29 or if the group ends and starts a new group. For new group It goes to the new page automatically but for line printed i have to force the page break...
My Access Report uses a field value from a table as a starting number and I want to store the last generated number (say invoice number) into the table, to be used when the report is run the nexttime.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.