[visual-basic] Forum Topics

I have followed every step in the My Sql forum posted - [URL="http://dev.mysql.com/tech-resources/articles/vb-blob-handling.html."]http://dev.mysql.com/tech-resources/articles/vb-blob-handling.html.[/URL] I have no problem in saving the picture file to MySql. The problem arises in retrieving the picture. I am using code as follow: - [CODE]Private Sub DataLoadPicture() On Error GoTo ErrFailed Dim cnPhoto As New ADODB.Connection …

Hello, I am almost done with writing the program below. My problem is when I go to get the next line in the file, the first line works great. I am writing it in autoit and I heard it is similar to Basic so hopefully someone could help. I am …

Hey guys, I want to write code that does something like this: If option = 1 Then Create one Button and display it Else If option = 2 Then Create two Buttons and display them End If To do this, can I simply do: [CODE]If option = 1 Then Dim …

I'm relatively new to VBA, and I'm trying to automate some macros for a datasheet. I need it to look at the value known as rackRack.Text (I know, not the best var name) and split it. The original value would look like: "B-04". I want it to split and select …

Hi, Please find my requirement - The Datetimepicker should display the current month - It should disable the 1st day of the month (i.e mindate should be 2nd day of the month) - It should disable all dates > current date (i.e maxdate should be current system date) So that …

How to get the difference of the month from the date specified. Example: [code=vb] date1.value="5/1/2010" date2.vale ="5/31/2011" [/code] it should give a result of 12. thank you for helping.!

Have gone through the basic microsoft tutorials but have yet to see how one goes beyond this to actually create something. Have downloaded visual studio express and XNA. My goal is to at least create a venue for a game idea and admit that I do not have a clue …

Hello! My first post here. I have a problem. I want to make a Windows form that it's exist a button, and if you click that button, then the mouse cursor will move to a choosen X and Y coordinates and after that the cursor will click left or right. …

I use Visual Basic 2008 I use bound Datagridview I use mysql database If i run this code, everything on the screen ( in the datagridview) [COLOR="Green"]neatly Updated[/COLOR]. But when I look at records in the table [COLOR="Green"]"stock"[/COLOR] always the first row (0) of the DataGridView [COLOR="red"]not updated [/COLOR]in the …

So I've been trying to convert CSV files to XLS. However, this line of code keeps giving me problems: [CODE] oExcel.SaveAs FileName:=FilePath_XLS(TableName), FileFormat:=xlNormal[/CODE] The FilePath_XLS returns correctly... I just can't figure out what's going wrong but it will not execute..

Hi everyone! i have a question if someone know how can i check with a VB application if another programs window is minimized or maximized? example i would make a simple VB app that could while running check with a timer if "MS Paint" for example was maximized and check …

Alright, I'm having a problem with a scheduled task not running. At first it wouldn't run the vbs, so I created a bat to run it and then it would work, but only when the user is logged in. I went into the local security policy and made sure my …

hi! we are having trouble in our program. every time we click login button it will proceed to the next form even if it doesn't have anything on it. can you please help us regarding this problem [code] Private Sub Command1_Click() Adodc1.RecordSource = " select * from login where username …

Hi I was just wondering if someone may be able to help with a program I'm trying to complete for college. I am useless at programming so I have tried and tried to sort it, to no avail, yet its probably something very simple and stupid! Basically I have created …

Hye All Please help me to create Data Reports Accourding to given Dates. I Created a VB6 Form put 2 Time/Date Picker Controls and one Command Button.what will be code for Button to display Report Between given dates.

sorry for long post name. anywyas, i'm converting an emulator a friend of mine made into VB form C. i came into some problems at the end where return is casuing an error. here is the code: [CODE] 'The following #define macro was replaced in-line: 'ORIGINAL LINE: #define ROPCODE(offs) ((oprom[offs] …

I am trying to control the security board using the Windows Firewall which connects to my server that was made in VB.Net. My only problem is when I open the Windows Firewall my server crashes. It also displays this error: "Error, win%fir%90y4e does not support this server. Please upgrade you …

