10,991 Topics
 | |
| | Was how to form the password one could call the 4 form with each different password. example for the administration can only open the form and form alone administration secretary could only summon his secretary form only & to superiors could open formnya all. thanks for attention & assistance  |
| | [CODE] Option Explicit Dim rs As ADODB.Recordset Dim savePurpose As String Private Sub getData() Call EnableEntryControls(False) lvRec.ListItems.Clear Set rs = GetRecordset("Select * from tblDocSched") If Not rs.EOF Then 'records exists Call SearchMode(True) While Not rs.EOF lvRec.ListItems.Add , , rs.Fields("PhysicianNo").Value lvRec.ListItems(lvRec.ListItems.Count).ListSubItems.Add , , rs.Fields("PhysicianName").Value lvRec.ListItems(lvRec.ListItems.Count).ListSubItems.Add , , _ IIf(IsNull(rs.Fields("Department").Value), "", rs.Fields("Department").Value) … |
| | [CODE]rsInventory.Open "SELECT Expiration_Date FROM YourTable WHERE Expiration_Date < DateValue(Date)", conn, adOpenStatic, adLockOptimistic[/CODE] what should be the value of that date. if i put date [CODE]rsInventory.Open "SELECT Expiration_Date FROM YourTable WHERE Expiration_Date < Date", conn, adOpenStatic, adLockOptimistic[/CODE] ive got an error 'no value given value given for one or more required … |
 | What i wanted to do is to limit the number of users to be registered for my system. One for User type and one for Administrator account, and if there is already a user and admin account, adding will be disabled, else, enabled. Here's the code im using. [CODE]Private Sub … |
