vba x 200

12,155 Topics

Member Avatar for
Member Avatar for kehar

Hi I have used three combo box in VB 6 form one for selecting date one for month and one for year. If the selection is say 12/07/2007 then I need it to be converted as 12/07/2007 under one field i.e date field of access database. So how can I …

Member Avatar for hopalongcassidy
0
125
Member Avatar for WhitePunk

i have a code of a projectile but... can these code be shorten or not??? i need new version of this and some times if i played this one some error was done hope you could help me to fing the error Option Explicit Dim Angle, Theta, y, x, t, …

0
96
Member Avatar for stargazr

how to declare dynamic 2 dimensional array in vb with one of the bounds variable .. [code] dim x(1 to i,1 to 4) as variant 'i is a variable [/code]

Member Avatar for shasur
0
429
Member Avatar for nuBudDy

hi all, i have problem creating queries in access.this is because i do not know how to call the value from a variable in vb into the query in access. let say in vb i've created : [code] Public booking_date As Date Public fac_type As Integer . . . . …

Member Avatar for kehar
0
180
Member Avatar for ambi

Hi friends i have a question here.. i am using Win Xp SP2.....i have installed VM ware Player on which DebianEtch linux is running... there in Debian Linux i am runnint say telnet service on port 23... earlier i had some executable through which i had forwarded the port 23 …

0
119
Member Avatar for lcssat

hi plz help for encode File winRar (*.rar) to oder software sample encode *.rar to *.mdb or *.avi

0
79
Member Avatar for stargazr

i want to pass 3 parameters to my data report in VB 6. [code] Private Sub DataReport_Initialize() DataEnvironment1.Command1 (Form1.txtregno.Text,form1.cstd.Text,form1.cinstlno.text) End Sub [/code] i am getting compile error. expected '=' plz help..

Member Avatar for stargazr
0
142
Member Avatar for zanaja

I created one Function in VC++(which is COM EXE) which i want to call from my VB code. I am passing Arguements as Variants from VB. In VC++ i filled SafeArray in those Argument.But after returning its showing Empty.. Here is my VB Code Private Sub Form_Load() Dim obj As …

0
65
Member Avatar for louislam123

I have several drop lists on my form, with either numbers or names on them. I want to change it so each item on the drop list has a certain "value" to it. For example, if a was "1" on my first drop list and hello was "23", wen I …

Member Avatar for choudhuryshouvi
0
133
Member Avatar for leovicAustria

Hi, Can anyone help me with this..!!! I found an error stating that "Unrecognized database format" How can I solved this..I am currently using VB to link my MS access 2000 database using DATA object, Please help me..Thanks..

Member Avatar for choudhuryshouvi
0
137
Member Avatar for aynn

have a nice day everyone. please help me....how to make data report. now i already make data environment.. but i'm stuck in data report. how to import from access to data report?...please...

0
66
Member Avatar for yogesh_vaidya12

I want to begin to create dll in visual basic 6.0. Can anybody give brief idea or examples.

0
76
Member Avatar for mohammadalipak

I'm logging employees' internet access for compliance with company policy. As soon as an employee visits a blocked site, he is redirected to a warning page (on the intranet). This warning page gets their IP addresses & emails them to the IT department. [COLOR="Red"]I also need their usernames.[/COLOR]I have found …

Member Avatar for cguan_77
0
710
Member Avatar for locsin

Greetings! I have database file with dateformat on a field. I want to view the data on files according to its date range using vb6. Like for example i want to view a file for starting date = 23/10/2007 upto 23/11/2007. Range of date is one month from starting date …

Member Avatar for kehar
0
141
Member Avatar for studgirl

I'm in the end of my final year project which is the time of developing. I'm confuse to use which program language to do my project as all current programing language i have a very basic of it only. current basic knowledge i have in are java, programing c and …

Member Avatar for Ramy Mahrous
0
181
Member Avatar for hawisme000

hello every1, really i need help on how i can make a login form that works and is connected to my database using ADO my frmlogin is composed of 2 textbox (txtuser,txtpass) and 2 command buttons (cmdlogin,cmdcancel) and my database name is (MAINDB2) inside MAINDB2 is (tblReg) fields inside tblReg …

Member Avatar for hawisme000
0
242
Member Avatar for hawisme000

