vba x 200

12,155 Topics

Member Avatar for
Member Avatar for satti

iam facing a problem ,i want to add a form to my project from another project,when i add the form and try to run it give me error,i dont know what is the problem i have added its module and database also but still giving me [COLOR="Red"](ERROR:Run time error 3709 …

Member Avatar for reygcalantaol
0
185
Member Avatar for vinothmca

I am Using Datareport but the label name was once i changed but not Changing new name in properties Caption is name New Changed name but not showing,showing only last name,so how can i change it?

0
62
Member Avatar for ZER09

hello to all, i got some problem in vb 6 in reports. actually i tried to create a simple ordering system, and i used ms acces for my database, now the problem is that when i generate a report it will show the first data of the row of the …

Member Avatar for ZER09
0
128
Member Avatar for satti

Hi , i use enable choice function to enable or disable the ADD button for data grid. now when i tried to use the code for update button its not working.. need to add cmdUpdateEntry. here is the code..[CODE]Sub EnableChoice() ' disable to remove button ' check to see if …

Member Avatar for satti
0
236
Member Avatar for happy006

Hello, I had convert my program from vb6 to vb.net, how come there is a error when i debug?? [url]http://img51.imageshack.us/i/debugerror.jpg/[/url] Pls help me, URGENT!!!!!

Member Avatar for happy006
0
410
Member Avatar for pito_donje

Public Declare Function SystemParametersInfo Lib "user32.dll" Alias "SystemParametersInfoA" (ByVal uAction As Long, ByVal uParam As Long, ByVal lpvParam As Any, ByVal fuWinIni As Long) As Long x = SystemParametersInfo(97, 1, CStr(1), 0) 'Disable Ctrl+Alt+Del Keys combination 'Use as in --->>> If KeyAscii >= vbKeyA And KeyAscii <= vbKeyZ Or KeyAscii …

Member Avatar for Jx_Man
0
99
Member Avatar for vinothmca

I am Using datareport When i was add the data and print to ok the output of report has Previous datas all are showing? so how can i get current data alone?

Member Avatar for reygcalantaol
-1
177
Member Avatar for j23

Im trying to write a program which simulates ten coin tosses and returns the results to the user .can anyone help please!! [CODE] Imports System.IO Imports Microsoft.VisualBasic.ControlChars Public Class Form1 'write a program that simulates 10ncoin tosses using Random Number generator + Returns the results to the user. Private Sub …

Member Avatar for j23
0
1K
Member Avatar for Anthonynz

Hi. I have written a process that takes a list of values from a spreadsheet and updates a foxpro table, adding records if they do not exist, or updating them if they do. I determine if the record exists by a seek command, which works fine. But if my process …

Member Avatar for sidnei
0
278
Member Avatar for TheDocterd

Hi There I just wanna find out how I can save some data to a text file or access database (doesn't matter - the one that's the quickest). What my form does is it has a list box with ID's in it. I can select them. Then I have a …

Member Avatar for AndreRet
0
205
Member Avatar for pito_donje

on each form is the "X" at the top right of Form. how ya how to disable or remove "x" is it?

Member Avatar for Jx_Man
0
133
Member Avatar for jasneg16

i'm trying to make a hangaroo game imitation but i dont know how to make the 4 labels to individually be marked as "X" when i click the wrong letter. i made all the letter answer invisible and the "X" mark invisible [CODE]' the Answer is "PLANTS VS. ZOMBIES" Private …

Member Avatar for jasneg16
0
109
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
49
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
116
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
153
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
715
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
220
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
99
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
256
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
1K
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
68
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
154
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
109
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
137
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
177
Member Avatar for Casper3912

I have a assignment which requires the use of multiple files. I don't believe I am linking them together correctly. I'm using visual basic 2008 at the moment. Ofter I get the program working I'll create a make file and test that. I'm also not too familiar with the string.h …

Member Avatar for thekashyap
0
195
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
447
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
209
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 aladar04

I have this code in the add button. The recordsource of the grid is a local view. Record is not updated after thisform.grid1.refresh. also tried thisform.refresh but it still not work. [CODE] SELECT teybolinboys APPEND BLANK replace c_id WITH thisform.txtcus.Value replace p_id WITH thisform.txtpro.Value replace selldate WITH thisform.txtdat.Value replace quantity …

0
82
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
168
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
63
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
583
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
143
Member Avatar for Khaldoun Latif

any one here can help me to make access database and connect it to a visual basic 2010 program and update and retrive information from it please help me if you can

Member Avatar for Khaldoun Latif
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
74
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
251
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
460
Member Avatar for BeansForChowder

I need help building a program that displays full-time and part-time employees names and salaries when the user uses a radio button to choose either full-time or part-time employees. It's a program from the Getting Started with Visual Basic 2010 but I can't determine which part of the chapter specifies …

Member Avatar for BeansForChowder
0
178
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
189
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
802
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
118
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
93
Member Avatar for bunnyali2011

magine there is search box (textbox), and below there are a search button with a rich text box. My text file located in the drive C is like this: Product: Cement Size: Big: Cost: 245 Type: Construction Product: Iron Size: Big Cost: 123 Type: Consruction Product: Glass Size: Small Cost: …

Member Avatar for bunnyali2011
0
451
Member Avatar for satti

iam using datagrid for data entry ,i have added ,add button remove button...but now i want an update button which can update the entries to database from data grid... here is code [CODE]Option Explicit ' couple'o global vars for size trackin' Dim MinHeight As Long Dim MinWidth As Long Private …

Member Avatar for AndreRet
0
209
Member Avatar for jaai

i got a type mismatch run time error 13 in the following line of the load event of my form... pls help me [CODE] set rs=db.OpenRecordset("SELECT * FROM STOCK") [/CODE]

Member Avatar for AndreRet
0
147
Member Avatar for pseudorandom21

I'm just wondering how programmers rate their own skills, for instance I haven't been using C# very long, but I do feel I have a good grasp on the language. If I see on a job listing: "* 3+ years C# or Visual Basic.NET " What the heck is 3+ …

Member Avatar for abelLazm
0
145
Member Avatar for Xcelled194

Hi all, I must admit I'm rather stumped by this one. I have a program that handles tickets/prizes for a business. Patrons obtain tickets, and then go to turn them in at a counter. An employee counts their tickets, and inputs that number into my program. The program then displays …

Member Avatar for Xcelled194
0
168
Member Avatar for martin11ph

Does VB6 have any feature that allows it to plot points and maybe lines in a 3 dimensional axis? I tried using the MS Charts component but it only allows up to 2D. Any help would be appreciated. Thanks.

Member Avatar for martin11ph
0
420

The End.