Visual Basic 4 / 5 / 6 Forum

Hello everyone, Attached is a sample of my project to help you see the issue yourself instead of me trying to explain. It's kind of confusing. Once you open the db. open up the frmQuoteLog and the frmPDMontior. You will notice one record is displayed in the frmPDMonitor (Justin Ryan). This is correct. Now to test out the issue leave open...

I have a Visual Basic 2008 project on my C: drive. It works fine, but when I try to make a backup on my external USB drive the Form1.vb code is copied correctly, but the design form is not copied.

HI, my code for search is rec.Open "select * from Body_Markings_new where Part Number like '%" & txtsearch.Text & "%' ", conn, adOpenDynamic, adLockOptimistic after compiling this code getting an error saying syntax error (missing operator) in query expression 'part number like' %1%" please help me I not able to fix this.

Hi there, First of all apologies for the long post. Hope someone can offer some advice. I have about 200 columns of time series data that I need to perform a correlation analysis on in terms calculating lagged cross correlations between all the variables. Currently the data is stored in Excel. Variable 1 is in Column A, variable 2 in...

Dear All! I have RTF formatted data stored in the database as varbinary(max). I want to retrieve all data and store it in word document using while loop. However, the first record is correctly retrieved while the rest are ignored. I have queried other non-binary fields and they are correctly display in the output document. Please check my...

hi, i made a mistake but can't find it ..the program says theres something wrong with this: Get #FileNum, Page, Save this program worked with a method to save values in a file but when i added more values it gives an error could this be only in cause of too many values??? or did i made an other mistake???

I've seen this mentioned as "bug" and wondered if there is a better workaround. When using the webbrowser control, I open a document (navigate) then getElementByID, scrollintoview. It does that then immediately goes back to top of the document. If I insert a message box, it does not. This works but what an ugly hack: Dim doc As...

I have a file that is stored in C:\users\123456\ with the name export.ttx . I want to create a VBS script that opens up this file, removes all the " in the file (and replaces these " with nothing)and then saves down the amended file as a .csv file. I am not sure where to start. To be clear I want the rest of the file contents to be unchanged - I...

Good day, i have a problem regarding to my crystal reports, i created a from with 2 datetimepicker to determine the date range , but when i run it, all data still showing, my stored procedure working on SQL Server, any advice?

Hello everyone, I need to reference a workbook from a formula, for example: ='WorkSheet'!$A$93 But instead of the formula always having the full path I want it to look for the path with the date before today. For example I places this in a separate cell (S11):

iam trying to add my visual studio 6 Application to windows file right click popup menu so please help me

Hi, I just begin programming in vb5(I use Visual_Basic_5.0_CCE AS Interpretor) My problem is how can I do for enabling drag and drop between two label controls.In others words,I want enable drag and drop between caption property of these two labels controls. Best Regard

Hi, I want to disable Textbox2 when Textbox1="YES". This "yes" value will be fetched from database Query table and not manually entered.

problems please solved datareport i create two tables name are ( re2014 and re2015 ) filed dataname in ( pay , exp and cost ) each table in filed record in see picture http://www.vbforums.com/attachment.php?attachmentid=112571&d=1396943849 total see pic http://www.vbforums.com/attachment.php?attachmentid=112573&d=1396943882...

I have an excel 97-2003 file called "MASTER - FX Reconciliations Modelvista.xls" that I open using Excel 2010. Within this file I run a VBA macro with the name FXcurr. This macro picks up a file called rollifrp.xls (97-2003 Worksheet) makes some amendments to it and then saves it down to a file path detarmined by the entries in two cells of the...

Hi, In a vb routine I try to get the text in a statusStrip box named statusStrip1 of another program, but the returned string is "statusStrip1" while the correct string is "red ball:3".Looking for help from you. Thanks in advance. Some of the routine are here: ahwnd = FindWindow("WindowsForms10.Window.8.app.0.202c666", "receive") bhwnd =...

Hi all, I have been scratching my head over this one for a day now! I have a word 2007 document with 2 user forms, Form1 and Form2. Form2 is activated from Form1 and should let the user select a value from a listbox and have that value sent to a textbox Text1 in Form1. I am doing this as follows: in Form1 module Public Sub SetCode(ByVal...

Can someone please tell me IF IT´S POSSIBLE, to have a vba code for calculating real-valued root of the polynomial of n power in excel 2007, by using Newton method? i tried to solve a simple P(x) such as X^10 + X^9+X^8+X^7+X^6+X^5+X^4+X^3+X^2+X-200 = 0 , by using solver from excel 2007, but it didn't work out. Al old friend of mine, NEO, send...

] I am using visual basic 6. There was no data come to my textbox even it was connected on my device. I have a settings of com3, 9600, 8, n, 1.

Private Sub CMDPHOTO_Click() With Cdlg .FileName = "" .Filter = "Image (*.jpg)|*.jpg" .ShowOpen If Len(.FileName) <> 0 Then FN = .FileTitle pathpic = .FileName Image1.Picture = LoadPicture(.FileName) End If

I have a form with a list box control that passes a person’s name to be filtered into a query. I have several buttons that open different queries. How can I get the button to deactivate if a person’s name is not an action party of the query? For example Joe may have actions for Query “A” and “C” but not “B”. I want button B to deactivate when...

I am confused about do loops. Of all I have read they still make no sense. I have a table with a list of manager’s names. I also have several tables that contain Action report items. I have already built a set of queries and file transfer protocols that will allow me to create spread several sheets in a separate excel workbooks for each manager....

Hi Everyone I need to make VB to press a key after a short time what should i do? witch button should i use or what to write there Thanks

i've got this code to create a textbox using a command button but i can't understand anything of it , please can you explain what each word especially(set,prevtextcontrol,controlid) mean and what each line mean, here is the code : Private Sub Command1_Click() Dim TextControl As TextBox Dim PrevTextControl As TextBox ControlID =...

I am giving the integer values to change the background color in text box. i want to get the color name based the RGB Value...