vba x 200

12,155 Topics

Member Avatar for
Member Avatar for problematic:)

hi! can someone help me with my problem, I'm using msaccess2003 and vb6. I've been trying to determine how can I save data using one form to two database. the scenario is like this, I have one form, the details of some information of the customer will be input in …

Member Avatar for Mark Alonzo16
0
193
Member Avatar for newbie26

hi please help me..how can i add checkbox in a listview? i already set the properties of listview checkboxes to TRUE. but it appears in the first column..i wanted it on the last column.. is it possible?? or the other way: programmatically move the first column (with checkbox) to the …

Member Avatar for newbie26
0
307
Member Avatar for Klahr_R

I do very little programming these days, but I try to maintain an application for our church that maintains most of it's bookkeeping and report generation. The application is all done in Excel/VBA, using many forms and several workbooks. Yes, we are using antiquated programs (XP/Office 2003) because we are …

Member Avatar for Klahr_R
0
379
Member Avatar for samer_control

I need a help for adding icon for my file association to be visible not as unknown file format i the explorer............

Member Avatar for johnangolluan
1
979
Member Avatar for Mireya B.

Hello, I am using VBA userform in MS Excel to insert data for database purpose. When I tested it for the first time, it was running okay. But after I saved it and used it again to insert the real data, it happens to repeat/duplicate the data to multiple times …

Member Avatar for Stuugie
0
330
Member Avatar for stefanm981

i need help about visual basic website click buttons without id. Html Code: <div class="likeBox"> <span class="like-active" style="display:none;"></span> <div class=" ghostLink"> <a class="like hintable" hint="Like" href="javascript:void(0)" onclick="if (!Profile.likesBlocked()) { Profile.quickLike('#like_box_53117043234'); $.ajax({data:'authenticity_token=' + encodeURIComponent('6S2x01Deqy77H5OYvhxaDVyncWWcQavyOsTuw7J52/M='), dataType:'script', type:'post', url:'/likes/qwert1312/question/53117043234/add'}); }; return false;"></a> </div> </div> <div class="likeList you-like-block" style="display:none">You like this</div> <div class="likeList people-like-block"></div> …

Member Avatar for Member #949455
0
154
Member Avatar for mirzabaig

Dear sir, i have desinged import application project in vb6.0 and data base connectivity ms-access using, But here first line may be problem importing because first line is information about the data then next numberical are imported properly,so my requirement is importing csv file and datareporting possibly can you sent …

Member Avatar for GeekPlease
0
1K
Member Avatar for taolas

Hi, my name is taofeek. am new in vb 6 environment, i ve little hider about the program and i wish to learn more about it. can some body put me through. Thanks.

Member Avatar for GeekPlease
0
369
Member Avatar for GeekPlease

Hello folks, I'm currently studying how to use LinQ in VB.NET but I guess I'm stock. I'm using VS 2008 version (framework) 2.0 Anyone who can help me get through this??

Member Avatar for GeekPlease
0
308
Member Avatar for Skate Bart

I have a MSHFlexGrid that gets all records via a recordset from a database. I want to add a search function so that it would search for the data entered by the user on to the search textbox. But it should search for the data only in a certain column …

Member Avatar for jamunadevi.v
0
1K
Member Avatar for jemartalaban_1

hi, i cant do my codes on how a combo1(i) will do its command when clicked, i have 10 combo box that have index from 1 to 10 on my form, when combo1(1) was clicked, it will do my command to that combo1(1) only not in combo1(2),combo1(3) ... to combo1(10) …

Member Avatar for rishif2
0
202
Member Avatar for Vixion

Hello there, I want to get all checked checkbox on the form. I always wasting my time to checking it one by one. There is a way to do this? Best regards vixion

Member Avatar for star.tamy.7
0
592
Member Avatar for PratikM

Hey guys, Hope y'all are doing well. So I'm just a newbie programmer that knows the very basics of some languages. I know the basics of C, C++, Java and Visual Basic -not exactly sure which language that fits into but I learned it alongside C- and yeah. Right now, …

Member Avatar for Dani
0
85
Member Avatar for rushimaadhav

I have a problem during making my project . the problem is I programmed it like if we press 123 a message box pops saying something when I type 456 I programmed it like a msgbox pops up and says something but when I run it the first time I …

Member Avatar for GeekPlease
0
155
Member Avatar for MichaelRyan

Hi folks...get into the wayback machine. :) I have a VB6 program I'm drastically modifying due to vendor API changes. This isn't my natural language, so I have to hack around every time I change things. Problem now is that the program won't end. I know it hits the END …

Member Avatar for GeekPlease
0
409
Member Avatar for johans22

I have a text file with one of the lines as : name=AB,CD,EF I read the line like this: input# line,str first str is name=AB then the next line is CD and then EF, why it does not read the whole line at once.