The project I'm working on has a bit of code in the workbook open event that makes excel go full screen, hide any toolbars that a user has configured to run in fullscreen (and make a note so they can be restored on exit) and loads a custom toolbar. [code] …

I am writing information to a list box and I want to be able to have a small case letter following a period with no space between them ie: Harry.c I am using VB6. I will appreciate any/all help. Thanks.

I wish to call a form with the form name contained in a variable using a declaration such as [CODE]public myform as form[/CODE] will work if the formname is used. but myform will not accept a variable containing the form name

I'm working on a vb parser for excel but when it comes across anything that is not int the spread sheet it gives me an excel error message and I want to stop that before it prompts. [CODE] Try xlWorkSheet.Cells.Replace(What:="Boulevard", Replacement:="BLVD") Catch ex As Exception ex = Nothing End Try[/CODE]

hi!!! my group is doing a thesis work... and the name of our thesis is Faculty Attendance Monitoring System Using TouchScreen Biometric System... Can You give me some code in making that system... please!!!! tnx.. from:Hotaru

Hi, Does anyone give me some suggestion? When I close the form, but some process is still running.I don't know how to handle this kind of situation. What I want to do is that stop all processes first and then close form automatically. [CODE]Private Sub Command1_Click() 'Do process 1 Call …

Hi. I've been trying to populate a <select> option list in HTML by querying a Microsoft SQL Server database. For some reason I can not do this by mixing the scripting code (VBscript) with HTML. If I place the query between the <select> and </select> tags it does not run …

Hell all I have problem to login as administrator and as Operator with less permissions. following code .i create and open recoedset "Type_rs" [CODE] dim Str_T as String SELECT Case Type_rs.Field("User Type")=Str_t Case str_t="Administrator" mainfrm.toobar1.enable=true case Str_T="Operator" mainfrm.toolbar1.enable=False End SELECT [/CODE] I thing Type_rs.Field("User Type")=Str_t is not working properlly please …

Hi, I don't know why i am getting this error. Please see my coding part, where i am facing this following error [ICODE]Private pbat As New ADODB.Parameter 'in form load With pbat .Direction = adParamInput .Type = adVarChar .Size = 4 End With 'saving part [B] pbat = Trim(Text1.Text) & …

Hi everyone, im still new to this forum and started to learn about visual 6, i have situation below, this program to obtain reader name and bonus point earned menu File Edit Help Points Clear About Summary __________ Exit Font Color Quesstion, For Points menu command what is a suitable …

Is there a simple way to list all the toolbars a user currently has visible? I'm trying to hide everything on screen appart from my worksheet, including the file menu. I've found a way to do it (custom toolbar, hide everything else) but need to be able to restore the …

Using VBA/Excel and need a VBA or VB help file. Doesn't appear to be packaged with Excel anymore. Any help?

Dear experts, I´m in trouble with this project. Strange 'cause the same code works on a different workbook. Can you guys help me, plz? Sub Graph() Dim y As Byte Dim x As Byte Dim a As Byte Dim D As Integer x = 0 y = 5 Workbooks("Graph1.xls").Activate Worksheets("Plan1").Select …

i just wanted to make a small bot using a web browser to post comments to wordpress blogs ! well i don't know the reason but it seems that only the last url is executed ! when i load a list and start the posting the loop seems to jump …

Here's the problem. I'm designing a worksheet for very young children and what they need to do is type a number into a cell and then click a button to run the macro. However, in order to click this button they first must either press ENTER or TAB or click …

hi i have application in vb 6.0 ,which i want to open in vb.net...how? i have tried *upgrade wizard of vb.net..............not working *installing vb 6.0 again...........now seems difficult althoght d .exe file of my application is running but some forms r missin help ...........