again im in need of help =( how can i show a random cell in a field on a textbox?? suppose my database(access2003, and using ADO) is -->MAINDB-->tblQuiz-->the field inside is "Question" and my form have 3 textbox.. when i run it, how can it display a random data from …

Member Avatar for hawisme000
0
97
Member Avatar for npstyler

[COLOR="Red"]Hey Frens, I Have to disable date time permission from VB but I'm not getting how to do this can we fix this problem ? [/COLOR]

0
89
Member Avatar for lz300

I have built an arcade cabinet from which I will play Mame, Daphne (Dragon's Lair) and pc games (like Warcraft, Quake, RTCW, etc). I bought a joystick control (Xgaming Tankstick) which does [U]not[/U] have an Escape button. I'm using VB6 to build the GUI that will drive the whole thing, …

0
79
Member Avatar for hawisme000

hello every1, really i need help on how i can make a login form that works and is connected to my database using ADO my frmlogin is composed of 2 textbox (txtuser,txtpass) and 2 command buttons (cmdlogin,cmdcancel) and my database name is (MAINDB2) inside MAINDB2 is (tblReg) fields inside tblReg …

Member Avatar for hawisme000
0
130
Member Avatar for AUALZ

Hi, Does anyone know how I can get the file name for the linked tables? I have linked the tables and renamed them. I am able to get the renamed name shown on table tab, but not the actual FILE NAME that i originaly linked the table. I am using …

0
70
Member Avatar for Prozeen

Hi, how do I use the EOF function with an Excel spreadsheet? I'm thinking that the EOF needs a file number. But in my code below, I don't have a file number. What do I need to do? Any links, code, info available? Thanks.[code]Dim app As excel.Application Dim book As …

Member Avatar for Prozeen
0
788
Member Avatar for powersakthi

Actually my requirement is some thing like this... I'm writing a parser which has standard xml format which will be written in a file like this "<TESTDATA><FACTORY NAME=""SAKTHI"" TESTER=""" & Getcontent(97, ":", 1) & """ /></TESTDATA>" and this parser has to watch a folder constantly and then once file is …

Member Avatar for powersakthi
-1
178
Member Avatar for lampie

Hello! I have problem here... I want to separate 12-07-1007 into 3 parts, which are day(12), month(7), and year(1007). I have made a function to do this separation and it works well. But i wonder if there is exist a [B]function in VB [/B] to do the separation? Thank U... …

Member Avatar for ramlisarip
0
176
Member Avatar for JohnKelly

Dear all I am writing an App in VB6 and I want to trap the Mouse Wheel scroll. I have search on the web and found how to hook the windows messages. I set the hook on Form.Activate and then Unhook it in Form.deactivate. This all seems to work OK …

0
86
Member Avatar for nschessnerd

Hey does anyone know a way to make a program run at a certain time? no... i dont wantto use task scheduler basically a person sets a time in my program and it runs a method at said time. Ideas? Thanks m

Member Avatar for nschessnerd
0
100
Member Avatar for me_j

I've a 'Birthday' form wherein when i click on Search command button, an input box is displayed. In this input box, i type in a month and when i click on OK i want details of all those students whose birthday falls in that month.i'm using ADO Data Connection.

Member Avatar for choudhuryshouvi
0
84
Member Avatar for ramlisarip

hye..i'm really new to visual basic.i just know a simple coding. i have a project in my university. it is about vehicular communication system. can anyone help me to build auto send program?is it possible??:?: it should be something like this. pc A can sent msg to pc B at …

0
67
Member Avatar for ziong
Member Avatar for fgarcia90

i need a vb code to pop-up the save dialog box in some time i inicialy put in another simple dialog box in a start of all the programs i work and i will will put this program

Member Avatar for debasisdas
0
138
Member Avatar for locsin

Hi everyone! It is possible in visual basic 6 to save and open picture file on a database like nortwind sample database program in Microsft Access. Anybody have idea to save and open picture file on a database using visual basic 6. thank you in advance

Member Avatar for debasisdas
0
48
Member Avatar for choudhuryshouvi

Hi, all here is my question:- My application uses vb6 as front-end,ms sql server7.0 as back-end. i connect my apps with the rdbms using an odbc dsn connection. now i've created some reports for my apps using crystal report 8.5. the print is going well. now i want to export …

Member Avatar for debasisdas
0
90
Member Avatar for shahriar2403

Let, i have a msàccess db with 3 tables having 'cost' field in all of them . Now in my report i want to 1) Show the sum of costs of indivisual table under the heading of each table (let $3000 for every table) & 2) show the sum of …

Member Avatar for shahriar2403
0
103
Member Avatar for laupitajs

Sorry for the nooby question, but could you help me find some list (extensive preferably) of commands for visual basic? I am very new at this, but i would like to make some macros'es that would take over some extensive formulas that i usually just enter in excell. :) I …

Member Avatar for agrothe
0
77
Member Avatar for kehar

Sir, I have prepared programme using VB6 and Access2003. The programme is working very fine so far as adding,deleting,modifying the record through VB is concerned. I have installed Crystal Report 8.5 and have prepared a report and save as (bill.rpt) but I dont know how to connect the report with …

