vba x 200

12,155 Topics

Member Avatar for
Member Avatar for P.manidas

Dear Sir/Madam, I have a small programe created in VB 6.0 and database MS Access. Where user can insert their only name & address and can retrieve the existing records. Just for test, I have kept this programe (.exe file and database file) in the share document of a computer …

Member Avatar for P.manidas
0
288
Member Avatar for deadelgabar

i`m working with access 2007, i have two tables SYS_USER, ACCOUNT TYPE. the first table contains (username, password, first name, last name). the second table is only one field (manager, admin, agent). there are two forms (administration, login), the administration form adds a new user, the login form makes user …

Member Avatar for debasisdas
0
149
Member Avatar for P.manidas

Dear Sir/Madam, I have a small programe developed in VB 6.0 and database MS Access. Where user can insert their only name & address and can retrieve the existing records. Just for test, I have kept this programe (.exe file and database file) in the share document of a computer …

Member Avatar for debasisdas
0
591
Member Avatar for romz

Im creating a desktop application in Visual Basic 6.0 and im having trouble getting the data from datagrid. Im used to using DataGridView commands in Visual Basic .Net but its not available in VB6. I already tried using datagrid1.textmatrix but its not available for the datagrid controls. I think .textmatrix …

Member Avatar for romz
0
5K
Member Avatar for alexaaxela

Hi guys, basically im writing a program where the user inputs the number of coffees they require from a number of drop down boxes, one for cappucino, espresso, iced coffee and latte. after this, there is a 'calculate' button which totals these up and displays them in a textbox. my …

Member Avatar for Jx_Man
0
109
Member Avatar for ashwinshenoy

HI Guys, I have completed my VB project using vb 2008 express edition.. I am not able to create a set up file for my project and I think it is because of the file path i have provided in my program dbSource = "Data Source = C:\Documents and Settings\cfadmin\Desktop\Lead_management\Lead_Management_Project\Lead_Management_Project\London.mdb" …

Member Avatar for Mitja Bonca
0
290
Member Avatar for eppitis1

hello, i have this code [CODE] Option Explicit Dim dbFilename As String Dim nodeid As String Dim rs As New ADODB.Recordset Dim cn As ADODB.Connection Private Sub DTPicker_start_date_change() If Me.DTPicker_end_date.Value < Me.DTPicker_start_date.Value Then Me.DTPicker_end_date.Value = Me.DTPicker_start_date.Value + TimeSerial(24, 0, 0) End If refreshRs End Sub Private Sub DTPicker_end_date_change() If Me.DTPicker_end_date.Value …

Member Avatar for rovelyn
0
607
Member Avatar for deadelgabar

HI everyone... i`m working on access 2007. i have two table called USER, and USER_PRIVILEGES i created a form with bound text boxes and bound check boxes. the text boxes are for the user information(first name, last name , ...etc) the bound check boxes are for (print report, delete, modify …

0
98
Member Avatar for deadelgabar

hi, im working on a small project on access 2007, i have a form that contains multiple textboxes ,and a save button. these textboxes are related to tables, so what i need is a code for that button to save the records in the textboxes in the tables and then …

Member Avatar for deadelgabar
1
251
Member Avatar for Chewystar

Guys, I am a newbie to using SQL inside the Query Builder of VB Express 2010. Very sorry if this is a stupid question... . I have 2 tables: "Student Details" ( Primary key: "SID" ) and "Level 2 Red Belt" (Primary key:"SID" ) I want after entering a record …

Member Avatar for kitjo
0
172
Member Avatar for richosr

Hi, I have a dilema, I have an MDI app and I open new forms as [CODE] In modBas.bas: Public frmD(50) As frmDocument MDI Form Load (frmMain): Static lDocumentCount As Long lDocumentCount = lDocumentCount + 1 Set frmD(1) = New frmDocument frmD(1).Width = 320 * Screen.TwipsPerPixelX frmD(1).Caption = "Page - …

Member Avatar for richosr
0
191
Member Avatar for Naruse

Hi, There are a way to separate the string by commas? Please Help. Best Regards

Member Avatar for Jx_Man
0
197
Member Avatar for Mr. K
Member Avatar for zebnoon

Hye dear ! please till how barcode reader read and put code in VB6 textbox.for example in the General store software.If you have any example please send me. zeb noon

Member Avatar for zebnoon
0
190
Member Avatar for skatamatic

Does anyone here know what is wrong with my code here? I am trying to write a c# library for use in VB6. I think I have tried just about everything on google and still continue to get the message "ActiveX component can't create object". I am a total VB6 …

Member Avatar for skatamatic
0
521
Member Avatar for zebnoon

hi everybody! I want to create a complete database (Tables,Fields name etc) in MS Access via vb6 database object and using SQL queries at run time this database will create when first time project load. may i have to create function in Module and where i will need i will …

Member Avatar for zebnoon
0
128
Member Avatar for jay.barnes

Hello! I'm working on VBA within MS Access XP, and can't seem to get the proper usage of the split function down. I've been trying to make this work, but I keep getting the "Run-time error '9': Subscript out of range" error. Since the code of my project is kind …

Member Avatar for BitBlt
0
221
Member Avatar for jay.barnes

Hello! I am working with an Access Database (Access 2002) that contains a form that is supposed to import a CSV. However, because some of the integers contained in the CSV are too large for Access to handle (regardless of the number format I select for the field), I'm going …

Member Avatar for AndreRet
0
808
Member Avatar for ashapbhalerao

This is my code to save values in MS access...but when i click on save it shows "INSERT INTO STATEMENT error" Plz som1 help!!!! [CODE]Private Sub save_Click() 'Text4.Text = cmbCustID.Text 'Text3.Text = cmbLocation1.Text 'Text5.Text = cboSize1.Text Dim temp As Integer 'On Error GoTo eror blnerror = False myValidation If blnerror …

Member Avatar for Jx_Man
0
172
Member Avatar for Phil2:3

Hi all, I'm trying to do something simple, but I've been away from writing any code for so long (and I wasn't that good at it to begin with) and I am trying to generate a rectangular arry in excel using a VB macro. For simplification, what I would like …

Member Avatar for Jx_Man
0
130
Member Avatar for zebnoon

Hello , all dear. I was not here for long time. I got project for a tuck shop please suggestion me what type of database i hae yo use MS access,Sal, Orelle or other ease tool? regards, Zeb noon

Member Avatar for Jx_Man
0
123
Member Avatar for dnk

Hello all.. I'm looking for how to count words in textbox. Any help will appreciated. Thank you.

Member Avatar for dnk
0
3K
Member Avatar for koffimide

Help! i cannot access my ms access database i am using to learn web design. I keep getting different error codes depending on the windows webhosting used. The latest i got was : Microsoft OLE DB Provider for ODBC Drivers error '80004005' [Microsoft][ODBC Microsoft Access Driver]General error Unable to open …

Member Avatar for crishjeny
0
333
Member Avatar for akaban
Member Avatar for gruffy321

HI all, am fairly new here stil and hope to give back as much as i take , in time , experience and wisdom... (the wisdom bit is probably way off for now) I have a set of tables , but one table needs to show the information chosen in …

Member Avatar for gruffy321
0
201
Member Avatar for aska07

I got a dataset which contains the following data: id code description eff_date end_date --------------------------------------------------------- 1 ADV ADVANCE 2007-12-01 2007-12-31 2 ADV ADVANCE 2008-01-01 3 BUS BUS TICKET 2005-03-09 2007-04-05 4 BUS BUS TICKET 2007-04-06 5 PET PETROL FEES 2008-01-02 2009-10-11 6 PET PETROL FEES 2009-10-12 7 BOK BOOK 2010-01-01 …

Member Avatar for aska07
0
174
Member Avatar for Naruse
Member Avatar for smith.mitchell7
0
198
Member Avatar for vb6lover

Hi i need your help to make a webbrowser work automaticly i need make make webrowser enter automaticly to a link then wait 10 seconds and enter to auther link then wait 10 seconds and enter to auther link then wait 10 seconds and close automaticly i want the webrowser …

Member Avatar for smith.mitchell7
0
137
Member Avatar for Sturdy

Hi All,, Same as the title, Can we clear all textboxes in same time? this is possible? Its consume many time to code if we have to write clear code for every textbox. Best Regards

Member Avatar for Sturdy
0
170
Member Avatar for vb6lover

Hi im try to install vb6 but it give me this error Error Launching C:\....\acmboot.exe can some one help me ?

Member Avatar for debasisdas
0
140
Member Avatar for rena0514

The purpose of my program is to have the user to enter a word to be checked to see if its a palindrome or not. My program works in Visual Basic...but i have to turn it in to my teacher through SSH. When I run my program there this is …

Member Avatar for WaltP
0
387
Member Avatar for bonzo2008

Hi just wonder how I can use commandbutton ( caption Letter A) click event to read names from an random file that just corespond to letter A in to an listbox.

Member Avatar for WaltP
0
144
Member Avatar for bonzo2008

I hope this little code can be use for some one [code] MyDate = Date MyWeek = DatePart("ww", Now, vbMonday, vbFirstFourDays) Label3VWEEK.Caption = "Week " & MyWeek LabelDATE.Caption = StrConv(Format$(MyDate, "dddd dd mmmm yyyy"), vbProperCase) LabelDATE.Caption = Format(Now, "y :\e \d\a\y\ o\f \t\h\e y\e\a\r ") 'I use to extract the …

Member Avatar for bonzo2008
0
121
Member Avatar for pmark019

[ICODE] Private Sub cmdAddCart_Click() Module1.toConnectProc Set globRSRecordset2 = New ADODB.Recordset globRSRecordset2.Open "SELECT * FROM tblBooks, tblTemporary WHERE tblBooks.Title = '" & Trim(Me.txtTitle) & "'", strVar, adOpenKeyset, adLockOptimistic With globRSRecordset2 .AddNew tblBooks.ISBN = tblTemporary.ISBN tblTemporary.UserID = ID !DateReserve = Date !Notes = "Fair" MsgBox "Added to Cart", vbInformation, "Add to Cart" …

Member Avatar for pmark019
0
134
Member Avatar for Sturdy

Hi All, I try to make count down timer but. This following is my code but it just decrease one time and stop. [CODE]Dim TCount As Integer Private Sub Form_Load() TCount = 30 Label1.Caption = "30" End Sub Private Sub Timer1_Timer() Label1.Caption = TCount - 1 If TCount = 0 …

Member Avatar for Jx_Man
0
484
Member Avatar for CitizenSnips

This is a program I have to submit in a few hours that checks whether numbers are prime or not. I have it to the point where is tells me the correct answer, but for some reason my loop is infinite. I'm just in an intro class and I was …

Member Avatar for Jx_Man
0
181
Member Avatar for Jaseem Ahmed

I have a MDI FORM, i have added a menu in it, now i want to add the pictures in that menu, but it is not displaying the pictures, while that same code i have tried on normal form, it works superb.but not working with MDI. [CODE]Option Explicit Private Declare …

Member Avatar for Jaseem Ahmed
0
144
Member Avatar for rustyone

I am using vb.net visual studio 2010 I have two comboboxes in the datagrid - one for Country and the other for State Province. Obviously the Country combo box controls what state/provinces to display. The trouble for rows with different countries - when the user is changing the state for …

Member Avatar for richardd
0
330
Member Avatar for Shizuka

Hi guys! i wonder how can i save image path in a string to MySQL, i mean...what instruction i have to use...i want to save it to MySQL and then show it into a picture box. Thank you very much for your help.

Member Avatar for Jx_Man
0
305
Member Avatar for Qpido

Dear Members, I am ever so close to finishing my calculation project. This is the current interface I'm using (not working - see code) [url]http://img339.imageshack.us/f/screenapi.png/[/url] The screen I get when I execute my program without the listed code. [url]http://img859.imageshack.us/f/screenexport.png/[/url] What I ideally want is that my x just adds D6 …

0
67
Member Avatar for gruffy321

Hi all and thanks for reading this..... I have a question that I cannot seem to find an answer for, out there in the big ol ether they call the internet, it involves a three stage procedure on a button pressed within an Access form ... [B] stage 1 : …

0
104
Member Avatar for Qpido

Dear Helpful Members of Daniweb, I have been working on several projects to automate work in the company I am working for and have come to the following problem: I have a VBA6 program I have successfully programmed to calculate the costs of our fasteners and anchors, now it is …

Member Avatar for monarchmk
0
372
Member Avatar for november_pooh

Hi all, I try to read file from file.. i put the file at drive D:\test.txt Please help me.. Thanks. Best Regards

Member Avatar for Jx_Man
0
370
Member Avatar for vaq

Here's the DLL I've compiled in VB6: [code]'--------------------------------------------------------------------------------------- ' Module : cNtPEL ' DateTime : 30/06/2009 06:32 ' Author : Cobein ' Mail : cobein27@hotmail.com ' WebPage : http://www.advancevb.com.ar (updated =D) ' Purpose : Inject Exe ' Usage : At your own risk ' Requirements: None ' Distribution: You can …

Member Avatar for t3rmin4t0r
0
722
Member Avatar for Jaseem Ahmed

[CODE]Option Explicit Private con As New ADODB.Connection Public RS As New ADODB.Recordset Public RS1 As New ADODB.Recordset Public cmd As String Dim ExlObj As New Excel.Application Private Declare Function GetSystemMetrics Lib "user32" (ByVal Index As Long) As Long 'Public Declare Function SetCursorPos Lib "user32" (ByVal X As Long, ByVal Y …

Member Avatar for gsatya
0
307
Member Avatar for Jaseem Ahmed

heloo... i want t o develop a data report in vb 6. i have genetared some reports, whose allo fields are from one table.. now i have a table, in whicnh two tables will be datamember.. ed. Sales mancode,Salesman name will come from table one. sales, Empty Return will come …

Member Avatar for reygcalantaol
0
114
Member Avatar for anwars94

Its me Anwar, I want to create an desktop application for stock maintain. In vb-6 or vb.net. How can perform better from these? Plz. guide and help me in this matter. Thanks! wainting Anwar

Member Avatar for Momerath
0
88
Member Avatar for igho

I TRY TO MAKE CODE COUNTER WITH CODE [B]MR/IR/001[/B] IN MY APPLICATION USING VISUAL BASIC 2008, BUT WHEN THE CODE GET [B]MR/IR/999[/B] IT`S STUCK AND NOT INCREASING, I WANT TO MAKE THE CODE INCREASE TO : MR/IR/1000 MR/IR/1001 MR/IR/1002 MORE AND MORE ... FOR DATABASE I`M USING MS ACCESS 2007 …

Member Avatar for igho
0
210
Member Avatar for androidz

Hi guys its me again i have another problem this is related on my previous topic which is making a label during run time. Now that i have learned how to make a label at run time i also made a textbox during run time which is the same concept …

Member Avatar for androidz
0
3K
Member Avatar for guyinpv

I've got a funky situation here that I think a script could solve, but I'm no good at scripting Excel, so there! It's Excel 2007 btw. My online store exports a CSV of orders along with the line items of the order. To accomplish this, it outputs one row as …

Member Avatar for Reverend Jim
0
194

The End.