10,991 Topics

Member Avatar for
Member Avatar for jogreenwood

Hi, I do need help with following problem. We have a password protected excel sheet with *complicated* macros in VBA. VBA code is protected, but some of our traders can still copy whole xls file and run it on private computers (strictly prohibited, but they violate rules and do it). …

Member Avatar for ghimangi
0
145
Member Avatar for misterjay3

Can someone help me with this???? [CODE]/****************************************************/ /* File: name of your file with the source code */ /* */ /* Created by: give your name */ /* Date: give the date */ /* */ /* Program to find the maximum of three */ /* floating point numbers */ /* …

Member Avatar for Sumyungi
0
114
Member Avatar for Masterace

hi everyone can someone please help am trying to convert numbers to words but there no response at all when i run the prog. i used the codes below [CODE] Function Getword(strNumber) Dim strtemp As String Dim x, y, z As Integer x = Val(Mid$(strNumber, 1, 1)) y = Val(Mid$(strNumber, …

Member Avatar for akaban
0
3K
Member Avatar for rcmlopez

I am working on a project that opens xml files into a TreeView window. I am able to import xml files into my window by using the following code... Private Sub Form_Load() Dim sFile As String sFile = App.Path If Right(sFile, 1) <> "\" Then sFile = sFile & "\" …

Member Avatar for vb5prgrmr
0
104
Member Avatar for rumpleteaser33

Hi, I'm writing my first application in VB and need some help with my Access database. I have 2 problems; the first one is the most important, the second I would just be very grateful for any help/advice. Firstly, I need help updating a record from my database. I have …

Member Avatar for kevinnrobert
0
154
Member Avatar for Giffordw

I've inherited a project which pulls data from 2 DB (*.mdb), one is access 97 and one is access 2002. DAO 3.6 is referenced. We use OpenDatabase and OpenRecordset instructions. When running, we get "Unrecognized data format" error or error code 3343 when attempting to refresh any table in the …

Member Avatar for Giffordw
0
65
Member Avatar for PinoyDev

Good day guys. I want want a little help of my query. The tbl_ entity: tbl_1(UserId(AutoNum ber - set as primary key),Validity(Date/Time)) [code=vb] dim logonid as long rs.open "SELECT * FROM tbl_1 WHERE UserId='" & logonid & "'",conn, adopenkeyset,adlockoptimistic [/code] It returns an error invalid data type expression. But when …

Member Avatar for PinoyDev
0
102
Member Avatar for jazzy2816

I'm having trouble trying to specify a counter for three loops to control the animation time. At the same time the application must display the current position of the button to move at any time as well as the current values of two increments.

Member Avatar for vb5prgrmr
0
43
Member Avatar for promisess

hi, i have a form that his size changed with the selected toolstripmenu like menu1 menu2 if menu1 checked the size will be 420,220, and if menu 2 size will be 220,220. the debugging alwas start from the original form doing on vb how i can start the debugging as …

Member Avatar for vb5prgrmr
0
72
Member Avatar for kelvinteh

Hi, I have this problem which I do not know how to solve in VB. I have to read from a text file, but only write selective lines to a new txt file. E.g. (original text file) ============================================ SINNWSQ .SINFMSQ 230606 SSM LT 23MAR00323C108 NEW SQ 3328 01NOV04 31DEC20 2 …

Member Avatar for vb5prgrmr
0
118
Member Avatar for prakashmanuel
Member Avatar for vb5prgrmr
0
48
Member Avatar for Comatose

Swaps Two Elements Of An Array (So that say, indice1's value would become indice2's value, and vice versa). Simple Code Piece Really...

Member Avatar for vb5prgrmr
0
254
Member Avatar for lamakun

Hi all, I am a PHP programmer with no knowledge on VB, so I apologize for my intrusion :). What I need is to split a .doc file with N pages into N different documents, using the first word of each page as the name of the documents. In php …

Member Avatar for vb5prgrmr
0
172
Member Avatar for TMARES

Good Day, Im new to visual basic. i created a simple database form using microsoft access as my database. my question is how can i create a browse button or text box where i can change the database path at runtime. please help. Tony

Member Avatar for abu taher
0
89
Member Avatar for hp.rios

Would anyone please help me transfer data from a specific datagrid line at vb6 to a bunch of textboxes ???

Member Avatar for abu taher
0
54
Member Avatar for kuteinheart

Hey ppl, I am fairly new to ms access & VBA... I have a list box and a command box in my form... The list box contains all the car brands like chevrolet, toyota etc., I have table with fields ItemName which has all the list of car names (Camry, …

Member Avatar for vb5prgrmr
0
78
Member Avatar for dfs3000my

Hi I would like to read ActiveCell.Value as it is in my macro. E.g. Even if i have #VALUE!, it will treat it as a string and read it. Can this be done?

Member Avatar for Yiannis_Sp
0
52
Member Avatar for Amorah

You are turning 21 on the 10th of May and you are having a party. A large marquee has been ordered for the occasion that will seat a maximum of 50 guests. Your parents are very particular about your mates as the party will be at home in your folks’ …

Member Avatar for puppykillaz
-1
88
Member Avatar for akaban

hello i am trying to make a program for prime numbers but facing some problem can any one can help me in making this program

Member Avatar for akaban
0
240
Member Avatar for gsatya

Hi, I have certain data stored in tamil font (TAM-TTValluvar) I am creating a text file using PRINT #1,<fieldname> through VB6. The output in the text file looks like a bunch of junk characters and I could not able to take the printout from my dot matrix printer either by …

Member Avatar for vb5prgrmr
0
401
Member Avatar for Simple

Hi friends, I have implimented a project. I connect it with Access database but problem is that I don't know how to make it as a Installaton file which can run on other machine (System) that donot have Visual Basic. Plz. give me the solution.

Member Avatar for kinwang2009
1
891
Member Avatar for needHelpVBA

Hi there :-) Your help is highly appreciated! I just don't know how to start... I already read a book, but I didn't get the knowlegde I need to key in the code. It is supposed to be a multiuse financial tool. I already have most of the mathematical backround, …

Member Avatar for jhai_salvador
0
69
Member Avatar for cabsjonel

good evening folks its me again, folks i need your help in flexgrid idont know how to use it in editing a database, can you give me some sample program thanks folks may god bless you:)

Member Avatar for asaukani
0
435
Member Avatar for edowen14

Hello, I have made a database system, when the database opens a login form appears and the username and password need to be typed into the text boxes. if admin is the username then the main switchboard. but if you log in as driver then a report opens. the trouble …

Member Avatar for edowen14
0
253
Member Avatar for syns
0
45
Member Avatar for mrk_chiz

I have a table in a database named "tblstudentnumber" it has the following columns: stud_id stud_fname stud_lname stud_address stud_age stud_course i need to have a data report using data environment that can sort all students with the age(a user input) of let say "16". i have a form, it has …

Member Avatar for abu taher
0
194
Member Avatar for danish_k12

Hi, I m making a software which calculates the hours worked by each employee per day. This is calculated by the in time and out time of the employee. I have the database which contains the in time n outtime of the employee in sql. Now, My problem is i …

Member Avatar for kinwang2009
0
195
Member Avatar for Jackgrt

Will vb run an old gwbasic .bas program? My problem is to lprint to a usb printer, and if I have to learn vb, so be it. thanx Jack

Member Avatar for kinwang2009
0
233
Member Avatar for C0DER

[B]Hello everyone,[/B] I am looking for a way to get hidden files fron a folder and then list them in a listbox control. Could someone help me with this? this is the code i got so far: [CODE]Sub hidden(path As String, list As ListBox) mypath = path MyName = Dir(mypath, …

Member Avatar for C0DER
1
101
Member Avatar for rumpleteaser33

Hi I'm doing a project where I need to have people register by entering a username and password. When they click register I want them to be added to the database, but I'm having trouble doing this. Can anyone help? This is my first time using VB. This is the …

Member Avatar for rumpleteaser33
0
235

The End.