| | Hi, Just a form where I want to put a default value for a combobox: private sub form_load() me.combobox1.defaultvalue = 3 end sub The property defaultvalue is giving an error, 'method or data member not found'. what do you think? |
| | please help me in making cpu scheduling in vb6!please...thank you so much for the help you can give.. |
| | Hi, Could anyone send me code for following problem.. I have two text files, one containing list of folder names another is a log file containing error description. I have to find error description from log file for every names in first text file. And i have to copy the … |
| | Hi, Can somebody tell me how i can link two or more list boxes so that if an item is selected in a list box in a row, another item will be selected in the same row without selecting them one after the other from different list boxes. Thanks. |
| | I have searched and cannot find out why my code will not update the database. The program stops at the mDA.Update(mDS, "temp_data") line with the following error: System.Data.OleDb.OleDbException was unhandled ErrorCode=-2147217904 Message=No value given for one or more required parameters. Source=Microsoft Office Access Database Engine StackTrace: at System.Data.Common.DbDataAdapter.UpdatedRowStatusErrors(RowUpdatedEventArgs rowUpdatedEvent, BatchCommandInfo[] …  |
| | Hello There, Is it possible to put a datepicker within a datagrid?. Can somebody show me the code pls. Thanks again Newvbguy |
 | Dear Sir/Madam How to check execution time of a procedure with the help of Timer control? How i have tried, i am attaching herewith my test program. Please guide me. |
| | [CODE] Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnSend.Click Dim strSubject As String 'subject title Dim strBody As String 'Body of message Dim strBody3 As String 'Body of message Dim strBody4 As String 'Body of message Dim strBody5 As String 'Body of message Dim strBody6 As …  |
| | i have a project, where i have a menu, in which option Customer info, where all the basic information of customer is stored...and blow there is another menu, whre Asset Servey is menu, now i have a text box in wch customer with its code is shown, now i want … |
 | hi guys im making a button which is print im still learning on how to do or use crystal report in vb6 to print a specific record based on what the user will input on the textbox or flexgrid anyone can help me on this?im eager to learn about this.i … |
| | Good day, I have a system and it has a studentdatabase.mdb database, ive putted password into the .mdb file and now when I run the .exe file of my vb6 program it says Not a valid password, Question: How can I automatically put the password of the .mdb file when … |
| | Dear Sir/Madam, I have two types of procedure for one/same result. No. 1 procedure is very long without loop and no. 2 procedure is sort with many loops. So I want to check those procedure, which one is taking less time than another. Please guide me. |
| | For example i have the following fields in the database name, student number, course then i have multiple data in the database e.g. 25rows = 25 students when i try to edit them, you need to first click the row in the datagrid that you want to edit then ive … |
| | Guys! im doing a search program where in ill just search the name of the product then print it. [CODE] Private Sub txtSearch_Change() rsTransaction.Close rsTransaction.Open "select * from tblTransaction where mid$(Date,3,2) like '" & txtSearch.Text & "%'", con, 3, 2 end sub [/CODE] it is actually doing fine but i …  |
| | [code]Option Explicit Dim connectionado As ADODB.Connection Dim recordsetado As ADODB.Recordset Dim num As Integer Private Sub cmdCanceL_Click() frmSTUDENT.Enabled = True frmSTUDENT.Show Unload Me End Sub Private Sub openDbaseConnection() connectionado.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Documents and Settings\student\My Documents\dbStudentInfo.mdb;Persist Security Info=False" connectionado.Open recordsetado.ActiveConnection = connectionado recordsetado.CursorLocation = adUseClient recordsetado.CursorType = adOpenStatic recordsetado.LockType = adLockOptimistic …  |
| | hi mam sir can i ask for a copy of a reservation system using vb 6.0? |
| | I am developing an inventory application. There is a form named frmInventory where material receipt has been done. Logic The logic is that First you Enter the Transaction no. in text box named TxtChalanNo Then a combobox named cmbval on flexgrid named mf1 will got focus then the user select … |
| | Good day Sir/Maam.. im new here. i have a project in MS Access 2003 that will tanslate numbers into words... is there a code using Asc? to this program... im sorry im newbie in programming.. thanks a lot.. |
 | in a textbox I write 100000. I want another text show automatically "one lac". I mean it aumatically show the in word of that numeric number what I write. how it possible. |
 | I think the title says most of it. How do I, in MS Access using VBA, get information from a workbook which I can then put in as a recordset in a table? I know that excel has an easy workaround for other excel workbooks, and I've read somewhere how … |
| | Hi. Can anyone help me with this code? I have a form which takes subject name, semester and class. I put this data in a database tables using 2 ADODC’s and the connections are as follows: ADODC3- LecturesAttended (StudentID, RollNo, Name, SubjectName) ADODC4- Student (StudentID, RollNo, Name,Class) I take studentid,rollno,name … |
| | Hi All, I'm trying to disply the last part of a hyperlink using the expression builder in access 2010 textbox. eg. #\\abc.org.uk\Root\OurSrevice\OurTeam\Peter\Dump\MyDoc.doc# #\\abc.org.uk\OurSrevice\Team2\Folder2\YetAnotherFlder\Dump\View\MyOtherDoc.doc# In the first example I want to display MyDoc.doc In the second example I want to display MyOtherDoc.doc I suspect I'll need to use the RIGHT and … |
| | Hey!! I need help! My project in vb isn't opening! When trying to open my project its saying it is in binary format and cannot be loaded in VB6!!! I don't have backup of the changes i made today..!! Please help me! It happened due to power failure. But my … |
| | I am trying to use a VB.NET AJAX Timer control within a Repeater. I cannot figure out how to get this to work. The timer needs to constantly check the server to see what time it is and then display a live countdown clock based on a given time. I … |
| | I need to be able to check if another user has an excel workbook open (from a network drive) from within another workbook. user 1 has workbook1 open and has a macro to open workbook2, paste some data in, save it and close it, I need to add code to … |
| | I have VB 5 learning edition which has suited me fine thus far believe it or not! One thing has really been annoying me for quite some time. I can't find how to set the command buttons forecolor (at least with the VB version I have). Backcolor is no problem, … |
The End.