10,989 Topics

Member Avatar for
Member Avatar for shena

Hi all, I have a column with duplicate serial numbers. I would like to find those duplicates and then highlight the whole row. How do i perform this in macro? Pls help anyone.

0
42
Member Avatar for ITKnight

Hi all, I already save my login config at registry. Thanks to Jx_Man and Debasisdas for helping me on previous thread. My following code running nicely. [CODE]SaveSetting "AddressBook", "Login", "Username", Trim(txtUserName.Text)[/CODE] My settings currently saved on "HKEY_CURRENT_USER\Software\VB and VBA Program Settings\AddressBook\Login" How i can save it one level more deeper. …

Member Avatar for ITKnight
0
100
Member Avatar for pito_donje

Private Sub Command2_Click() CommonDialog1.ShowOpen Text5.Text = CommonDialog1.FileName Picture1.Picture = LoadPicture(Text5.Text) Text5.Visible = True End Sub

Member Avatar for pito_donje
0
135
Member Avatar for ITKnight

Hi all, I want to save some form setting at registry, my friend told me that vb has a function to save it.. what it is? and how to use it? Please Help Thanks

Member Avatar for ITKnight
0
700
Member Avatar for ITKnight

Hi all, How i can split a string that include spaces by "&" ? I already used split function but there are problem with spaces. thanks.

Member Avatar for ITKnight
0
208
Member Avatar for yineth888

i need to write a separate program (this program is not connected with my assignment) to validate e-mail, phone number, group, GPA so far this is what i have...i need help please Private Sub btnEmail_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnEmail.Click Dim Symbol1 As Integer Dim Symbol2 …

Member Avatar for debasisdas
0
91
Member Avatar for sidnei

Hey, guys (and girls...)! I'm in trouble with (like it seems to me) a little bug on Hierarchical FlexGrid control... Let me explain: I want to merge some content between cells. I made it many times before, but in the FlexGrid control, not the Hierarchical Flexgrid conrol - for sure, …

0
224
Member Avatar for Jaseem Ahmed

i am having some problem in navigating records... when i am moving any record next, it moves record by record nect,and also it moves previous,but when i either press last or first, then these both next and previous button do not work.. here is a code. [CODE] Private Sub movefirst1_Click()'it …

Member Avatar for Jaseem Ahmed
0
1,000
Member Avatar for doremon89

Can anyone help me show how to upload file into database which is ms access. The file can be document,picture or video..Anyone???

Member Avatar for doremon89
0
48
Member Avatar for Jaseem Ahmed

can u pass an idea... is this is possible to plus all that items(Integer) that are in listbox or listview... e.g a list box have 4 items... 1)-20 2)-40 3)-80 4)-100 is this possible to plus these items,??? items also can b infinite, depends upon user...i dont have any idea, …

Member Avatar for AndreRet
0
137
Member Avatar for jogieglenmait

hey. i had a question regarding activating and making command buttons control visible in a form by manipulating it from another form. ex. form 2 command button will be activated by manipulating it in form 1. i had this syntax for form 1 cmdActivate [CODE] form2.cmdAdd.Enabled=false [/CODE] will form 2's …

Member Avatar for jogieglenmait
0
101
Member Avatar for josephbeluan

HI, I'm new to VB6 programming and i need some help of anyone to please help with my problem. I want to know what do I need to do or know before to create a code that connect VB6 to my SQL. and if you desire please give a sample …

Member Avatar for Jx_Man
0
117
Member Avatar for StephNicolaou

Morning all, Unfortunately I am currently working with Access VBA. I have a simple method; moving an object on a form: [code] button.Top = button.Top - 20 [/code] However on click, I receive the 'Invalid Outside Procedure' message, including: *The exression may not result in the name of the macro, …

Member Avatar for StephNicolaou
0
167
Member Avatar for ben25x

Hello everyone. I am looking to see if there is any possible way Visual Basic 6.0 code can run in Visual C++ 2008 Express. Any help would be very appreciated.

Member Avatar for Ancient Dragon
0
431
Member Avatar for JerieLsky

Hi.. another post from me on how to retrieve a picture of a certain person from MS Access Database using the OLE Object.. Any one who can show me some samples how? Thanks for the time.

Member Avatar for doremon89
0
190
Member Avatar for ben25x

I have figured out how to create command buttons and have tried to change their general color, but to no avail. This is what I tried, but it did nothing: [CODE]Option Explicit Dim WithEvents Com As CommandButton Private Sub Form_Load() Set Com = Me.Controls.Add("vb.commandbutton", "BtnName") With Com .Left = 100 …