I use Visual basic 8.0 I have a bound Datagridview. This Datagridview has 25 row. Only thing i want to clear the row [COLOR="Red"]Contents[/COLOR] of a specific row. [COLOR="red"]I want not delete of remove the row!!!![/COLOR] How can helpme with this problem? Thanks, André

I am learning visual c# and am having trouble subscribing to an event. The book says, [B]"Now you create the handler for the two text boxes that must be checked to see whether they are empty. You do this by subscribing to the Validating event of the text boxes. You …

Hi, I've been trying for the past couple of hours to get this modal dialog box working, it is basically supposed to ask for text input and once entered will open a message box with that text. At this point though I'd be happy to just get the box up …

[ATTACH]20944[/ATTACH] pressing save button i want to store/save all input data in one storage. attached file is the sample form i made thanks

Hi there, I have been having some problems with my Visual Basic. In trying to figure that out, un-installing, and reinstalling, running virus scans, etc, I have lost a lot of my time to get this assignment done. I would just keep messing around with it and try to be …

Using Visual Studio 2010 I'm trying to save the Items in a listbox to the User Settings, ([I]System.Collections.Specialized.StringCollection[/I]) named MyListItems. When I start debugging from VS it will not save the settings or load any settings already in the config. But If I run the appname.exe (in bin/debug) as an …

I have written a Visual Basic macro in Excel. The following is the link to that file: [url]https://rapidshare.com/files/3870906097/Deconvolution_ver1.xlsm[/url] While running main(), selecting BU4 from userform, a type mismatch error is encountered. I am unable to solve this problem. kindly help me out. my mail id is [email]shivam1410@gmail.com[/email]

Hey, Plz, I need some help with this code, In another workbook it worked. Specific on this one it's not working. The error is occuring on the red line, right after it's added a new serie on the graph. Sub Graph() Dim y As Byte Dim x As Byte Dim …

Hi Guys, Can you please let me know how I can create a Form which it's border color is Fixed and not change by windows system default style?How can I change the color from Blue to Gray and render the form with new color in any OS regardless of what …

I have tried to google this but returned nothing useful; I have code which runs in a menu item (StartToolStripMenuItem_Click). Later in the project i want to code clicking this menu item but if i just use the StartToolStripMenuItem_Click sub it wants the 'e' argument passed to it. I simply …

Dear All, Could somebody let me know the search code in VB6. I am using ADODC1 connection. im handling employees databse called databse.mdb when in click the search button i want to get the details of the said employee using their badge nos. pls help..... Have a nice day..

Hello Everyone! My problem is this. I have a VBscript encrypting passwords using capicom.dll RC2. I want to use C# to decrypt this password. Which I can't get to work for the life of me. Keeps coming back saying 'Specified key is not a valid size for this algorithm.' (but …

Hi all, I would like to format a column in datagrid with 2 conditions. The column must be entered with only "N/A" or date (DD-MMM-YYYY) format value. [CODE] If Me.grdDataGrid.DataFormats(10).Format <> "N/A" Then MsgBox "Invalid Data Entry!", vbInformation Exit Sub End If[/CODE] The code above still produce "Invalid Data Entry" …

They want to have a [COLOR="Red"]"search textbox"[/COLOR],[COLOR="Red"] "result textbox"[/COLOR] and a [COLOR="red"]"datagrid".[/COLOR] If the secretary input a keyword, all the "familiar data" will be displayed in result textbox. and if that secretary click one of the results in the result textbox, the details of that data will display in datagrid. …

Hi experts, well, nearly 10 years after .net became the mainstream I am finally making the move to vb.net after having supported VB6 apps all this time. I have been learning vb.net 2010 but am finding it difficult to find relevant information on the COM aspect. In VB6 COM was …

Hello, I am new to vb and I need some help from you all. I have to do a project which is interface an vane anemometer to computer by parallel port. I have done almost everything now i only left with the programme. My idea is the anemometer will give …

I have the problem to convert the rtf document to PDF. I search around the internet but it still cannot solve my problem.I am using TextControl in visual basic to create the document .Please help thx :)