Member Avatar for choudhuryshouvi
0
523
Member Avatar for aynn

hello. how to do if when we double click at list view, then the information from list view will be appear at label. many times i tried but always debug (run time error '_2147217904(80040e10) 'no value given for one or more required parameter) . Private Sub ListView1_DblClick() checkConnection strSql = …

Member Avatar for choudhuryshouvi
0
96
Member Avatar for jhowell

hi to everyone, Im creating an application which it can show all records of the two tables in single form. its like costumerTable and OrderList. how can i show a record of specific costumer from costumertable together with his product order details from OrderList table. Supposed I have costumerNo field …

Member Avatar for jireh
0
1K
Member Avatar for pramesh

hi, Every one, i am creating a from .in this i have calender control and label buttons avilable. i click calender day . i want to display the date at label.. give me a suggestion.

Member Avatar for kb.net
0
58
Member Avatar for leovicAustria

Guys please help me. I'll try to create a program which computes average for the entry of students grade through NOTEPAD..The file "Scores.txt" is in my desktop. If ill try to run my program this error appears: ""run time error 53" file not found". What should I do. Where will …

Member Avatar for leovicAustria
0
156
Member Avatar for leovicAustria

Hi guys, can you please help me. Is it possible to get data from NOTEPAD,Store each data into a new table of MS-Access, Thanks..God bless

Member Avatar for choudhuryshouvi
0
115
Member Avatar for avanthik

Can anyone help me in creating a VB code to send data to the serial port using VB6. Have to send three hexa bit streams each with a 1ms delay. Thanks

Member Avatar for leovicAustria
0
49
Member Avatar for shahriar2403

Let,in my msaccess db there is 3 tables. Now in my report i have to show 1) The datas of each table wth a heading of table name, sum of each table data( let $3000 summing all datas on that table ) under the heading, and 2) Sum of all …

0
84
Member Avatar for ReeciePoo

[code] [COLOR=#000000]] Dim GETWORD[/COLOR] [COLOR=#000000] Dim GETLINE[/COLOR] [COLOR=#000000] Dim ARRAYNUMBER As Integer[/COLOR] [COLOR=#000000] Dim itmx As ListItem[/COLOR] [COLOR=#000000] [/COLOR] [COLOR=#000000] [/COLOR] [COLOR=#000000] nFileNum = FreeFile[/COLOR] [COLOR=#000000] Open "C:\Documents and Settings\Reece\My Documents\I.T\Visual Basic\Reece\client.db" For Input As nFileNum[/COLOR] [COLOR=#000000] If Input(LOF(nFileNum), nFileNum) > "0" Then[/COLOR] [COLOR=#000000] GETLINE = Input(LOF(nFileNum), nFileNum)[/COLOR] [COLOR=#000000] GETLINE …

Member Avatar for reeturaj
0
357
Member Avatar for JaceDBN

Hi, I have created a database using Access 03 and VB, and I will be letting some people use it shortly. I would like to create a way in which the program cannot simply be copied onto another computer. I was thinking of using VB and referring to some system …

Member Avatar for kb.net
0
114
Member Avatar for rajksarswat

Is there any method to assign the particular number to the current page number control in data reports using vb6.0. This is required to assigned the continous page numbering for the different report generated by the Data Report.

0
65
Member Avatar for kingflux

Hello-- I have an ordering screen that displays hundreds of items in a datagrid and provides a blank for the user to enter a Quantity. Datagrid "CatalogGrid" is bound to a datasource which is based on the System.Collection.CollectionBase class. If the user has entered a Quantity on a row, the …

Member Avatar for ptaylor965
0
260
Member Avatar for CLAY ROBINSON
0
57
Member Avatar for wmr30075

I have created and populated an Excel workbook with 3 worksheets. Sheet1 contains data; Sheet2 and Sheet3 are empty. I massage the data in Sheet1 and enter the output into Sheet2. I would now like to delete Sheet1 and close and save the Excel file. I am embarressed to say …

Member Avatar for binoj_daniel
0
124
Member Avatar for bakedsushi

I am making a simple payroll program that keeps track of my hours, jobs, descriptions, etc. It also keeps track of the checks I've gotten. I have three main tables: Hours consisting of date, time started, ended, total hours, customer, job, description, Payperiod number, I know this one could be …

Member Avatar for choudhuryshouvi
0
350
Member Avatar for damyna

Hello,Am new and I want urgent help.AM submiting a program in Oct And most of the functions are not working.For Example, am Trying to have search function but a failing to work.Am using visual basic 6 .Am using Ado as the Jet engine.Email me please with ideas and [email]sugestions.damyna@gmail.com[/email]

Member Avatar for jasimp
0
102

The End.