Member Avatar for rishif2
0
152
Member Avatar for Reverend Jim

I find that I occasionaally have special projects where it would be nice to have a context menu for files. I tend to write housekeeping scripts and it is convenient to be able to run these scripts against one or more files at a time without having to navigate and …

0
1K
Member Avatar for The X-Man

Hey Everyone, I'am Using vb6 data enviourment and Access 2010 to show an Invoice in a Data Report. I Have many orders and many different items in orders. So I select an order from a MSHFlexgrid and will load the report. All The different items (in different orders) are stored …

Member Avatar for The X-Man
0
337
Member Avatar for skyshare

I am using VB6 to execute an sql statement. I have two access tables and want to insert the contents of a field in one into the other subject to the key no being the same. I have been unable to get it to work and would appreciate some help. …

Member Avatar for Reverend Jim
0
140
Member Avatar for ponnu

I am trying to compare one column of an excel sheet with the database table.If the value in the column matches with the data in the table,the excel has to be populated with another value in the table in a new column.If match is not found the value in the …

Member Avatar for Reverend Jim
0
143
Member Avatar for DickEM

I've fought the Error 91 problem for years programing (self taught) in VB 6. Below is a simple example of a program getting data from a database and putting it into a grid. I know I'm supposed to use Dim and Set statements, but I've never figured it out. Can …

0
77
Member Avatar for baabjitvk

hi when i'm giving some string to search in the data base, ms access, that search is going to be ignoring case. i want case sensitivity. how..? ex: if i would like to search for the word "Done", if there is no that word, and "DONE" is available in the …

Member Avatar for tinstaafl
0
119
Member Avatar for alaya
Member Avatar for divakar.it

Hi, As part my developement I would like to keep all employees document stored in database table rather in folder. I dont want to store the files in folder and keep the file location in table so that get the file from the location. I tried my level best in …

Member Avatar for usiegd
0
664
Member Avatar for Sweet_pink
Member Avatar for raizuke.blademaster

help guys, i need to know how to add images and video files (if its possible or just its file path) on access database to be retrieve in vb6 with every images and videos filename included (can be displayed on a separate label for example)

Member Avatar for ROBBOHORT
0
236
Member Avatar for taolas

Thanks to Daniweb, My Name is Taofeek oladosu, am from Nigeria, i work with IT firm presently and i study computer science Education. Basically what i do is purely education of which i love software and IT generally very well and i want to start with Visual Basic. am an …

Member Avatar for JorgeM
0
41
Member Avatar for Victoryy

Hi All, I am developing a windows application which uses Ms Access Database. The code is working smoothly in Visual Studio. But, when I create a setup for that project and install it on any machine. I am not able to write data in that datbase. I think its because …

Member Avatar for Victoryy
0
218
Member Avatar for joeyliew7

how do i convert this code to VB? i am new in VB.Pls help. ABC (int xyz) { If xyz==0 { return(0) } else { return (xyz + ABC(xyz-1)); } }

Member Avatar for joeyliew7
0
241
Member Avatar for jemartalaban_1

hi , can u help me ... my problem is the recordset must be based on the text in the textbox like that, but its not working. conp.Open ("Provider=MSDASQL.1;Persist Security Info=False;Data Source=PAYMENTS;Initial Catalog=payments") rsp.Open ("select * from &Text12.text& where Term='" & Text10.Text & "'"), conp

0
91
Member Avatar for bruce.feist

Situation: My VBA program compiles, but fails at runtime when I try to access a specific method. It doesn't seem to matter whether I set the method up as a function or a property get. Here is the code fragment which calls the method: ****** Function roots() As Variant ' …

Member Avatar for WetCoastLife
0
433
Member Avatar for mickeygee99

Hi I am currently on placement but I am very keen to gather some ideas for my final year university project. Has anyone got any good ideas on which to base my project using VB? I am just looking for ideas which I could look into and research further. any …

Member Avatar for dineshpaatil
0
439
Member Avatar for jemartalaban_1

any remainders,tips or pointers for using fingerprint scanner in vb6 ? im using win7, please can u help me

0
91
Member Avatar for geraldike

Good day pals. please i need a VBA code that could make ms excel automaticly tell the maximum point of a curve in a chart. Secondly, another code that would make it automaticly tell the Y-value of the point of interception i.e when two series or range of values are …

Member Avatar for ddanbe
0
193
Member Avatar for White King

Hallo, Am Having Ebilling And Invoice system project.In Report Section am having error as variable not found. code- cr1.windowState=crptMaximised - ERROR Cr1.ReportFileName=App.Path &"\reports\billsummery.rpt" cr1.DataFiles(0)=App.Path & "\data.mdb" cr1.action

0
63
Member Avatar for Stuugie

