9,979 Topics
 | |
| | Hi, I don't know why i am getting this error. Please see my coding part, where i am facing this following error [ICODE]Private pbat As New ADODB.Parameter 'in form load With pbat .Direction = adParamInput .Type = adVarChar .Size = 4 End With 'saving part [B] pbat = Trim(Text1.Text) & …  |
| | Hi everyone, im still new to this forum and started to learn about visual 6, i have situation below, this program to obtain reader name and bonus point earned menu File Edit Help Points Clear About Summary __________ Exit Font Color Quesstion, For Points menu command what is a suitable …  |
| | Is there a simple way to list all the toolbars a user currently has visible? I'm trying to hide everything on screen appart from my worksheet, including the file menu. I've found a way to do it (custom toolbar, hide everything else) but need to be able to restore the … |
| | Using VBA/Excel and need a VBA or VB help file. Doesn't appear to be packaged with Excel anymore. Any help? |
| | Dear experts, I´m in trouble with this project. Strange 'cause the same code works on a different workbook. Can you guys help me, plz? Sub Graph() Dim y As Byte Dim x As Byte Dim a As Byte Dim D As Integer x = 0 y = 5 Workbooks("Graph1.xls").Activate Worksheets("Plan1").Select … |
| | Here's the problem. I'm designing a worksheet for very young children and what they need to do is type a number into a cell and then click a button to run the macro. However, in order to click this button they first must either press ENTER or TAB or click … |
| | [ATTACH]20944[/ATTACH] pressing save button i want to store/save all input data in one storage. attached file is the sample form i made thanks  |
| | I have written a Visual Basic macro in Excel. The following is the link to that file: [url]https://rapidshare.com/files/3870906097/Deconvolution_ver1.xlsm[/url] While running main(), selecting BU4 from userform, a type mismatch error is encountered. I am unable to solve this problem. kindly help me out. my mail id is [email]shivam1410@gmail.com[/email]  |
| | Hey, Plz, I need some help with this code, In another workbook it worked. Specific on this one it's not working. The error is occuring on the red line, right after it's added a new serie on the graph. Sub Graph() Dim y As Byte Dim x As Byte Dim … |
| | Dear All, Could somebody let me know the search code in VB6. I am using ADODC1 connection. im handling employees databse called databse.mdb when in click the search button i want to get the details of the said employee using their badge nos. pls help..... Have a nice day..  |
| | Hi all, I would like to format a column in datagrid with 2 conditions. The column must be entered with only "N/A" or date (DD-MMM-YYYY) format value. [CODE] If Me.grdDataGrid.DataFormats(10).Format <> "N/A" Then MsgBox "Invalid Data Entry!", vbInformation Exit Sub End If[/CODE] The code above still produce "Invalid Data Entry" … |
| | They want to have a [COLOR="Red"]"search textbox"[/COLOR],[COLOR="Red"] "result textbox"[/COLOR] and a [COLOR="red"]"datagrid".[/COLOR] If the secretary input a keyword, all the "familiar data" will be displayed in result textbox. and if that secretary click one of the results in the result textbox, the details of that data will display in datagrid. …  |
| | Hello, I am new to vb and I need some help from you all. I have to do a project which is interface an vane anemometer to computer by parallel port. I have done almost everything now i only left with the programme. My idea is the anemometer will give … |
| | I have the problem to convert the rtf document to PDF. I search around the internet but it still cannot solve my problem.I am using TextControl in visual basic to create the document .Please help thx :) |
| | I have prob. with my printer my printer is Mini Dot Impact Matrix Printer. model AB 300 Kc. how to setting paper for this printer? |
| | Hi, i really need help making this program: Write a program that will ask a teacher to enter his 4 digit password. The program gives three tries for the password. If the teacher fails in three tries, the program displays the message, “you are not eligible to enter the grades”. … |
| | just wondering if there was any way to disable some values in the combobox or at least grey them out. i populate the combo box from the database: rs.MoveLast With Me.Combo1 .Clear Do .AddItem rs.Fields("CustomerFirstName") rs.MoveNext Loop Until rs.EOF End With once one value has been selected, is there a … |
| | Hey all, I have split an Access database not on the server. I have decided to VBA code the links, however I have reached a stall when attempted to VBA code the update query; updating the remote table with data from the local temporary table. I have tried multiple things … |
 | Hi masters, I try to write and read file into txt file but i dont know how to do it. Anyone know how to achieve this? Please help me. any help will appreciated much. Best Regards |
| | I put this code to button_event: [CODE]01 On Error GoTo ErrT 02 If mValidateControl.Validate(txtKode0, txtKode0.Text <> "") = True Then 03 MsgBox "Kode Bahasa belum diisi" 04 Else 05 Rs.MoveFirst 06 If Not (Rs.EOF = True And Rs.EOF = True) Then 07 While Not Rs.EOF 08 If Rs("kdBhs") = txtKode0.Text … |
| | How to display the field in text box using combo box. When the user click the combo box, two fields will be displayed, the first field will be displayed in 1st text box1 and 2nd field in text box2. These are my codes. Can you help me how? Dim cmdoff … |
| | sir i have vb6.0 with crystal 10 with oracle 9i but when form is run it giving strange run-time error'424' object required. but later ver.(crystal 7) same report running file. pls.help me. kewal sharma |
| | im using the dlookup() to prievew password at a unbound textbox within a criteria that the username and security question that are entered matches the database. Ex: user forget password. he enters his user name, and select the security question, and answer the question. if these data match the data … |
| | [CODE]Private Sub Command4_Click() Dim vPass As String If IsNull([usernametxt]) = True Then MsgBox "Username is required", vbOKOnly, "Required Data" ElseIf IsNull([answertxt]) = True Then MsgBox "Password is required", vbOKOnly, "Required Data" End If ' Evaluate filter before it is passed to DLookup function. strFilter = "[USERNAME]= '" & Me.usernametxt & … |
| | Hi experts out there, I'm using a zebra printer, model TLP 2844Z. I need to print my company logo on a label. I've been trying this for the past two weeks and no idea what I'm doing wrong with the code below :( Other lines are printed except for the … |
 | Hello All, As the title.. Does any one know how to find how many specific character in a text? Best Regard Eko. |
| | Dear All, Could someone can help me with this.... I need to extract file name example ABC-01.xls in to ABC-01 only what method i could use on this? Could anyone help me please!!! Thanks & Best Regards |
 | Hi all,, How i can sum all item on listview column. Thank you in advance. |
| | [CODE]Public Sub loginbtn_Click() If IsNull([usernamecbo]) = True Then MsgBox "Username is required", vbOKOnly, "Required Data" ElseIf IsNull([passwordtxt]) = True Then MsgBox "Password is required", vbOKOnly, "Required Data" Else If Me.passwordtxt.Value = DLookup("PASSWORD", "SYS_USER", "[SERIAL_NUMBER] = " & Me.usernamecbo.Value) Then strUser = Me.usernamecbo.Value strAccountType = DLookup("USER_TYPE", "SYS_USER", "[SERIAL_NUMBER] = " & …  |
| | Hye all I am developing a Shop Software i want to know what kind of Grid i have to use at Sale Form which will sum up and print bill? |
The End.