11,868 Topics
 | |
| | I'm stuck on this problem for about 2 days now and i still can't find a way on how to bind my data column on the combobox. need help guys i really appriciate your help. And this is the code i have made so far. Private Sub Form_Load() adodc1.ConnectionString = … |
| | what i want is to put a range in the textboxes like 1-100 and will not accept if it is greater than 100 or a negative number... hoping for your response...  |
| | im creating a simple calculator and i dont know how to disable letter in the textbox.. can someone help me please...newbie here....BTW im using VB6...  |
 | Please help, i do not know whats causing the problem... Dim miqty As Double Dim mitc As Double Dim siqty As Double Dim sitc As Double Dim diffqty As Double Dim difftc As Double Dim dvqty As Double Dim dvtc As Double dvqty = dynavqty.Text dvtc = dynavtc.Text Set editSIrs … |
| | !! i was trying to create a simple grading system but my project doesnt work it always shows the last if statement and ignore the other statement...please help here's my code...can someone please tell me what's wrong coz i dont know how to use if/elseif/else statement... newbie here...please help Private … |
| | hi everyone... my problem is i got 2 command button named command1 and command2..what i want to happen is when command2 is click the function of command1 will work... can someone please help me... |
 | hi, im using vb6 and i dont know how to work on a commandbutton that will trigger to another form. For example, i have a commandbutton in form1 and when i click it, there will be an effect in form2. Example, form1 1+1 and the answer will go to form2. … |
 | Hello Guys .. I want to understant how to share my Database to the other Computer USing IP address.. Anyone can show me the code for connection.. This is my Code, acd.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\POS.mdb;Persist Security Info=False" acd.CursorLocation = adUseClient where can i put the ip in … |
| | i would like to know hot to put a limited input in a textbox.. situation is like this i put a textbox in a form then what i would like to happen is to accept only 2 number and will not accept the following number that is being pressed...please help... … |
| | Hello Guys I Have A Question.. I have a Table for My Daily Reports.. But I dont know to Show the Daily, Weekly, Monthly and Annual Reports. What Should I do? |
 | Hi experts, I have listview table but when I click or double click the row the data could be changed or edited? How could I disable it but still able to select every row? Many thanks! Kimangel |
| | Hello Guys, I hav a Code For My Report in Daily .I don't know why there is nothing show the records. even though the Error not Popup. This is My code guys. Help Me Guys Dim rsReport1 As New ADODB.Recordset rsReport1.Open "Select purchase_date, BarCode, Price, ProductName, Quantity, TotalPrice From Dailyrecord … |
| | A script I have that checks if an external HDD is connected, which has a prompt to mount the drive, with the option 'retry' and 'cancel'. If I click 'retry' it says it has found the drive, even though it's not connected, how can I fix this ?  |
| | Hi Everybody, Could somebody let me know the search code in a database (mdb database : with 1 table only) to write for a search command. I am using ADODC1 connection. Please also let me know for the above table if i want to add a new contact to the … |
| | Hi experts, I have a type mismatch error in getting time difference from database. Below are my codes. Private Sub cmdSearch_Click() Dim sTrID As String Dim Total As Integer Dim xhours As String Dim Intime As String Dim Outtime As String sTrID = txtSearch.Text Set rs = New ADODB.Recordset rs.Open …  |
| | Here's a simple wrapper for printing text. Built as a class library, this can be used in any .net application. This has automatic word wrapping. I figured that using the new constructor to accept different parameters would easily allow for printing different documents with different settings. I included Name, Font, … |
| | I am developing a VB6 application which connects with an Access 2010 database. I want the application to execute queries stored in the database. Some of the queries include Access functions in field names. For example- FieldName: IIf(Nz([AnotherFieldName],0)=0,3,[AnotherFieldName])" Is there a way in VB6 to execute the queries natively in … |
 | In a previous thread I was trying to get some code to work as a search function and after messing with it for a while I finally got it to work-sort of. What I have is a search function and when I run the code it does find the part …  |
| | **I am building a hospital managment system as a practice in visual basic. I am having some problem I want to write or read data from particular row or column with visual basics How do I o it? Thanks in Advance -Hassaan bin Jalil** |
| | Dim Dbl1 As Double Dim Dbl2 As Double Dim Aux1 As String Dim qtyadd As String Dim subtotaladd As String Dim itm As MSComctlLib.ListItem Dim i As Integer Set itm = ListView1.FindItem(txtCode.Text) If itm Is Nothing Then ListView1.ListItems.Add , , txtCode.Text ListView1.ListItems.Item(ListView1.ListItems.Count).ListSubItems.Add , , txtproductname.Text ListView1.ListItems.Item(ListView1.ListItems.Count).ListSubItems.Add , , txtqty.Text ListView1.ListItems.Item(ListView1.ListItems.Count).ListSubItems.Add … |
 | just want to know the correct synthax for creating a table in access database using vb myqry = "CREATE TABLE HoldInvoide'" & k & "'(Barcode varchar(20) not null Primary Key, ItemName varchar(40) not null, Quantity int , Price double, Total double)" k is a variable i want to create a … |
| | experts please help on querying and counting the frequency of data, i want to count the number of data appearance then put it on like this: Name----Lastname----Relationship----Freq Egie----Tayag-------Brother---------2 i will place the result on a report counting the number of a person's visit on the theme park. TIA ^_^ SELECT … |
| | Hello I am trying to display an ID which is a primary key in my table by selecting the corresponding name in my table. the names have been saved in a combo box and depending on the name selected the textbox will display that Id. the code I have so …  |
| | 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 … |
| | 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", … |
| | 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 …  |
The End.