Hi All, I met with some people from a private firm that has been hired to automate some data flows from PDF files to Excel and then to SharePoint. I wrote some VBA code for them to brute-force-test and they were impressed with what I had accomplished. The one fellow, …

Member Avatar for Member #949455
0
447
Member Avatar for jemartalaban_1

hi, im my database there are COUNTRY NAMES and its CAPITAL, my problem is using adodc1.recordset if i selected a country in combo1 the label1.caption beside the combo1 will change into its capital. example Combo1[PHILIPPINES] : Label1[MANILA] can u help me thanks advance :)

Member Avatar for Ancient Dragon
0
112
Member Avatar for rahul.gour

Public Function FTPFileTransafer(ByVal Host As String, _ Public Function FTPFileTransafer(ByVal Host As String, _ ByVal User As String, _ ByVal Password As String, _ ByVal Serverfilepath As String, _ ByVal LocalFilePath As String) As Boolean On Error GoTo FTPError Dim intFTPConnect As Integer Dim intFTPPutFile As Integer FTPFileTransafer = False …

Member Avatar for tinstaafl
0
273
Member Avatar for Pixelzzz

I have a numeric field that I am calling in from an access backend. If the length of the field is less than 6 digits, I want it padded with 0 at the front => as a leading zero/s. How do I implement it in crystal report? eg: 2567 I …

Member Avatar for GeekPlease
0
237
Member Avatar for Stuugie

Hi All, Since most of you are professionals and I'm trying to be a professional at work I thought I would pop this question at you. Have you ever had one of those days where your coding stinks, errors are difficult to find, and no matter how you proceed with …

Member Avatar for Reverend Jim
0
159
Member Avatar for LeNenne

Hi I have a lstdata3 with 4 emails in it and I will that thoose shall come up in a textbox seperated with ; at the end of each. the lstdata3 list is with the checkbox enabled so I can choose wich I will use. a commandbutton is used to …

Member Avatar for LeNenne
0
150
Member Avatar for schroaus

You know how if you open up options in many applications you are no longer able to click to the side of the program until you have either hit ok or cancel. I was wondering if this is possible to do with a program in visual basic, and if it …

Member Avatar for tinstaafl
0
250
Member Avatar for TheOneTopCat

I need to populate a listbox from a textfile that contains data from a workshop class. The class contains the definitioin of the properties (FIELDS) of the workshop class. The text file looks like this. 0\3\800\Programming in Java 0\3\800\Programming in Visual Basic 0\3\800\Programming in C# 0\5\1500\Advanced Java 0\5\1500\Advanced Visual Basic …

Member Avatar for GeekPlease
0
606
Member Avatar for daniel1977

I am wondering why the techniques do not transfer between VISUAL BASIC & C# programming languages Thoughts? Dani

Member Avatar for GeekPlease
0
70
Member Avatar for dossm

hi i want vb6 code help. 00:01:00 + 00:05:00 = 00:06:00 00:10:00 - 00:05:00 = 00:05:00 i want the result is same format.

Member Avatar for rishif2
0
131
Member Avatar for mridul.ahuja

Normally it seems that every vb 6 compiled exe file requires atleast MSVBVM60.DLL in Windows system folder, is there any way to make a **standalone exe** (without any dependencies) ?

Member Avatar for Reverend Jim
0
176
Member Avatar for LeNenne

Hi I wonder how to extract just rs("Email") from this code If rs.RecordCount = 0 Then Exit Function End If rs.MoveLast rs.MoveFirst max = rs.RecordCount rs.MoveFirst LstData3.Clear For i = 1 To max LstData3.AddItem rs("Email") rs.MoveNext Next i I have 10 different person in the databas but only 3 with …

Member Avatar for Jx_Man
0
162
Member Avatar for jemartalaban_1

hi im using vb6 on win7 64bit with my digital persona u.are.u 4000 , my u.are.u 4000 cd is only compatible for winxp so i looked for win7 compatible and i got 1 so the scanner start working,and when im trying to capture my biometrics with the scanner using vb6, …

Member Avatar for tinstaafl
0
104
Member Avatar for haviansyah

First You Must Download ODBC 5.2w at http://dev.mysql.com/downloads/connector/odbc/ Next Open Your ODBC And click Add ![11](/attachments/large/4/11.jpg "11") Next click MYSQL ODBC 5.2w Driver ![21](/attachments/large/4/21.jpg "21") Click Finish And ![31](/attachments/large/4/31.jpg "31") Click OK and Click OK Again Creating Your MYSQL Create Database With Name data Create Table with name user_data CREATE …

Member Avatar for jemartalaban_1
1
4K
Member Avatar for burnweb

Hi, Im trying to make an order for an invoice that will take in some details like name, number and have an array of product details like price, qty. It uses variables used in class mods. See if you can make sense of this. Sub webservicetest() Dim NewOrder As New …

Member Avatar for burnweb
0
243

The End.