11,868 Topics
 | |
| | Hi, I would like to replace the ACCESS with SQL Server 2000 enterprise edition. But I have the following problems: 1. While installing SQL should I install as Server or Client. 2. How to connect the SQL with VB 6 for saving,retrieving, modifying data using ADODB connectivity. Pl help me … |
| | Hi, I would like to know how can I make the system beep louder I know you can change the frequency of the beep but its not loud enough as I am using it in a noisy environment. How can I sound the loudest system beep or make the system … |
| | Hello everybody.. I have tried to use these codes that I got from a book. I'm using MSFlexGrid, with the Grd name. It was set to be invisible (false visible). And when i enter the year (tahun) needed in the "txttahun" textbox, it will only show the data that related … |
 | I want when I write some text in a textbox it direct pass in data report. I mean generally a data report connect a database and show data from it. but here I want I write and it pass that time data report. |
| | I have two tables in my database, one customer and other cddetails.. n i`m trying to search both tables for letter entered by user.. The code for Customer table works fine...but the code for cddetails is giving me some problem... I would appreciate if some could help me out... Here … |
| | if db.open = true then db.close End if I want some code like this where it will check in the form load and if the connection is open , and if it is open it will close it.. |
 | hi guys, does anyone got an example on how to export outlook mails or contacts to pst thru vb6? thanks.. :) |
| | Dear Sir, Let me know how to connect a access database in Visual basic 6. |
| | Hi, I would like to query from you people if its possible to change back color either row wise or CELL wise in List box. Also I would like to know any other ways of listing record in forms other than in List box, Flex Grid and Data grid. Regards, … |
| | [CODE=vb]' Private Sub department() Dim dep As String dep = Trim(Adoaddlec.Recordset.Fields("department")) If (dep = "1") Then optict.Value = True ElseIf (dep = "2") Then optassessmentprogramme.Value = True ElseIf (dep = "3") Then optdbt.Value = True ElseIf (dep = "4") Then opttvet.Value = True ElseIf (dep = "5") Then optcarrerdev.Value = … |
| | Hello there. I have successfully read my emails from outlook into access. The problem is that I am trying to get the sent date field but I can not figure out the command for it. Below you will find the commands I used to find the subject, body and sender. … |
| | hi everyone, i have successfully saved the image file to DB by this code: Private Sub cmdSave_Click() Dim picsm As ADODB.Stream Set picsm = New ADODB.Stream picsm.Type = adTypeBinary picsm.Open picsm.LoadFromFile filepath With rs .AddNew .Fields("Last") = txtLast.Text .Fields("First") = txtFirst .Fields("Pic") = picsm.Read .Update MsgBox "Successful" End With picsm.Close …  |
| | Hi I am trying to limit the cursor to a single form on loading. It works fine when testing it in Visual Studio but when I compile the exe the rectangle it limits is bigger than the form also if I change the start up position of the form from … |
| | Hi Friends! I am creating a project & want to minimized its form like photoshop in its own status bar. How can I do this ? Any Idea .... ? |
| | I made a datareport simple. just connect. but I want to make it with condition. I have 2 dtpicker for date. I want 1 day report or weekly or monthly report by dtpicker. example I want 03/11/08 report or 01/11/08 to 03/11/08 report. But I dont know how make it. … |
| | Hi, I need help building a very simple excel macro that iterates through all cells of the table, checks if they are not a particular color and if so changes to another color. So if the two colors are called BLANK and FILLED respectively, then the psedocode would look like: … |
| | what's wrong with the code, it doesn's display the data based on the SQL query: Private Sub cmdSearch_Click() On Error GoTo Notfound squery = "": squery = "Select * from tblStation where Station like " & txtStation.Text & "" Call ExecuteCommand With Me .txtStation = rs!Station .cboCluster = rs!Cluster .txtArea … |
| | I am running the following Update Query in my program and I am encountering the following Error: Run-time error '2147217900 (80040e14)': Syntax error in UPDATE statement Here is the code i am running My module contains the following code: Public UserName As String Public UpdatePassword As String Public rsUpdateUserQuery As … |
| | hi all, I have one problem with resizing forms. I am developing our application in vb and i gave code for resizing forms in resize event of form. First i save the sizes of all controls in forms in form load event and then in resize event i resizes all … |
| | Where should I get the declaration ADODB.Stream Object? as far as i know, ADODB library has only 4 objects: Command, Connection, Recordset & Parameter. I need this object for the Image DB. thanks |
| | Hi, im working on a Computing A Level project, it involves making a virtual Ballot Box. One of the things the Ballot Box is required to do is to choose the winner by determining which candidate has received the highest number of votes. Has anyone got ANY IDEA how i … |
| | [COLOR="Red"]URGENT[/COLOR] Hi, Ive found that earlier when i used DataControl in any of my Forms it did not give any problem worked fine. But after sometime when i started to run those Forms it gave me an error message (to debug) of "Visual Studio 2008" (Just-In-Time Debugger). I felt that … |
| | Hello, I created command object in DataEnvironment. Now I wish to change to command object's Sql Text since table name gets changed depending upon year of working. |
| | i'm doing the eigenvector and eigenvalue calculator system. i don't know how to find eigenvector from a corresponding eigenvalue!! help!!  |
| | hello, i have a problem i am trying to encrypte an xml file and decryte the file. what am doing for a comapny in canterbury kent is to create a mobile banking application in visaul basic so customer could downlaod it onto their pda using microsft ce ...which i have … |
| | good day! I want to pass the value that contains tha table name and load its data.But my sql turns error.Below is my code. [code=vb] Combo2.Text = "first_year" sql = "select * from " & Combo2.Text & "'" rs.Open sql, conn, adOpenKeyset, adLockOptimistic, adCmdText [/code] Im using mysql as backend … |
| | Good day.! Thank you for all of you in this forum in helping me in all my post. I just got one last problem with my project.!Please help me on how to back up and restore my mysql database that when i click backup my mysql database named (onlineenrolement) will … |
| | Hi I'm trying to creat a numeric pyramid. I have created th code for one side but can't seem to figure out how to do the other side this is what I have so far. size = Val(txtsize.Text) Picout.Cls ' For loop to iterate over every column Dim row As … |
| | I have 2 tables Details,Mstr. Mstr table contains(PSNO,NAME,DOB,DOJ)=>PSNO- PK Details(PSNO,NAME,PH,SAL_ACC,ADV,DT_PREP)PSNO-FK In Grid i need to display SAL_ACC NAME ADV DT_PREP 12345 abc 150 5/25/2009 12345 abc 300 5/30/2009 12345 abc 200 6/11/2009 how do i do ths,please help |
| | Hi there. I am writing a program in Access 2003 and I trying to update a forum with new strings. To explain better. The forum window is already up and I hit a button to process a command. Now I need the fields in the forum to update without saving … |
The End.