vba x 200

12,155 Topics

Member Avatar for
Member Avatar for wamcclintock

Experts, I'm new to VB and I'm trying developing a VBA application to send and receive data to an RFID reader and put the result into Microsoft Access. Project has: Mscomm command1 (command button) Text boxes (Text1, Text2) At this stage i have developed the following code. [CODE]Private Sub Command1_Click() …

Member Avatar for emond
0
3K
Member Avatar for xtianenikkian

i need to now how i can answer "yes" or "no" automatically when excel asks to save to clipboard.

Member Avatar for xtianenikkian
0
60
Member Avatar for Goitseone

with this codes i created rectangle image with a line inside that has to mimic a single clock. Dim MyGraphics As graphics=e.graphics my graphics.Draw Rectangle(pens.colour,x1,X2,y1,Y2):whereby x1=60,x2=70,y1=80,y2=90,and choosen colour my graphics.Draw line(pens.colour,x1,x2,y1,y2):whereby x1=60,x2=70,y1=100,y2=120,and also choosen colour. Now help me with ideas and solution here.the hand or line within the square has …

Member Avatar for BitBlt
0
189
Member Avatar for jgab

Hi I'm new to vb6, i just wanna ask something.. i want to create a Progress Bar race game in vb6, my question is how do i randomize progress bar speed?assuming that i have FIVE Progress Bars, any help is appreciated..thanks!:)

Member Avatar for BitBlt
0
144
Member Avatar for thamim.it
Member Avatar for Netcode
-1
2K
Member Avatar for leecker

I need to average the last 4 data points in a row, i can do it in columns but not rows. Here is what I have (This is using "SUM" I can replace with "AVERAGE") B C 1 2 Month Qty Months Total 3 Jan-10 10 3 240 4 Feb-10 …

0
74
Member Avatar for AK47

I am creating a business software package in visual basic.net that will handle invoices, quotes, purchase orders, inventory items, customers, etc. This program is multi-user meaning that different people could each be running an instance of the program on their computer, with each instance modifying a central database. The problem …

Member Avatar for gearup4it
0
319
Member Avatar for Midar01

Pease please help.. with visual basic 2008. I am trying to get ListView to work but it does not for me. I already set up ListView with 3 colums, but the coding is not working first column called ITEMS, second Quantity and 3rd is PRICE. All items are on Buttons …

Member Avatar for Midar01
0
163
Member Avatar for Amit33sharma

Please help me for developing a vb6 application for accessing multiple web cams simultaneously (is there any example source code in vb6.0) Thanks, Amit

Member Avatar for creophagist
0
1K
Member Avatar for lovelydan

i want to design a module to count each assets on a table so i can generate an aggregated data report of for each item. this is where i got stuck:Help! [CODE] Private Sub countAssets() Dim mydb As Database, MysetAssets As Recordset, MysetSoftware As Recordset Set mydb = DBEngine.Workspaces(0).Databases(0) '............................................................................ …

Member Avatar for BitBlt
0
110
Member Avatar for Wheen

An application that I am making uses a web browser object to watch videos from YouTube (From an embedded link like [url="http://www.youtube.com/v/fregObNcHC8"]this[/url], not a regular link). The problem is that when the user clicks anywhere in the web browser object, it screws up some other aspects of the application. How …

Member Avatar for Wheen
0
104
Member Avatar for acidking001

good day all.. While I am compiling a vb6 project, the error highlighted this: format(date,"YYYYMM") Can anyone help me? Thank u very much..

Member Avatar for BitBlt
0
276
Member Avatar for lianpiau

I develop a cash bill system. when a salesman have more than 2 order no paid, then cannot insert order. (1 order can contain many item, if in database can have same order no. but different product). database field : - name(text), paid(boolean),orderNo(text).and so on ...

Member Avatar for debasisdas
0
83
Member Avatar for shena

Hi experts out there, I'm populating records from access db. The condition is that if the first column has been filled with 5 pairs of records (10 rows and a row of gap between each record), then move to next column and so on. How do i accomplish this? Kindly …

0
47
Member Avatar for SuperJunkeh
Member Avatar for WaltP
0
147
Member Avatar for churva_churva

[CODE] Private Sub cmdCancel_Click() txtcode.Text = "" txtdescr.Text = "" txtumsr.Text = "" txtqtyh.Text = "" txtuprice.Text = "" End Sub Private Sub cmdSave_Click() Dim itemcode As String * 10 Dim descr As String * 10 Dim umsr As String * 10 Dim qtyh As Integer Dim uprice As Currency …

Member Avatar for BitBlt
0
201
Member Avatar for Archades