Member Avatar for WaltP
0
4K
Member Avatar for Jaseem Ahmed

can u help me regarding listview control in vb 6... i want to use listview as datagrid.. i have 3 textboxes, and a list view with 3 coloums. now when i enter data textboxs, it asks "do u want to add another data?" when user enters so data, how much …

Member Avatar for peter_budo
-1
297
Member Avatar for Jaseem Ahmed

i want to delete selected record from listview and database, but when i press delete button, it deltes onlye first record of listview not selected record... here is code...[CODE] Private Delte_Click() Call Mydatacon Dim rs As adodb.Recordset Set rs = New adodb.Recordset rs.Open "SELECT * FROM AAAAA_DEMO", con, adOpenStatic, adLockOptimistic …

Member Avatar for Jx_Man
0
1K
Member Avatar for saddas

hello all, i really hope you can help me. im trying to get a list of customers which are in my database to show up in a combo box but with the code i currently have, it only shows the last record that was entered [CODE]rs.MoveLast With Me.Combo1 .Clear Do …

Member Avatar for saddas
0
157
Member Avatar for Thamizh Bharat

Hi, How do I write a VBA function to display blank if I want to refer to a blank value in pivot? Excel shows 0 in such cases. I don't want to handle this using [CODE] =IF(formula="","",formula) [/CODE] since it involves repeating the formula twice. Please let me know how …

0
55
Member Avatar for vedel
Member Avatar for PM312

Hi I have program where multiple forms remaine open at a time. I dont want user to move away from last opened form unless he closes that form. i.e last opened form should not lose focus by clicking on other forms unless active form is closed. How it can be …

Member Avatar for WaltP
0
566
Member Avatar for ashvyas

HEllo, After dat RFID TAG detection program, now i want to move 1 step further. Like if TAG is Detected as 012234F13A Now weneva dis code is detected, it must fetch a name from Database For example, m designing a Library system From RFID There must be two fields, 1. …

Member Avatar for ashvyas
0
124
Member Avatar for vinothmca

In My source code folder near they are lot of TMP file(temporary file Creating) so how to stop that all

Member Avatar for debasisdas
0
62
Member Avatar for cryzone77

i am a freshman IT student and im making a citizen records database for my thesis... i would like to ask help from you guys with my codings, ms access relationships and errors. errors: empty row cannot be inserted. access relationships: how do i make a one-to-many relationship with enforce …

Member Avatar for AndreRet
0
220
Member Avatar for Jean Pion

Dear People, I want to use the ListView with larger images. For this I use the ImageList with images of 120x80 pixels. Now for each ListItem I have two images. With a timer I want to alternate the imahes like: [CODE] Private Sub Timer1_Timer() Dim i As Integer For i …

Member Avatar for AndreRet
0
407
Member Avatar for shielaolid

[CODE]Private Sub Form_Load() Call dbConnect Call DBRS strstudinfo = "SELECT Members.StudentID, Members.LastName, Members.FirstName, Members.MI, Members.Sex, Members.Address, Members.Age, Members.Birthday, Members.[Time Returned], Members.[Date Returned] FROM Members" [B]rsstudinfo.Open strstudinfo, dbcon, 3, 3[/B] Call datafill Call disabling 'strstudinfo = "INSERT INTO Members(StudentID,LastName, FirstName, MI,Age,Address,Birthday,Time Returned,Date Returned) VALUES (" & txtmemstudid.Text & ", '" & …

Member Avatar for debasisdas
0
184
Member Avatar for bunnyali2011

Hello who knows how to create a search box in Visual Basic? I want the search box based on streamreader. In proper terms, when I will input a text, it has to read on a text file in drice C. I know the streamreader code but don't know the code …

Member Avatar for Nick Evan
0
772
Member Avatar for cryzone77

hi! i am making a nso system(a citizen record system w/ ms access as database) i dont know how to make it work: there is a citizen, then under the citizen there is subdatasheets namely: father, mother, sibling 1-5. all i managed to do is have ONE subdata sheet under …

Member Avatar for debasisdas
0
109
Member Avatar for doremon89

My project is like this. Firstly we will key in the product ID in "search" button. After it finish search and highlight the product ID,I must click the product ID where it will shows another listview which contains the detail of that product. Can anyone help me??URGENT

Member Avatar for debasisdas
0
74

The End.