|
How to set
Day1 As Legi
Day2 As Pahing
Day3 As Pon
Day4 As Wage
Day5 As Kliwon
Day6 = back to Legi
Day7 As pahing
Day8 As Pon
and so on......
|
|
|
|
|
Hi guys,
I'm developping a Word 2010 macro to get an extended wordcount.
Briefly said, the word macro needs to do 2 things: gather wordcount stats, but including and excluding hidden text and get seperate word counts for texts in main body, headers & footers, shapes, ...
Detailed statistics would be saved to a new Word document. Lay-out etc would be no problem.
There is however a big issue. A lot of the documents that has to be processed are made with Word 2007 or even Word 2003 and earlier. When these documents contain (classic) Word Arts, I can't detect them (they're not in ActiveDocument.Shapes).
How do I:
* read the text from the Word Art?
* take a wordcount from the Word Art text (everything else uses Range.ComputeStatistics(), so I would like to use it as well - eventually creating a temporary range)
* copy the Word Art document to the new document, adding a reference to the page it is on (something like "Word Art on page 5)?
Thanks in advance you guys 
Cheers!
modified 8-Apr-13 3:52am.
|
|
|
|
|
This sounds very complicated, and I have managed to access shapes in both 2007 and 2003 version before, but I dont think that would help you much.
I think it would be better if you asked this question on the VSTO forum over at microsoft. http://social.msdn.microsoft.com/Forums/en-US/vsto/[^]. They are regularly responded by MVP in the Office interop area.
|
|
|
|
|
|
Hi,
Got the andwer
I had to loop through the InlineShapes collection.
dim ishp as InlineShape
For Each ishp in ActiveDocument.InlineShapes
If ishp.Type = 3 Then
End If
Next
Cheers!
|
|
|
|
|
Brilliant, It is not easy finding out things like that, I appriciate your effort
Edit:
MEaning some time in the future you will save me a lot of hours.
modified 8-Apr-13 5:52am.
|
|
|
|
|
Probably That's why I shared the answer
Cheers!
|
|
|
|
|
Hey Im having a problem with my calendar project and cant get my Mybase.new to work. This project is way over my competence and would be very greatful if someone could take a look at it.
Public Sub New(ByVal calendar As Calendar)
MyBase.New(calendar) <-------
_topsPassing = New List(Of CalendarDayTop)()
_backgroundColor = Color.Empty
_borderColor = Color.Empty
_oreColor = Color.Empty
_backgroundColorLighter = Color.Empty
End Sub
Im getting the error "Value of type 'WindowsApplication1.Calendar' cannot be converted to 'System.Windows.Forms.Calendar.Calendar"
The project is quite big so the problem might be somewhere else. I uploaded it on speedyshare if someone got the time, I would really appreciate some help.
http://speedy.sh/sYRjS/ProjArbete4.zip[^]
Regards Christoffer
|
|
|
|
|
You're trying to pass your Calendar class in the place of what your base class is expecting, a System.Windows.Forms.Calendar.Calendar. The two are not interchangable as it's saying that your Calendar class did not inherit from System.Windows.Forms.Calendar.Calendar.
You have to pass in a System.Windows.Forms.Calendar.Calendar, or something that derives from it.
|
|
|
|
|
Hi all Master VB6, someone can help me, please...
I need source code or ocx (free) for EditableGrid, our customer need input detail trx in editable grid, and easy to use.
And will be running on Windows 7 (32 or 64 bit).
Thanks before
|
|
|
|
|
Why on this earth are you doing new development in VB6?? It's dead and has been for quite a long time now.
|
|
|
|
|
Because vb6 has help me to get jobs and get money from it and have value for me, not mean we should forget it.
I create project with vb6 for small project, but now I am focus to the web programming like dot net and php.
May be another person can help me, please.
Thank you
|
|
|
|
|
Good luck! Industry support for controls for VB6 is just about completely gone.
|
|
|
|
|
h0k3n9 wrote: Because vb6 has help me to get jobs and get money from it
In that case you better hurry to VB.NET, as VB6 is dead. It's no longer sold, and the modern platforms will not be built with VB6 in mind. Unless you still develop for Windows 95, it's time to move on..
..or become a part of history
Bastard Programmer from Hell 
If you can't read my code, try converting it here[^]
|
|
|
|
|
You could download the VB.NET 2012 for free here[^]. Think that would be just as helpful as any other answers youd likely to get.
|
|
|
|
|
|
I've been working around this for years and think it's time I finally learn something.
I need to implement what in MS Access would be a "Form_Current" event. An event that fires each time a new record is displayed from the underlying record set and *after* the controls have their values.
I've tried BindingSource.PositionChanged and BindingSource.CurrentChanged but they're no good because I can't rely on the controls actually having a value. Using the change event on each control (in this case) would be a royal pain because so much goes on when the record changes (things light up, bells and whistles go off, etc.)
What's the best practice?
|
|
|
|
|
I have a vb6 project with a form with a Apex TruedbGrid 6 Oledb datasource that has as an ADODC (Ado 6.0 sp6) on the same form.
cn.ConnectionString = "Provider=SQLNCLI.1;Data Source=pc-musica;Initial Catalog=QdE;User ID=sa;Password=*******"
In Form_Load :
Adodc.ConnectionString = cn.ConnectionString
Adodc.RecordSource = "Select Code, Description from Cantine"
Adodc.Refresh
When executes last statement Adodc.Refresh only on Windows 7 (because everything works quietly in Xp) gives me the error:
Login failed for the user, type: -2147217843 Automation Error.
I checked the connection string and it is also right when the program uses the same connection to open a recordset and operates quietly.
The connection is declared in a module.
How do you think I can fix on Windows 7 32 bit?
|
|
|
|
|
|
This is not my case. I don't change password e don't work with SharePoint
|
|
|
|
|
Well try another Google search for that error code.
Use the best guess
|
|
|
|
|
marco.bruni wrote: How do you think I can fix on Windows 7 32 bit?
By moving to VB.NET; there's no guarantee that anything VB6 will work on the modern platforms. It has been dead quite some time now.
marco.bruni wrote: Login failed for the user, type: -2147217843 Automation Error.
Did you register your TruedbGrid? And all the other stuff referenced?
Bastard Programmer from Hell
If you can't read my code, try converting it here[^]
|
|
|
|
|
You could download the VB.NET 2012 for free here[^]. Think that would be just as helpful as any other answers youd likely to get.
|
|
|
|
|
I am getting this error when ever I want to add a second student to a form that has a Student ID that is Auto incremented. I first tried inserting all field to the database using the following code but failed to insert the Student photo and the enroll date properly.
Private Sub SaveBtn_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles SaveBtn.Click
Dim m, fe, F, P, H As String
Dim STPhoto As Image
Dim EnrollDate As Date
EnrollmentDateTxt.Value = Format(Now.Date, "yyyy-MM-dd")
EnrollDate = EnrollmentDateTxt.Value
Dim TA As StudentEnrollmentDataSetTableAdapters.StudentEnrollmentTblTableAdapter
TA.Insert(StudentIDTxt.Text, TelephoneTxt.Text, FirstNameTxt.Text, MiddleNameTxt.Text, LastNameTxt.Text, LevelTxt.Text, ClassroomTxt.Text, GuardianFnTxt.Text, GuardianLnTxt.Text, InstructorLnTxt.Text, m, fe, F, P, H, StudentPhoto.Image, DoBTxt.MaxDate, EnrollDate.Date, GraduationDateTxt.MaxDate, AboutStudentTxt.Text)
So I decided to use the dataset drag & drop feature to see if it can be helpful. It worked for the first entry but if I want to add another student right after the first one I am Getting the Concurrency Violation and the
Me.TableAdapterManager.UpdateAll(Me.StudentsListDataSet) is highlighted.
here is the full save button code:
Private Sub SaveBtn_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles SaveBtn.Click
If FirstNameTextBox.Text.Trim = "" Then
MsgBox("Fadlan Gali magaca hore ee Ardayga", MsgBoxStyle.Critical Or MsgBoxStyle.OkOnly, "First Name box cannot be empty")
FirstNameTextBox.Text = Focus()
Exit Sub
End If
If FirstNameTextBox.Text.Contains(".") Or FirstNameTextBox.Text.Contains("-") Then
MsgBox("Adeer Dhibic iyo xariixin lama ogala ee magaca hore ee ardayga gali", MsgBoxStyle.Critical Or MsgBoxStyle.OkOnly, "First Name box cannot contain (.) or (-)")
Exit Sub
End If
Try
Me.Validate()
Me.FulltimeStudentsTableBindingSource.EndEdit()
Me.TableAdapterManager.UpdateAll(Me.StudentsListDataSet)
MsgBox("Waxaad ku dartay 1 arday ", MsgBoxStyle.OkOnly, "One Student Added to Students lists")
Me.StudentsListDataSet.Dispose()
Me.TableAdapterManager.Dispose()
Me.Refresh()
I am not sure what
I am doing wrong as I when trough the code line by line and couldn't figure it out. I will highly appreciate if anyone can point me to what I am doing wrong. I even added an Insert Query into the table adapter to handle the table insert. Please help me if you can with any of my methods.
Thank you in advance. 
|
|
|
|
|
IgaBaro wrote: that has a Student ID that is Auto incremented.
Has it been set as a primary key in the database?
IgaBaro wrote: It worked for the first entry but if I want to add another student right after the first one I am Getting the Concurrency Violation and the
How do the update and insert-statements look like? Can you post them here?
Alternatively, you could try your luck on MSDN; How to: Update Data by Using a TableAdapter[^]
Bastard Programmer from Hell
If you can't read my code, try converting it here[^]
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