So I am working on a small project. A video game uses a scripting engine called LUA so people can create their own UI modifications in game. Which is why I am also using LUA. I am trying to convert this LUA function into a VB.NET function and... [ICODE] local …

0
105
Member Avatar for Brewerb

Hi I know how to create new excel menus using VBA but I am new to vb.net and would like to know if it is possible to use vb.net to creat additional menus within/for Microsoft Excel. I can't seem to find anything on this on the web :sad:

Member Avatar for Netcode
0
234
Member Avatar for gurushankar

Hi All, I have to test a wsdl. I am using XMLHttp object in VBscript. I have to specify an operation in the script, I am not sure how i can do that. xmlObj=CreateObject(XMLHttp object) xmlObj.open "post",[U]ESDL File Location[/U],"False" xmlObj.SetRequestHeader "content-type",[COLOR="Red"]"applicatin/mentioned the application i need to access"[/COLOR] xmlObj.send RequestXML 'I …

0
71
Member Avatar for TrueCoding

Hi Im new here-I wanted to create a Login System. I am using Visual Basic 2008 Express Edition, Microsoft Access 2007/2010 Beta. Ok this is my current code-the main problem I have is that I dont how to compare what the user puts into the textboxes and then check that …

Member Avatar for karthi5390
0
11K
Member Avatar for BARATUM

My assignment is using mobile 6 sdk for testing and code is visual basic In my assignment, i able to add record to txt file and view it at listview, now i want to delete the record file by check the checkbox at each row of listview and click delete …

0
72
Member Avatar for adri00713

what i wanna do is when i click timein button the selected value in my combobox will appear in the datagridview that i created too would someone so kind help me with my problem thank you so much !!!!!!!!

Member Avatar for adri00713
0
117
Member Avatar for mariegomez84

Hi, everyone! I'm kind of in a hurry. I need to know for tomorrow how can I open a file and get the file name. I was using the Common Dialog and with ".Filename" I could be able to get the name. It was easy and it worked!! The point …

Member Avatar for WaltP
0
701
Member Avatar for honey17

can somebody tell me the coding of " how to make a list box so that if I write any alphabet in search text box and the list box show the hints mean all the data resemble to that alphabet???" Its quite like a dictionary in which we write a …

Member Avatar for jogieglenmait
0
134
Member Avatar for rajeshgs

how can i convert date such as 20/03/2011 0r string 20032011 to twentieth march two thousand and eleven

Member Avatar for Coco Chanel
0
694
Member Avatar for Coco Chanel

Hi! I'm new and I'm not very expert with the basic code. How can I shutdownn the pc whithout using a file batch or some elements out of my program?

Member Avatar for Coco Chanel
0
122
Member Avatar for Goitseone

What's happening in this commands:Dim StudentName As String,Dim pincode As Integer,Studentname = "David",pincode=2011

Member Avatar for debasisdas
0
99
Member Avatar for S.N.Mazumder

I prepared a simple database in ms excel. Now I want to link it with ms visual basic 6.0. I want to enter data in ms visual basic form and it will update my excel database/ spreadsheet. How to link a record in ms excel with visual basic 6.0 ? …

Member Avatar for rexgb_34
1
6K
Member Avatar for Prasadbabu

HOW TO WRITE SQL USING CRYSTAL REPORTS 9 IN VB6? Dear Friends, I designed one INVOICE crystal reports9 using vb6 and connected with access database. It was displaying all the records. Now i want to display particular invoice number. I used below code. but its not executing. default code only …

Member Avatar for Prasadbabu
0
1K
Member Avatar for ravikant_scn

Hi Experts; I am creating a project and I want user can move my form inside of the screen only. How can I do this ? Please help.

Member Avatar for BitBlt
0
121
Member Avatar for wilson sweet

How can i write a program that creats a password and a username using Visual Basics 6.0

Member Avatar for Netcode
0
96
Member Avatar for Muhasin

I was developing a login box. But when i give the id and password it never checks for the sensitivity of case. It accepts both capital and small letters if they are same. What i do?

Member Avatar for Netcode
0
116
Member Avatar for bantex07

Someone can gave me a code for search as u type searching from may MS ACCESS DATABASE Thx GOD SPEed :P

Member Avatar for bantex07
0
128
Member Avatar for xtianenikkian

Is there any code to create or generate bar codes in vb6? Please help me, advance thank you for all that will respond :)

Member Avatar for xtianenikkian
0
95
Member Avatar for xtianenikkian

Good day guys, im just wondering if there is a notes, functions or code related to print, i just want to come up with a good hardcopy of the information every time the employer request it. my source is adodc1 or datagrid

Member Avatar for xtianenikkian
0
160
Member Avatar for Luvme

