|
Problem sorted - it was down to dumb user error 
|
|
|
|
|
i have a access database(oledb not sql)
i have a datetimepicker and a datagrid in my form.
i would like know picking my data from my database with the datetimepicker.
when i choose 01/05/2003 from my datetimepicker, i would like only this data should be shown.
01/05/2003 James $5.000,15
01/05/2003 Mary $7.500,01
01/05/2003 Adam $25.99,45
Please Help,,,
sorry for my english,,,, türkish man in forum
Turan
|
|
|
|
|
Hi,
try reading this[^]Article
I wrote it as a reply to a similar Q.
|
|
|
|
|
Thanks for your answer...
I tryed this code;
komutum = "SELECT * FROM tblkomisyon WHERE Tarih =#" & DateTimePicker1 & "#"
but it gives this error
operator() '&' is not defined for types 'String' and 'Systems.Windows.Forms.DateTimePicker'
Any help please...
Turan
|
|
|
|
|
So you use VB.NET 
that article was in VB6 , try using (+) not (&) to concatinate strings.
|
|
|
|
|
Can someone tell me how to compare a header from a website with a string in VB.NET. The header is in Japanese font so is the string.Do, i need to download the file or can i compare the string with the header directly. Also, if i download the page as an html then the downloaded page does not match with what is seen. Is it because i dont have the fonts properly installed.
Any help will be appreciated
|
|
|
|
|
Does anyone have source code that look at the file allocation table on the hard drive for deleted files. I would like to write a program to Undelete a deleted file stored on a NTFS drive.
|
|
|
|
|
Is it possible? If so, how do you go about it?
God, I pity me! - Phoncible P. Bone
If I end up Windows ME someone is going to be hurting. - One of the answers to a question for What OS are you
|
|
|
|
|
I see all sorts of controls out there to create PDF files. Are there any available that allow you to view PDF files from within a VB app? Also, is there one that will allow you to create thumbnails from the individual pages?
Thanks,
Jeff
|
|
|
|
|
Greetings, fellow Columbus developer...
Are you talking about VB or VB.NET? Either way, the easiest way I can think of to view a PDF file is using the Internet control, or just spawning Internet Explorer to view the PDF. As long as the client has the Acrobat Reader plug-in to IE installed, they can view the PDF.
|
|
|
|
|
Hi
i have several crystal reports questions:
1- how can i change the text of boolean field from true or false to available or something like this?
2- how can i load values to discrete values' combo box?
3- how can i change parameter field within vb.net code?
thanks.
|
|
|
|
|
Hi
i've made a connection object with ConnectionString that looks like: "Data Source= C:\...."
the problem is that when i an installation of that program it looks for the database file in the specific location that i wrote in the connection string.
how can i make the connection string so it'll turn to the database in the same directory where the app's EXE is located?
|
|
|
|
|
Hi,,
If you use VB6 use App.Path to get the EXE folder.
<br />
"DataSource=" & App.Path & "\FileName.mdb;......."<br />
|
|
|
|
|
|
Dim strPath As String = Application.StartupPath & "\db4.mdb"<br />
Dim Connection As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & strPath
Application.StartupPath being the app's path ( like App.Path in vb6 )
hope it helps.
Csharp™ the coder formally known as dynamic
Dim TwinsHaveArrived As String = "twins arrived safely , 17/08/2003 (18:05 & 18:07)"
|
|
|
|
|
I am currently implementing an interface that will launch applications based on document information stored in an application I am building. I am trying to support all the popular applications (Notepad, WordPad, Word, Excel, Access, Powerpoint, Project, IE, Adobe AcrobatReader, Winzip, Visio, and FrontPage).
I am using the CreateObject method to instantiate an object for a given application.
set AppObj = CreateObject("<appname>.Application")
Unfortunately, I can't find the proper application references for some of the applications I'm trying to launch. For example:
Set AppObj = CreateObject("project.application") does not work.
Additionally, I need to be able to determine the "Open" method required for each application. For example:
Set AppObject = CreateObject("Access.Application")
AppObject.Visible = True
AppObject.OpenCurrentDatabase fpath
Where can I find this information? Currently, I have the correct definitions for Word, Excel, Access, PowerPoint, and FrontPage. The others however, are a mystery.
|
|
|
|
|
If I read what your doing correctly, all your are trying to do is launch an arbitrary application. In that case, all you have to do is start the application using the Shell.
But, for some reason, you are using the automation front ends for these applications. But you don't specify why that is. The flaw in your plan is not obvious, but simple. Most applications don't expose a usable automation front end; Notepad, Wordpad, and WinZip being examples.
Think about it... What is Notepad? Nothing but a TextBox control with a small interface wrapped around it. Wordpad is just an interface wrapped around a RichTextBox control.
In order to help out with this we're probably going to need a bit more information about what you are trying to do and why.
RageInTheMachine9532
|
|
|
|
|
Thanks for the reply.
Yes, I agree with respect to the simple applications (notepad, wordpad). I just listed them all because they are all on my list of common applications used by our users.
However, with respect to MS Project and WinZip, I assumed that these Microsoft products would have some form of object model interface.
The reason I don't want to use the shell, is that there will be instances whereby I will want to control aspects of the application launch that are not readily available through a Shell call. For example, I might want to auto-populate some tagged fields in Word.
Any ideas where I can find the object interfaces for these types of applications (not the simple ones ... but Third Party and Microsoft non-office apps).
Thanks,
|
|
|
|
|
Paul Melanson wrote:
WinZip
Paul Melanson wrote:
these Microsoft products
Huh?
Paul Melanson wrote:
For example, I might want to auto-populate some tagged fields in Word.
Well, Word has a COM automation interface, so that won't be too hard.
I'd really like to see the day when all applications have automation interfaces.
"Blessed are the peacemakers, for they shall be called sons of God." - Jesus
"You must be the change you wish to see in the world." - Mahatma Gandhi
|
|
|
|
|
Sorry ... I assumed WinZip was a MS product, since that is where I downloaded my last version.
Yes, Word has what I need and it would be nice. Maybe XP and it's XML layer will solve the truly integrated office components problem; however, it is my understanding that it is still a few years away.
|
|
|
|
|
Hi.
I would like to know how to link a context menu to a control...
Actually, it's easy to do it with a control like a textbox (in properties, go to ContextMenu and choose your context menu ). But in my case I use an OCX control that does not have contextmenu in properties...
How can I do?
thx!!
bobo
|
|
|
|
|
my screen have some textbox, and I want to goto next textbox when I press ENTER (finish input) on one textbox (same textbox in VB6 Mircosoft Forms 2.0 object library)
thanks any help!
a beginner
dungti
|
|
|
|
|
Put in a KeyPress handler for the edit control, and add the following code:
<br />
if (KeyAscii) = 13 then ' Enter Key<br />
SendKeys "{TAB}"<br />
Endif<br />
This will trap the Enter key, and send a "Tab" to the form. Need to ensure that next control in the tab order is the next control youwant to go to....
Just out of interest - are you sure this is what you want to do? Not really standard windows behaviour, and precludes the use of enter as OK...
"Now I guess I'll sit back and watch people misinterpret what I just said......"
Christian Graus At The Soapbox
|
|
|
|
|
I have a MDI application that has several child forms. On different child forms, I have to open a dialog form that asks for user input and then update that form. The problem that I am having is that when the dialog box is displayed and the user clicks on another window (ex IE, Word, etc) and then returns to my app, when they close the dialog form the window that they were just on gets the focus rather than my MDI app. How do I fix that?
Thanks,
Brian
|
|
|
|
|
I'm currently trying to write an application that needs to interface with a 3rd party vb app by automatically 'reading' the text from one of its textboxes into an array in my app.
I do not have access to any of the source code of the 3rd party app and therefore need a method of automatically reading the textbox data from a 'user' perspective.
Can anyone let me know if this is possible, and if so point me in the right direction?
Cheers
Grazza
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
