vba x 200

12,155 Topics

Member Avatar for
Member Avatar for vonnoy

need help here guys! i want to open record from form1 and form1 composed of two listview namely listview1 and listview2 if i choose listview1 or listview2, form2 will appear and data will display in labels then if listview1 was selected then save it on table 1st_sem and listview2 on …

Member Avatar for AndreRet
0
113
Member Avatar for Krs13

Hi, I have an access database where in i have 3 separate fields for day, month and year which are comboboxes. I have an separate field where i need to combine these 3 fields into that single field(dd/mm/yyyy). can somebody help me on this please.

Member Avatar for rishif2
0
129
Member Avatar for sheena.sabado.5

Hello daniweb folks. I am here to ask some guidance, tips, suggestions and advices regarding the round robin scheduling algorithm. We are tasked to solve for the waiting time and turn around time of each process. They all have the same arrival time which is zero. here is my codes: …

Member Avatar for sheena.sabado.5
0
306
Member Avatar for t2nator

How can the following code be change so the children form move event is smoother? Dim isMouseDown As Integer Dim MyX, MyY As Integer Private Sub Form1_MouseDown(ByVal sender As Object, ByVal e As System.Windows.Forms.MouseEventArgs) Handles Me.MouseDown isMouseDown = 1 MyX = e.X : MyY = e.Y 'Me.Cursor = Cursors.SizeAll End …

Member Avatar for t2nator
0
143
Member Avatar for vonnoy

i have search box,listview and 3 labelcaption namely: fname,lname and total. my database name is students and table name attendance. if i search particular student and display in listview, once i click the name on the listview automatically display on the labels, and display total number of records of that …

Member Avatar for AndreRet
0
2K
Member Avatar for opera-rotas
Member Avatar for squigworm

Hello, I am trying to run a simple loop and am having trouble. I would like for this loop to run through the data in an excel spreadhseet and analize column "p". Upon analisys, the macro will create a new worksheet each time it encounters a new digit in coulmn …

Member Avatar for demon916
0
337
Member Avatar for aliyahkusnan

excuseme :) sorry I have some problem here, I make a simple paint using vb 6.0 I already can save the image that I load, but something like brush and pencil that I draw in the image can't include :( after I save and open it, it just the image …

Member Avatar for Jeff-Bennett
0
3K
Member Avatar for sheena.sabado.5

Private Sub cmdSimulate_Click() Dim comm As CommandButton Dim zi As Long, ki As Long Dim shorts(10) As Integer, count As Integer Dim temps As Integer, z As Integer, n As Integer, m As Integer, i As Integer If typeSched = 1 Then temps = 0 btnP(0).Width = Val(txtBT(0).Text) * 100 …

Member Avatar for sheena.sabado.5
0
658
Member Avatar for mark.scutt.7

Hiya, I have 10 people and need to assign 10 random numbers between 1 and 10 for random seating purposes each time.My code so far is below but assigns sometimes the same numbers. How can I make it so that once a number is used it won't be produced for …

Member Avatar for AndreRet
0
970
Member Avatar for dan.ni.aiza

*It's my first time here but the way I see things around here is good * I'm a newbie in VB2010 so please don't judge me too much... HERE is my codes for INSERTING DATA but the problem is I don't know how to use it for SEARCHING Imports System.Data.SqlClient …

Member Avatar for Reverend Jim
0
260
Member Avatar for brendalyn.quiba

hi i cant seem to make the search code for my program work . . how is this so . .? this is my code: Private Sub cmdSearch_Click() With Adodc1 .RecordSource = "Select * from PATIENT where Last Name='" & txtSearch.Text & "'" If .Recordset.RecordCount = 0 Then MsgBox "No …

Member Avatar for AndreRet
0
142
Member Avatar for rishif2

hello experts . . . i've designed a form (two textboxes and one commandbutton) i wanna display id and user(fields of the table). and i display id and user on the basis of the id(inputted through textbox1).And for that i've written following code within command button's click event Private Sub …

Member Avatar for rishif2
0
164
Member Avatar for arasten

I made a program that makes someone think his desktop cleaned up, its just for fun and make me learn a littel bit of codes because i'm still a beginner in programming i'm 16 years old in high school grade 11 so i wanna learn more codes because at school …

Member Avatar for pritaeas
0
5K
Member Avatar for learningcoding

I am making a visual basic project and using MS Sql database as datasource. Now my problem is if I will use the project's .exe file on any other machine which has MS Sql already installed, then will the application will start using the database on its own or do …

Member Avatar for pritaeas
0
187
Member Avatar for Bile

-->>Hello, I hope I can get help on this its like this... -->>I have an application that allows a User to brows files in a Computer... -->>On My point of interest Zipped files,that's My filtering Criteria... -->>When the File wiht .zip is found it is displayed on the Textbox very …

Member Avatar for AndreRet
0
161
Member Avatar for vonnoy

i have my two database namely: "data1st.mdb" and "data2nd.mdb", then my combobox items are "1st_semester","2nd_semester". if i chose combobox "1st_semester" then all values inputed from the txtbox will directly save to "data1st.mdb", then 2nd_semester combo save to data2nd.mdb.i got no idea with this. thanks a lot. please help me with …