just wanna ask if how to print your from adodc and datagrid which is from access using vb6? tnx in advance

Member Avatar for xtianenikkian
0
90
Member Avatar for jheanal

what is the code in timer if the user enter a negative number a dialog box will appear saying that is invalid !! NEED THE ANSWER ASAP THANK YOU

Member Avatar for debasisdas
0
105
Member Avatar for hanky

Hi, Please let me know how to resize an Image with form resize event. Also I will have to limit the size so that the image size is not larger than the scrreen width and so small so that the text in the Image is illegible. Also, please let me …

Member Avatar for Awon02
0
279
Member Avatar for churva_churva

[CODE] public i As Integer Dim num(18) As Integer Private Sub cmdEntry_Click() For i = 0 To 18 Step 1 num(i) = InputBox("Enter a number:", "Array", 0) Next i grd.TextMatrix(0, 0) = "Array" For i = 0 To 18 Step 1 grd.TextMatrix(grd.Rows - 1, 0) = num(i) grd.Rows = grd.Rows …

Member Avatar for BitBlt
0
140
Member Avatar for m1234ike

Hello, I am starting this thread to inquire about if anybody knows any ways to manipulate an image by dragging the perimeter of the image and by doing so, re-shaping the image. I.E. A web site logo or company banner with some text inside a Superman diamond. Sounds cool? Does …

0
90
Member Avatar for wouterkind

I have a similar issue (somewhat) -- VB6 and Access97 My code in Option Explicit is [CODE]Dim dbs2 As Database[/CODE] In the Private Sub Form_Load(), I have [CODE]Set dbs2 = OpenDatabase("C:\Program Files\members\members.mdb",True,False)[/CODE] The Run Time Error I get is: Couldn't find file 'C:\Program Files\Members\Members.mdb'. In the Debug: When the cursor …

Member Avatar for wouterkind
-1
144
Member Avatar for jamielli

Please help. I have an excel file, I wanted it to search for a word let's say "marketing" from column A5:CH5(or maybe more) and wanted it to copy the entire columns that contains the word marketing next to the original columns. There will be more than 1 column that contains …

Member Avatar for Netcode
0
119
Member Avatar for oglatinoloco

I have a project, I was tasked to make an interactive map of the Philippines using vb6. When you click on a certain region/city/town, a window would pop-out showing the notable event, land marks, & info of that location. The problem is i don't know how. Please help me.

Member Avatar for slepnot
0
183
Member Avatar for johnsong4

So I have a program that is supposed to support a small business. I have the work completed and the professor said it was correct but I wanted to go do a little extra. Basically, on the Order screen, you begin to type the name of a customer/supplier/employee into a …

Member Avatar for johnsong4
0
170
Member Avatar for mikefromchitown

Hi, I'm trying to use a variable to import a text file. Is it possible to change the path and filename below to a variable? I would like to change "L:\GEAM Data.txt" to a variable "fname", which a user previously entered using Application.GetOpenFilename. [CODE]With ActiveSheet.QueryTables.Add _ (Connection:="TEXT;L:\GEAM Data.txt", _ Destination:=Range("A1"))[/CODE] …

Member Avatar for ibancracker74
0
138
Member Avatar for xtianenikkian

Im currently working now into a monitoring system Adodc2.Recordset.AddNew Adodc2.Recordset!employeeNumber = txtNumber.Text Adodc2.Recordset.update now i've noticed that after i input a value and save it. it goes to the bottom of the datagrid, how can i add value in the top of the datagrid? Thanks for the reply in advance

Member Avatar for xtianenikkian
0
137
Member Avatar for rosiec

I have a basic comment page (code below) that I made in Visual Studio 2010 using GridView and FormView. The user fills in the text boxes, the info is put into the database and then inserted into my GridView. I want to password protect the form, so that not only …

Member Avatar for hericles
0
263
Member Avatar for faroukmuhammad

Hi guys, What does the [B]owner[/B] in [B]show[/B] method do and how does it work. Thanks in advance. [CODE]FORM.Show([Modal], [Owner])[/CODE]

Member Avatar for faroukmuhammad
0
189
Member Avatar for deepmadan

I am developing an application in VB6 which will communicate using UDP Connection to a hardware which recieves and sends data using UDP Connection. My Hardware works fine. It has already been tested with an application written in VisualC using UDP connection only. In VisualC, I had working on UDP …

Member Avatar for BitBlt
0
599
Member Avatar for Marc Smets

Hi there, Is use Now()-1 in VBA to achieve the date of yesterday in a query. What is the syntax for it in basic. Thx

Member Avatar for Marc Smets
0
98

The End.