vba x 200

12,155 Topics

Member Avatar for
Member Avatar for Vedj3

I am stuck on Visual Basic problem regarding combo boxes. The question states: [I]Assume that the Simple combo box appears as shown and that the Sorted property is set to True. Give a statement or statements that will carry out the stated task. The combo box contains: Dante Goethe Moliere …

Member Avatar for Jx_Man
0
1K
Member Avatar for glfnfvr

I am trying to write a code that asks for a date in a user form text box and then takes that date and looks for it in a range. Once it finds that date I want to enter the data from the second text box in a cell on …

Member Avatar for glfnfvr
0
150
Member Avatar for laharven

[COLOR="red"]Hey guys, I have just convert my coding from vb to c++. However when i paste the codings inside another new project, it could be debugged but the designer view shows me error.[/COLOR] "C++ CodeDOM parser error: Internal Error Hide at Microsoft.VisualC.CppCodeParser.OnMethodPopulateStatements(Object sender, EventArgs e) at System.CodeDom.CodeMemberMethod.get_Statements() at System.ComponentModel.Design.Serialization.TypeCodeDomSerializer.Deserialize(IDesignerSerializationManager manager, …

Member Avatar for laharven
0
260
Member Avatar for max8888

[code=cplusplus] PROC bHook(LPSTR BaseLibraryName, LPSTR BaseFunctionName, PROC NewFunctionPointer, bool UnHook, PROC Custom) { PROC hBaseProc; return hBaseProc; } BOOL APIENTRY DllMain( HANDLE hModule, DWORD ul_reason_for_call, LPVOID lpReserved ) { switch (ul_reason_for_call) { case DLL_PROCESS_ATTACH: OutputDebugString("--------Detour dll Load!"); bHook("KERNEL32.DLL", "CopyFileW", (PROC)MyCopyFileW, false, 0); break; case DLL_THREAD_ATTACH: break; case DLL_THREAD_DETACH: break; case …

Member Avatar for max8888
0
214
Member Avatar for bornok15

I'm currently designing a report using VB6 and crystal reports using mysql as backend but everytime i open the report in VB i always have the error "Access Denied". I never had such error in the old version of MYSQL. I using WAMP server with MYSQL 5. Anyone who has …

0
82
Member Avatar for lostandfound

Hi again, In my previous thread regarding Combo box at runtime I had not forseen the problems I would experience introducing a variable to the code. [CODE]Private Sub Form_Load() Set myconn = New ADODB.Connection myconn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source = C:\Documents and Settings\Gareth Powell\Desktop\db2.mdb" myconn.Open Set mycomm = New ADODB.Command Set …

Member Avatar for lostandfound
0
206
Member Avatar for lostandfound

Hi all, What I need to do is populate a combo box at runtime according to specific inputs from other forms.The code listed below is a seperate trial and works OK. I would like to know if I am overdoing the code thing for what I am achieving. [CODE]Private Sub …

Member Avatar for lostandfound
0
366
Member Avatar for Broxy

Hi There In an Excel Macro. I am trying to install a manual Page break in an IF Statement, if it results in a 'Yes'. What I am missing? Please help. Best regards, Broxy. Sub PM3() ' ' PM3 Macro ' ActiveCell.FormulaR1C1 = "=IF(RC[1]=""yes"", ActiveCell.ActiveWindow.SelectedSheets.HPageBreaks.Add Before:=ActiveCell)" End Sub

0
71
Member Avatar for bpb-p

I have a form with several list boxex. The form feeds an Excel spread sheet. I need to move thed data from the list box to the spread sheet. Some times it works, and some times it doesn't. I have varified that the list indexes are correct, and have even …

0
53
Member Avatar for woseng

I am trying to create an alert in Vb.6 code that tells the user to make purchase since he has riched limit of the product

Member Avatar for steve585
0
77
Member Avatar for Yogesh Sharma

steps i Follow- 1) Go to Control panel-->Admintrative Tools-->Double -click Data sources(ODBC)-->click Add button-->I choose SQL server(last option), Is it right or wrong option for connecting to SQL 2000.Then a new screen appears Create a New dataSource-->in name textbox,we can write anyname--Right or wrong. suppose i enter sonia, & my …

Member Avatar for choudhuryshouvi
0
1K
Member Avatar for wrichardson530

Hi all. I'm having difficulty making a log-in screen. i am using an adoc contorl called adoClerk, which contains only two fields and ClerkId and Password. The ClerkId is a autonum and password is text. I Have two text boxes that need to be read from this screen txtClerId and …

Member Avatar for choudhuryshouvi
0
225
Member Avatar for muguus
Member Avatar for Jx_Man
0
89
Member Avatar for Scott Marchione

Hello all, I have a VB Script that creates a phone list for my company, and I have been asked to alphabetize the names listed under the department headings....I am so new to VB that this is the first time I have used it.....ever I've done a great deal of …

Member Avatar for Scott Marchione
0
170
Member Avatar for Adrian99420

Hi, I created 2 window form using visual C++, I am trying to display the string typed by user in second window form's textbox. Here is what i wrote, but the code is not working: Form1.h private: System::Void button1_Click(System::Object^ sender, System::EventArgs^ e) { tabPage1->Text=Form2().textBox1->Text; }

Member Avatar for mitrmkar
0
107
Member Avatar for swapna7999

hi thanks for ur suggessions now i got mysql connection with vb but i need to use the mysql Queries in this application hope i wil get solution thank u very much

Member Avatar for swapna7999
0
855
Member Avatar for mrhard2004

Hi... I am developing a software where I need to enter both [B]text as well as some Mathematic equation or some BMP picture [/B]inline with the text. Is it possible to enter this as input to any one variable. If so what type of the variable should be used? Please …

Member Avatar for ROBBOHORT
0
88
Member Avatar for alalmocera

My name is Alexis Erich S. Almocera... call me [B]Alex[/B], ladies and gentlemen. I'm a BS Mathematics student of the University of the Philippines, Cebu College (UPVCC), graduating this school year. Since I was a little boy, I'm pretty much into mathematics along with the desire to make computer programs. …

Member Avatar for november_pooh
0
144
Member Avatar for drpaur

Hi, I have made a DataProject in VB6 with Access as back-end. Using Jet OLEDB 4 as provider. Programme is running well on my Computer. When I Installed the project on another Computer where VB6 is no installed on Hard disc, Error comes. When I try to show Report in …

Member Avatar for wrichardson530
0
224
Member Avatar for Mr.Wobbles

The Title says it all - I don't really need the exact code, but a point in the right direction would be appreciated.

0
94
Member Avatar for nemag

after i put earch code in my project : Private Sub cmdSearch_Click() Dim search search = InputBox("please enter card no", , "") Data1.RecordSource = "SELECT * FROM waqf WHERE cardno LIKE (""" & "*" & search & "*" & """)" Data1.Refresh End Sub ------------- the search working but appear problem …

Member Avatar for choudhuryshouvi
0
148
Member Avatar for hasmiza

i'm using adodc. i want to empty all the text box when form load i already use to reset all that but it cannot work private sub form_load txtname.Text = " " txtIc.Text = " " cboroom.Text = "<choose room type>" cbocheckin.Text = "<choose>" cbocheckout.Text = "<choose>" cbomonth.Text = "<choose>" …

Member Avatar for choudhuryshouvi
0
118
Member Avatar for kenm26

Hello, I have a problem pulling external vbscript into an html template. I have various .vbs files written in vbscript, in a function library. Each .vbs file contains many functions that do a variety of things. Every function is documented with the following format; 'Function Name ''Purpose 'Date 'Author etc... …

Member Avatar for ndeniche
0
61
Member Avatar for ra_rodri

hello all i wrote the a dll using vb 6.0 this dll only has this function: Public Function Impresion(ByVal Nombre As String) Printer.Orientation = vbPRORLandscape Printer.ScaleMode = vbInches Printer.Font = "Arial" Printer.CurrentX = 0.5 Printer.CurrentY = 1 Printer.Print Nombre MsgBox Nombre Printer.EndDoc DoEvents End Function the dlll works fine when …

0
72
Member Avatar for Divya.BS

I dont have any idea of vb script.now i have a requirement. please help me if somebody can.we have created a web page which contains a text box, with two buttons named create and transfer.when we enter a value into a text box in the format yyyymm and when create …

0
52
Member Avatar for leedsy7

hey Really strugling with Access today so i could do with some help :) I'm attempting to add items to a list box. The Sources are 2 text boxes which have been fed to from a querey. So first I tried... lstReorder.AddItem (ITEM_NUMBER.Text) lstReorder.AddItem (ITEM_DESCRIPTION_1.Text) Which brought up the error …

Member Avatar for leedsy7
0
270
Member Avatar for SpnIslander

Hi All, pls help i'm new in programming and trying to make one could you pls help me to correct my code below? What s/b my code if i want to display the value of txtPrice to lblVal and txtQty > txtPrice but if not it will multiply? Private Sub …

Member Avatar for cometburn
0
329
Member Avatar for laoballer

I have a dataset that contains data for a blinking light bulb as a function of time, another for a different light bulb which turns on for a duration of time and at percentage of intensity. What I would like to do is graph a scatter plot of the blinking …

0
72
Member Avatar for Tekito

At one point in my program, if there is an error I need to show a customized form that allows the user to make necessary changes to some data. The code needs to be paused until the user is finished and closes the form. In Access, it is very easy …

Member Avatar for QVeen72
0
82
Member Avatar for rrocket

I am trying to display the results of a store procedure, but cannot seem to get the Move Next to work for me. Without it I am currently only getting the first row. Here is what I have so far: [code=asp] Set x1 = server.CreateObject("ADODB.Command") Set RS = server.CreateObject("ADODB.Recordset") With …

Member Avatar for rrocket
0
166
Member Avatar for TPclan

I am an extreme new comer to C++. Currently I have written a short script in VBscript to delete two specific files on a specific day. This script is set in the start up menu so that it checks for the day of the week. If the day matches the …

Member Avatar for Arne Kristoffer
0
139
Member Avatar for dee2020

Hello I have a module that consist of Ms Chart show out all five month sales amount. Then I can show out the chart either in 2D bar or Pie chart. The problem is each time eg the first time I show the Pie chart, the amount of % of …

0
98
Member Avatar for sandip250382

Friends, I am facing a strange problem with Visual Studio 2005 for few days. While I am surfing online for more than 15 minutes or so, an pop up message shows "An unhelded win32 exception occured in svchost.exe[808]",an error generated by Just in time Debugger,though I disabled Just in Time …

Member Avatar for Jx_Man
0
94
Member Avatar for bornok15

Where can i find in the registry the value of the savesetting function of vb6? im getting the value using GetSetting("Project", "Options", "Auth").. anyone who has an idea on how to find this value in the registry?

Member Avatar for choudhuryshouvi
0
324
Member Avatar for shahriar2403

Is there any way to indicate row number of a datagrid? I mean list1.listindex = 1 means 2nd item of that list box, how can i indicate such type in datagrid? I want to select a row from datagrid and with my given criteria depending on the row number or …

Member Avatar for ritstu
0
89
Member Avatar for jwagman

I am porting an app over from an XP to a 2003 server which has the same version of VB6 installed. However, when I try to compile, I get errors on both the "left" keyword and the icFTP in the following code:frmMain.Inet1.Protocol = icFTP. It is missing the msxml5 library, …

0
52
Member Avatar for kharri5

Hello again, I posted before about reading values from a delimited text file into a class with string properties, and then jamming that class into a dynamic array. It turns out that reading from the text file (which will be updated and contain about 500 lines to start) is a …

Member Avatar for yarfangor
0
565
Member Avatar for radhakrizz

hey ppl i'm using postgresql for backend.. once i connect it to the sever it should disconnect and all the update ,edit should be done offline and others should not edit the data in which im working.. for this i can use FOR update clause,, ???? can some one suggest …

0
73
Member Avatar for alrjr79

I'm trying to create a simple macro that changes header name. Example: header name: vcom#, run macro will change to itemnumber. I want the macro to check the first row for vcom# and change it. The header vcom# will never be in the same cell, it will vary worksheet to …

Member Avatar for alrjr79
0
300
Member Avatar for SpnIslander

Hi All, Pls help to correct my code below. how the Else statement work? i can't get the correct answer it's alway the IF statement is evaluated.tks. Private Sub txtPrice_Change() Dim intVal As Integer If Val(txtQty.Text) >= 0 Then lblVal.Caption = Val(txtPrice.Text) Else lblVal.Caption = Val(txtQty.Text) * Val(txtPrice.Text) End If …

Member Avatar for venkatramasamy
0
109
Member Avatar for msantosh18

can any help me how to create a database and its table in the run time of an application. i need to create new tables also and also specified columns in the table with some record. the application should ask the user to specify the file path also.. help needed …

Member Avatar for QVeen72
0
579
Member Avatar for andyx181x

hello there, i need some help as my teacher gave us a very vague example on random number code and i'm stuck on doing my assigned homework. the assignment is to have three text boxes, generate random numbers between 1-10, and afterwards both automatically added together. so one text displays …

Member Avatar for Jx_Man
0
186
Member Avatar for ThursdaysChild

Could someone plz help? I am trying to do age conversion Enter DOB and find out if the age is 21 or not (date should be mm/dd/yyyy) I'm sure I have something in here I don't really need But, Here goes Dim BirthDate As Integer Dim Answer As Integer Dim …

Member Avatar for Jx_Man
0
102
Member Avatar for Quintillus

I've just started trying to learn how to implement Windows API calls in VB, as the graphics in VB themselves seem to respond rather slowly no matter what computer I run them on, but ran into a couple problems. The graphics at first wouldn't appear until I went over each …

Member Avatar for Quintillus
0
149
Member Avatar for leroi green

Hey all, I am trying to display a message asking if the user is sure that they want to close just before closing. Here's what I've got...and it's only telling me that there's something wrong with the word "Message" after the MessageBox.Show part [code] Private Sub xExitButton_Click(ByVal sender As System.Object, …

Member Avatar for Jx_Man
0
91
Member Avatar for pparker

Hi, Have a quick couple of questions. I have been assigned a project that involves modifying a MS Excel 2003 VBA app so that it gets data from SQL Server 2005 instead of a MS Access database. I'm unfamiliar with Visual Basic in general, and will have to learn about …

0
65
Member Avatar for tarunisgod

[B]When i try to extract the data from a datbase and display it in text area i get the following error message inside the text box:[/B] [code=html]<font face="Arial" size=2> <p>ADODB.Field</font> <font face="Arial" size=2>error '800a0bcd'</font> <p> <font face="Arial" size=2>Either BOF or EOF is True, or the current record has been deleted. …

Member Avatar for pmpn
0
142
Member Avatar for sonia sardana

Dim i as integer=10 dim j as integer=20 In the above two statements, y the error is coming...How can we initilase the values to the variables???

Member Avatar for choudhuryshouvi
0
233
Member Avatar for kartouss

Hello, I am calling a c++ dll in vb... Everything is working fine.. Just i am unable to write the vb code in order to perform the require action... Code for calling the c++ dll in vb [code=visual basic 6]Private Declare Function do_encrypt Lib "AES.dll" (ByVal text As String, ByVal …

Member Avatar for kartouss
0
197
Member Avatar for leroi green

hey guys, i'm working on this assignment in where I have to take a For...Next Loop and turn it into a Do While Loop. I think I've kinda got the coding down but when I try to calculate the rates the program freezes up. I got the code here, any …

Member Avatar for leroi green
0
153

The End.