Member Avatar for vonnoy
0
116
Member Avatar for major_lost

Is there a way to get the hard drive letter with VB 4.0? I have an older program written in this language that I am attempting to modify and need to get the hard drive letter to update it. Thanks for your help. major_lost

Member Avatar for TnTinMN
0
408
Member Avatar for gsatya

Hi friends, I need to know how the auto responding softwares work. for example if I send keyword IBAL to 567666 I will be receiving my current bank balance through sms. Is it possible to develop such software using vb6? if so I need basics to communicate withe GSM/CDMA modem/Phone …

0
153
Member Avatar for Jake.20

Guys i need help or tips about allowing only one dot in calculator and i'm using button. could you guys provide me some tips on how to do it? Thank you in advance.

Member Avatar for Jake.20
0
300
Member Avatar for keth
Member Avatar for peter_budo
0
190
Member Avatar for sarman.boyslo

hi all, newbie wanna ask... :) if i have a button, normally (before it clicked) the button is just like usual, but if i clicked it, in the button appear dotted line, how if i want to before and after he button clicked without dotted line? please see the pict, …

Member Avatar for sarman.boyslo
0
300
Member Avatar for 2mhzbrain

i connected and migrated all the things from access to mySQL (online) using free hosting on the net, when i make my simple program to .exe, then run it on different computer, its asking for some OCX and dll files... why is that happening? my .exe program run well on …

Member Avatar for 2mhzbrain
0
291
Member Avatar for rishif2

hello experts `rec.Open "select * from tbl where id="& inputted, con, 2, 3` i used the above code to find records and now the real problem occures when a value is inputted and that doesn't exist in the database so in such a case i wanna display en error message …

Member Avatar for AndreRet
0
148
Member Avatar for vonnoy

i search record from the present form then i want to load it in another form for editing and saving the record. here's my code but its always error. With list_stud .label1.caption = ID_no .label2.caption = lvStudentInfo.SelectedItem.SubItems(1) .label3.caption = lvStudentInfo.SelectedItem.SubItems(2) .label4.caption = lvStudentInfo.SelectedItem.SubItems(3) .label5.caption = lvStudentInfo.SelectedItem.SubItems(4) .label6.caption = lvStudentInfo.SelectedItem.SubItems(5) .Show …

Member Avatar for tinstaafl
0
190
Member Avatar for shanaka895

Hi... I want to create a project to use in my cd's.So I want to create a button, when I press it should open a new window and browes the cd.Please help me guys... thank you soooooooooo much..

Member Avatar for AndreRet
0
197
Member Avatar for viktoriaong

need help mybe this site can help me with my vb6 class.., i'm trying my best in our lab.class but still i'm having hard time with the codes and logic of the problem that our instructor give us. i don't know why but in our java class and object-oriented class …

Member Avatar for AndreRet
0
136
Member Avatar for vonnoy

can anyone help how to save using this code below.? i used adodc recordset with adodc1 .ConnectionString = connectdb .RecordSource = "Select * from 'tablename'" .Refresh 'dont know the next action end with 'what does this code mean?

Member Avatar for vonnoy
0
229
Member Avatar for rishif2

