12,155 Topics
Hi Experts, my sql query below returns 0 value, though I have entries in my data base. Please help me check my codes below; Private Sub cmdSearch_Click() Dim sTrID As String sTrID = txtSearch.Text Dim Total As Integer Set rs = New ADODB.Recordset rs.Open "Select Count(DateIn) as Total from Time_In …
I'm new with VB6 and i'm a self learner.. I need help with coding for generating data report by filtering between 2 dates using 2 dtpickers. i'm using data environment and the dates are in 1 field
Hello Guys Help Me To Count The Item in Listview and Update it. Scenario.. Customer Buy 3 Milk and 2 Nescafe then the Cashier Punch it Item-----------------Qty Milk-------------------2 Nescafe---------------2 The Cashier Forget to Punch the 1 Milk. the Cashier should Punch Another One Milk..But My Code This is What Happen …
Hi Group! I need to write the data from multiple TextBoxes (which I've moved to individual string names) into one text file (miscflds.txt). These individual strings will need to be written one on top of the other. To be clear, it will need to look like this: Item A Item …
Private Sub Command1_Click() Dim a, b, cc As Integer Dim p(3), d(3), e(3), t(3), h(3), w(3), c(3), f(6) As Integer If Text4.Text <> "" Then strfile = Text4.Text Open strfile For Input As #1 For i = 1 To 3 Input #1, p(i), d(i), h(i), w(i) Next i Close #i …
Hi All, I'm trying to save an incoming email as a .txt document but I'm having some trouble with the VBA. My procedure is as follows: Sub ConvertToPlainAndSaveAs(Mymail As MailItem) Dim strID As String Dim objMail As Outlook.MailItem strID = Mymail.EntryID Set objMail = Application.Session.GetItemFromID(strID) objMail.BodyFormat = olFormatPlain objMail.SaveAs "C:\Users\Me\Documents\path\to\Test.txt", …
Group, The SQL Server (I'm using the edition that comes with Visual Studio 2010 Express) is different in every aspect form the database(s) that existed in the UNIX based program I work with over the last 15 years. There is much to learn and understand. With that said, I've connected …
I'm making a calculator, and I want the question(text) to shift the left when the textbox is full. So as you type, it shifts to the left(only when the textbox is full) to make the newly typed question visible. In a normal textbox the text shifts to the right making …
I've been battling with this for the pass few days. I have an access03 database that is used to track training that we give to employees. i had a form that has, the training info and then a subform that lists all the attendees and their scores. Now I was …
Hello, its been a while since I have been here but I am in need of assistance. First off I haven done this in a while so to say that I am rusty is an understatement. What I am trying to do is create a form that allows for input …
Hi, I've never really created a login screen in VB and connected it to a table in MS Access before. So I'm supposed to create a login screen and after gaining access to it, a main menu form needs to show up which would be connected to the rest of …
Hi experts, I have a Daily Records form of an employee. my fields are; search box search button datefrom (datepicker) dateto(datepicker) datagridview (fields are Employees_IdNo, DateIn, TimeIn and TimeOut) totaldays totalhours The scenario is this, first search for an employee using Employee number, set the datefrom and dateto to two …
how to add scroll bars to mdi form when the height of child form is greater than the actual height of mdi parent form . . .
hello guys, can help me out? My assignment need to do a registration system. Student register use identification card(put in mycard reader) and the existing database(already have student data) will recognize and mark the student attendance and the system also can check how many people are coming for the event. …
Hello, Here is the scenario : I have the follwoing sales return from in my software:  In the from I have tow listview control, the left is Listview and the right is Listview1. I have the following code in procedure : Dim xsprice As String Dim xsprice1 As …
If .SubItems(19) = "Y" Then chkTax.Value = 1 txtTaxRate.Text = .SubItems(16) Else chkTax.Value = 0 txtTaxRate.Text = "" End If having problem Compilation error : method or data member not found with this code chktax is a check box.
How do you go about pausing your code from operating. I want to make an animation by making a picture box visable then another then another but I need a period of time between transitions? How would I go about doing this? boredPic(1, 1).Visible = True boredPic(1, 1).Image = My.Resources.Red …
I would really like to be able to compare two cells in visual basic from a database access database in two different tables and the idea is to take one paragraph from one cell and a paragraph from another cell and compare how closely related they are. How would you …
what code can i use in my game when i'm upgrading or i will evolve or build ong picture to another picture ? please help me thanks !
When I create data report use VB6 Enterprise, when I add Data Source to that form, I'm get error message "UNHANDLED EXCEPTION AT 0X89067542 IN VB6.EXE : 0XC0000005 : ACCESS VIOLATION READING LOCATION 0X89067542" and VB6.EXE close What happen ??? any body can help me, thanks for advanced Regards, FX …
Is there a way to open a form in vb6 when they clicked on one of the field in crystal report? Ex. If I want to update certain deposit, when clicking on crystal report, it will open the vb6 form to display for editing.. Ive found 1 in vb.net from …
I'm having trouble with this: Option Explicit Dim hold1, hold2 As String Public LoginSucceeded As Boolean Private Sub cmdCancel_Click() LoginSucceeded = False Me.Hide Welcome_Scrn.Show End Sub Private Sub cmdOK_Click() With Adodc1.Recordset hold1 = "[Username] like'" + txtUserName.Text + "'" hold2 = "[Password] like'" + txtPassword.Text + "'" If .EOF <> …
Hi, I am (still) converting an old asp web app / vb6 dll to aspx / vb.net I am now biting on a fairly simple function in vbscript: the execute() function What the vbscript does is the following: It reads in a variable name and its (string) value from a …
Its all in the title, i want to get 2 dates from user then view them in a data report text labels so we have idea what the report is displaying
hello. i'm only 15 year old and so i dont know much about vb6.0 . i m using a code for a search button that would display the fields in a database(ms access) in textboxes when i select a date from the combobox i used the code: Adodc1.Recordset.Filter = "infodate='" …
Hello, I suck at programming, so I'd like some help on createing a .vbs script to disable right mouse clicking on the entirely Is this even possible? Google searching yeilded me nothing usefull... javanoob101
Hi experts, I have an update form, even without changes made in fields the form will still be updated. How can I code that the form will not update without changes made. Pls help me. Thanks alot. below is my code. Private Sub cmdUpdate_Click() If Trim(txtLastname.Text) = "" Or Trim(txtFirstname.Text) …
Hi all, Looking to extract all HTML tags from a dump of HTML data and put them all in a listbox. I currently have the following code. It displays to me things like HTML HEAD TITLE BODY. But i want things like the IMG and ALT tags. ' Obtain the …
I'm trying to create a form with multiple labels, textboxes and buttons within a panel. The user will fill in their data and click a button that will create a new identical panel with the same labels, textboxes and buttons. I read through the following thread in an effort to …
i am tyring to create new project nemmed as car parking system please help to get the password and check the name in database and display the already gathered displays ........please help me ...........<snip>
Hi, I'm doing a software analysis assignemnt which requires me to deal with visual basic. I've never used the language before. I have a loop which I would like to calucate the time taken to complete the loop. Any heads up guys? I want something very simple.
Good day to everyone. I am new to Visual basic and I am having a hard time at school because they dont teach all the codes in visual basic 6.0 and they want us to have self study and all. What a bummer. For our midterm exams, our professor wanted …
Hi Experts, good day! I have hard time coding the click event when I click cmdTime on the second time a message box will say, "Your first time in for 2/16/13 at 9:00:33 am, Are you sure you want to record this time in, Yes Cancel?" The time 1:22:33 is …
-->>Hope all is well,I've Managed to write code to Open Folders/Browse Folders using Common Dialog... -->>The name of Common Dialog is Folder... -->>But now as I've the Open Button when the Browse Windows Show up,I was wondering how can I... -->>Open the Selected File when User Click the Open Button …
So I've FINALLY gotten my code to work but unfortunately my code's sooo messed up that its displaying something else! As you can see in the picture below, the Flex Grid is displaying the data of "Service" http://i213.photobucket.com/albums/cc228/rose_408/receiptform_zps1a66f838.png http://i213.photobucket.com/albums/cc228/rose_408/service_zps5e886a12.png When its actually supposed to show the data of "Receipt Service"! …
Hi Expert, my Option1.value is not save to databse while Option2.value is saving. Pls help me check my code. Thanks Private Sub cmdSave_Click() Set rs = New ADODB.Recordset rs.Open "select*from Employees", cn, adOpenKeyset, adLockOptimistic On Error GoTo err rs.AddNew rs!Employees_IdNo = txtSearch1.Text rs!Lastname = txtLastname1.Text rs!Firstname = txtFirstname1.Text rs!Middle_Initial = …
MY code doesnt saves the data entered through dropdown box into access database
I have the following code that hyperlinks the file to a cell in excel when you type in the file name. I need to alter this code and not sure how. I need for the code that when you type in file name it also finds the filename path and …
I have vb form tht accepts user data.I need to check whether user enters emailid in the correct format ?Please provide suggestion .Thanks in advance
-->>Now I have managed to go through some codes that creates a System Tray Icon... -->>I've managed to create it but something is wrong here that disturbs Me... -->>When I Click on the Tray Icon of My Software it wont Load My Application... -->>That is Say if it was Minimized …
hi all! I have created two datetime picker for getting input for start time and end time. but i could'nt able to calculate time duration between them. How to calculate the time duration by getting start and end time input. Thanks in advance elanch
I was here once before and I'm back; Here's my quandary: What I want to do is build a filename (and save it of course) using what the user puts into a txtbox. In that filename I have the user select one of three option buttons and a number of …
Hi experts, kimangel is here again, doubling my time. Thanks alot for helping. I have problem with two tables, when I click cmdSearch button searching for Employees_IdNo error occur "The specified field 'Employees_IdNo' could refer to more one table in the FROM clause in your SQL statement. below is my …
I've got 2 flex grids in one VB form and I wanna connect both of these Flex Grids to 2 different tables in MS Access. This is how my form looks like: http://i213.photobucket.com/albums/cc228/rose_408/form_zps100c290c.png Here's the code for the service flex grid (FlexService): Private Sub Form_Load() Set conn = New ADODB.Connection …
Hi, I newly installed VB6 and Visual Studio 2012 Premium. OS - Windows 7. I want to add Listview control to my form. For this when i add reference to MS Windows common controls, VB crashes and closes. This is the error msg i am getting "Unhandled exception at 0x00409719 …
Please I need the codes that enable a user to create a new user with a password and also to enable one change a password in Visual Basic 2008
How does one connect an Access Database to Visual Basic 2008?
Good day! I have this datasets format in sql server! AccountID AccountName 1/30/2013 2/30/2013 3/30/2013 4 Credit Cards 20,000 30,000 12,000 5 Loans Payable 5,000 6,000 5,000 How can I load all this data to listview? The colums are dynamic. It could be 6, 7, 8, or 12, or higher. …
Hello, I want to re-arrange my existing macros in the excel file. I have a macro which goes to the specified sheet and checks column R if there are commas. If it finds the commas it replaces it to dots. Column R is called Email. But in some of documents …
The End.