how to make a mdiform fixed size(can't be resized or maximize) as there is no property like border style in mdi.

Member Avatar for AndreRet
0
150
Member Avatar for QUADCOREDELUX

I Have these Programming Project In School Using Visual Basic 2005 Express, we were assigned to do a First Come First Serve Simulator however it's just my Second Year in College and I'm No good in Programming cause I'm not majoring in IT.. Any one can help me on how …

Member Avatar for Reverend Jim
0
522
Member Avatar for t2nator

I'm having trouble figuring out how to fill a dynamic array function and then print it on declaration. Here is the function: Public Function SQLConductGetFields(InCommand As Object) As String() Dim ConnectionA As New MySqlConnection(My.Application.sqlconnect) Dim command As New MySqlCommand() ConnectionA.Open() command.Connection = ConnectionA Dim reader As MySqlDataReader command.CommandText = InCommand …

Member Avatar for Begginnerdev
0
217
Member Avatar for silversurf

Hello, As I am building a pos and inventory software in vb 6.0 with Ms-Access as database, I am building the face of the software where I have one MDImain form with toolbar and menus and related some mdichild form holding different informations (I have attached the image). ![main2](/attachments/large/3/main2.JPG "main2") …

Member Avatar for silversurf
0
459
Member Avatar for dipankar_pr

1. A access database contain one table PhBook with fields First name, Last Name, Mobile Number 2. Few record already exist in PhBook table 3. Mobile Number is consider as unique and appears in database once. 4. First name and last name may duplicate. 5. One excel contains few records …

0
85
Member Avatar for romz

hi everyone. I want to delay the click event in a vsFlexgrid so that the double click event will run 1st. I used a timer for the delay in the click event and managed to get the value of the double click speed in the windows library for the timer …

Member Avatar for romz
0
1K
Member Avatar for silversurf

Hello everyone. I am trying to build a inventory and pos software with vb 6.0 and MS-Access as database. In one of my form I have the following code to call my inventory of a certain invoice number to print tag for my products. I am using a MSHFlexgrid with …

Member Avatar for silversurf
0
2K
Member Avatar for imti321

'the code is working properly only problem with this code is when the first line ends in excel and data is inserted in next Row "instead of inserting another row it copies the same content which is inseted last time in form "

Member Avatar for tinstaafl
0
395
Member Avatar for 2mhzbrain

Please show me what is the correct code to compare the DateAdded (2012-12-26 00:00:00 - its format inside MySQL) and DTPicker (01-01-2000 default format from user input) Sub FilteredQuery() cnDDR.Open "Driver={Mysql ODBC 3.51 Driver}; server=x; port=3307; database=x; user=x; password=x; OPTION= 1 + 2 + 8 + 32 + 2048 + …

Member Avatar for AndreRet
0
446
Member Avatar for John Mello

*to copy the codes of this sample article: just go to facebook to type this in your facebook search browser to find & added me: **jm amaro**, or you can add me as one of your friends in fb for i enable to share this topic.*Emphasized Text Here** or else, …

0
68
Member Avatar for rishif2

Hello experts i am using following code in order to truncate a ms access table Dim con As New ADODB.Connection Dim rec As New ADODB.Recordset con.Provider = "Microsoft.Jet.OLEDB.4.0" con.Open App.Path & "\db.mdb" Dim query As String query = "truncate table tbl" rec.Open query, con, 2, 3 con.close but its producing …

Member Avatar for AndreRet
0
2K
Member Avatar for Siberian

I'm trying to associate VBS files with WScript.exe, when I think it is associated it isn't, I tried numerous times to associate the file type wit the program. Anyone know if this registry file would work on Windows8 ? Windows Registry Editor Version 5.00 [HKEY_CLASSES_ROOT\.VBS] @="VBSFile" [HKEY_CLASSES_ROOT\.VBS\PersistentHandler] @="{5e941d80-bf96-11cd-b579-08002b30bfeb}" [HKEY_CLASSES_ROOT\VBScript] @="VB …

Member Avatar for Siberian
0
362
Member Avatar for tinstaafl

I'm working on a project that contains 3 different lists. 2 lists of 2 different controls, and 1 list of a custom class. I found that I needed each of these lists sorted. The problem with sorting a list of complex types is there's no default comparer for them. That …

Member Avatar for Ketsuekiame
0
314
Member Avatar for amaicahglyne.decastro

I need a programme for my mom's business inventory. I tried to download Dev-C and Visual Basic so I could make one, but after downloading it, the software would not open completely in the computer.

Member Avatar for JamesCherrill
0
100
Member Avatar for Prysm[VA]

Hi, My name is Erik :) I've learned a bit of java, visual basic, and now I'm working on learning alot in c++. I have been taking classes but next semester I'll be off until I transfer to Devry in the spring. Joining a forum would help me learn more …

Member Avatar for falkopartey
0
171
Member Avatar for ImZick

Hello :) i'm new here and i love programming my field is visual basic hope you can lend me a help whenever i got a problem in my codes and i will appreciate your reply. Thank you and God Bless :D

Member Avatar for falkopartey
0
67
Member Avatar for ScarWars9

Hello my name is Scarlett! I am currently going to school for Database Prgramming/Web Development I am also studying Visual Basic right now and will be jumping into some mobile developent soon. Looking foward to learning alot on here!!!

Member Avatar for falkopartey
2
100
Member Avatar for Tekito

This is an issue that I've discusses many times before, but never with a conclusive solution. I am trying to programmatically change the data range for an existing chart in Excel. My code goes something like this: [CODE] With WS.CharObjects(SelChart).Chart With .SeriesCollection(1) .XValues =DataWS.Range("A1:A101") '<-----ERROR! .Values = DataWS.Range("B1:B101") End With …

Member Avatar for gmcfarlane
0
283
Member Avatar for Divinedar

I am trying to reference a cell with a date from one worksheet to the other. I am using ='Statistics MVP'!A16 but it doesn't give me the date format it just gives me the number 41125 or any other number. When I format as a date form I get 1/0/1900 …

Member Avatar for Divinedar
0
126
Member Avatar for s1lentb0b

Hi I have an insert statement in my VB code that updates about 20 fields in sql. I pass through todays date and a set of values. This occurs on a button click event. My problem is if the button is clicked more than once the data is duplicated in …

Member Avatar for pritaeas
0
149
Member Avatar for StarTrekCafe

hi. a blind programming student, and did ask my lecturer, but he could not answer. has not done the talker classes before. i have a hangman self voicing game. it uses the anna voice, but looking for some more human sounding voices, like aussie, british, united states. did downloa and …

Member Avatar for lolafuertes
0
189
Member Avatar for killer88

For instance , i need store a database of a student.i will get all the details through the respective fields like name , no , mark1 , mark2 , mark3 etc.. nw i need to save this information . how do i do it ?. thanks :)

Member Avatar for tinstaafl
0
165

The End.