| Subject | Date Asked |
|
| Trouble in VB 6 With Access 2003 | 11/21/2009 |
Q: 1. VB 6, 2. Database Access database with two tables and with password (set by using : ...
A: use this: conn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0; Data ...
|
| Macro Coding for updating the textbox | 11/13/2009 |
Q: Sir, Kindly tell me the coding for the text box, where the text box should not be blank when it is ...
A: Option Explicit Private Sub Text1_LostFocus() If Text1 = "" Or IsNumeric(Text1) = False Then Text1 ...
|
| Printing Data Report | 10/31/2009 |
Q: Good Day. I am a beginner in vb 6.0.My question is how to print a data report as a result of search ...
A: your method has problems: here's a typical code: connect dataenvironment to the table connect it to ...
|
| Excel VBA | 10/27/2009 |
Q: I'm not sure if you have any experience in the VBA side of excel, but I am trying to write a macro ...
A: it is not the no of hours to write the code but the number of years understanding the ...
|
| Programming User Form | 10/26/2009 |
Q: My Knowledge is very limited. I have a user from set up and want it to get information from a ...
A: for this the excel sheet needs to be open then you can put this code with changes as required ...
|
| visual basic 6.0 and data report | 10/22/2009 |
Q: i have following tables in my database master-containing all account no transaction2007-containing ...
A: from your description it is not clear about the design of your tables. if you are filtering on dates ...
|
| VB problems | 10/21/2009 |
Q: I want to check a text box value with sql2000 server db using sql query and show the new form. Where ...
A: strsql is just a string and not the recordset's field value you need to open it as dim rec as ...
|
| run time error 91 | 10/16/2009 |
Q: i have a exe of a project which one of my friend mailed me he says that the exe runs perfectly right ...
A: i think that in your PC, the ActiveX Data Objects is not checked or it is wrongly declared. open a ...
|
| run time error 91 | 10/16/2009 |
Q: i have a exe of a project which one of my friend mailed me he says that the exe runs perfectly right ...
A: exe will run only if you have vb in your comp. you can try adding vbruntime files (available frin ...
|
| storing data | 10/6/2009 |
Q: i feel i should have explained my state /problem clearly. my pc is interfaced with a current ...
A: you can save data to 1) array,2)text file,3)excel sheet,4)access table etc. where is the data: in ...
|
| vb 6.0 question | 9/30/2009 |
Q: I have developed a software which server and client based i am asking you adopendynamic and ...
A: this lockoptimistic etc does not prevent any insertion or update. If 2 persons are using this at ...
|
| Visual Basic Program | 9/27/2009 |
Q: how to print selected data from datagrid connected to database(msaccess) using data report
A: datareport requires dataenvironment(available in your project) you could filter the command for ...
|
| VB 6.0 Web Browser | 9/24/2009 |
Q: 1. VB 6.0 2. No DB 3. Inter 4. VB 6.0 Web Browser 5 Jim Isom 6. VB 7. Every time I click a ...
A: lloks like a problem with your registry. first check if there are 2 ieframe.dll s in the system32 ...
|
| VB pdf reader | 9/21/2009 |
Q: sir, i am a te comp engg student from pune,maharashtra. we have to design a proj on library ...
A: method 1: use a web browser control on the vb form Option Explicit 'in the dialogbox uncheck always ...
|
| How to connect Visual Basic 6.0 with Microsoft Excel. I want to know the code. | 9/14/2009 |
Q: How to connect Visual Basic 6.0 with Microsoft Excel.
A: under project References, check Microsoft Excel object Library and add this code: Dim xl As ...
|
| VB code for ms access | 9/10/2009 |
Q: Sir, I am a new user in ms access & vb. i am preparing a table in ms access with column as name, ...
A: better to have the runners nos in a combobox rather than a textbox. 'put a check mark on ...
|
| vb6+access | 9/9/2009 |
Q: SIR,I am developing a library management application.I am a student of information technology.I want ...
A: dynamic table creation is not advisable. anyway here is one method: put a command button, text box ...
|
| getting run-time error 94 | 9/8/2009 |
Q: i am doing project on VB6 and i getting values or ans as sum of blow code da = "SELECT SUM(amount) ...
A: the execute method gives this problem if you use recordset property then you can check if ...
|
| this is actually a follow-up of the last question | 9/5/2009 |
Q: But the site said there are too many follow-ups.The cell reads "7/12/09 TO 8/21/11." I have to get ...
A: i agree it is too many follow ups. here's how it goes split the string using left and right ...
|
| converting string to date (vba in excel) | 9/4/2009 |
Q: My name is Kevin Tse. I have taken a course on C++ in NYU Poly a year back. I have been ...
A: i presently do not remember the function which i used some years before but here is a way in a ...
|
| visual basic 6, Intermediate | 9/4/2009 |
Q: any help please, i already have my microsoft access data base table with only one column after id ...
A: add an imagelist and add 2 images, 1 command button add this code T is the name of Treeview Option ...
|
| Snyconize the boxes | 9/3/2009 |
Q: So I have a table that call reference with three fields/columns ( ref name, ref #, ref ver.) I have ...
A: one doesn't need to have VBA, it is part of Office suite for excel, word etc. the trouble in this ...
|
| Printing in VB6 | 9/3/2009 |
Q: I'm Sherwin Lester Aquino and I have some problems with regards to printing in a program i'm making ...
A: it is not a vb problem. sometimes the pagedefaults or printer default gets locked at Landscape. to ...
|
| Snyconize | 9/1/2009 |
Q: So I have a table that call reference with three fields/columns ( ref name, ref #, ref ver.) I have ...
A: you can all these in access itself. you could use VB but for that you need to install vb6 and so ...
|
| VB 6....... | 8/30/2009 |
Q: how to convert VB6 program into a software that can be installed and run from other computers (i m ...
A: it does the same job as the package. it is meant for persons who dont have vb installed in their ...
|
| flexgrid | 8/29/2009 |
Q: I want to display all records in my database.Am i use flex grid for this? If yes, please give steps ...
A: to display all records you can use flexigrid or datagrid or dbgrid. depends on your coding 'check ...
|
| ado connectivity | 8/28/2009 |
Q: am bca final year student my question is i don't know how creat an ado connectivity wit sql as back ...
A: let your sql server be running open control panel_Admin Tools-ODBC create a user DSN give it a ...
|
| data report based on query | 8/26/2009 |
Q: i need to display the result of the query on a data report....(i.e)i have table named student with ...
A: put a dataenvironment on form and point it to your database add a command it its sql properties ...
|
| Public Variables in VB 6 | 8/20/2009 |
Q: I had declared a public integer variable on Form1 & I'm calling Form2 using Show method, on a ...
A: what is the hangup about using a module as that is the proper method. however you can call the ...
|
| visual basic 6.0 | 8/19/2009 |
Q: plz help me sir, this is my coding Private Sub Command1_Click() Dim constr As String constr = ...
A: this is not the way to get balances into the account. your table needs to be redesigned.create a new ...
|
| Require SQL Query | 8/18/2009 |
Q: i have a table in ms access with date field, i want the sql query for date field between two dates ...
A: this is a concatenation problem. vb gets confused about the " character. use this way out: Dim ...
|
| export | 8/12/2009 |
Q: 1 How to export datagrid data from vb to Excel ? 2 How to export ms-access table from vb to Excel ?
A: 1)the datagrid gets the data from ADODC which gets the data from access table. that is the purpose ...
|
| datacombo in vb | 8/12/2009 |
Q: I am using datacombo with adodc control. the data from mysqldatabase should fill in datacombo box. ...
A: your connection string is wrong and you need to open the connection which you have not done. also ...
|
| visual basic | 8/7/2009 |
Q: how can we add button to msflexgrid columns
A: as far as i know, the button is not part of msflexgrid, but you can place commandbuttons on rows ...
|
| vb6 | 8/6/2009 |
Q: sir, I am designing Quiz Questions in vb6. I am design multiple forms for 100 Questions with option. ...
A: your question is not fully clear. how have you displayed time using time function or a timer? are ...
|
| datareport in vb6.0 | 8/6/2009 |
Q: i want to know how do you generate datareports in vb6.0? this is the coding which i have done ...
A: for datareport use a Dataenvironment control. add this to the form and for dataenvironment you add ...
|
| vb6 & ms access - run time error 13 type mismatch | 7/30/2009 |
Q: my boss ask me to develop a database(db) system. he gave me a lot of data to enter into db and he ...
A: 1) how many records are there in the db? 2) where is the data now from which you are entering? 3) i ...
|
| prevent the data table form duplicate Entry with vb 6 application | 7/28/2009 |
Q: Im working in vb 6.0 in which i make the two tables one of the masterdata of Employee in which EmpId ...
A: you have too many mistakes in the code: 1) what is Bool here and where is the value. 2) there is no ...
|
| prevent the data table form duplicate Entry with vb 6 application | 7/22/2009 |
Q: Im working in vb 6.0 in which i make the two tables one of the masterdata of Employee in which EmpId ...
A: you should not enter the Primary Key. it is automatically updated. anyway the description you have ...
|
| Search or Find Codes | 7/22/2009 |
Q: Im using vb6.0 to create a simple system for library. Now im looking for the search or find codes to ...
A: 1 which isthis country satellite provider? 2 you need use a recordet using dim esql as string ...
|
| Search method(VBA-Excel) | 7/17/2009 |
Q: I have an application in VBA and MySql as database.I have around 24 fields on user form.user can ...
A: your statement "I have an application in VBA and MYsql as database" does not make sense to me. where ...
|
| to display data in a listbox after updating a database | 7/17/2009 |
Q: i have seen your past answers and i have been using the codes in my project but i have a few ...
A: 1) it is not a good idea to use Table as the Name of table. it is a Keyword. Again the word Key is ...
|
| automatic update jpg in excel | 7/16/2009 |
Q: it is possible to have a jpg in excel file that automatic get the update when i rewrite the jpg ...
A: first, it is NOT vb but what is called VBA which is a completely different language and Usage. the ...
|
| About Flexgrid Control | 7/9/2009 |
Q: I have a flexgrid displaying data from a combo box. One of the columns displays qty. I actually ...
A: camt understand what you are trying to achieve. there is no sense to me loading data from a combobox ...
|
| How to read specific integer in the line of text file | 7/2/2009 |
Q: hope you can help me... i made program that write string into text file but before writing i want ...
A: from VB you cant directly read a particular line. you need to loop thro all the lines and check for ...
|
| Visual Basic 6.0 | 6/20/2009 |
Q: How can i make connection between VB and Sql Server by coding Reply me i am Software Engineer ...
A: first make a DSN in control panel admin tools data sources. start the sql server in vb use the ...
|
| VB6.0 | 6/19/2009 |
Q: i want to know how we can convert vb6.0 to an EXE file and how we can save the files inside and ...
A: save the project. in menu File _ make poject exe .runit. if there are errors correct then and make ...
|
| VB Query | 6/18/2009 |
Q: I made a form and connected it via ADODC to MS Access database for the 'institute code' and ...
A: to a button click add for such an event follow these steps: for ADODC recordsource initially you ...
|
| VB6 installation | 6/15/2009 |
Q: I have written an application code in VB6 and it is making use of registry to store settings in the ...
A: *which values of the Registry are you changing in client's system? * are you expert enough to know ...
|
| vb connectivity | 6/12/2009 |
Q: sir, i want to connect ms access with vb6.0 using adodb connection.plz tell me the solution
A: 'put a check mark on Project_references_Microsoft ActiveX Dataobjects library Option Explicit Dim cn ...
|
| question | 6/6/2009 |
Q: i created a form which contains 6 text boxes labeled as enter regno,regno,name,m1,m2,m3.Except ...
A: change the first textbox into a combobox and add this code making changes as needed: better to have ...
|
| Programming Help | 6/5/2009 |
Q: Using Visual Basic 6.0 : Dim x as string x=">" if 2 x 3 then msgbox "2 is Greater" else msgbox "3 ...
A: you cannot assign the arithmetic operators to a string you need to write a function based on the ...
|
| Urgent Help!!!!!!!!!!!! VB6 Saving | 6/3/2009 |
Q: Ravindra i am a student and i am having trouble saving on my program. it says i have a bad record ...
A: your code makes my head spin. why add comments when you dont know what is to be written. normally i ...
|
| LOGO | 5/19/2009 |
Q: I have make a software in vb. I want to make a logo for my exe file. I do not want to so vb form as ...
A: in your project add a form using the Project Menu_ Add Form choose Splash screen. make this the ...
|
| VB 6.0 and MS Access (Datepicker) | 5/18/2009 |
Q: I am using ACCESS DATABASE and VB 6.0 and developing a small program for inventory. The following ...
A: you are the person starting with ADODC; you are supposed to know its properties and not toss back ...
|
| DTPicker Tool | 5/18/2009 |
Q: I am using ACCESS DATABASE and VB 6.0 and developing a small program for inventory. The following ...
A: the datepicker.value can be assigned to a variable which can be used to add the record to the table. ...
|
| LISTVIEW | 5/17/2009 |
Q: How to display records in a listview from a password protected daabase.
A: Private Sub Form_Load() Set conn = New ADODB.Connection Set rec = New ADODB.Recordset conn.Open ( ...
|
| Check Box and Datagrid control in VB 6.0 | 5/17/2009 |
Q: I am shankar and interlevel using VB 6.0, I need code for the following. I am using Ms access as ...
A: the datagrid configures well only with ADODC. add adodc and point it to the table create a query ...
|
| Drawing a Line on the form using timer control | 5/7/2009 |
Q: Ravindra VB 6.0 - I want to draw a line on the form using Timer. I have three lines drawn.One for ...
A: sample programme i have incremented only one axis but you can do the same for both x and y axis , 2 ...
|
| Drawing a Line on the form using timer control | 5/7/2009 |
Q: Ravindra VB 6.0 - I want to draw a line on the form using Timer. I have three lines drawn.One for ...
A: it is not such a good idea. anyway here's the sample methood. make changes to suit you. under ...
|
| need help with vs2005 for printing | 5/5/2009 |
Q: 1. vb pro sp1 2. no database 3. complete beginner - never done vb, I have done html. 4. I want to ...
A: vb 2005 is a bit more advanced for a beginner. it is easier using VB6. ( it can be done but needs a ...
|
| simple exercise and examples | 5/4/2009 |
Q: can you tell me about site that provide a simple and important exercise and examples about : ...
A: there is no single site which completely answers all your topics free. i also help out in vb 2005 ...
|
| colorize partial cell in rowset of listview... based percentage | 5/4/2009 |
Q: see the image of my listview... I want colorize each cells in rowset based the percentage in cells, ...
A: i dont think the same cell can have two colours. what you can do is have labels on these rows of ...
|
| VB & SQL related question | 5/4/2009 |
Q: I am trying to use an sql statement to retrieve data to put into my datagrid. I am using ADODB ...
A: the sql can be done in this way Dim esql As String esql = "select * from testable where ...
|
| need of vb codes | 5/1/2009 |
Q: sir, i have design a employee in vb and the data source is from access sir i need to save or ...
A: 'under general declarations Dim esql As String, conn as ADODB.connection, rec as ADODB.recordset ...
|
| how to retrieves data from table by using two combo box | 5/1/2009 |
Q: I am trying to use an sql statement to retrieve data to put into my datagrid. I am using ADODC ...
A: Private Sub command1_Click() Dim adu As String, esql As String, ravi As String esql = "select * from ...
|
| VBA modeless userform | 4/28/2009 |
Q: . I want to show a modeless userform with a picture.. the purpose is i want to show a message ...
A: in the excel code window (alt +F11), choose Insert and select User Form. put an image Box on the ...
|
| How to select multiple records from a table in Access | 4/26/2009 |
Q: I have table called VolunteerScheduledData which has many rows. More than one row can have the same ...
A: pl send the full details with your table,required display etc to mgravi2005@dataone.in in zipped ...
|
| retriving data adodc | 4/26/2009 |
Q: sir, can you give me sample code to retrieve a specific record? (e.g when you enter student's ID, it ...
A: 1)better move to ADODB because if the same project is loaded in another computer the ADODC has to ...
|
| How to select multiple records from a table in VB | 4/26/2009 |
Q: I have table called VolunteerScheduledData which has many rows. More than one row can have the same ...
A: first it is not clear if you are in access using VBA or VB,which is a separate programme. second ...
|
| datagrid in VB | 4/25/2009 |
Q: i want to know how to populate the datagrid with the data retrieved from the database.my connection ...
A: datagrid requires use of ADODC. if you are using ADODB switchover to Msflexgrid coding is like dim ...
|
| Compile Error: Procedure Too Large | 4/22/2009 |
Q: I also need to make this applicable for 2 sheets that I have to report on a monthly basis. ...
A: for a beginner you have tried things beyond your depth. for god's sake where did you pick up such ...
|
| Compile Error: Procedure Too Large | 4/22/2009 |
Q: I also need to make this applicable for 2 sheets that I have to report on a monthly basis. ...
A: your code does not make sense to me. first the scroll simple moves the cursor, so repeated calling ...
|
| vb6.0+ ms access | 4/22/2009 |
Q: i want to add photos in my database and want to display it in the picture box. can i do this? i am ...
A: in acces you can use one method: in the table, have a field with OleObject type make a form based ...
|
| Listbox in VB 6.5 | 4/21/2009 |
Q: I am a beginner, but mostly capable of making things work. I have a user form that has 12 list ...
A: first are you referring to VBA (which is very much different from VB) or just VB. there is nothing ...
|
| VB+Access | 4/15/2009 |
Q: I'm having Data grid On my form. I'm inserting data into that by record set.I want to print this ...
A: you can use the dataenvironment even for conditional filter put a dataenvironment on form and point ...
|
| Can we Create Tubular Form like in access in vb | 4/13/2009 |
Q: With great esteem and honour I would like to guide me in the following problem. Can we insert ...
A: you mean Tabular form? whatever you can do in access, you can do in VB. you can take a value from ...
|
| how to link VB6and MS access | 4/11/2009 |
Q: sir, my question is that how to connect VB6 and ms access to display data of ms access
A: 'put a check mark on Project_references_Microsoft ActiveX Dataobjects library Option Explicit Dim ...
|
| VB 6 option button query | 4/10/2009 |
Q: In VB 6 i will create Quiz using database. My knowledge is beginner in VB. I have a problem to set ...
A: what is ans(0) ? how can the user be responsible for Label6, label7 and label8 caption? if ans(0) ...
|
| Dear sir | 4/7/2009 |
Q: hi please tell me the way of displaying all items of listview in datareport by grouping like putting ...
A: datareport needs dataenvironment. first where did the listview get the data? listview is for ...
|
| vb | 4/6/2009 |
Q: i m doing project in vb 6.0.i have done connection of database with adodc and i want to retrieve the ...
A: Option Explicit Private Sub Command1_Click() Dim esql As String esql = "select * from testable ...
|
| include? inheritence | 4/2/2009 |
Q: in visual studio 05 im using visual basic and on one form (form1) i have a listbox called Pnames and ...
A: in form2 add this code: Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As ...
|
| VB6.0 Multi-User Problem(Auto-Number) | 4/1/2009 |
Q: I am using a multi-user application in vb6.0 and using back-end ms-access. I have splitted the ...
A: first of all autonumber is inadvisable. change it to Number. you will have the freedom to alter it, ...
|
| Query on MS Access | 3/27/2009 |
Q: VB6.0+MS-Access Please, I need help on the following: I run a query (table view) and then manually ...
A: ok, this cannot be done automatically from vb you need to change the value by code or manually if ...
|
| Query on MS Access | 3/27/2009 |
Q: VB6.0+MS-Access Please, I need help on the following: I run a query (table view) and then manually ...
A: if you change values in table view of access, you can do so by moving to the other field and change ...
|
| Visual Basic 6 | 3/25/2009 |
Q: My level of knowledge is beginner. My problem is that I'm trying to create an array in Visual Basic ...
A: here's the sample code: Option Explicit Dim arr() As Integer Private Sub Command1_Click() Dim ...
|
| passing variable to the procedure | 3/22/2009 |
Q: Ravindra The program is VB6. My question is: I have two combo boxes from which I wanted pass values ...
A: i dont remember your previous question(i get a huge no of them daily) what has Public, static to ...
|
| visual basic 6 | 3/18/2009 |
Q: Sir,I have tried installing visual basic 6 on my system. At the end of the set up procedure,a ...
A: uninstall vb6 and reinstall the same. while installing, you should not run any other programme. if ...
|
| Filtering data | 3/16/2009 |
Q: Sir, Can i filter and retrieve data from my database i add ADO DC connection to my simple ...
A: better change over to ADODB from ADODC. the code is slightly different. you can add, edit,delete ...
|
| delete seleted record in datagrid | 3/14/2009 |
Q: delete seleted record in datagrid view i also database table
A: assign the datagrid1.row to a variable(when selected) delete from your Tablename where ITem=" & "'" ...
|
| Filtering data | 3/13/2009 |
Q: Sir, Can i filter and retrieve data from my database i add ADO DC connection to my simple ...
A: it can be filtered sample code; Option Explicit Private Sub Command1_Click() Dim esql As String ...
|
| VB 6 & Access Connection for multiuser | 3/5/2009 |
Q: I am hoping you can help me. We have developed an app using VB6 & Access 2000. It works fine on all ...
A: the problem here is with access. though it allows multiuser operation, trouble starts with updating ...
|
| vb6+excel-- beginner to VB6 | 3/2/2009 |
Q: I am very new to VB and i m currently using VB6..i have a from wid 2 text boxes thru which i accept ...
A: this is a sample code: you can modify areas to suit your needs: Option Explicit 'under ...
|
| Need help regarding Data report in vb 6 | 3/2/2009 |
Q: I created a simple Sales program in VB6 (Access as back-end), added dataenvironment and datareport ...
A: in the dataenvironment command1 enter under sql statement. see that command name and connection ...
|
| Function of random Numbers | 2/10/2009 |
Q: Hey, I wanted to know how to write a function that can generate random numbers. I hope you ...
A: try this out Option Explicit Private Sub Command1_Click() Dim i As Integer, holder As Integer ...
|
| VB 6.0 | 2/7/2009 |
Q: can I find any particular record using this-'ADODC1.Recordset.Find' method in VB 6.0 when our ...
A: Option Explicit Private Sub Command1_Click() Dim esql As String esql = "select * from testable ...
|
| excel vb | 2/2/2009 |
Q: I have created a form having several textboxes and one commandbutton named as add in excel vb. The ...
A: Option Explicit 'under project_references check Microsoft Excel 11 library Private Sub ...
|
| How to lookup details from Excel in VB | 2/1/2009 |
Q: My name is Naman Shah I am a Beginner in VB development I am using VB 6.0 Using Microsoft Excel ...
A: these are the steps 1) get into your excel sheet using VB: under project_references check Microsoft ...
|
| lottery numbers | 1/31/2009 |
Q: i am a beginer and olso need advise to what sort of compilers are available for the advise i need ...
A: you can store the previous values in a table in access. are you using VB or access, your question ...
|
| Split text | 1/29/2009 |
Q: Greetings, sir i just want to ask how can i split the multiple text contained by one text box and ...
A: you can first use the instr(1,"string,",") to find the position of the delimiter ie comma. then with ...
|
| datagrid and data report in vb | 1/29/2009 |
Q: sir i was wonder if u could help me out with something. well i have a invoice form and on the form i ...
A: you have been asking the wrong questions,considering what you want. this is not possible using ...
|
| datagrid | 1/28/2009 |
Q: sir i was wondering i u could help me out with one more thing. i have a datagrid and i want all the ...
A: asking questions like this, change it and modify it etc wastes my time. to get the data of the ...
|
| adodc in vb6 | 1/27/2009 |
Q: i am using a vb6 and database 2003. what i am trying to do is i have a invoice form and the inform ...
A: 'check mark on Project_References, Microsoft ActiveX Data object 2.8 dim conn as adodb.connetion,rec ...
|
| Help wiht Access and Excel | 1/26/2009 |
Q: I am working on a database fora class. the data provided is in raw text fiel format and i have to ...
A: you can load the lines of the textfile into an access field, one line at a time. then using Mid and ...
|
| database project in Visual basic | 1/26/2009 |
Q: In the module i have created an ADODB connection provider=Microsoft.jet.oledb.4.0 In the form i have ...
A: the access table stores dates by default in the mm/dd/yy format. 1) in the design of table, see ...
|
| VB Report | 1/2/2009 |
Q: Namaskar. I created a simple Sales program in VB6 (Access as back-end), added dataenvironment and ...
A: you need to make the command in the dataenvironment with a ? the value of which is obtained in a ...
|
| Code problem | 10/14/2008 |
Q: Hey i wonder if ya can help, im using VB 6 and bascially i have a code to hide rows that have spare ...
A: i dont like your hiding the rows based on contents. it is not a good coding logic. why disturb the ...
|
| Excel Macros | 10/11/2008 |
Q: I have to sheets. Sheet 1 have some columns like 1,2,3,4 and rows A,B,C,D_ _ _not fixed. Can ...
A: remember that this is a free site and you are using my time. if you want any help, you should be ...
|
| VBA Option Explicit error | 10/10/2008 |
Q: I am updating and maintaining a database written by someone else. I have very little VBA or Access ...
A: option explicit means you have to predeclare the variables before using them. here validate and ...
|
| don't read removable disk | 10/10/2008 |
Q: sir i know you are an expert of vb, I hope you can answer my problem...i have a visual basic project ...
A: if you make an exe of the project file and use a package and deployment wizard and turn out a ...
|
| How to pass an array of TextBoxes by parameter to a Sub | 10/9/2008 |
Q: I am working with Visual Basic 6.0 and my level is intermediate. I am working with forms containing ...
A: have all the textboxs in one array and use this code to empty them Option Explicit Private Sub ...
|
| VB code | 10/9/2008 |
Q: I have sent you a question about VB and you said that it is not VB. I think that the code is VB ...
A: the windows logon details are available in the registry and if you are at least an inter level ...
|
| A Question related to vb 6 | 10/9/2008 |
Q: Please guide me how to scroll a ms flex grid using PgUp and PgDn keys on keyboard Thanking you ...
A: i do not like your coding. anyway this is your lookout the scrolling by code can be done with this ...
|
| vb excel | 10/8/2008 |
Q: How can I populate the data I entered on our purchase order running on macro (PO number and date ...
A: if you have excel, then access must be there; it is part of Msoffice. in excel alone, you may not ...
|
| excel vba | 10/8/2008 |
Q: can u guide me with excel vba. i have some questions. am working on current project on vba excel ...
A: you need to make macros dealing with each range where formatting needs to be done. to format the ...
|
| A Question related to vb 6 | 10/8/2008 |
Q: Sir, I want to protect my software using a username and password form to be loaded as soon as I ...
A: a genereal description of such a nature cannot help me locating your source of error. how can i ...
|
| vb excel | 10/8/2008 |
Q: How can I populate the data I entered on our purchase order running on macro (PO number and date ...
A: this can be done in Visual Basic and access. using Excel and macros may not be suitable. if you have ...
|
| values | 10/7/2008 |
Q: i make a value of alphabet example A=1,B=2 and write any person name the name value is appear how i ...
A: you could use use arrays and make it a number. it is not such a hot idea. because letters z,v,w etc ...
|
| Get Data from DBGrid | 10/7/2008 |
Q: Sir. I want to get the data of only one column from DBGrid at runtime before updating the Database, ...
A: question unclear to me. the dbgrid gets its data from the database, so what do you mean at ...
|
| VB6 and Access DB, search between two dates | 10/7/2008 |
Q: I read a question today regarding subject, I don't understand the GOOD=chr(35) . . . Using VB6, ...
A: the problem here is you are picking my answer in part1, add your own code, and take my help and ...
|
| VB6 and Access DB, search between two dates | 10/7/2008 |
Q: I read a question today regarding subject, I don't understand the GOOD=chr(35) . . . Using VB6, ...
A: 1)you dont understand GOOD? then have BAD=chr(35). it is used to avoid confusion of the characters ...
|
| vb+excel | 10/6/2008 |
Q: i am using vb 6.while exporting to excel i am not getting the negative values from ms access dbase ...
A: why not export directly from access to excel using the auto wizard? you will get all the values why ...
|
| Saving data entered in vb6.0. form to a table in Access 2003 | 10/5/2008 |
Q: I am getting an error regarding data type mismatch and parameters. When trying to save customers and ...
A: that is better.i understand the question now but require some more clarification. it is clear that ...
|
| Printing With DataGrid In VB6 | 10/4/2008 |
Q: How 2 Print Content Of Data Grid In VB6 i m using following codes Private Sub cmdPrint_Click() Dim ...
A: you are using your own code for display and using a loop to fill a textbox. this does not make ...
|
| Printing With DataGrid In VB6 | 10/4/2008 |
Q: How 2 Print Content Of Data Grid In VB6 i m using following codes Private Sub cmdPrint_Click() Dim ...
A: rowset problem arises if grid is not displaying the data. 1)the code sent by me works alright. 2) ...
|
| How to Open .hlp in vb project | 10/4/2008 |
Q: Sir. I'm a computer engi student, i trying to studying Visual Basic my self. But Sir i have ...
A: first, you need to correct your english syntax then vb syntax. i trying shows bad choice. then in ...
|
| problem in filling datacombo in vb.6 | 10/4/2008 |
Q: I'm inter in vb.6 and i have a datecombo and a textbox in one of my form.i want my datacombo to be ...
A: dim conn As ADODB.Connection, rec As ADODB.Recordset, private sub form Load() Set conn = New ...
|
| Printing With DataGrid In VB6 | 10/3/2008 |
Q: How 2 Print Content Of Data Grid In VB6 i m using following codes Private Sub cmdPrint_Click() Dim ...
A: first all the lines for datagrid1.columns(... in above code should be in one line. second, you dont ...
|
| regarding to "Data Report of VB 6.0" | 10/3/2008 |
Q: Repected Sir, i've completed project in VB 6 and in Data report i want to display the report ...
A: your question is not clear. i couldn't success (gramatically incorrect) and does not say what the ...
|
| about vb | 10/2/2008 |
Q: ....i m a beginner in vb6, i hav refffered d code which u hav given to kevin...on 16/8/2006...i m ...
A: have you put a check mark on Microsoft ActiveX data objects Library 2.8 under Project_References? ...
|
| Importing lines of data from a text file | 10/2/2008 |
Q: I wanted to know what Visual Basic (VB 6.0) code I might use to import specific lines of data from a ...
A: in such a case you need to Read the text file move next if the lines are not required and then ...
|
| Select data between two date fields | 10/2/2008 |
Q: i have developed a VB6 project using ms access database. my level of knowledge will be between ...
A: first, you need to modify your tables. the tables should receive data and you can use queries to ...
|
| modifying a record | 9/26/2008 |
Q: respected sir, please tell the coding for vb6 in modify a record. thank you
A: Option Explicit dim conn As ADODB.Connection, rec As ADODB.Recordset, esql As String Private Sub ...
|
| rs.addnew inserting rather than adding | 9/22/2008 |
Q: I;ll pay you £20 for a solution...(probably obvious to you!) VB6, Access Database, DAO: When I add ...
A: it is nice of you to offer 20GBP. i'm willing to solve your problem. 1st which is your version of ...
|
| VB6 & Access 2003 | 9/22/2008 |
Q: I am a beginner with databases. In writing my program, I am creating a database programmatically. I ...
A: no change in case of dates except it should be formatted to same as the table design. suppose the ...
|
| vb 6.0 | 9/22/2008 |
Q: how can i prevent duplicate entry in database , i have Student table where idno and scholar no are ...
A: Option Explicit 'put a check mark on Project_references_ Microsoft ActiveX dataobjects 2.8 library ...
|
| VB6 & Access 2003 | 9/21/2008 |
Q: I am a beginner with databases. In writing my program, I am creating a database programmatically. I ...
A: under project_references put a check mark on Microsoft Data access components 2.6 / 2.8 or ...
|
| vb6 | 9/21/2008 |
Q: I have designed an application with vb6. When I run this application on other systems, fonts change ...
A: you are asking the question in reverse. the standard fonts are already chosen on other computers. ...
|
| Calender control | 9/19/2008 |
Q: Im facing permission denied error while trying to add Microsoft calender control in my program.can ...
A: check for existence of mscal.ocx this should be in C:\Windows\system32 directory you can get this ...
|
| date setting control in vb | 9/18/2008 |
Q: sir I want to change the date setting in system through vb coding. please give me an idea about ...
A: this is an unhealthy practice because if someone changes the system date and time you need to have ...
|
| Runtime Error | 9/10/2008 |
Q: I consider myself a beginner when it comes to writing macros. I'm trying to write a macro that will ...
A: type mismatch means data type error. the macro is working fine in my excel work book. the cola ...
|
| Runtime Error | 9/9/2008 |
Q: I consider myself a beginner when it comes to writing macros. I'm trying to write a macro that will ...
A: note this is NOT visual basic but Visual Basic for Applications (VBA) they are different programmes ...
|
| visual basic 6.0 | 9/8/2008 |
Q: i am a absolute beginner.i want to learn visual basic,but confused which version should i learn, ...
A: 1)stick to vb6 2) links to sites http://www.codeguru.com/vb/ ...
|
| VB6 & SQL Server 200 | 9/6/2008 |
Q: I have a project on VB6 and the back end is SQL Server 2000. My problem is how am I to run the ...
A: sample code: esql = "insert into testable values" & "(" & "'" & Text1 & " '" & "," & Val(Text2) & ...
|
| vb+oracle | 9/4/2008 |
Q: my name is afnan zubair. i was the one who asked u to do a project on sports club management. i sent ...
A: you are from Dubai right? ok, give me the details of what you want in this programme. i do a large ...
|
| Excel listbox | 9/3/2008 |
Q: Can you please help me with my problem regarding listbox indexing. I am trying to assign a specific ...
A: try this: Private Sub ListBox1_Click() Static Myse As String Dim id As Integer Dim x As Integer ...
|
| doing OCR on VB | 9/1/2008 |
Q: 1.) VB6 2.) not really 3.) I can understand / manipulate some codes (begginer i think) 4.) VB + OCR ...
A: checkout this link: ...
|
| vb 6.0 quest | 8/31/2008 |
Q: explain the difference between declaring a variable in general declaration section of std code ...
A: it would be nicer if your question started like could you please explain... the tone appears ...
|
| VBA 6.05 +Access 2003 EVAL function use | 8/25/2008 |
Q: Requested info: VBA verison 6.05, ADO version 2.8 +Access 2003 version 11, Intermediate knowledge ...
A: you could use a function like Private function Selector(olage as integer) and in the function add ...
|
| Caesar Cipher - VB | 8/24/2008 |
Q: I'm fairly new to Visual Basic but i have some basic knowledge and if you could help me with the ...
A: it is not the problem in VB but the logic of how to set about. it may be a bit of a struggle if you ...
|
| Visual Basic Commands for Microsoft Word 2007 | 8/22/2008 |
Q: (I would definitely say I am a beginner) I'm using what the about window says Visual Basic 6.5 and ...
A: you are chewing more than your zone for a beginner. first,this has nothing to do with visual basic ...
|
| Making a field that can act like excel in VB6 | 8/22/2008 |
Q: I am working on a database project (using VB6 and access database, ADO connect) for my own use. What ...
A: by link a database to datagrid to DISPLAY? is that what you mean. the datagrid is only for display ...
|
| Easy question | 8/21/2008 |
Q: I want to insert a page break if there is a value in a column a. The break should be immediately ...
A: 1) how do you say easy question? 2) what is a pagebreak in excel? it is only for printing. for ...
|
| API | 8/20/2008 |
Q: I have an application which needs to determine determine whether the caption of the command button ...
A: why api have two command buttons and add this code Option Explicit Dim adu As Boolean Private Sub ...
|
| VB 6.0 | 8/18/2008 |
Q: mr. Ravindra.i need your help. In my accounting audit system software, I need to audit the ...
A: for a beginner your code is improper. now why not get the IDs into a listbox (not listview) and ...
|
| vb6 Slider Plz help me... | 8/17/2008 |
Q: I have added slider to my project. And i have changed its orientation to 1-sldVertical then the ...
A: first, your words "Please some body help me." is plain STUPID. you are asking me the question and ...
|
| Change code with cell value | 8/15/2008 |
Q: I have code that get file names from a directory, but I do not want to have the user have to go into ...
A: there are a number of errors in your code: 1 you are using Application.screenupdating etc before ...
|
| Setup Wizard | 8/12/2008 |
Q: I have been using VB 5.0, as a self taught programmer for many years. I have been using it for ...
A: the package and deployment wizard is part of visual studio tools. perhaps this installation covered ...
|
| Setup Wizard | 8/11/2008 |
Q: I have been using VB 5.0, as a self taught programmer for many years. I have been using it for ...
A: sometimes vb files get corrupted and produce some errors. try uninstall vb fully and reinstall. if ...
|
| printing a form in vb | 8/11/2008 |
Q: i want to print the current form and as wel as save the form in word document after printing it..plz ...
A: first, you can print the form using printform command. i do not know why one should save the ...
|
| Visual Basic | 8/6/2008 |
Q: i can pay u, no problem. how is the payment system?.... i need the project on sports club management ...
A: good. i'll make the project for you.before that,confirm these: payment thro' Paypal. easy. 1) you ...
|
| vb+excel+notepad | 8/6/2008 |
Q: I have used your code of extracting notepad contents to excel. Its working fine. I had a problem ...
A: firstly, i dont like a weblink to my own reply. it is pure waste of my time. why cant you add the ...
|
| pausing a macro for user entry. vb+excel | 8/5/2008 |
Q: Using VB 6.3 Fairly good knowledge of vb, self-taught. I must transfer a lot of data from access ...
A: any system design which calls for copy paste 40 times a day is surely not very logical. to make ...
|
| pausing a macro for user entry. vb+excel | 8/5/2008 |
Q: Using VB 6.3 Fairly good knowledge of vb, self-taught. I must transfer a lot of data from access ...
A: i dont see the need for any macro or such when you open the access database, choose menu item ...
|
| about excel sheet | 8/5/2008 |
Q: Sir,, I want to open an excel sheet in my vb project which I have saved in D drive.... Is there any ...
A: put a check mark on Project_references_ Microsoft Excel 11.0 object library. option explicit Dim ...
|
| How to print Report from MS Access | 8/2/2008 |
Q: Please help me. I want to print report directly from Ms Access using VB 6. I had geberated the ...
A: check my code after the line appaccess.visible =true there is a line exit sub then 1 set ...
|
| ADO, VB6 Delete | 7/31/2008 |
Q: I am a bit stumped with trying to delete a record form a Textbox. 1. the record was selected from a ...
A: the problem here is the apostrophe in Bob's. sql gets confused in concatenation. to get around ...
|
| Combo Box Trouble | 7/31/2008 |
Q: Hey! I am trying to create a ComboBox with a default value visible and then when the arrow is ...
A: the problem here is you are in Visual Basic help line and you are asking a question which is in ...
|
| Accessing VB code in a Word Doc from a VB Program | 7/29/2008 |
Q: I am trying to write a little VB program that will open an existing Word document that has a lot of ...
A: my code was to be used as a sample. if you change appword.visible=false then the document wont be ...
|
| VB+Excel | 7/28/2008 |
Q: Full name: Jovan Roy Level: Beginner I put a command button on an Excel sheet to perform a loop. ...
A: 1) for a beginner, such analyses is not reccommended. 2) there is no VB in excel, it is VBA which ...
|
| Accessing VB code in a Word Doc from a VB Program | 7/28/2008 |
Q: I am trying to write a little VB program that will open an existing Word document that has a lot of ...
A: 'put acheck mark on Project_References_Microsoft Word Object Library Private Sub mnuWord_Click() ...
|
| vb6 | 7/28/2008 |
Q: my database test.mdb is protected with password I write : public DB as Database set ...
A: your code does not make any sense. switch over to ado and use this code: 'check Microsoft ActiveX ...
|
| date format using date picker | 7/28/2008 |
Q: ravindra, i wanna ask how to know the day name like monday, friday, saturday, sunday, etc with date ...
A: Option Explicit Private Sub Command1_Click() Dim adu As String adu = ...
|
| VB6 & Access Report | 7/27/2008 |
Q: I have a report designed in VB6 however i would like to know if it is possible to bind a criteria to ...
A: 'first create a report in access where all records are shown. say this is RTestable 'Under ...
|
| Search for a FIle on a Drive in VB6 | 7/23/2008 |
Q: I am using VB6. I have been having some trouble determining the proper search command to search for ...
A: 'put a check mark on PRoject_references _ Microsoft Scripting runtime Public Function ...
|
| nesting of if else and checking multiple conditions in if else | 7/23/2008 |
Q: how to nesting of if else and checking multiple conditions in if else
A: are you also ravindra? there are different methods: you could nest a select case if passing ...
|
| VB 6 And report | 7/19/2008 |
Q: Please, I designed Access report and use VB6 to invoke it, but whenever I invoke it, it opens ...
A: in access database choose Tools_startup in display forms combobox choose none. uncheck all options ...
|
| Regarding datagrid | 7/18/2008 |
Q: Sir, I want to display records in datagrid from sql database ..How can I do that?????/ Kindly help ...
A: your coding is improper. you use object, adodb, adodc everything. and for dates your coding makes me ...
|
| VB6 - ADO | 7/17/2008 |
Q: I ve got a simple program usin ADO to read from as database. I already populate a combobox with the ...
A: if custId is a textfield then use: "select * from TableName where CustId=" & "'" & iDsearch & "'" ...
|
| visual basic+ms access | 7/16/2008 |
Q: .i am using vb6 and ms access..i have created a parameterized query including single parameter..the ...
A: for command of dataenvironment use this: Select * from testable where FieldName=? and with the ...
|
| VB6 Printform | 7/16/2008 |
Q: Question V.B. 6 level Inter Michael Rae Saga simple question... How can i manipulate the width and ...
A: in print command the label does not exist. you can change the fontsize just before and after this ...
|
| Printer Label width & height | 7/14/2008 |
Q: V.B. 6 level Inter Michael Rae Saga simple question... How can i manipulate the width and height of ...
A: you cant change the lable using printer commands. the printer.print etc are used to print after the ...
|
| To retrive records from sql database | 7/12/2008 |
Q: Sir My query is how to retrieve records from sql database and display it into textbox .M using vb6
A: sample code: always use a label or grid to display results and not a textbox as the user may change ...
|
| vb | 7/10/2008 |
Q: how to retrieve values from access file in vb?
A: 'put a check mark on Project_References_ Microsoft ActiveX Data Objects Library 'you can addnew ...
|
| vb + access | 7/8/2008 |
Q: please tell me how to connect a db other than biblio and nwind.mdb..i am using vb 6.0 as a ...
A: this error is because of version of access if you are using data control. use this code: better to ...
|
| VSS 6.0d and VS 2005? | 7/3/2008 |
Q: After using Visual Sourcesafe 6.0d with VB 6.0 for several years, I recently installed Visual Studio ...
A: thre reason the allexperts is not allowing ratings is I have disabled this feature as i wish to get ...
|
| adodc | 7/3/2008 |
Q: i am using vb6. I used adodc in order to display different fields from my database.. my problem is i ...
A: i dont advocate use of adodc. change to adodb because no control is needed. here is sample code: ...
|
| VSS 6.0d and VS 2005? | 7/2/2008 |
Q: After using Visual Sourcesafe 6.0d with VB 6.0 for several years, I recently installed Visual Studio ...
A: vb 2005 is a completely different way of writing code and you need to unlearn many aspects of Vb6 ...
|
| Visual Basic 6 | 7/1/2008 |
Q: I am a beginner in visual basic 6. I am currently doing project in visual basic 6. In that I want ...
A: Option Explicit Dim entry As String 'this puts the text into the textfile Private Sub ...
|
| Error:input past end of file | 6/30/2008 |
Q: I have used this code and getting an error input past end of file(written near line. )What does it ...
A: it means the point of reference in text file has gone beyond the length of text file (instead of 11 ...
|
| How to link the Help menu contents to one another??? | 6/28/2008 |
Q: In vb6 i have created a program i.e i took 1 form and i have created Help menu using menu editor. ...
A: there are 2 methods, vbhelp and html help/ for html a chm file is needed. if you have a .chm file ...
|
| Visual Basic, Opening a file to a multi-line txt field through a FilelistBox | 6/27/2008 |
Q: I'm writing a program to help edit a specific .ini file for a program to help newcomers out. What I ...
A: store the path of the selected text file to a variable and use the shell command to open the same. ...
|
| adding text and data files in VB 6 | 6/26/2008 |
Q: I am creating an .exe program with VB6. I would like to have the program add certain files to a ...
A: you cannot add the text files to the exe file. you can put them in a folder along with exe and refer ...
|
| MSFlexGrid Data ,put it in .txt | 6/23/2008 |
Q: read this type of data from .txt and put it in MSFlexGrid, Coke 4500 1 2 3 4 5 Minerals 4200 5 ...
A: my system was down and restored now. because of the backlog of unanswered questions, i'll be able to ...
|
| combo box with notepad | 6/23/2008 |
Q: I have combo box in my vb project.but the combo list vl be more than 100 items.so i want to create ...
A: no problem with 100 items in adodb open the connection and add this code: Private Sub ComboLoad1() ...
|
| application disappears | 6/22/2008 |
Q: vb6, access db, beginner, Hi, this my first commercial application after practising vb for sometime, ...
A: if you are willing to donate some cash, ok, send me the following points: 1)what does the ...
|
| Msflexgrid in vb6 | 6/20/2008 |
Q: I have a specific requirement of inserting a row into MSFlexGrid at runtime. This should be ...
A: sample code for inserting a row at a selected point. G is the name of the msflexgrid. Dim i As ...
|
| Combo box in VB | 6/20/2008 |
Q: i wnat to ask a question ? My question is : i m making a project in vb. in this project i place a ...
A: put your values red,blue etc in Combo1 list property and have combo1.enabled=false have a ...
|
| Execution of between operator of access through vb 6.0 | 6/17/2008 |
Q: "i have two dtpicker and one cmdbutton in my application and i want display the datareport according ...
A: your code is too simplistic. it wont work. the date between 2 dates produces errors in datareport. ...
|
| about print option | 6/16/2008 |
Q: sir i want to ask a another question. sir i have a tabstrip in my project in which i have a two ...
A: you could use: printer.print text1 printer.print text2 'and so on printer.enddoc 'or you could ...
|
| browsing pictures in common dialog box to load pictures | 6/16/2008 |
Q: I am doing project in VB 6.0+ oracle.I am a beginning .I want to know the coding for browsing the ...
A: common dialog isnt an ideal way of viewing pictures. better to load the full paths in a list or ...
|
| problem in LostFocus property of textbox | 6/15/2008 |
Q: First many many thanks for your previous valuable suggestion, Sir here i am doing a validation ...
A: Private Sub Command1_Click() rec.Open ("select item from testable"), conn, adOpenStatic, ...
|
| SET UP CAN'T CONTINUE BECAUSE SOME SYSTEM FILE IS OUT OF DATE | 6/11/2008 |
Q: i created an application useing VB 6.0 and MS-Access.i made it exe and packaged as well as deployed ...
A: the ideal case is where the second computer has vb6,windows xp3 and ms access 2000. or else, you ...
|
| VBA+Excel | 6/10/2008 |
Q: I am trying to write a program that reads a .txt file from notepad into excel then use that ...
A: code in macro: Open "C:\test.txt" For Input As #1 ' change to your filename path linecount = 1 ...
|
| vb with MS access | 6/10/2008 |
Q: i m beginner in vb 6 my question is : when i start the project my first, last , previous and next ...
A: the idea in giving a sample code is for you to study the same and pick out what is needed> your ...
|
| problem in retrieving null value from database | 6/10/2008 |
Q: i am developping an application using VB 6 and MS-Access.i just showing some records in the form ...
A: dont waste my time by asking such partly hidden questions like Null for a date. Does your ...
|
| have a problem in query expression | 6/10/2008 |
Q: i make a project in vb & ms access. design a table name joborder and make some fields like ID ...
A: you have not defined your problem clearly. the trouble with autonumber fields is that while ADDNEw ...
|
| vb with MS access | 6/10/2008 |
Q: i m beginner in vb 6 my question is : when i start the project my first, last , previous and next ...
A: see sample code: 'put a check mark on Project_References_ Microsoft ActiveX Data Objects Library ...
|
| problem in retriving null value in the front end | 6/7/2008 |
Q: in the access table i assigned date and text datatype in two fields.and also set that allow Zero ...
A: you have to tweak these factors in your access table. in design, see that the datatype is set to ...
|
| problem in installing set up file in other system | 6/7/2008 |
Q: i created .EXE file and Packaged it. while i am installing in own system it installed successfully ...
A: this is because of version conflict in the third machine. if the version of VB or microsoft office, ...
|
| How do i print form contents having same formating | 6/3/2008 |
Q: how do i print formatted contents of the form my code is here and it prints simple text iwant to ...
A: printer will take default values. you need to set them or use: when you type printer. you will ...
|
| Simulate VLookup in Access VB Code | 6/2/2008 |
Q: Ravinda, I have a table in Access that I need to change the value of a field based on a "similar" ...
A: if the values are changing .how do you get them on to your table? by entry. Then enter them to an ...
|
| Simulate VLookup in Access VB Code | 6/2/2008 |
Q: Ravinda, I have a table in Access that I need to change the value of a field based on a "similar" ...
A: function round(1.5) may meet your job. or you could compare using a function: sample: Option ...
|
| VB and MS Access dB communication | 6/2/2008 |
Q: I have a problem communicating between VB 6.0 and a MS Access database. The dB if in Access 97 ...
A: vb is independent of access. it does not matter which version. vb6 can deal with all or any versio ...
|
| vb 6.0 buttons codes | 6/2/2008 |
Q: i want to know how i can code for the following buttons:Add,Update,Delete,and Search;when i'm using ...
A: the adodc is not a good control to use the above options. better shift to ADODB. here's how it is ...
|
| installation problem in set up file | 6/1/2008 |
Q: i created .EXE file and Packaged it. while i am installing in own system it installed successfully ...
A: there could be various reasons: path of mdb file different. version of office different. also vb is ...
|
| Adodc | 5/31/2008 |
Q: I'm actually using Adodc control on my form . I want to put a listbox where two fields from my ...
A: use a Microsoft Remote Data control instead of adodc and use a DBlistbox instead of listbox. you ...
|
| summing up the values of datagrid column | 5/30/2008 |
Q: Sir I would like to know how to sum up the numeric values of a column of a datagrid whose answer ...
A: i have already given you the method. it should come from a query and not by adding column values. ...
|
| Datagrid in vb6 | 5/30/2008 |
Q: Please how to get selected row of datagrid in the next form of textboxes and comboboxes.For example ...
A: i have already answered your question. assign the value of the row to an integer variable to ...
|
| About click or doubble click of datagrid in vb6.0 | 5/30/2008 |
Q: Please how to get the selected row record of a datagrid on the next form having controls like ...
A: i think i've already answered this question for you. dim adu as integer Private Sub ...
|
| Domains | 5/30/2008 |
Q: My version is Visual Basic 6. I would want the code for printing a data grid named datagrid1 with ...
A: Option Explicit Private Sub Command1_Click() Dim rowVal As Integer printer.print "" ...
|
| datareport | 5/28/2008 |
Q: How to prepare the data report in vb according to the fields wise.. Ex. I've the fields ...
A: in your dataenvironment on which you base the datareport.. add this command1 ... commandtype ...
|
| vb6 datagrid | 5/28/2008 |
Q: Please could you tell what to do, I want to print a dataGrid with all the data inside the grid.I am ...
A: Private Sub Command1_Click() Dim RRow As Integer, RecNum As Integer RecNum = ...
|
| While extracting selected row from Access being in vb 6 facing error | 5/27/2008 |
Q: i am going to retrieve selected record from data base.there is an error i am getting which i did not ...
A: change the code to sqlstmt = "SELECT * From CertificateStatus WHERE VesselName=" & "'" & TextString ...
|
| Regarding datagrid | 5/26/2008 |
Q: I have a datagrid that contains a coloumn of attendence of a particular ID.Whai I want is to count ...
A: one method: Option Explicit put another ADODC2 on the form and a label and this code 'change the ...
|
| excel vb macro to sort columns numerically | 5/25/2008 |
Q: I am writing an excel VB macro that sorts columns based on the header column title ("DEVICE") and ...
A: firstly, note that it is NOT a VB macro but a VBA macro. they are two different kettle of fish. ' ...
|
| vb | 5/25/2008 |
Q: how can i fetch the record set into the ms-flex grid .. (i want to, when i execute the query the ...
A: your quetion is not worded clearly for me to understand exactly what you mean. however see the ...
|
| VB - Nested loops, Beginner | 5/24/2008 |
Q: 1. Create a program which will print a triangle of stars, given the size by the user(edit for this). ...
A: 1) Private Sub Command1_Click() Dim adu As Long For adu = 0 To 27 Print (adu + 1) ^ 3 Next End Sub ...
|
| Need Help in Connectivity in VB6 | 5/24/2008 |
Q: I am working as Technical Support Engineer in a Software company for Last 4-5 Years. I have the ...
A: 'put a check mark on Project_references_Microsoft ActiveX Dataobjects library Option Explicit Dim cn ...
|
| visual basic | 5/23/2008 |
Q: what's the quiry of delete in adodc(access link) ?
A: your question is badly framed. you want to delete a record using adodc? what do mean by quiry of ...
|
| excel | 5/20/2008 |
Q: I'm a newb w/vb. I have a code that runs long and I still have a lot to enter. You can see that ...
A: 1) ok, looking at your problem, excel is NOT the ideal choice for a programme. a nice programme ...
|
| Printing in Visual Basic 6 | 5/20/2008 |
Q: Programing Language - VB 6 Database - MS-Access Level of Knowledge - Inter I want to print ...
A: you can print using the printer.print option with the tab(number) to print the format as per columns ...
|
| vba excel | 5/19/2008 |
Q: I'm a newb w/vb. I have a code that runs long and I still have a lot to enter. You can see that ...
A: first, are you in Visual Basic form or user form in excel? secondly, my advice to you is you should ...
|
| the use of & | 5/19/2008 |
Q: what is the use of & in visual basic, when and why it is used, i am using it for data field as '" & ...
A: &, which is known as ampersand, is used to concatenate (join) 2 string in vb dim adu as string adu ...
|
| VB5 Shutdown | 5/19/2008 |
Q: I am an intermediate user of VB5. I performed the Shutdown example that you showed using the ...
A: when you ask a question please refrain from mentioning other querant's names eg; david. dont expect ...
|
| Printing problems. | 5/18/2008 |
Q: Halo there, my name is Konstantin Pecurov from Macedonia 3 year student applaed com. sience with ...
A: printer.trackdefalut =true is not necessary use printer.print .. also when you multiply 9.52 by ...
|
| vb6.0 | 5/17/2008 |
Q: i am create one excel document.eg.the excel documnt 6 coloum have.A,B,C,D,E,F.i make one visual ...
A: i hope your question is to open a workbook and depending upon the commandbutton on VBform you want ...
|
| Thank For last Time it works | 5/17/2008 |
Q: Pls, I don't want to use adodc to connect to access(access 2000) using vb6, i want to use program ...
A: you say your code.. did i give it to you? and what is the comma doing at the end of ...
|
| Key deactivation | 5/15/2008 |
Q: I d'like to deactivate Arrow keys on a drop down list. is it possible I use vb6 Thank you ANSWER: ...
A: sorry thought it was for a textbox. it is not such a good idea to disable arrowkeys in a listbox. ...
|
| vb6 + Access | 5/14/2008 |
Q: I'm creating a Slam book, in which my users [friends] can save their slams using a User name and a ...
A: once the user chooses a button to verify his username and password then you need to use adodb and ...
|
| VBA Excel | 5/14/2008 |
Q: Sorry i didnt realise we couldnt paste url's Im sure Excel.xlMultiply is the missing link but im ...
A: see, you have used some code which is not based on your logic so every time you have an error, you ...
|
| Error in SQL Statement | 5/14/2008 |
Q: Kindly advise what is wrong in the following sql statements: INSERT INTO: (nor inserting the ...
A: 1) what do you mean by nor inserting the record? the code for insert is: Option Explicit 'put a ...
|
| vb6 datagrid | 5/13/2008 |
Q: Please how to select a full row in a datagrid with a clik or dbclick and displays the data of the ...
A: Option Explicit ' have 3 labels and 1 commandbutton in form1 and add this code in Form1 Private ...
|
| Excel VBA | 5/12/2008 |
Q: I work on Excel VBA.I wanted to know how to restrict the value in the cells to only numbers(It ...
A: the data validation which you do on the first range of cells is not applicable to the cells to which ...
|
| vb6.0 count male and female from table col. | 5/12/2008 |
Q: in my table i have column name Categeory in this categeory Male and Female , how can i count Male ...
A: you need to create a query with sql 'here sex is the fieldname SELECT Count(TableName.Sex) AS ...
|
| Query in VIsual Basic programming | 5/9/2008 |
Q: Wat is the syntax code to link one command button to another command button in Visual Basic ...
A: i dont get your logic. why link 2 buttons? it makes no sense to me. of course you call the ...
|
| vb 6.0(adodc) | 5/9/2008 |
Q: i'm sidney again the beginner in vb and i appreciate for the last help you gave me.now my problem is ...
A: the error is on the line And Programme=" & "'" "part-time" & "'" It should read And Programme=" ...
|
| Errors in Previous Question | 5/8/2008 |
Q: Looking through your replies to other questions, - I had already checked for any relevant ones, but ...
A: do you want VB or VBA? these two are poles apart so be specific. for questions that require a lot of ...
|
| Retrieving data from a sub Function | 5/8/2008 |
Q: I am working with 'MS Visual Basic 6.5' from MS Office 2000. (specifically Excel, but I'm not ...
A: by reading your question, i can rate you only as beginner not intermediate. it is not personal but ...
|
| VB 6.0 | 5/8/2008 |
Q: How can we read text files word by word in visual basic 6.0, if each word is separated by tab space?
A: Option Explicit Dim lincount As Integer, adu As String Private Sub Command1_Click() Dim pos1 As ...
|
| DTPicker Query | 5/7/2008 |
Q: I want to insert date through DTPicker tool. My database is in access..Fore ur conviencee i hav ...
A: i dont know what your dat refers to: anyway here's a sample code for insert Option Explicit 'put a ...
|
| VB6 , Winsock | 5/6/2008 |
Q: i can run the project on my note book, but i can run it on other notebook / desktop, which dont have ...
A: you need to use a package and deployment wizards from VB6 on yournotebook and build it around your ...
|
| error 3251 in vb | 5/5/2008 |
Q: I am working on one project. Database connectivity is ok. All others forms are running properly. I ...
A: your code is following c or C++ format. VB does not recognise the varchar, no(4) etc. you need ...
|
| vb6+access | 5/4/2008 |
Q: how to display distinct number of columns in msflexgrid from access database.for example i have 5 ...
A: first you get the adodb.recordset using adodb.connection and you code msflexgrid1.textmatrix(1,0)= ...
|
| v.b 6.0 + Ms Access | 5/3/2008 |
Q: i'm a beginner and i'm develloping a application in vb 6.0 which i connected to the Access database ...
A: obviously you have not read the answer. i asked you to change to module name but you are asking the ...
|
| v.b 6.0 + Ms Access | 5/2/2008 |
Q: i'm a beginner and i'm develloping a application in vb 6.0 which i connected to the Access database ...
A: i suggest you change the ADODC to ADODB. you can open One connection and have several recordsets ...
|
| excel vba 2003 | 4/29/2008 |
Q: Scenario: I have a userfForm that contains a few buttons, textfields etc. And at the workbook, I ...
A: 1) no, you can delete the user form. user form is required if the user needs some action on the ...
|
| VB + MS Access & Internet Options | 4/26/2008 |
Q: Sir i am a cyber cafe owner, trying to develop a software for its management. I am using a THIN ...
A: first part of your question. it is better to change over to ADODB than ADODC . use this code: ...
|
| VBA+Access Prob with SUM ... GROUP BY... | 4/25/2008 |
Q: knowledge : Turbo C :) This is the output that I want the sum of the product for the year 2006 ...
A: in view of security, i do not like to visit links posted by you. however this is my surmise and ...
|
| Combo Box property | 4/21/2008 |
Q: I am doing one project in Vb 6.0. I have placed a combo box in a form and using ADODB connection, I ...
A: put an ADODC and a datacombo on the form point it to your database and table and point the ...
|
| Special characters in access table | 3/18/2008 |
Q: How do i restrict users from inserting special characters in a text box and how to remove any ...
A: Option Explicit Private Sub Text1_KeyPress(KeyAscii As Integer) If KeyAscii = 33 Then KeyAscii = 0 ...
|
| VB6 | 3/18/2008 |
Q: I want to put the contents of an array in an excel sheet.The content of the array will be entries of ...
A: Option Explicit Dim adu(5) As String Dim xl As Excel.Application Private Sub form_load() adu(0) = ...
|
| vb6 with data report | 3/18/2008 |
Q: Good day sir! im constructing a program that enables to search a certain records from the database. ...
A: for searching records: better to have the runners nos in a combobox rather than a textbox. 'put a ...
|
| vb+access | 3/18/2008 |
Q: sir, 1.I would like to know how retrive an image stored in MS access database and how to access the ...
A: one of the methods: in access table have two fields no and path store the path of the ico file ...
|
| Sending results of Macro to Text file, VBA Excel | 3/13/2008 |
Q: Hey! I took a class a year or so ago on VBA but cannot remember for the life of me how to do ...
A: there are many options but the simplest one is to concatenate them in the same row of an excel ...
|
| visual basic | 3/13/2008 |
Q: how to create more than one textbox in vb at runtime ANSWER: it is not a hot idea to create ...
A: i still say that this is in no way a follow up anyway the sample code: sample code: Option ...
|
| VB in excel | 3/12/2008 |
Q: I'm a beginning VB user in Excel, writing macros to make my work faster. And I'm having trouble with ...
A: firstly, it is not VB but VBA which is a different lanugage (though similar) here is sample code: ...
|
| acess | 3/12/2008 |
Q: how to connect the two table with each other. my histry table is no update automaticly which is ...
A: First, your english makes it unclear. now what is meant by your stating hitry table is no update ...
|
| connectivity with access 2000 | 3/12/2008 |
Q: i am new to vb. i have created a form and do not want data control on it. on a SAVE button i want to ...
A: data control is a thing of the past. try this sample code: Option Explicit 'put a check mark on ...
|
| vb+vb reports | 3/7/2008 |
Q: im a beginer in vb 6.0.i have a datagrid table in vb form entered data in the table using visual ...
A: this is not the way. first, the Visual data manager does not work witht the latest versions of ...
|
| VB+Access+Records+Reports in word | 3/5/2008 |
Q: You sound like and interested genunine person, I am looking for someone to help me. I have created a ...
A: every person is a genuine person and i did not know where i sounded? now it is not clear how you ...
|
| VB 6.3 | 3/3/2008 |
Q: Via a series of formulae I input rows of data by date into a spreadsheet. I want to find yesterdays ...
A: your logic is not clear to me. you mean the dates for the whole month is already entered and you ...
|
| VB 6.3 | 3/3/2008 |
Q: Via a series of formulae I input rows of data by date into a spreadsheet. I want to find yesterdays ...
A: your question is confusing. you say vb 6.3 and state spreadsheet. there is no spreadsheet in VB. if ...
|
| Designing a "loader" type interface | 3/3/2008 |
Q: my name is Dustin. Let me begin by giving you a few details. I am a complete newbie to visual ...
A: what you are attempting is not for a beginner. if the paths are stored in an access database then ...
|
| VB 6 Data report | 3/1/2008 |
Q: Sir, I am using data report by passing parameters and it worked perfectly. The problem I have now ...
A: first create the query in access in the design mode ... go to sql mode which gives the design in ...
|
| VB2008 | 3/1/2008 |
Q: Pardon me if english is bad. I'm new to vb2008 and havve access database. I try to create form ...
A: dont ask question like frustrated etc. DONT you have a name? yes, you deserve to be frustrated. you ...
|
| list view control | 2/29/2008 |
Q: 1)can you please help me. I need you to help me with code for retrieving data from access database ...
A: sample code: L1 is the listview control Option Explicit Dim i As Integer Dim conn As ...
|
| Database Connectivity in Visual Basic | 2/28/2008 |
Q: i m beginner of Visual Basic 6.0. i always had trouble in database connectivity using SQL in visual ...
A: Option Explicit 'put a check mark on Project_References_ Microsoft ActiveX data object Library Dim ...
|
| MSflexgrid | 2/27/2008 |
Q: gud day sir!i am g graduating student and we have a thesis,can you help me or give me some code on ...
A: sample code: 'put a check mark on Project_references_Microsoft ActiveX data 'Objects Library Dim ...
|
| linking listbox to textbox fiels data | 2/26/2008 |
Q: i have a list box and a text box. The list box displays the contents of the fieldname BNAME from the ...
A: ' cn is the open connection Private Sub List1_Click() Dim esql As String esql = "select * from ...
|
| please help me i badly need it in my thesis | 2/25/2008 |
Q: i'm not as good in programming as you may be...sir can you help me cause i want to retrieve records ...
A: i do not like your asking more than one disconnected questions. to backup code this to a ...
|
| VB6 and ado connection with access | 2/24/2008 |
Q: I am a beginner in Vb6 with access 2000 coding i am designing a project for the diabled people.I am ...
A: remove the ADODC from the form. it is old hat. using ADODB , if you have opened the connection it ...
|
| visual basic | 2/23/2008 |
Q: Need help pls. i have a program that display a record from a database in texbox. Now i want that ...
A: the access tables are to have unique data.. that means no duplicates. if you are saving data from ...
|
| printing datareport | 2/23/2008 |
Q: I am developing a project using vb, msaccess and datareport for reports. in one form i have ...
A: 'you need to connect datareport to dataenviroment, adjust the command and configure them Option ...
|
| calculation in grid | 2/21/2008 |
Q: Q:In vb how i do calculation in grid, like excel. Example:(2+2=4). thanks
A: which grid are you talking of? there are some grids which can get records from tables. but ...
|
| VB6 and ado connection with access | 2/21/2008 |
Q: I am a beginner in Vb6 with access 2000 coding i am designing a project for the diabled people.I am ...
A: your create table code is OK, but the code is used everytime you open the project. so create ...
|
| please help me i badly need it in my thesis | 2/21/2008 |
Q: i'm not as good in programming as you may be...sir can you help me cause i want to retrieve records ...
A: sample code to which you need to make suitable changes 'put a check mark on Project_References_ ...
|
| Executing SQL QUERY | 2/20/2008 |
Q: I need to execute sql query in VB and the output has to be displayed using report but i need to ...
A: better to have the nos in a combobox rather than a textbox. 'put a check mark on ...
|
| VB | 2/20/2008 |
Q: I do have a command button. I want it to go the folder where my pictures reside and load the picture ...
A: put a commondialog control on form a picturebox and a command button add this code Option Explicit ...
|
| Date parameters - VB EXCEL | 2/19/2008 |
Q: I asked another expert this question but they were unable to answer. VBA - using for excel. my ...
A: as a beginner, you need to improve the logic than go for coding. here imagine there are 20 cells out ...
|
| visual basic and SQL | 2/19/2008 |
Q: i am doing project for OPD where i have chosen Visual Basic as frontend and SQL server as backend, i ...
A: too many different questions joined into one. to connect to sql server on a server, you need to ...
|
| vb data report | 2/19/2008 |
Q: i got connection of database but after running it i get multiple data in it(how much data is ther in ...
A: the datareport shows all records. to do what you want ,you need to make a parameter query. for that ...
|
| vb data report | 2/19/2008 |
Q: i got connection of database but after running it i get multiple data in it(how much data is ther in ...
A: first, it is not Data report as that would mean a control called Datareport in your case, if you ...
|
| VB6: Simple calculation but rough result | 2/19/2008 |
Q: It is my first VB6 program. I simplified the problem as following: Dim a As Single, b As Single, c ...
A: sorry, now your question makes sense to me okay, the problem here is not VB but how we communicate ...
|
| VB6: Simple calculation but rough result | 2/18/2008 |
Q: It is my first VB6 program. I simplified the problem as following: Dim a As Single, b As Single, c ...
A: there is nothing wrong here. when you assign d as b/a it shows 3 but when you include this value in ...
|
| vb6 | 2/17/2008 |
Q: i have one table in access.that table always have one record.if i click command button that record ...
A: first, it is not such a good idea to open the record in Word from VB.there are other methods to ...
|
| VB6 arrays + MsAccess 2002 | 2/15/2008 |
Q: I am a newbie to VB6 and arrays and would be most grateful for your help on the following problem. ...
A: your code makes no sense to me. normally one needs to have a number field so that such filtering for ...
|
| vb | 2/13/2008 |
Q: Good Day!!! How to auto click a command button using a timer. thank you very much.
A: it is not such a good idea becuase the timer needs to be running , stoped and rerun. i hope you ...
|
| vb+access | 2/13/2008 |
Q: I'm a beginner. I am trying to create a form in microsoft Access and would like to have a text box ...
A: okay though it sounds illogical to me you may be having other reasons for this. Also there is no ...
|
| v.b 6.0 | 2/13/2008 |
Q: Sir, i am having two tables by name unit and tempunit contains similar fields in a bills.mdb now i ...
A: ' check microsoft DAO objects library Option Explicit Dim db As Database, rec1 As Recordset, rec2 As ...
|
| Query in VB 6.0-basics | 2/13/2008 |
Q: I am checking if a line containing the text "Trc 04500" is present before the line containing the ...
A: are you in a text file?and how are you reading the lines. do not rush to ask questions.. you need ...
|
| VB6 & MS ACCESS linked via ADODC control | 2/13/2008 |
Q: I am a teacher in the UK. My students have simple one table databases linked to a VB form using an ...
A: it is easier to do validation at the vb form as it does away with the data moved to access, ...
|
| VB 2005 | 2/12/2008 |
Q: ok I want to know how to convert the node in treeview to 1- button and how to convert it to ...
A: vb 2005 is a bit advanced for beginners and if you did not use vb6 there will be some snags. ...
|
| Felxgrid and Saving to CSV | 2/12/2008 |
Q: I am creating a application that will allow the user to enter information into a flexgrid and i have ...
A: it requires some programming experience first you need to open the file ( text file separated by ...
|
| TreeView VB 2005 | 2/12/2008 |
Q: I have question tired to find answer .. and I think its simple one but because am beginner in VB ...
A: for a beginner and that too in vb 2005 the job is a bit too much. what do you mean by ebook.? it ...
|
| I want to delete Macro in Word file but it says | 2/12/2008 |
Q: I am just a normal computer user. Recently, I have just installed a macro in word file but when I ...
A: ok you have tried a lot. try this: under Tool, Macros-Macros_choose the option chooe All active ...
|
| Reading Text File | 2/11/2008 |
Q: I am very new at VB I am learning on my own and have really no programming background at all. I have ...
A: first throw your vb programme into the dustbin. kill means delete. that is what it is doing. you are ...
|
| Reading a range into an Excel UDF | 2/11/2008 |
Q: Hey Ravindra, I am writting a UDF (User Desfined Function) in Excel (of course using vb code). I ...
A: no need for an array to get formulas Range("D16:D20").Select Range("D20").Activate ...
|
| Reading a range into an Excel UDF | 2/11/2008 |
Q: Hey Ravindra, I am writting a UDF (User Desfined Function) in Excel (of course using vb code). I ...
A: i do not follow your logic. Note that there is NO vb in excel. it is VBA which is different from VB. ...
|
| print a report during on data entry in vb6.0 | 2/11/2008 |
Q: How to print a report in vb6.0 after entering data on form ANSWER: your question is not clear ...
A: from your questions you cannot be Inter level coder. once you open a datareport or crystal report, ...
|
| VB6, MS Access and MS Word | 2/10/2008 |
Q: I am currently working on a VB 6 project where I have a number of forms that display/add/edit/delete ...
A: i answered this before, is this a duplicate question? i am surprised to see this question. i ...
|
| Getting Started with VB | 2/10/2008 |
Q: Previously i had done small Inventor & billing project using MSAccess, but now i want to start with ...
A: sample code for ADODB better to have the runners nos in a combobox rather than a textbox. 'put a ...
|
| Stand alone database | 2/9/2008 |
Q: ..Im really problematic right now on how to make my library database system a stand alone program ...
A: you cannot use ADODC in a stand alone application you need to use ADODB sample code for adodb 'put ...
|
| Use of Timer | 2/8/2008 |
Q: I now want to automate it and make it timer based so that the update can be made regularly. I have ...
A: it is not such a good idea. for this the programme has to be running and it takes memory resources. ...
|
| Visual Basic Search Command | 2/7/2008 |
Q: How do I write the code for a Search Command? I want my search button to search my database for ...
A: better to have the runners nos in a combobox rather than a textbox. 'put a check mark on ...
|
| vb 6.0 | 2/7/2008 |
Q: sir, i am astudent. i created data report and data environment in my project when i passed two ...
A: to the command1 text add this line after pointing it to connection Select * from testable where ...
|
| vb | 2/7/2008 |
Q: what is difference between scale height and scale width?
A: these basically refer to the graphics property after you select the scalemode..vbpixels,vbtwips etc. ...
|
| VB6 | 2/7/2008 |
Q: hallo sir, iwanted to join two fields in twoforms form1, form2 having 2 tables in MS ...
A: add a .bas module to project and code Option Explicit Public StoredVal As String 'set the form1's ...
|
| macro with VB | 2/6/2008 |
Q: Hi this is Ram from INDIA. I have few questions in excel macro in VB, 1). How to enter/get values ...
A: 1) you can open other applications (some. not all) using the shell command. But you cannot get the ...
|
| Vb6 | 2/5/2008 |
Q: I want to know to get 5-10 employee details from the access database and to create a report with ...
A: Option Explicit Dim cn As ADODB.Connection, rec As ADODB.Recordset, esql As String 'check ...
|
| Crystal Reports | 2/4/2008 |
Q: How r u There is a VB6 prog. with access database and crystal reports. All is working fine except ...
A: your code is not proper. where is wdb declared. you are deleting, addingnew and filtering with a ...
|
| VB | 2/4/2008 |
Q: We are creating exe in vb.6. While executing it shows "Vb6.0 has generated errors and will be closed ...
A: following points need checking declaration of variables, spelling errors, option explicit must ...
|
| Uploading data from another table | 2/4/2008 |
Q: I am an intermediate user of VB. I also have a little knowledge in SQL. I am having a problem ...
A: you could link or import tables without using any code. if you want to use only code: then open ...
|
| about 2 forms in one project | 2/4/2008 |
Q: I am a begineer with Visual Basic express 2005. I am Creating Windows application and create one ...
A: i hope you have some VB6 programming experience. to jump straigtaway to vb2005, it may be a bit ...
|
| Hyperlink in VB6.0 | 2/3/2008 |
Q: I was wondering if you knew how to code a label to be a hyperlink? If so, could you include source ...
A: 1.have the label1.font underlined 2.under project_references check microsoft internet controls. ...
|
| Printing Report using Data Report with ado recordsets | 2/2/2008 |
Q: Kindly guide me using data report with ado recordset connections.
A: personally i prefer access reports to datareport anyway here is the method: put a dataenvironment ...
|
| vb 6 & access 2003 | 2/2/2008 |
Q: please help me on connecting the Access 2003 database to VB6. how to check if jet 4.0 is available ...
A: Dim db As Database, rec As Recordset, esql As String Dim rec1 As Recordset End Sub Dim db As ...
|
| VB+DATABASE | 2/1/2008 |
Q: I am just a begginer using vb with database By entering 16 digit no in a textbox ,automatically ...
A: i consider your options not of good logic. why tup16 digits? instead have combo boxes showing ...
|
| Visual Basic 6. | 2/1/2008 |
Q: the code below produce an output of frm 0-10,i want this output to be put in a temporary file and ...
A: automatic numbers cannot be incremented. however to increment numbers mentioned by you put a text ...
|
| Visual Basic 6. | 2/1/2008 |
Q: the code below produce an output of frm 0-10,i want this output to be put in a temporary file and ...
A: this is a trivial question but i'll answer it. Option Explicit Dim i As Integer Private Sub ...
|
| Password Change Input Boxes in Access | 1/31/2008 |
Q: Ravindra, My Access database has a password-protected form using the following code: Private Sub ...
A: first of all this is NOT VB but VBA which is a different kettle of fish. here's the code which you ...
|
| Visual Basics | 1/31/2008 |
Q: using grid controls ,how to multiply with one grid column with another grid colum
A: first, there is NO visual BaiscS.. it is visual basic then which grid are you talking about, ...
|
| About Sql database | 1/31/2008 |
Q: Sir, I want to save unique images(i mean no duplicasy while saving images) in sql Is this possible? ...
A: he's right. the images cannot be scanned pixelwise and matched like a fingerprint( unless you use ...
|
| VB | 1/31/2008 |
Q: I AM NOT ABLE TO ENTER LONG NUMBER (REQUIRED IS 17 DIGIT) Private Sub SERIALNO_LostFocus() ...
A: it is not such a good idea to have such large numbers but you can get round this by using Option ...
|
| Visual basic + Ms access | 1/31/2008 |
Q: ! I have a question about visual basic and ms access. 1. How to display content of my database in ...
A: Option Explicit Dim smenu As Variant Dim password As String Dim realpassword As String Dim iChances ...
|
| Visual basic + Ms access | 1/30/2008 |
Q: ! I have a question about visual basic and ms access. 1. How to display content of my database in ...
A: first, i believe your table has these three fields. better to have the ID in a combobox rather ...
|
| VBA form seaching | 1/30/2008 |
Q: Im using 2007 MSA, VBA code, JAMES Graham OK i want a peace of code for VBA that searches a form, ...
A: Option Compare Database Private Sub Command1_Click() Dim adu As Integer adu = CInt(InputBox("Enter ...
|
| vb6 Form serch | 1/30/2008 |
Q: sir i am beginner in vb6 programing i have a project and it has more than one forms how can i get ...
A: each form is a separate object without reference to the other forms. i think from the form it may ...
|
| vb 6 & access 2003 | 1/30/2008 |
Q: please help me on connecting the Access 2003 database to VB6. how to check if jet 4.0 is available ...
A: to check if jet 4 is available, put a ADODC on form and properties point to using connection string ...
|
| problem in getting data | 1/29/2008 |
Q: i need the code for copying the data from one excel workbook and paste in another excel workbook ...
A: curious to know why operate it from VB? do you have to do it often or only once. i know the method ...
|
| How to use Replace function in VB 6 | 1/28/2008 |
Q: I am new to VB6 coding,I want to retrieve data from SQL server database table, where one name field ...
A: try this one out: make changes that you want Option Explicit Dim conn As ADODB.Connection Dim rec ...
|
| Search Command Button Coding?? | 1/28/2008 |
Q: I want a search command button coding for my school project that i am making on visual basic 6.0 i ...
A: the adodc requires initializing. connect the adodc to the database and point to the table as the ...
|
| VB form seaching | 1/28/2008 |
Q: Im using 2007 MSA, VBA code, JAMES Graham OK i want a peace of code for VBA that searches a form, ...
A: question unclear. do you want vb form search(uses VB code) or access form search. (uses vba code) ...
|
| adodb | 1/28/2008 |
Q: sir, i am developing a project using vb6 and access 2003 In purchases table i have fields ...
A: Option Explicit Dim conn As ADODB.Connection, rec As ADODB.Recordset Dim esql As String Private Sub ...
|
| vb6 | 1/28/2008 |
Q: how to open db(access) in word using vb6
A: your question is a puzzle to me. i cannot follow why you need to get a database into word. one ...
|
| notepad to vb6 | 1/23/2008 |
Q: 1. vb6 3. inter 4. vb + notepad 5. Himanshoo Shourie 6. VB6 7. I want to transfer data from notepad ...
A: to read the data from text file dim entry as string,linecount as integer Private Sub ...
|
| VB6+Access Database | 1/23/2008 |
Q: Iam developing a employee shift Scheduler using vb6 and microsoft access 2003 for my school ...
A: to get month and date of system can be shown in label as in the form load event Option Explicit ...
|
| VB Excel 2003 Question | 1/22/2008 |
Q: My level of knowledge for VB language is at a beginner lever so I'm not quite sure what to do for ...
A: you are again using the word tabs ..named otherwise or not they are NOT tabs and it is not called ...
|
| notepad to vb6 | 1/22/2008 |
Q: 1. vb6 3. inter 4. vb + notepad 5. Himanshoo Shourie 6. VB6 7. I want to transfer data from notepad ...
A: if you mean a text file .. it can be done if they are properly formatted. like abc,123,lmn or abc ...
|
| VB6 screen melting issue | 1/22/2008 |
Q: Ravindra, I was asked to post a new question because my prev question has too many follow ups. Okie ...
A: no need for explanations, i did not ask. what i suggested was to close all the forms and save the ...
|
| Query:: logic in Visual Basic | 1/22/2008 |
Q: my question is like, i have many option buttons in my application. could be more than 100 option ...
A: you can create a control array first is option1. copy and paste this and say yes to an array. then ...
|
| How to concatenate multiple fields in Visual Basic... | 1/22/2008 |
Q: If I have the following fields from a excel sheet how would I concatenate them to print out in a ...
A: there are many options ..like concatenating these fields to another field, assign to a variable etc ...
|
| Query:: logic in Visual Basic | 1/21/2008 |
Q: my question is like, i have many option buttons in my application. could be more than 100 option ...
A: of course there is a loop method of setting it but only 1 option will be true and all the rest ...
|
| Save listbox items in MS Access Database. | 1/21/2008 |
Q: I'm using VB 6 and MS Access Database with it. This is my second year as a vb user for school ...
A: Option Explicit Dim cn As ADODB.Connection Dim rec As ADODB.Recordset Private Sub list1_Click() ...
|
| VB6 screen melting | 1/21/2008 |
Q: My level of knowledge is beginner. We are currently having an issue where one of our programs runs ...
A: i got your screen shot. as a rule you need to close all the windows and the forms and save the ...
|
| VB6 screen melting | 1/21/2008 |
Q: My level of knowledge is beginner. We are currently having an issue where one of our programs runs ...
A: just to check if vb installation is faulty do this. create a new project add a command button, a ...
|
| VB referencing field names / variables | 1/17/2008 |
Q: I am using Access 2003, VB 6.3 In my table I have some field names that are somewhat repetitive, ...
A: 'create a function and check for field values Option Explicit Dim YesMatch As Boolean Private ...
|
| vb access connectivity | 1/17/2008 |
Q: how to perform vb access connectivity? transfer data from vb textboxes to access table fields?
A: 'put a check mark on Project_references_Microsoft ActiveX Dataobjects library Option Explicit Dim cn ...
|
| Print form | 9/23/2007 |
Q: 1) VB6 (no SP) 2) Access 3) Inter 4) Print a form 5) Jacob Mendelovici 6) VB (I don't know what's ...
A: your code is incorrect printer.width .. does it make sense to you? position the form to the ...
|
| Visual Basic 6 and Excel | 9/23/2007 |
Q: Ravindra, Thanks for the reply to my query about Excel. As this is the first time I have tried to ...
A: you cant use code that you create. it has to be excel syntax. for column width you use ...
|
| need a help with VB and exel | 9/23/2007 |
Q: I need to copy to the other sheet certain rows that contain negative value in a certain column. ...
A: Option Explicit Dim xl As Excel.Application Private Sub Command1_click() Set xl = ...
|
| MaskedEdit field updating | 9/23/2007 |
Q: I am new to VB6 and writing a windows application that uses and Access database. I am using ...
A: i dont know what the problem is in the masked edit box's mask property enter (###) ###-#### you ...
|
| recordcount | 9/23/2007 |
Q: i m working on vb6.0 and ms access, my code is like below: Dim conn As New ADODB.Connection Dim ...
A: strconn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\GSMMobile.mdb" & ";Persist ...
|
| vb+excel | 9/21/2007 |
Q: Using Visual Basic6 to insert data into Microsoft Excel workbook and format same. What do I write in ...
A: 'check references Microsoft excel objects library Dim xl As Excel.Application Dim strFileName As ...
|
| Dynamic calculation inexcel and saving the result back to SQL server using VB | 9/21/2007 |
Q: I have an excel file created with several values from SQL server by a VB application. Now the user ...
A: too much to expect in a free site. 1)why get to excel when you can calculate these in sql server ...
|
| vb 6.0 | 9/21/2007 |
Q: i want in textbox using two fonts one default english and another hindi in one textbox and save ...
A: Option Explicit Dim Badalu As Boolean Private Sub Command1_Click() If Badalu = True Then ...
|
| VB6.0 question. | 9/20/2007 |
Q: I maintain one Access database. It's huge. After each process user need to compact the database. ...
A: in access itself have a switchboard form or any other form which has to be opened by default. and to ...
|
| Textbox edit protection (VB+Excel) | 9/20/2007 |
Q: I am making a "program" in Excel 2000 to check some data. My idea was to monitor everything in a ...
A: could not fully understand what you are looking for. How do you post the data to the text/label? ...
|
| project into a stand alone program | 9/19/2007 |
Q: I am using XP with VB6 and I am trying to use Package and Deployment Wizard and I am getting an ...
A: what does your programme do? any internet connection reqd? vb requires Internet explorer on your ...
|
| ms access and vb | 9/19/2007 |
Q: i have 1 employees table which contains combined primary key PS Number and Effective from date. the ...
A: quite simple dim adu as string ' or integer if it is a small number adu=val(text1) if string ...
|
| Date query in Datareport | 9/18/2007 |
Q: I want to write a query to display only present days records(i.e today) in a Datareport. ...
A: connect dataenvironment to the table connect it to your database add command command1 properties ...
|
| Excel Cell with | 9/14/2007 |
Q: Good morning. I have a VB Macro that is looking for Empty cells at which time it is to exit the ...
A: use of empty etc is ambiguous sample code which you study and make your own, Sub CheckBlank() ' ...
|
| VB6 and SQL query | 9/14/2007 |
Q: I am using VB6 and Access. Most of my work is completed. However, being a beginner, I can not get ...
A: 'put an ADODC on form , point to your databse. 'set its recordsource to adcmdtext and enter ' select ...
|
| Looping listItems in a listbox | 9/14/2007 |
Q: Ravindra I am trying to loop through a listview in the listitems: SourceAxisID = ...
A: Private Sub Command1_Click() Dim adu As String For i = 1 To ListView1.ListItems.Count adu = ...
|
| VB6 and SQL query | 9/14/2007 |
Q: I am using VB6 and Access. Most of my work is completed. However, being a beginner, I can not get ...
A: here the problem is in access. open the design view of these tables and for every textfield set ...
|
| Detail section Height of Data Report | 9/13/2007 |
Q: M new in vb,using access as a database with data control.i want to fix the height of detail section ...
A: check height per record. check the property of detail section1 and choose forcepagebreakafter and ...
|
| VB6 and SQL query | 9/12/2007 |
Q: I am using VB6 and Access. Most of my work is completed. However, being a beginner, I can not get ...
A: dim esql as string esql="Select * from tbPatron where fldSeat=" & 24 or esql="Select * from ...
|
| PLEASE HELP!!!!! | 9/12/2007 |
Q: ! I have 3 very important questions relating to vb6 and ms access 2003 database 1 - How to open ms ...
A: 1)to connect to tables. it does not matter how many tables you have, as you can choose the ...
|
| check box control array in vb6.0 | 9/12/2007 |
Q: i had 4 check box control array and i want to control these 4 check box thru another check box. ...
A: Option Explicit Private Sub Check2_Click() If Check2.Value = 1 Then Allcheck Else NoCheck End If ...
|
| VB6 and sqlserver 2000 | 9/12/2007 |
Q: I am using vb6 and sql server 2000 I want to design a logon form, in this form how can use ...
A: first i don't like my name to be wrongly addressed. you have picked up my previous code and have ...
|
| SQL | 9/11/2007 |
Q: i crated a SQL statement that will give the ID of a table i verify it and its correct i having a ...
A: put ADODC on form and point it to the database. point the recordsource to adcmdtable and point to ...
|
| DBgrid short ascending when colum header click | 9/9/2007 |
Q: I use DBgrid as my data view table, there is 3 column on it (column0,column1,column3) I need help ...
A: i have designed a procedure which is not normally found in visual basic. i think it is good and i ...
|
| Visual Basic with access database | 9/9/2007 |
Q: I am working on a program that stores alot of information in an access database, My question is can ...
A: that way there is NOTHING to prevent a hacker to get into your database. But that takes an expert ...
|
| Formating a text file | 9/8/2007 |
Q: I have a file that has one line that can be from 1 to ~ long. I need to read in the line 80 ...
A: the string is stored to a variable and length is no problem. you can check how the info is ...
|
| VB6+Oracle8i | 9/8/2007 |
Q: Sir, I developed a project using visual basic 6 and Oracle 8i as back end. How to generate auto ...
A: autonumber field is entered automatically if you addnew values to other fields and update. where ...
|
| Formating a text file | 9/7/2007 |
Q: I have a file that has one line that can be from 1 to ~ long. I need to read in the line 80 ...
A: sample code: Option Explicit Dim entry As String 'this puts the text into the textfile Private Sub ...
|
| EXCEL VBA | 9/7/2007 |
Q: I have a userform that opens immediately when an excel workbook is opened. I added ...
A: excel macros appear to be harmless but if wrongly used, they could corrupt your excel installation. ...
|
| Countdown Loup | 9/7/2007 |
Q: Well, i am just starting to learn visual basic, and for our first loop assignment we are suppose to ...
A: put a picturebox, a timercontrol and a commandbutton on form and add this code: 'timer interval set ...
|
| combo box query | 9/7/2007 |
Q: I am using 2 combo box in vb form.In the 1st combo if i entered 220kv ,the 2nd combo has to display ...
A: your idea does not seem to be unclear to me. anyway here is the sample code: Option Explicit 'it is ...
|
| combo box query | 9/7/2007 |
Q: I am using 2 combo box in vb form.In the 1st combo if i entered 220kv ,the 2nd combo has to display ...
A: you need to use ADODB. here is the code which you can alter to make the ADD button to add records to ...
|
| Excel VB question | 9/6/2007 |
Q: I hope you can help me with this as I have no experience in VB. I have an excel spreadsheet with a ...
A: first of all, this is not VB but VBA which is different altogether, though similar in some ...
|
| Connecting to local Oracle database. | 9/6/2007 |
Q: I have got both VB and Oracle installed in my machine now I want to connect to the Oracle DB that is ...
A: create a DSN using control Panel_ODBC and system DSN and point it to your oracle database. save it ...
|
| reports | 9/5/2007 |
Q: i am new to vb programming i am trying to design a application with access as backhand. how to ...
A: Option Explicit 'check microsoft access libray under Project References Dim AppAccess As ...
|
| Save to Word Doc | 9/5/2007 |
Q: Yes that is correct, also, can you pls provide your paypal details. Thanks. Hello Ravindra, ...
A: 'check mark on Project_References_Microsoft Word Objects library Option Explicit Dim appWord As ...
|
| connecting vb to access problem | 9/3/2007 |
Q: sir i write this type of quire but it seems there is a problem Set db = OpenDatabase(App.Path & ...
A: why have you opened 2 recordsets from the same table? and what is info? the sample code : Option ...
|
| VB sorting | 9/1/2007 |
Q: I am new in VB. I managed to sort an array of 30 data in ascending order. However, I wish to ...
A: sample code: Option Explicit Dim arra(10) As String, i As Integer Private Sub Command1_Click() For i ...
|
| Save to Word Doc. | 8/31/2007 |
Q: currently I am not using my usual email, since I am not at the office right now – will rate your ...
A: re: rating, no problem, that is not my concern. And re: payment: some persons get nasty and have ...
|
| VB6 and Access | 8/30/2007 |
Q: Can you give me any advice on how do use a combo box on a form, to access a table in Access? Thanks
A: easiest method: 1) create a new system DSN in Control Panel_ODBC sources_ point it to your access ...
|
| creating buttons | 8/30/2007 |
Q: i want to create a button that automatically saves the file and pops up a window that specifies the ...
A: get this straight. IF you are in Excel you use VBA and not VB; they are 2 different things. if the ...
|
| Password Protected Document | 8/30/2007 |
Q: with all the other experts on "vacation" you must be pretty busy huh? Maybe I should change my ...
A: 1) others' vacation makes no difference to me. 2)Doing such work is not paying and takes time off ...
|
| Water Resource management | 8/30/2007 |
Q: I am New In VB Programming and using VB6. I am facing problem in writing a source code, wherein I ...
A: this is not a very good plan. anyway the vbtab entries must be created using vbtab and not space. or ...
|
| Shell in VB | 8/30/2007 |
Q: iReturnValue = Shell ("Notepad " & txtFile.Text ,1) MY Question is what is the purpose of this ! in ...
A: your code should read txtFile.txt not .Text and you have used ! rather than 1 the correct ...
|
| Access 2007 and VB6 | 8/29/2007 |
Q: How can I connect to an Access 2007 database in VB6, using code?
A: sample of code given as answer given to another person: make changes in path,etc. choose what is ...
|
| Linking textbox to a cell | 8/29/2007 |
Q: I've created a table in Access (with no primary key) that has 9 rows and 3 columns. I want to link ...
A: put nine text boxes named text1(1) to text1(9) by making copy paste of text1 and pasting 10 times ...
|
| calculate the difference of start date time and end date time | 8/29/2007 |
Q: i want to now how to calculate the start date time and the end date time in visual basic 6.0. tnks a ...
A: there are several methods and here's a method you can use and alter as you want: put 2 ...
|
| Access to Word (FormFields) | 8/27/2007 |
Q: I can do that just fine. But the checkbox's to dont check on the form field in word. I do get the ...
A: your code is not right for adodb 'put a check mark on Project_references_Microsoft ActiveX ...
|
| Access to Word (FormFields) | 8/27/2007 |
Q: I can do that just fine. But the checkbox's to dont check on the form field in word. I do get the ...
A: that is not the way to do it. you need to use mail merge and it does not require any operators. it ...
|
| between two dates | 8/27/2007 |
Q: I wonna get date from Access database based on two conditions. 1. those employees whom i pick from a ...
A: in such cases, the formatting of date and query on string is very strict, even if there is a small ...
|
| captring numeric value from text file and putting it into another text file | 8/27/2007 |
Q: i wanted to capture the numeric value like date and time from text file and later on put it into ...
A: 1) question not clear. 2) does the first text file have only this date and time and the second ...
|
| Save to document | 8/27/2007 |
Q: can you please tell me: I have a form where some information that i type into the textboxes is saved ...
A: treeview is an advanced control and putting to a dat file is elementary. to follow treeview ...
|
| vb+word | 8/24/2007 |
Q: I am brand new to VB and macros, so forgive me if this is elementary. I am working in VB6.3, ...
A: you cannot write a macro for word from vb. (not unless you are a whiz at code and then it is code ...
|
| print option | 8/24/2007 |
Q: for my menu editor i have to implement "print" option can u please help me wid the code
A: are you using vb? and what do want to print. print is not something casual, it needs to be ...
|
| checkbox and access database | 8/23/2007 |
Q: I am Long, a VB beginner. I have an old Access database and I want to create an interface for it. I ...
A: ask me after a week or so, as right at the moment my hands are too busy. in the meantime you can ...
|
| visualbasic and notepad | 8/23/2007 |
Q: how to get the visual basic output to a notepad application
A: Option Explicit Dim entry As String 'this puts the text into the textfile Private Sub ...
|
| checkbox and access database | 8/22/2007 |
Q: I am Long, a VB beginner. I have an old Access database and I want to create an interface for it. I ...
A: first update your access to higher version save it. use vb6 and connect to table using ADODC or ...
|
| Connecting to an Excel spreadsheet | 8/22/2007 |
Q: I am using VB 6.0, I believe... though under 'About Visual Basic' at the bottom it says 'VBA: Retail ...
A: you are in VBA and NOT , repeat NOT vb. anyway here's way. create a macro named GetPos sub getpos() ...
|
| Excel VBA | 8/22/2007 |
Q: What code do i need in order to have todays date entered into a textbox when it is double clicked?
A: why have a textbox in excel sheet. you can enter date to cell directly. what is the purpose of ...
|
| saving data from data grid into acsess and printing data grid | 8/22/2007 |
Q: Please help me! i have done only small test programs and now i need to save data from data grid ...
A: 'my grid has 3 columns so you need to make changes 'here to suit your casee Private Sub ...
|
| add usercontrolls | 8/22/2007 |
Q: It has two user controls and one form. But it dont want to work. I go to "add usercontrolls" and add ...
A: when you choose add a form menu, you can choose a splash screen. under project properties, make it ...
|
| Excel VBA | 8/22/2007 |
Q: My excel workbook has one sheet with a command button. This button runs a macro to create a new ...
A: create a macro sheetNos(with code shown below) and assign it to your command button Sub SheetNos() ...
|
| help required to create ms access form | 8/22/2007 |
Q: sir, I have create an table and a form in ms access. now i want to insert formulas to ...
A: basically the calculated fields need not be entered ,they can be calculated in a query anyway here ...
|
| check the sequence | 8/22/2007 |
Q: Actually i want check the structure placed in column D of the excel sheet and needs to validate the ...
A: put 2 listboxes on form in vb 1st non sorted and the second sorted.property sample code: Private ...
|
| Monthly reports | 8/22/2007 |
Q: I am using visual studio 5 (visual basics) to enter information into a access database (2000).Uses ...
A: first note it is not called visual basics abut Visual Basic. first create a report showing all ...
|
| dataReport | 8/22/2007 |
Q: i am in trouble , i hope u will help me, i have a coustomer list around 200 pages. i need to skip ...
A: check height per record. check the property of detail section1 and choose forcepagebreakafter and ...
|
| Send information to the internet using VB | 8/21/2007 |
Q: I have an excel program that uses input boxes to gather information, I would like to have a macro ...
A: basically you cannot send any info to a website. you need to visit that site and then paste the ...
|
| Storing date values in oracle from vb | 8/21/2007 |
Q: this is steve sorry to bother u, but i m struck with a problem i have a saving function which ...
A: there must be some reference to Date which is wrongly recognized by computer as present date. OR ...
|
| vb6 form resize | 8/21/2007 |
Q: Assist me with a "Form Resize" source code. Whenever the application is run on a smaller monitor ...
A: put a frame on form and put all your controls on it. then you can add hscrollbar on frame and code: ...
|
| vb6 | 8/21/2007 |
Q: Im an inter vb learner trying to come up with a vb6 application connected to ms access database. ...
A: 1) Option Explicit Dim entry As String 'this puts the text into the textfile Private Sub ...
|
| Storing date values in oracle from vb | 8/21/2007 |
Q: this is steve sorry to bother u, but i m struck with a problem i have a saving function which ...
A: read the error message: DD-Aug-YYYY" to type 'Date' is not valid." what is aug doing there? it needs ...
|
| VBA Macro Within a Macro | 8/20/2007 |
Q: I am trying to create an Excel Macro that runs a Macro from another Excel file and I am trying to ...
A: do not attempt this unless you are inter level vba coder. here is a method: a macro can be ...
|
| Why? | 8/20/2007 |
Q: Over the last year or so, you taught me so much about VB for which I am extremely grateful. But I ...
A: here is what goes: * i am doing several projects and i find these questions a break for my work. * ...
|
| How to link Vb with Ms Access | 8/20/2007 |
Q: Hey..Im still new at VB and Access but would really love to link the two.I have a small database of ...
A: what is your name? cannot be Mxolisi. normally i do not reply when names are not mentioned ...
|
| Help me urgently | 8/20/2007 |
Q: No.sir.I didn't mean that. I read those record from the database and show this way. if record ...
A: the display has to be worked out by you. you can use Option Explicit Dim recNum As Integer Private ...
|
| using rich textbox | 8/19/2007 |
Q: can i use rich textbox to save the content which i hav typed on my text box? if yes can u ...
A: this code will carry the text1.text to the richtextbox1 Option Explicit Private Sub ...
|
| urgently | 8/18/2007 |
Q: do u know flexgrid in vb.i want to know the data show by side by side. eg. No Address Name No ...
A: let us say your msflexgrid1 name is G you code g.textmatrix(rowval,colval)= the value so you can ...
|
| passing date variable to sql statement in vba | 8/17/2007 |
Q: Am getting date values from excel using userform, and wish to pass to sql statement and post the ...
A: the problem is with formating and it should match that of the table. try this code: Option ...
|
| passing date variable to sql statement in vba | 8/16/2007 |
Q: Am getting date values from excel using userform, and wish to pass to sql statement and post the ...
A: pardon me for being so rude. nothing personal, but technical i fail to understand your plan.. to ...
|
| password protection | 8/16/2007 |
Q: Sir, I made a project (VB6.0 and MS Access) on yellowpages, which runs directly from cd, using ...
A: how can you change a CD? you need to redo the project with password. and there is no big deal ...
|
| Write # statment | 8/14/2007 |
Q: I would like to write the value of a cell to a file For example the in the write statment below I ...
A: your question is misleading. you have written the topic as visual basic. from that i understand ...
|
| Visual Basic | 8/14/2007 |
Q: Hey again, thanx for response on my first question..here's my second. How do i input data into a ...
A: you need to all the fields of a table. 'put a check mark on Project_references_Microsoft ActiveX ...
|
| help for word meaning dictionary | 8/14/2007 |
Q: .. i want to develop a word meaning program/Dictionary from English to punjabi. I completed almost ...
A: i am not familiar with Siphra. 1)is your dictionary web based or on a single computer? 2)database ...
|
| Creating a record in a table based on values chosen in 2 combo boxes | 8/14/2007 |
Q: Using VBA in Access 2003 (VB 6.4), I need to create a new record in a table based on values chosen ...
A: i trust you want this to be in access. you have wrongly used the title visual basic. it is NOT VB ...
|
| About creating a VB program | 8/13/2007 |
Q: Sir, I have already created a database in MS Access and created all forms in MS Access and running ...
A: 'put a check mark on Project_References_ Microsoft ActiveX Data Objects Library 'you can addnew ...
|
| Document Library | 8/13/2007 |
Q: This time I don’t have a specific code question, but I would like to get your thoughts on something: ...
A: i have designed 2 such programmes to index and search for code that i have created. in an excel ...
|
| Viewing Data in Access Using Visual Basic | 8/12/2007 |
Q: 6 in the library - Dim workbase As Database Dim workrs1 As Recordset Dim sql As String Set ...
A: sample code: put 5 commandbuttons and 4 text boxes on form and add this code: Option Explicit 'put ...
|
| vb6 + ms Access 2000 | 8/11/2007 |
Q: I have VB6 installed in my system. The problem is that it does not recognize Access 2000 files. So I ...
A: as i see, this is not a fault of vb. when did you install Office 2000 and the database created ...
|
| vb+ms access | 8/10/2007 |
Q: I am thankful to u that u have solved my problems before. i want to know how can the controls(text ...
A: Private Sub Form_Load() Dim n As Integer Text1(0).Text = " Text " & n + 1 For n = 1 To 29 ...
|
| VB 6.0 Print question | 8/10/2007 |
Q: I need to print a word document along with the form that i am already printing. is there a way to ...
A: 'put acheck mark on Project_References_Microsoft Word Object Library Private Sub mnuWord_Click() ...
|
| Visual Basic Validations | 8/10/2007 |
Q: how can i validate a name ? ie: i want to check whether the user entered name has only the words not ...
A: Option Explicit Dim adu As String Private Function checkAlpha(olage As String) Dim i As Integer, It ...
|
| Help Urgent please | 8/9/2007 |
Q: i am steve, i actually got a problem, i got a table in oracle database called doctor, i am trying to ...
A: to manipulate the listbox text you need to use i do not want to go thro' your code: trial code: ...
|
| Help me... | 8/9/2007 |
Q: I have a slight problem.I try to save an Excel Workbook with SaveAs method in a VB6 dll but it fails ...
A: Dim xl As Excel.Application Private Sub Command1_Click() Set xl = ...
|
| VB 6 + Access | 8/9/2007 |
Q: I hope this wont sound silly pliz elaborate this part of the response u sent me last - (reference ...
A: there is nothing with these controls except that these are not automatically loaded controls. if ...
|
| how to select dbgrid?? | 8/9/2007 |
Q: i use data control to connect to access databases.i just want to select the data grid and it will ...
A: Option Explicit 'you must click at fixed column at extreme left 'let us say there are three ...
|
| display record in dbgrid | 8/8/2007 |
Q: I am making a program "BROWSE DATA" with textbox and dbgrid. I want dbgrid show record that I write ...
A: the dbgrid is meant to get the results from a database table and not from a textbox. the display ...
|
| VB6+Access | 8/8/2007 |
Q: Am a beginner in programming. Have done a project in VB6 and my database is in Access. I am ...
A: the db has to be in the same directory. then you test the project and save. then create exe file in ...
|
| VB6+Access | 8/8/2007 |
Q: Am a beginner in programming. Have done a project in VB6 and my database is in Access. I am ...
A: the database may be referenced differently in other computers. to avoid this, always locate the ...
|
| Open Website via VB button | 8/8/2007 |
Q: can you please tell me; how to open a webpage eg ...
A: Option Explicit Public WithEvents Web As SHDocVw.InternetExplorer ' put a webbrowser control on ...
|
| error at open form | 8/8/2007 |
Q: I developed a project in vb6sp5. Suddenly that system o/s is corrupted.So, my project shifted to ...
A: sometimes, these controls do not load automatically. in the project, remove any grid on the form ...
|
| Freeze columns in MSFlexGrid in VB 6.0 | 8/7/2007 |
Q: How can I freeze columns in VB 6.0 MSFlexGrid? Let say if i have 10 columns and I want to freeze the ...
A: this may be a second best solution: Option Explicit Private Sub MSFlexGrid1_MouseMove(Button As ...
|
| Connect to DB | 8/7/2007 |
Q: QuickI have been given a pre-made application to update which was made using VB6, and has a SQL ...
A: create a DSN from Control Panel_ODBC. and point it to your network database. check if the connection ...
|
| HELP | 8/7/2007 |
Q: this is steve, i am working on a project for my course, i need some help, i actually got 2 list ...
A: i do not know how you are connecting to Oracle database. But this is how it is done: you get the ...
|
| VB+MS Access | 8/6/2007 |
Q: I have some knowledge of vb6.0I want to know how can a reminder be set in a vb application.I am ...
A: Option Explicit Dim todayy As String Private Sub Form_Load() todayy = Format(Now(), "Medium Date") ...
|
| VB6(beginner level) | 8/6/2007 |
Q: i wan to draw a rectangle so i use the code : Me.CreateGraphics.DrawRectangle(Pens.Yellow, 232, 140, ...
A: where are you using the enter key? in the form code, under command2_click() if you use me.cls the ...
|
| Lik between excel sheets and master xls. | 8/4/2007 |
Q: Please help me out in coding my requirement. I have 5 excel sheets in a folder named July. I also ...
A: First of all, your question is NOT visual Basic BUT VBA, which is completely different, though ...
|
| VB+CrystalReports | 8/4/2007 |
Q: I have a password protected ms Access DataBase. I am connecting the database with VB 6.0 using ADO ...
A: easy method: open control panel_Admin Tools-ODBC create a user DSN give it a name say Test. point ...
|
| greater as or less than | 8/3/2007 |
Q: can you please tell me; i want to have a msgbox when a textbox numeric value is greater than another ...
A: Private Sub Command1_Click() If Not IsNumeric(Text1) And Not IsNumeric(Text2) Then Exit Sub If ...
|
| how to load word doc saved in access as ole into vb6 | 8/2/2007 |
Q: i'm a beginner with visual basic programming, i have an access d/base with the table petcare, i have ...
A: this is one method: in access create a form based on the table. In the form, in the ole field ...
|
| VB6(beginner level) | 8/2/2007 |
Q: i wan to draw a rectangle so i use the code : Me.CreateGraphics.DrawRectangle(Pens.Yellow, 232, 140, ...
A: Option Explicit Private Sub Command1_Click() Line (500, 500)-Step(2000, 1000), vbYellow, BF End Sub ...
|
| help! - excel forms | 7/31/2007 |
Q: I have created a form in visualbasic - which needs to print out data in an excel spreadsheet. ...
A: 1) you need to connect to excel worksheet. 2)get the reqd values and store the data onto a grid or ...
|
| VB | 7/31/2007 |
Q: SIR, IS THERE ANY CODE TO FIND OUT MAXIMUM LENGTH OF PERTICULAR FIELD LIKE THERE IS A CODE TO FIND ...
A: you need to loop thro all the rows to find the max length of a field. sample code: Dim con As ...
|
| printing Data Grid data | 7/31/2007 |
Q: I have a DataGrid which I want to print or send to a blank form for print preview and then print. ...
A: sample code: Option Explicit Private Sub Command1_Click() Dim rowVal As Integer ...
|
| Visual Basic Replacement | 7/30/2007 |
Q: Im sort of new to visual basic but im alright at it, I want to allow the user to enter a link, in ...
A: Option Explicit Private Sub Command1_Click() Dim adu As String, modalu As String adu = ...
|
| effects of programming language | 7/30/2007 |
Q: can i just ask you about the benefits, impact, or effects of programming languange in the society? i ...
A: programming leads to Applications which will improve the efficiency of Managers of all Industries ...
|
| HERECHICAL FLEXGRID | 7/30/2007 |
Q: I AM WORKING ON A PROJECT IN WHICH I HAVE TO WORK WITH GRIDS 1. USING MSFLEXIGRID IT IS VERY EASY ...
A: again you are using both msflexgrid and mshflexgrid . you must know that they are different though ...
|
| record what ever i enter in a text box into a text file | 7/30/2007 |
Q: i want to record what ever i enter in a text box into a text file and then when i press command ...
A: Option Explicit 'put a text box without a text and 2 command buttons ' first you need to enter some ...
|
| change button colour | 7/29/2007 |
Q: sir, i hav a form which has 2 buttons "a"&"b" & textbox"text1" i am a beginner & use vb 6.0. i ...
A: button colour change is not for beginners. to operate buttons from keyboard use &a and &b as ...
|
| HERECHICAL FLEXGRID | 7/29/2007 |
Q: I AM WORKING ON A PROJECT IN WHICH I HAVE TO WORK WITH GRIDS 1. USING MSFLEXIGRID IT IS VERY EASY ...
A: cannot connect directly. there are 2 grids, you say msflexgrid and then code mshflexgrid. both are ...
|
| abt visualbasic | 7/29/2007 |
Q: error display. i want to see all company name for login company in listview on form load event. how ...
A: better use the listbox rather than listview. use this sample code, altering the path and name of ...
|
| scrollbar problem of textbox | 7/28/2007 |
Q: respected sir, i hav a form in which i hav set textbox property as multine & scroll bar property of ...
A: increase the size of the textbox. increasing both width and height you can read /write. scrollbar ...
|
| VBA+Access. Retrieving values from a query as strings. | 7/26/2007 |
Q: VBA 6.3/Access. Intermediate. Hi, I hope I can explain this clearly! I need to e-mail values ...
A: Option Compare Database Dim db As Database, rec As Recordset, arra(10) As String, i As Integer ...
|
| vb & SQL | 7/25/2007 |
Q: I have a situation here, we have a database "item". it contains a query "dtdata" with query detail- ...
A: i am upset because you have not fully read my code. the line date1 = Format(#10/3/2000#, ...
|
| vb & SQL | 7/24/2007 |
Q: I have a situation here, we have a database "item". it contains a query "dtdata" with query detail- ...
A: for sql involving dates you need to use a small trick to concatenate strings, else computer gets ...
|
| vb6.0+ms access asked by sweta suhasaria | 7/23/2007 |
Q: I am a beginner . I am using vb6.0 and ms access and the data environment is ADODC. Please tell me ...
A: Option Explicit 'check microsoft activex dataobjects library Dim conn As ADODB.Connection Dim cmd As ...
|
| Read file from txt, & fill the data in msflexgrid | 7/23/2007 |
Q: I'm writing an application for doing N number of claulation for diffrent parts of pressure vessel. ...
A: to read the data from text file dim entry as string,linecount as integer Private Sub ...
|
| vb6.0+ms access asked by sweta suhasaria | 7/22/2007 |
Q: I am a beginner . I am using vb6.0 and ms access and the data environment is ADODC. Please tell me ...
A: your question is confusing to me: data environment and ADODC are different. if multi users are ...
|
| help me urgently please | 7/22/2007 |
Q: how can i block the right click of the mouse in the text box of the form of vb6.0. ?
A: Dim bIsRightClk As Boolean Private Sub Text1_MouseDown(Button As Integer, Shift As Integer, X As ...
|
| MS ACCESS (VBA) - Queries: Append, Update, | 7/21/2007 |
Q: Ravindra, A basic overview is even helpful... I have 2 MS ACCESS tables. One is Receiver Data. ...
A: the idea of a good database is that it has tables which hold records and each entry must be unique. ...
|
| (VB6 + Access 2003) verifying new records before adding to database | 7/20/2007 |
Q: I am a intermediate developer in visual basic 6 i am creating a form which will add new Products' ...
A: Option Explicit Dim modalu As String, yeradu As String, esql As String Dim con As ADODB.Connection, ...
|
| increment in date using db grid | 7/20/2007 |
Q: I am using grid on one of my vb6 forms. there are 3 columns in the grid. Date extyear need ...
A: Option Explicit 'dbgrid is for getting records from a database and entering the data is not possible ...
|
| vb6 reading text file | 7/20/2007 |
Q: I want to hold my numeric data in a separate text file or data file and I want my vb6 program to ...
A: Option Explicit Dim entry As String 'this puts the text into the textfile Private Sub ...
|
| VBA /access question | 7/19/2007 |
Q: Ravindra, Hi, I am a new user to VBA and am struggling with the following scenario. I will give as ...
A: first create a table with categories as one field and other fields. create a form based on this ...
|
| Manipulating Closed Excel Files using VB | 7/19/2007 |
Q: Good Afternoon, What I want to do is select a file from a dropdown menu linked to a file directory ...
A: sample code 'check Microsoft Excel Objects Library Option Explicit Dim xl As Excel.Application Dim ...
|
| VB help very stuck | 7/19/2007 |
Q: I am contructing a VB lottery program for Uni but am stuck on the last bit as i am very very new to ...
A: sample code: Option Explicit Dim arra(6) As Integer, i As Integer, j As Integer, temp As Integer ...
|
| Manipulating Closed Excel Files using VB | 7/18/2007 |
Q: Good Afternoon, What I want to do is select a file from a dropdown menu linked to a file directory ...
A: you are confusing the use of VB. only if you are operating from Visual basic 4,5,6 then it is called ...
|
| Formated Output sending to msword | 7/18/2007 |
Q: I am one of your fan. i had problem on subjected topic as i went through your suggation and faced a ...
A: it is not possible to give a standard reply in this case. it depends on many things like, nature of ...
|
| do not save dublicate record in database | 7/15/2007 |
Q: i m using sql server personal edition and i have one table name is desigmast and when i click on ...
A: i suppose you are using ADODB to connect to the sql server. then you could use:(cn being ...
|
| Vb+Excel | 7/14/2007 |
Q: This is priya Actually I am very new with developing macros Actually the requirement is when the ...
A: there is some misunderstanding here. vb + excel means you are using Visual Basic 6 to open an excel ...
|
| Restrict keystroke in Visual Basic Rich Text box | 7/12/2007 |
Q: Sir, I don' want the user to use backspace in richtextbox. I tried the code which I usually use ...
A: i had given you the code before. also there is no meaning in disabling keys. however this will stop ...
|
| help in data retrieving | 7/12/2007 |
Q: in my application i gave two fields(From and TO) where i should get data according to that fields so ...
A: your question is not fully clear to me. i trust you have two fields in access tables and you want to ...
|
| Export some fields from VB to excel Sheet | 7/12/2007 |
Q: sir I am trying to export some fields from vb to excel sheet. so that i want to create a file in ...
A: i do not want to check your code, which appears to confusing to me. however this is one of the ways ...
|
| HTML Programming | 7/11/2007 |
Q: I got the MS Office WORD by which I can save htmls, as you know, Word lets users use VB for html ...
A: simple. you cannot use VB in any other programme. But that method is known as VBA, visual basic for ...
|
| Visual Basic Programming | 7/11/2007 |
Q: I am a Cross Country Coach at a local high school and I will be responsible for the "finish line ...
A: better to have the runners nos in a combobox rather than a textbox. 'put a check mark on ...
|
| Programming a macro and executing a exe | 7/10/2007 |
Q: what would you charge to write a full program for me.
A: give me broad details of the macro and also your budget for this. i do a lot of freelance ...
|
| read a text file, check for values, and update values | 7/9/2007 |
Q: I have a text file with many lines. Each line represents a record. I need to read positions 385 thru ...
A: get the value of 000000 etc into a string and work out as shown below: Option Explicit Dim adu As ...
|
| Record source in VB 6.0 | 7/9/2007 |
Q: I have connected a access file to visual basic and now I want to save,delete,add,print,edit and ...
A: 'put a check mark on Project_References_ Microsoft ActiveX Data Objects Library 'you can addnew ...
|
| Visual Basic | 7/6/2007 |
Q: I have developed a software in Visual Basic 6. I have used MS-Access in back-end. The software takes ...
A: 1) vb does not run automatically on other machines because of conflicts in version of VB,Operating ...
|
| Programming a macro and executing a exe | 7/5/2007 |
Q: csv file and export the data to another exel workbook, the data needs to go to particular columns. ...
A: you state it is visual basic. there is no macro creation in visual basic. you must be referring to ...
|
| winsock error requring licence | 7/4/2007 |
Q: I trient to design a client/server application, i added the OCX files in my project components ...
A: mswinsock.ocx is a part of vb components and if you check it , then you can place it on the form. if ...
|
| incrementing through cells in VBA | 7/3/2007 |
Q: I have been working on a major project were I need to display comments in a cell. Every comment ...
A: first make a macro which will insert a comment in the cell. make a second macro Sub Commenter() ' ...
|
| VB 6 | 7/3/2007 |
Q: Query ------- Sql = "Select Client, FileName from tblWauRecord Where CleanStatus = 1" rs.Open Sql, ...
A: to addnew use this: sql11= "select * from tracker" rs1.con,adopendynamic,adlockoptimistic rs1.addnew ...
|
| visual basic | 7/3/2007 |
Q: is it possible to connect mshflexigrid with database use microsoft DAO 3.51 LIBRARY. IF YES KINDLY ...
A: 'check Microsoft DAO object library under Project_references Option Explicit Dim db As Database Dim ...
|
| 23,000+ records Export to Excel | 7/3/2007 |
Q: Ravindra, I'm trying to export query results to Excel from form. I tried 'docmd.outputto' and ...
A: this can be done in excel itself. create a macro that does this: Data_Import External Data_Import ...
|
| OLE waveSound | 7/1/2007 |
Q: I have a simple question. I've been trying to get an OLE wave sound file to run automatically in ...
A: Option Explicit 'set the ole autoactivate property to automatic 'see that the ole object 's tab ...
|
| In Vb Some Program | 6/30/2007 |
Q: I Hava Some Doubt In MsFlexGrid Control.. In Vb .. I Dont ABout MsFlex Grid Controls And All.. I ...
A: the msflexgrid does not get the records directly from the table by any code. you need to assign the ...
|
| VBA + Excel + Sorting | 6/29/2007 |
Q: this is Andres again and I was just wondering if there was a way to sort the rows on excel using ...
A: VBA+EXCEL and vb6 is confusing. vba is different though similar, from VB6. controlling excel within ...
|
| Connecting to Access DataBase using VB6.0 | 6/28/2007 |
Q: I am a casual VB programmer. I have a database which has several tables. I want to open the tables ...
A: 'sample code. 'for find use the method in a separate form to have movenext etc Option Explicit 'put ...
|
| Ms Acess 2003 | 6/28/2007 |
Q: I am Using Access 2003 as a Back end Database for Vb 6 for Multi-user how can I set access For ...
A: anyone who can access the update form can update the data in the tables. Only you need to see ...
|
| Notepad in VB | 6/28/2007 |
Q: I am very much beginner in the vb & i want to create the notepad in vb. so pls help me. becoz i have ...
A: to open notepad Option Explicit Dim adu As String Private Sub Command1_Click() adu = "notepad" Shell ...
|
| Connecting to Access DataBase using VB6.0 | 6/27/2007 |
Q: I am a casual VB programmer. I have a database which has several tables. I want to open the tables ...
A: sample reply i gave another programmer. see if you could use it. 'put a check mark on ...
|
| Running and Viewing Access Reports from VB6 | 6/27/2007 |
Q: My reports are Access 2003. Some clients still use Access97. The code to view Access reports from ...
A: reports created in 97 can be viewed in both versions. the other way is not possible. no need to ...
|
| parent child relation on same form | 6/27/2007 |
Q: This is my first question to this forum.Since 4-5 days i m trying to find solution of my doubt but ...
A: as far as vb is concerned there is no parent and child tables. they are 2 separate tables with a ...
|
| parent child relation on same form | 6/26/2007 |
Q: This is my first question to this forum.Since 4-5 days i m trying to find solution of my doubt but ...
A: ' do you mean ADODC, or ADODB ? what do you mean by ADO data enviroment. the data environment is ...
|
| vb6.0+acess | 6/26/2007 |
Q: in my project i want to generate sequence number customer code.that means for first run it will be ...
A: call this function at the form load or any other stage where the no has to be increased; Private ...
|
| visual basic | 6/25/2007 |
Q: when we connect database to flexgrid control and run the programme the rows are not expanded enough ...
A: you can adjust the colwidth using code like MSFlexGrid1.ColWidth(1) = 1500 in the form load event. ...
|
| vb database connectivity | 6/25/2007 |
Q: how to connect with M.S.Access 4 database connectivity using ADODC?tell me every step soon?thanks.
A: 1) put adodc on form. point its connectionstring property to the database you want to connect. 2) ...
|
| VB | 6/25/2007 |
Q: Could you please tell me how to call a new form from another by pressing a button. What I wanted to ...
A: if you want to declare a public variable, you can do it in a module. add a module and add the line ...
|
| design combo bottom in access | 6/23/2007 |
Q: i have 2 tables, one of the name of countries, and another table has 2 field : countries & city. ...
A: sample code: ' have 2 combos c and c1 on form and add code c has all the towns using combobox ...
|
| No Personal.xls When Using Ole Automation | 6/22/2007 |
Q: Ravindra, Sorry for not responding sooner. I'm using Visual Basic 6.0 I mentioned earlier I was ...
A: Dim xl As Excel.ApplicationPrivate Sub Command1_Click() Set xl = CreateObject("excel.Application") ...
|
| Crystal Report Deployment | 6/22/2007 |
Q: I have developed a vb application that uses CR to generate reports. It is time I should my project ...
A: crystal reports is a third party shareware program that is not a part of VB now. if you want to read ...
|
| regarding the generation of reports in vb | 6/22/2007 |
Q: this is kishore from hyderabad, india. i have been devoloping software in vb since 8 months. i have ...
A: You are not following the KISS (Keep It Simple S..) principle of programming. you are using ADODC, ...
|
| Listbox to textbox, with if, so that.... | 6/19/2007 |
Q: I basically have a listbox with six names in it, and I would like it so that if I press the GO ...
A: Option Explicit Dim adu As Integer Dim arra(10) As String ' 10 is the number or items in list box ...
|
| VB 6 Database Query | 6/19/2007 |
Q: I am using VB6 and have a database that has fields called StartDate and EndDate. Data stored in ...
A: ' put check mark on Project References _Microsoft ActiveX Data objects libray ' latest number Dim ...
|
| VB in Excel | 6/19/2007 |
Q: I have an Excel sheet with multiple tabs (sheets) at the bottom. On the first sheet called "Work ...
A: there is NO VB in excel, it is VBA and it is different from VB. i don't know what the difficulty ...
|
| Hi, i have a question about VB and Access | 6/18/2007 |
Q: Ok, i am new at this, and i want to put the information that i have in Access in my program on VB, ...
A: you need to learn ADODB or ADODC to do all these. can dowload a tutorial from the Web. sample code: ...
|
| VB 6 + excel | 6/18/2007 |
Q: I am programming a macro to find and replace certain cells with other information and then sort the ...
A: there is no VB in excel, it is called VBA and is not the visal basic. though they look similar they ...
|
| Crystal Report | 6/16/2007 |
Q: How to generate chart type crystal report by passing parameter through visual basic 6.0.Please send ...
A: if you are using access, you need to make a parameter query and have a report based on this query. ...
|
| Query Help | 6/16/2007 |
Q: Hey there , well i am new Visual basic and i am working on the project i have creted a Data ...
A: have you chosen the connection in the dropdown list of the Command properties? if your query ...
|
| Access Database | 6/15/2007 |
Q: I'm trying to create a database regarding change control. I have tblchange control with all the ...
A: the terms you used in your question are ambiguous to me: like qrychangecontrol, tblchange control. ...
|
| vb6+inter | 6/15/2007 |
Q: first iam explaining what i have done i have create a procedure which will checks the table whether ...
A: the declarations: ' check Project_references_Microsoft ActiveX Data objects 2.8library '(or higher) ...
|
| No Personal.xls When Using Ole Automation | 6/15/2007 |
Q: Ravindra, I'm using Office 2003 with Windows XP. When I invoke Excel using CreateObject the instance ...
A: under Folder options check show hidden files. Are you running the code from Visual Basic 6? and ...
|
| Query Help | 6/14/2007 |
Q: Hey there , well i am new Visual basic and i am working on the project i have creted a Data ...
A: for a beginner you are attempting too much to start. first you need to configure the dataenvironment ...
|
| recording a dynamically changing cell value according to time | 6/13/2007 |
Q: I am currently running an excel based brokerage program from a company called Interactive Brokers. I ...
A: 1) to copy data to another sheet and keep it updated: eg: say you want cells A40 and B40 of sheet1 ...
|
| Query Help | 6/13/2007 |
Q: Hey there , well i am new Visual basic and i am working on the project i have creted a Data ...
A: you can use this: dim esql as string, adu as string adu=text1 esql="select * from students where ...
|
| how to design login window | 6/13/2007 |
Q: i want to design the login window through the database and it has a administrator which allow to ...
A: the login form is available in the project under Forms menu choose the login form code sample: *OR ...
|
| how to desing login screen through database | 6/12/2007 |
Q: how to call user name and password from database inorder to check login validity
A: the login form is available as an object from the form menu in the project( add form ) and use ...
|
| using DATE .... | 6/9/2007 |
Q: ....... I am having a peculiar problem using date format in MS-Access & VB.... my ...
A: while displaying date variables specifically see that is formatted to the type that you want. every ...
|
| Retrieving data from database based on the date | 6/5/2007 |
Q: Am developing a small dental suite and i have a small problem, i have set an sql statement in one of ...
A: date field is a tricky one. use this method, alter the field names and range. instead of between ...
|
| rank (vba) | 5/30/2007 |
Q: I would like to create a database that will contain a rank field on the form which allows me to rank ...
A: have you done what i suggested first? the form if created can add the ranks automatically. No need ...
|
| rank (vba) | 5/30/2007 |
Q: I would like to create a database that will contain a rank field on the form which allows me to rank ...
A: create a table with fields like Name,Marks,Rank make the rank (in table design window) no ...
|
| Excel: Text to columns | 5/29/2007 |
Q: I need code on how to perform following task: I have about 300 rows in following format: JD JUL ...
A: vb code is different from VBA code. i feel that you are wrongly mentioning VB. if you are in excel ...
|
| mschart+Access+vb6 | 5/29/2007 |
Q: I am having a problem with plotting multiple series using MSCHART control. I have access data base ...
A: 'put check mark on Project_references_Microsoft ActiveX Data Objects Library Option Explicit Dim ...
|
| abt vb | 5/29/2007 |
Q: How to connect vb with ms-access
A: 'put a check mark on Projects_references_ Microsoft ActiveX Data Objects Library. 'you can addnew ...
|
| Array | 5/28/2007 |
Q: Can we assign Procedure's to array so we can call this Procedures on Click on a form, which will ...
A: i believe you mean cmdbuzz to be a button. then you need to use call cmdbuzz_click() also to get ...
|
| vb+ms access | 5/28/2007 |
Q: I am encountering a problem while developing a project application in my school(beginner) in Visual ...
A: you need to make the exe file even if you change a small bit of code in the project. But what is so ...
|
| can we call command button in another procedure | 5/25/2007 |
Q: can i call cmd(commandbutton) in another procedure or can i use cmd in loop for some action and also ...
A: you can call the command click in other procedures add call command1_Click() in the procedure. ...
|
| VBA find Function | 5/24/2007 |
Q: Ravindra, First off, thanks so much for taking time out of your busy schedule to help me! I'll try ...
A: create a macro named Finder and add this code; Sub Finder() Dim egg As String, rowVal As Integer, ...
|
| Loops in VB | 5/21/2007 |
Q: How to nested for loops in Vb and syntax of looping structers
A: your question does not let me know what exactly you are looking for. the way to nest a loop in VB: ...
|
| format | 5/19/2007 |
Q: I have designed a program in VB. When I transfer this program(with *.exe format) to another computer ...
A: maybe the fonts or version conflict. what does your exe file do? use textfile or word/other ...
|
| VBA find Function | 5/17/2007 |
Q: Ravindra, First off, thanks so much for taking time out of your busy schedule to help me! I'll try ...
A: first the format of the date selected should match that in the rows. next try ...
|
| vb+excel+notepad | 5/15/2007 |
Q: sir i m a beginner.i need to copy certain details from a long notepad file into differnt columns of ...
A: Dim Pos As Integer, totsun As String, linecount As Integer Dim xl As Excel.Application Private Sub ...
|
| VB 6.0 + SQL connectivity for backend | 5/12/2007 |
Q: i have developed some minor level projects as users requirments with VB6.0 & MS Access but now i ...
A: this is a bit tricky and requires some amount of skill or trial and testing. 1. create a DSN from ...
|
| find records | 5/9/2007 |
Q: vb6, ADO i want to find a record that match a particular criteria in a database Say , the first ...
A: in vb findfirst etc are not the normal thing. use: 'put a check mark on Project_reference_ Microsoft ...
|
| Left Shift Operator | 5/9/2007 |
Q: what is the syntax for it I have tryed num1=num1 << 4 It gives error that expression is required
A: your question is incorrect. there is nothing called the left shift operator. you cannot use codes ...
|
| how to use hidden variable with textbox | 5/9/2007 |
Q: I am using &h with the first textbox like autonumber we use for increment the employee no in any ...
A: it is not that you are new to VB but new to programming. in your case you can have 2 variables for ...
|
| Syntax error in UPDATE | 5/8/2007 |
Q: I have connection to my Access table named "EnquirySalesEDP" and I am trying to set out UPDATE to ...
A: obviously you do not read the replies. i have told that concatenation for strings i.e the values of ...
|
| how to use hidden variable with textbox | 5/8/2007 |
Q: I am using &h with the first textbox like autonumber we use for increment the employee no in any ...
A: first, do not use can any body help me out . when you address it to one person, this is certainly ...
|
| help | 5/8/2007 |
Q: dere sir/madam i m beginner for vb prog. so plz help me i want to know - 1. how can i connect vb ...
A: itis not a good idea to address as deresir/madam. it is not backhand but backend. sql server ...
|
| Syntax error in UPDATE | 5/8/2007 |
Q: I have connection to my Access table named "EnquirySalesEDP" and I am trying to set out UPDATE to ...
A: your concatenation for the update query appears too complex. would suggest breaking it down to one ...
|
| How can print Data Grid data int VB6 | 5/7/2007 |
Q: I want to print Data Grid data completely. Please can you help the code for this snippet
A: Private Sub CmdPrint_Click() Dim RRow As Integer, RecCount as integer ...
|
| mshflexgrid | 5/5/2007 |
Q: Sir, I am very new to Visual Basic. I want to know how to connect mshflexgrid with dao as well as ...
A: better choice is msflexgrid whose code is similar to mshflexgrid. sample code for mshflexgrid (named ...
|
| Visual Basci TAB STOP | 5/5/2007 |
Q: I want to prevent user pressing tab key. I am doing this using tab stop =false I run a loop and ...
A: not a good idea to prevent the tab key form operating. many users are used to tab key to move to ...
|
| Datareport | 5/4/2007 |
Q: We had developed a billing system. we had used Data report for that. the problem arises when we need ...
A: need to get rid of this thing so please help me. what do you mean by this? you might have used data ...
|
| VB dialog | 5/3/2007 |
Q: My program has two forms: frmMain - Main form (also startup) frmSaveDialog - Save File dialog It ...
A: your problem not fully clear to me. when you shift to second form use frmSaveDialog.visible=true ...
|
| DBGrid Deletion and Updation | 5/3/2007 |
Q: Sir, if I am populating a DBGrid with records from two tables (having relationship on Primary and ...
A: the dbgrid does not get data from ADODC but the DataGrid does. when you connect this add a command ...
|
| ReadAllText at specified time intervals | 5/2/2007 |
Q: I'm trying to write an app that will do a ReadAllText on a specified file at specific time intervals ...
A: put a timer on form and set its interval to say 500 . change to make it faster or slower. have two ...
|
| Substitution for FlexGrid | 5/1/2007 |
Q: I am wtiting now a program that uses A flexGrid. The flexGrid is filles with strings, read from a ...
A: i have a flexgrid with 2 columns and 7 rows. you can have as many as you want but my code needs to ...
|
| mci controls | 5/1/2007 |
Q: i do not have the multimedia mci control in my components... i really need to add this .wav file and ...
A: try this one out: Option Explicit Private Declare Function sndPlaySound Lib "winmm" Alias ...
|
| Urgent | 5/1/2007 |
Q: i have a customer table in an access database. i need to know how i create a search form so that ...
A: How are you connecting to the access table? are you in VB or access? re: your second question,what ...
|
| database in workgroup | 4/30/2007 |
Q: I have a problem with Open mdb data file with vb6. How can I open may database file(mdb) in 2 ...
A: use this code in both the computers if you want and access the table. it is the locktype which will ...
|
| Exporting Access table to Excel using VB 6 | 4/30/2007 |
Q: sir i need ur help i want to export a single access table to Excel file. will u let me know the ...
A: 1st method under project references check Microsoft Excel 9.0 Object Library (or any number) Dim xl ...
|
| ranking records | 4/29/2007 |
Q: I was wondering if you can give me some tips on how to do this. I have an access database and it ...
A: have the field in access table, text with option Indexed with no duplicates. that means no ...
|
| data reports | 4/29/2007 |
Q: i m using vb6 and access. i hav crated as data report using data environment. when i want to fetch ...
A: you must point the command1 to a query which joins 2 tables on a common field eg: which i have used: ...
|
| Visual Basic 6.0 | 4/28/2007 |
Q: Sir, last time I could not explain my problem correctly. Pl. go through my problem. I have MS Access ...
A: what you are asking is a parameter query which is not possible in DataReport unless you enter in the ...
|
| Add search for field value | 4/28/2007 |
Q: Ravindra Thank you for your answer to my first question about refreshing and adding data in a form. ...
A: your code to find suits access form and NOT vb form. i suppose you are in Visual Basic Project ...
|
| VBA in Access. Tabel to Form Problem | 4/27/2007 |
Q: This may be a bit detailed, so stick with me. Is there a way to have a form which you can pull tabel ...
A: defining the problem is half the solution. your description is too general. give me clear picture ...
|
| Switching Forms and Refresh Data | 4/27/2007 |
Q: I have two VB6 forms (Form1 & Form2) and ADODB connection to Access 2000 Database and Table. Form1 ...
A: you can addnew and display in the same form1 and eliminate Form2. have 4 commandbuttons and 2 ...
|
| vb 6 Data Report | 4/27/2007 |
Q: now a movent if record r more or less the detail section spread or shrink with respect of the fetch ...
A: 1)you can fix the height of Detail section of the report by entering the height in its property. ...
|
| Formula parsing | 4/26/2007 |
Q: Is there any way to parse a formula from a string (recordset) to make calculations possible? Please, ...
A: Private Sub Command1_Click() Print Formula(CSng(Text1), CSng(Text2)) 'change option here, instead of ...
|
| VB | 4/26/2007 |
Q: i have a program that generates 6 random numbers and i need to make sure that it dosen't generate ...
A: one method: Function Rand(ByVal Low As Integer, _ ByVal High As Integer) As ...
|
| notepad | 4/26/2007 |
Q: i am kishore. i am a beginner in vb programming.i am doing a project currently. i just wanted to ...
A: i have used 2 command buttons first one adds data and the second one gets the data. make changes ...
|
| Automate import of bas file | 4/25/2007 |
Q: I have 130 users where I work and we have recently created some WORD macros that we would like them ...
A: it is better to make a word template with your .bas module + macros. let all the users use the word ...
|
| msword to textbox | 4/25/2007 |
Q: i am kishore. i am a beginner in vb programming.i am doing a project currently. i just wanted to ...
A: explain your requirement properly. the word document holds hundreds of pages, whereas the textbox ...
|
| VB6 ADO SQL query WHERE clause error | 4/25/2007 |
Q: I'm using VB6 writing an SQL query as follows. When I run the clause "SELECT * From tSlides", it ...
A: change these 3 lines from 'strSQL = "SELECT * From tSlides WHERE ActivityType = kick" 'strSQL = ...
|
| VB data report | 4/24/2007 |
Q: sir, i new to VB 6.0, i have a form with some controls. Now i want a report based on the values of ...
A: since you are a beginner, i can see that you do not know how to use DataReport. Data Report Requires ...
|
| open .accdb database using DAO | 4/24/2007 |
Q: How can I open a .accdb access 2007 database using DAO?
A: first see that you have the latest DAO from Microsoft 3.5 or so. only with this you can get the ...
|
| Can't concatenate | 4/23/2007 |
Q: This is my code: For i = 101 To 400 DoCmd.GoToRecord , , acFirst Select Case ...
A: your code acfirst, movenext seems a bit awkward. better to usee Do while not eof rec loop anyway ...
|
| VB6 SQL query command | 4/23/2007 |
Q: 1.Hello, I have a request, I want to replace this line: Data1.RecordSource = "select * from CDs ...
A: comment: using both datacontrol and adodc in the same form is not a good idea. Better use ADODB ...
|
| Can't concatenate | 4/23/2007 |
Q: This is my code: For i = 101 To 400 DoCmd.GoToRecord , , acFirst Select Case ...
A: first of all are you in visual basic? then docmd has no place here. are you in excel or access? how ...
|
| VB6 SQL query command | 4/23/2007 |
Q: 1.Hello, I have a request, I want to replace this line: Data1.RecordSource = "select * from CDs ...
A: 1)do you have a table called testable3 2)have you connected the ADODC1 to your database? 3)the line ...
|
| VB.NET with MS ACCESS,Beginner | 4/21/2007 |
Q: can u tell me how to validate the textbox with date,that is i want to check whether the user entered ...
A: Option Explicit Private Sub Text1_Validate(Cancel As Boolean) ChekChar (Text1) End Sub Private ...
|
| VB6 | 4/21/2007 |
Q: how to link my access database with my program?
A: there are several methods but for each, you need to know some coding. the methods are using DAO, ...
|
| MS Access traversing through a record set | 4/21/2007 |
Q: I have a reporting utility that displays certain records from a database. Now I have a function that ...
A: you want to check if a particular amount is found in 1)any of the fields of a Single Recordset or ...
|
| How to Terminate Process by using PROCESS_TERMINATE access? | 4/20/2007 |
Q: I am calling one of the exe with the help of shell command. As I am using XP windows I was not able ...
A: first let me warn you that is somewhat risky to use these API. Also, i do not know if it works in ...
|
| flexgrid | 4/20/2007 |
Q: its me again , my bad luck i replaced the 0 with the i , it doesnt work if that can help the msg ...
A: FIRSTLY, know that the code works here alright and you must have made some mistake while copying the ...
|
| flexgrid | 4/20/2007 |
Q: vb6.0 I have a flexgrig om my form which am able to fill in with data frm a database. However am ...
A: when an error happens FIRST CHECK IF YOU HAVE ENTERED THE CODE PROPERLY befor rushing back to ...
|
| VB6 SQL query command | 4/20/2007 |
Q: 1.Hello, I have a request, I want to replace this line: Data1.RecordSource = "select * from CDs ...
A: have a field in the table indicating the Number of Record say from 1 to 7 then try this code; ...
|
| flexgrid | 4/19/2007 |
Q: vb6.0 I have a flexgrig om my form which am able to fill in with data frm a database. However am ...
A: here is one method: Option Explicit Private Sub Command1_Click() Dim j As Integer For j = 0 To ...
|
| Create Windows folder via VB button | 4/18/2007 |
Q: How to create Windows folder via VB button? I forgot to say: I am using VB6 Thanks, Ryan
A: you should not create a windows folder as this is meant for Windows programming only. however you ...
|
| Create Windows folder via VB button | 4/18/2007 |
Q: In most code i can find where you connect to MS Databse, you'll find somehting like 'data source = ...
A: there is a package and dev. wizard which you can use to make a package and run it. But the ...
|
| Connecting to SQL Server | 4/17/2007 |
Q: Hi, I'm new to VB.net and am trying to establish a connection to SQL server but get an error. I've ...
A: dim strcn as string, cn as adodb.connection ' declare in general section 'NOTE; Servername here ...
|
| about vb | 4/16/2007 |
Q: sir, i am regularly disturbing you. sorry. i have a same problem so i am again here. this time i ...
A: i cannot help you without knowing the full details. sql server requires some initiation before ...
|
| about vb | 4/15/2007 |
Q: i'm again sir, in general declaration area my code is dim cn as new ADODB.connection dim rs as ...
A: dim strcn as string, cn as adodb.connection ' declare in general section private sub form ...
|
| VB6/Access2000 Project from Win98 to WinXP | 4/14/2007 |
Q: My question concerns rebuilding an application (VB6 + Access 2000) that was originally developed on ...
A: it is a problem with access on your WINXP settings.have you set any password or group information? ...
|
| data combo | 4/13/2007 |
Q: how to use data combo in simplest way? if i m using 2 data combo is it going to effect the pther ...
A: the simplest way to use a datacombo put a Microsoft ADODC on the form ( select this from tools ...
|
| How to allow control to form while running the VB Code | 4/12/2007 |
Q: I am new to VB Programming. I have written one application in VB that searches in the EXCEL and ...
A: normally the procedures need to run ALONE. it means when a procedure is running, other procedures ...
|
| VB-Varsha Desai(knowledge level-Advanced) | 4/12/2007 |
Q: I am calling one of the exe with the help of shell command as follows ProcessId = ...
A: since i work with win2000, i cannot verify the code that i send. but try this link. it says that ...
|
| VB-Varsha Desai(knowledge level-Advanced) | 4/12/2007 |
Q: I am calling one of the exe with the help of shell command as follows ProcessId = ...
A: since this uses win API, it may or may not work in WINXP but it works ok in Win 2000 code sample: ...
|
| about vb | 4/12/2007 |
Q: i'm again sir, in general declaration area my code is dim cn as new ADODB.connection dim rs as ...
A: you have given me part code so my solution applies to the. part. first check if you have checked ...
|
| about VB | 4/12/2007 |
Q: i am a beginner in vb.i had done a project in VB+SQL.but when its running time it shows a ...
A: to check the exact cause, when you get the error message, click the debug button on the message to ...
|
| How dor i create forms, text boxes, etc. at runtime? | 4/3/2007 |
Q: i want to create a form at runtime with two text boxes one under the other and and a list box under ...
A: for practical purposes, a runtime creation of these objects isn't much helpful. But for programming ...
|
| VB nuances | 4/2/2007 |
Q: What's the difference between Text1 = "A" and Text1.Text = "A" and if I have a sub routine called ...
A: no, you are reassigning the stemp to Myvariable and assigning it "Tom" there is error in default ...
|
| Removes Duplicate Item in Listbox | 4/2/2007 |
Q: I have one question..I have an application that uses the listbox control...my question is how to ...
A: you can create a query based on the table. suppose you need to filter on the field "Block" then you ...
|
| VB nuances | 4/2/2007 |
Q: What's the difference between Text1 = "A" and Text1.Text = "A" and if I have a sub routine called ...
A: the default setting for Text1 is text1.text. so both are OK, the omission of .text is for ...
|
| VB6+SQL Server | 3/29/2007 |
Q: Problem : Password Modification in VB 6.0 and SQL Server. Our problem is that we need to retrieve ...
A: i have shown the code in access. just change the connectionstring and the path and use the code: ...
|
| Saving dates in registry in VB6 | 3/28/2007 |
Q: I am based in the UK and my question is related to handling of different date formats in VB6. ...
A: no need to go to registry. also no need for CDATE, which converts string to date format. to display ...
|
| VB + ACCESS | 3/28/2007 |
Q: (VB/6, MS Access,Intermediate) I am doing a project in vb. can u tell me that procedure for how to ...
A: i had asked you to explain but you have just said it is from 2 tables. if you need specific ...
|
| VB: Can a function return an array? | 3/27/2007 |
Q: I would like to pass two arguments to a function and have the function generate an array to return. ...
A: you can pass the strings to an array. see code sample Dim arra(1 To 10) As String Private Sub ...
|
| ADO | 3/25/2007 |
Q: Good day.. i ask if you can help to solve my problem. i am using vb 6 and i used MS Access database ...
A: you can adopt this plan. under control panel, ODBC, create a new DSN (data service Name) point to ...
|
| Runtime Error 3251 in VB6 | 11/29/2006 |
Q: Just one more question.Im using a piece of code to show images in a picturebox which correspond to ...
A: your code is basically unsound because of use of Data1 you need to protect against 2 main types of ...
|
| VB and MSAccess | 11/29/2006 |
Q: I am relatively new in VB6 and MSaccess combination. Please help me correct this program. All i need ...
A: you need to use DAO or ADO to connect to the database. under Menu Project_References, put a check ...
|
| Runtime Error 3251 in VB6 | 11/28/2006 |
Q: Im using the following code to create a search button for my program: Private Sub ...
A: Option Explicit Private Sub Command1_Click() Dim searchvar As String searchvar = InputBox("Please ...
|
| vb 6 adoc | 11/26/2006 |
Q: hye...i'm doing project using vb 6...i've face some problem... this is my situation...i've create 2 ...
A: obviously, you don't seem to read the code.ok if you want to use a textbox in the above code ...
|
| vb 6 adoc | 11/24/2006 |
Q: hye...i'm doing project using vb 6...i've face some problem... this is my situation...i've create 2 ...
A: put a datagrid on the form( 1 or 2) and point the datasource to adodc1. now you can edit alter etc ...
|
| vb 6 control | 11/24/2006 |
Q: hye...i'm doing project using vb 6...i've face some problem... this is my situation...i've create 2 ...
A: this is towards 2ndServer is usually referred to a big computer that can service several computers ...
|
| VB | 11/22/2006 |
Q: sir,, How to calculate the number of line in a file using VB. -----Answer----- question not clearly ...
A: Option Explicit Private Sub Command1_Click() Dim linecount As String, totsun As String Dim idu1 ...
|
| Uploading Excel in vb | 11/22/2006 |
Q: i m working on Building monitoring system when i run the program that time i want all information ...
A: this is not called Uploading, which means thro internet. anyway here is the method: 'under ...
|
| VB | 11/22/2006 |
Q: sir... how to get the fields in a line which are separated by a comma.... and how to assign each and ...
A: Option Explicit Dim linecount As String, totsun As String, temp1 As String, temp2 As String Dim ...
|
| VB | 11/21/2006 |
Q: i want to create a table in run time with fields and its type which are also known at runtime.... ...
A: Option Explicit Dim conn As ADODB.Connection, esql As String, cmd As ADODB.Command Private Sub ...
|
| Run-Time Error 13 | 11/18/2006 |
Q: But I did have all the numbers filled in the text boxes. I even tried to enter them as actuall ...
A: the code works alright. put a breakpoint to each function and see which call produces an error.also ...
|
| v.b.6.0 not installing | 11/17/2006 |
Q: Sir im sentil.My computer not accept the v.b 6.0 software,After install it says "Failed to Register ...
A: Do not completely follow you. what do you mean accept the vb6 software? you mean installation was ...
|
| input from serial port | 11/15/2006 |
Q: i m telling u 2nd part dear..: i just explain u again... one string str having total 12 chacters.. ...
A: put a textbox and a label on form make the size of label around 3" x 4" enter a string into a ...
|
| Dates in VB | 11/15/2006 |
Q: I have developed an application program in VB with Access as B/end. I m storing dates through ...
A: i dont know how you are storing the date values in the listbox use this code: Option Explicit ...
|
| input from serial port | 11/15/2006 |
Q: . i want to communicate between PC to serial com port.. Now m using mscomm1.. 1) how to take input ...
A: i do not want to answer your 1st part of the question. re Part 2, i can help you but do not ...
|
| how to do calculation in a Flexgrid | 11/13/2006 |
Q: i am using a flexgrid control to retrive data from db, and in a flex grid there is a one colum for ...
A: Option Explicit Private Sub Command1_Click() Dim date1, date2 As Date date1 = #5/22/1938# date2 = ...
|
| status bar | 11/12/2006 |
Q: hye... i need your help...i've problem with vb...anyway,thanx for your help... this is my ...
A: 1) using sql and ADODB connection dim esql as string,conn as ADODB.connection, rec as ...
|
| how to select listbox item | 11/10/2006 |
Q: hye... i'm new with vb 6...hopefully you can help me.... i've put one listbox called list1..and ...
A: when you click on the listbox, then it fires an event called List1_click. you can extract the record ...
|
| Creating New Sheets | 11/10/2006 |
Q: Is it possible to create new sheets in an excel file using Visual Basic 6? If so, how can it be ...
A: 'under project references, check mark for Microsoft Excel9.0 object Library Option Explicit Dim xl ...
|
| Query doubt | 11/8/2006 |
Q: Its a datagrid in Flex Builder 2.Hello, I've got a query as such: "Select D,B,A,C from tbltest ...
A: first the grid is not a standard component of VB. i have no knowledge of this tool. But you can ...
|
| Query doubt | 11/8/2006 |
Q: I've got a query as such: "Select D,B,A,C from tbltest where true;" When I display this in a grid, ...
A: which grid are you using? the query can be made using Private Sub Command1_Click() esql = "SELECT ...
|
| printer | 11/7/2006 |
Q: how can i change printer mode from portrait to landscape and from landscape to portrait by code in ...
A: CommonDialog1.ShowPrinter If CommonDialog1.Orientation = cdlPortrait Then ...
|
| question regarding dates in excel vba | 11/6/2006 |
Q: I have two questions for you as follows: Q1 I am calling a data from someother excel sheet which is ...
A: 1) to insert month, you can this option" format the cell as 18-Mar,2006 and add this to a macro Sub ...
|
| Worksheet Calculate Event | 11/6/2006 |
Q: Ravindra, I am hoping you can help me on my current excel program. I am using the worksheet ...
A: i had replied to you before stating that i would not like to answer your question. anyway to exit ...
|
| Multiple listboxes item selection issues | 11/2/2006 |
Q: this is difficult to explain so bear with me. I have 2 listboxes on my form (connected to the same ...
A: Option Explicit Dim conn As Connection, rec As Recordset, esql, esql1 As String Private Sub ...
|
| Follow up: VB6: Select all check boxes in Datagrid | 10/31/2006 |
Q: Well, Once you get the Apex true DBGrid pro 6.0(oledb) on the form, select Grid and go to property ...
A: Apex true DBGrid pro 6.0(oledb) is a third party component and not DBGrid that belongs to VB. there ...
|
| Entry of decimal numbers (VB + Access) | 10/30/2006 |
Q: I am basically an astrologist and need to enter numbers (viz 1.15 or 12.35 or 123.48 or 22.1 or ...
A: place the maskedbox on the form. set its properties as below: format ###.00 Mask ###.## prompt ...
|
| VB-Access, recordsource | 10/27/2006 |
Q: 1)I am a student intern working in the company and it is a small part of the project that I am ...
A: * basically you want to extract the lower numbers that would be applicable to a given Upper number. ...
|
| Visual Basic | 10/25/2006 |
Q: How to scroll to a particular cell in Flex grid programatically.when I give a new entry it is ...
A: Option Explicit Dim i As Integer Dim conn As ADODB.Connection, rec As ADODB.Recordset, esql As ...
|
| VB6-Random function | 10/25/2006 |
Q: I am beginner, "Question is I am having 5 forms named f1,f2,f3,f4,f5. One more form Named MainMenu. ...
A: your need to open at random does not sound logical to me . anyway since you ask for code, here's a ...
|
| how to use Crystel Report | 10/24/2006 |
Q: I'm Trendra Chauhan, I have created VB application using MS access as backend, and I’m using DAO ...
A: first create a query in access using Design view, include the tables you want and join them by a ...
|
| VB6 - Info error Apex XarrayDB Object | 10/23/2006 |
Q: This is Dhaval Shah. I am working as a Database Designer/Programmer in company called RuggedCom, ...
A: Apex XarrayDB Object is not a regular feature of Vb6 and such it is an outside programme and as ...
|
| MSAccess Picture (OLE Object) in VB | 10/20/2006 |
Q: I have a VB application, which (among many other things), manages Staff members (add/update, etc.) ...
A: create a access form that has an ole object that is bound to the access table. for adding pictures, ...
|
| encrypt file | 10/19/2006 |
Q: i want to read file which is already encrypted. now i want to check whethere this file is already ...
A: the file should have some documents and when you check if the documents can be opened and read with ...
|
| VB programming | 10/19/2006 |
Q: it solved my problem thanks again, I've already rated you. i got anotherhow can I search something ...
A: Option Explicit Dim good As String, adu As Date Private Sub Command1_Click() adu = #5/2/2002# ' ...
|
| How to Open MSAccess data with Password protected | 10/18/2006 |
Q: Need help on VB6. I tried number of times to Open MSAccess data(I protect with a password on it), ...
A: you cannot read a password with the normal code. you need special programs to do it. ONLY if you are ...
|
| VB programming | 10/18/2006 |
Q: I'm doing a simple VB program which has a DataGrid and Adodc, I would like to change Datasource of ...
A: have the recordsource of the adodc1 as adcmdtext and initially use select * from tablename during ...
|
| Word/Visual Basic | 10/17/2006 |
Q: I have a follow up question. I'm working with the visual basic editor and word (2002) by the way. I ...
A: you need to have a variable and assign the text of the listbox or combo to this. then Sub InsWord() ...
|
| DataReport in Visual Basic 6.0(intermediate) | 10/17/2006 |
Q: can i create a datareport for selected fields in a particular table while running the project
A: the data report and the dataenvironment from which the data is extracted should already be in the ...
|
| VBA,beginner,VBA+Excel+picture NMG | 10/17/2006 |
Q: Ok, inside VBA(with Excel), what is the object, code or whatever that I should use, to insert a ...
A: as i told you that you need macro construction practice. you create a new macro and physically do ...
|
| Word/Visual Basic | 10/16/2006 |
Q: I need to write a program within Word/VB that will allow me to hit a command button that will bring ...
A: can be done in word using VBA using a Macro,or VB but requires some work and time. you have an array ...
|
| visual basic database access | 10/16/2006 |
Q: i build software using visual basic i put into network and before they can access this software i ...
A: there are several strategies, some involving complex but some others- simple. at startup, if you ...
|
| VB6 connection to access 2003 | 8/18/2006 |
Q: iam a beginner in database programming...iam now facing to a problem with connection from vb6 to ms ...
A: you need to use DAO or ADO to connect to the database. under Menu Project_References, put a check ...
|
| Replacing special character with plain spaces | 8/17/2006 |
Q: Is there a way to remove special characters from a string in access database field on a large table ...
A: the storage of data in access comes with the carrrige return but while display in a label it is ...
|
| Vb6, ADODB.Connection | 8/16/2006 |
Q: I'm new in vb6.after inserting using command,I dont know how can i make sure the value entered in it ...
A: I suppose you are using ADODB with connection , recordset etc you need to check if it exists in the ...
|
| How to Calculate Expeceted Retirement date of Employee | 8/15/2006 |
Q: My names are Ameen B. Designer, an a beginner in VB6 (Teaching myself). I am presently trying my ...
A: better to display results in a label as the user cannot alter the same. here is the sample code. ...
|
| Access Multiuser | 8/15/2006 |
Q: Can you give me some resources wherein I could find list of functions which can be used in VB...I ...
A: to become an expert at VB requires some basic technical need that will force a person to start with ...
|
| Access Multiuser | 8/14/2006 |
Q: I am new to VB 6 & Access..Your replies / advices really good & help..I am currently developing ...
A: for a new person to vb6 it is a bit more complex. you need to learn about creating DSN(quite simple ...
|
| VB 6 | 8/14/2006 |
Q: I have created a data report.I want to find the sum of the values of three fields(not the values of ...
A: the sigma control gives sum of field values in the report footer section only. to get the sum of ...
|
| Open Pwp Protected Access database | 8/11/2006 |
Q: G. I don't understand. I didn't have any problems setting the database password; in fact it was ...
A: the password protection is complex and once you do that, all other access databases will ask for ...
|
| LIKE Operator with 2 Tables | 8/9/2006 |
Q: I know this may be simple, but I cannot get this to work! I have 2 tables. I'm trying to find ...
A: are you operating from VB or access? also it is not clear what you mean by parts numbers that are ...
|
| Open Pwp Protected Access database | 8/9/2006 |
Q: G. I forgot to ask; i am using this code that i got from you to view MS Access forms and Reports ...
A: password protection of a mdb is not a good idea for beginners. remove the password and learn all the ...
|
| Combobox dropdown list from MS Access | 8/9/2006 |
Q: G. Here i am knocking on your door...yet again, and would like know if you can help me with the ...
A: instead use a datalist box (available from components ..rt click on General Tools panel) and point ...
|
| sql | 8/6/2006 |
Q: i'm just a beginner! thats why i can't retrieve fields from a database. "SELECT * FROM tbl_Pawn ...
A: the concatenation of date is wrong. also it is better to change the date field name to say DateD to ...
|
| How to access MS Access | 8/5/2006 |
Q: G. I headed your expert advice (if you still can remember) and familiarized myself with ADODC. I am ...
A: in your vb form, under Project_references Menuput a check mark on microsoft access 9.0 object ...
|
| VB6 Trigonometry | 8/4/2006 |
Q: okay here goes. I require a trigonometry mathematical function in to vb6. Some notes Text boxes ...
A: in vb the trigonometric functions are on radians and not degtrees. you need to convert degrees to ...
|
| visual basic-how to draw a graph | 8/3/2006 |
Q: visual basic 6.0 Beginner/school studnet seeking to learn how to draw a line graph in VB URGENT ...
A: place the microsoft chart control on the form. choose the type of graph(pie, column, 3d etc) .select ...
|
| help me to answer | 8/3/2006 |
Q: i have a flex grid.then the flex frid contain all the data from the data base. then i will choose 1 ...
A: first of all this is not called Edit. Edit means to alter the value. to shift values from one grid ...
|
| crystal report | 8/3/2006 |
Q: .. in my VB code i am calling 1 crystal report.... ... the problem is that my database linked to ...
A: there is no code involved. in the crystal report .rpt file who select the option which does not save ...
|
| help me to answer | 8/3/2006 |
Q: ------------------------- hello! here again how can i UPDATE if i choose only one in the records ...
A: question unclear. which grid? datagrid,dbgrid,flexgrid? also how are you changing the data? some of ...
|
| Beginners VB Code Site | 8/2/2006 |
Q: ravindra I am a beginer in'VB 6.0' I really want to learn who to use this application but ...
A: try these links 1) http://vbnet.mvps.org/index.html?http://vbnet.mvps.org/search/main/vbhowto.htm ...
|
| Excel related question | 8/2/2006 |
Q: I have used the code as suggested: Sub ListBox1_Change() Dim adu As String adu = list1.Text ...
A: change the code as below: ' your reference to vb code was what made the mistake. you should say VBA ...
|
| Searching the entered data in the textbox from database thru the vb6 interface with ADODC controler | 8/2/2006 |
Q: . Pleas Help me out My Question is as follow How to search a text/number(ex:-ramu/empno.16)which ...
A: Private Sub Combo1_click() Dim esql As String esql = "Select * from testdata Where First=" & "'" & ...
|
| Line spacing Macro | 7/31/2006 |
Q: I have a document that is divided into sections. After each section there, on a new sperate line, ...
A: there are standard macros that do the job you have in mind. it takes some time and effort to write ...
|
| VB6 MSAccess Crystal report | 7/31/2006 |
Q: I have created VB application using Crystal report and MS acess as backend.I have made package of ...
A: vb and crystal report required in the second machine to avoid such errors.crystal reports is not ...
|
| vb6 Access | 7/30/2006 |
Q: as a vb6 beginner, i want to add new tasks to my listbox to be stored in its respective field in my ...
A: [Private Sub cmdAdd_Click() rs2.addnew rs2.Fields(0).Value = txtID.Text .. .. .. rs2.update if ...
|
| Crystal Reports 10 and SQL Views | 7/28/2006 |
Q: Yeah it's me again, i've a problem with Crystal Reports, it's basic, how can I open a report into my ...
A: 1) crystal reports is not a free report and it requires license. so i don't use it. but to use it ...
|
| VB 6 | 7/26/2006 |
Q: I want to search access db via a VB6. Either by name or phone number and display results in a ...
A: better to use a grid like MSflexgrid which can be programmed easily. anyway here is a sample code to ...
|
| vb 6 | 7/26/2006 |
Q: i am using a form with two textboxes for login, and a table which has the usernames and passwords. ...
A: i don't know from where you get the code. it has no logic. here's the method: you need to use DAO ...
|
| Date in VBA | 7/26/2006 |
Q: Ravindra, I have been taking your help since last one month. It is useful for may of times. But date ...
A: GOOD = "#" DATE1 = Format(#1/12/2001#, "dd/mm/yy") DATE2 = Format(#1/12/2001#, ...
|
| DbListbox | 7/25/2006 |
Q: vb6 access, beginner I hve read your answer on rather using this listbox for db data, I however do ...
A: 1) using this listbox for db data means what? listbox cannot be the right choice for data from ...
|
| SSTab-moving from one tab to another | 7/25/2006 |
Q: I am looking for a way to shift focus from one tab to another in an SStab. For instance, if there ...
A: after placing the sstab on the form, and to move the focus to specific tabls. have 3 option buttons ...
|
| SQL Server Error | 7/25/2006 |
Q: I have a VB6 project that connects to my SQL Server, I use the Microsoft SQL Server Managment ...
A: yes, i got it now. if you are going to have duplicate values in all fields, naturally for delete the ...
|
| Input and output Arrays in VBA | 7/24/2006 |
Q: I named a range in my spread sheet called duration. It is an array of 53 numbers in one column. I ...
A: your code is not OK. and your question is unclear to me. array1 is just one variable. how can the ...
|
| How to open an access form using vb6 or vb2005 command button | 7/24/2006 |
Q: I have vb6 and vb2005 and i would like some code to open (launch) an access from from a command ...
A: it is not such a good idea to open an access form. think why do you want to do so. when you are in ...
|
| Listbox, ADODC | 7/23/2006 |
Q: i have a problem in trying to link my listbox with its respective field in the database. when i run ...
A: adodc shows only 1 record at a time. for loading the listbox with all the values of a field you need ...
|
| Access in vb6 | 7/23/2006 |
Q: i am a beginer in vb6 and i would like to know how to get info from a table in database( just say a ...
A: the simplest way is to use ADODC. from the components menu (rt click on General Tools panel) select ...
|
| Date | 7/23/2006 |
Q: Sir, I am using VB and backend as access. I would like to retrieve the data during a particular date ...
A: date variables are sensitive to the format in which they are compared. use this method: Dim GOOD ...
|
| Re : VBA for Excel reports | 7/22/2006 |
Q: I have developed a small package in VB6. I have written the code for printing report in excel spread ...
A: use this code and make any changes that may be needed to get the exact effect: Sub Border() ...
|
| Opening an excel sheet | 7/22/2006 |
Q: I am new to vb programming.I got an error when i try to open an excel in runtime.i have pasted my ...
A: 'check mark for project_references Microsoft Excel Objects Dim xl As Excel.Application Private ...
|
| VB ms access | 7/21/2006 |
Q: How Do I generate a run time report . for eg i have to generate a report based on SQL query 'select ...
A: Option Explicit 'Under Project_references put a check mark on Microsoft Access Objects Library ...
|
| Access Command Button | 7/20/2006 |
Q: I have created a command button in Access which launches a word document, then fill in certain ...
A: when error shows mismatch then there may be a problem with the data. it may be blank or in access ...
|
| How to retrieve a certain text from .*txt file into textboxes? | 7/20/2006 |
Q: I met with some problems with my Visual Basic codings...I need to retrieve certain texts and ...
A: for display of data Lable is used so that user does not enter data and corrupt the table. remove the ...
|
| Combo boxes | 7/19/2006 |
Q: Beginner - Int Using 2003. I was trying to get combo box2 dependent on combo box1. For instance. If ...
A: Option Compare Database Dim esql As String Private Sub Combo1_Change() esql = "select rate from ...
|
| Combo boxes | 7/19/2006 |
Q: Beginner - Int Using 2003. I was trying to get combo box2 dependent on combo box1. For instance. If ...
A: Option Compare Database Dim esql As String Private Sub Combo1_Change() esql = "select rate from ...
|
| vb 6 | 7/19/2006 |
Q: i have used the code you sent me but when i run it, i get an this error "field'tblUsers.username' ...
A: obviously you are too new to attmpt adding new records. before you add new records to your table you ...
|
| VB Reporting | 7/19/2006 |
Q: I cant able to view data in VB Data report in detail section even after using drag and drop method ...
A: 1) i don't see why drag and drop from data environment does not work. maybe there is no data in the ...
|
| crystal report | 7/18/2006 |
Q: i have put the control on the form... still its not working....and also while debugging when i put ...
A: don't you read what i sent? you say cr1 and crystalreport1. looks like some common sense is ...
|
| crystal report | 7/18/2006 |
Q: following code is giving error that " report can not be loaded"... whts the problem... i want to ...
A: this is not the procedure to get the display. put the crystal report icon(from tools_components ...
|
| What type of reports do you suggest? | 7/17/2006 |
Q: I'm to go straight to the point. I'm developing a VB6 app along with a SQL server database, I was ...
A: unfortunately, most of the report designers (crystal reports etc) are not available free and you ...
|
| Run Time Error '91' | 7/17/2006 |
Q: I am sending my coding. I have some problem in this program.I have two combobox-cboModel, ...
A: rsCarmake.Open "select * from CarMake where ID =" & cboModel.ItemData(cboModel.ListIndex) here ...
|
| find date | 7/17/2006 |
Q: i've been set of data in Ms access 2002, have a field called "Date from" and "Date to" I must ...
A: have 2 datepickers one for startdate and the other for end date. dim esql as string have this code: ...
|
| subform/query data access | 7/17/2006 |
Q: Could you write example code of "a public procedure and/or a variable(in module)" for a variable in ...
A: choose modules, New , create a new blank module in that enter this code: Option Compare Database ...
|
| vb access karthik regarding access database | 7/16/2006 |
Q: sir, i have a problem in accessing database i have 3 fields in database but i need to ...
A: this is not such a good idea and a waste of resources. this can be done easily using arrays. it is ...
|
| MaskEdBox | 7/16/2006 |
Q: about how ican view date years in object MaskEdBox1
A: you cannot view dates unless you enter them. draw the maskededit control on the form. in its Mask ...
|
| insert into access | 7/15/2006 |
Q: i have following stamnt ... insq = "insert into table1 ...
A: my god are you kidding! in the values( ...you should put the actual data that you want to put in the ...
|
| recordset addnew | 7/15/2006 |
Q: hey.... i have recordset rsmain.... and have following code rsmain.Open "select * from table1", ...
A: read my answer to your earlier question. you must ask upto a specific level.clear it; then move to ...
|
| insert query | 7/15/2006 |
Q: ..can u please help me..i have following query in which i am only inserting values for some ...
A: if you are inserting only some values insert into tableName(fieldlist)values(valuelist) dont enter ...
|
| VB 6.0 | 7/15/2006 |
Q: How i could use instr() function in recordset.filter statement. I have near 10000 records in ...
A: the easy way to get records based on a criteria: you need to use DAO or ADO to connect to the ...
|
| ADODB.Connection | 7/14/2006 |
Q: I made a login form just like you said. I made a blank table in MS Access, and saved it. But when i ...
A: i do understand the views of a beginner but the beginner cannot hope to learn everything by asking ...
|
| List of sno. change to Sno. Fm - Sno. To | 7/14/2006 |
Q: I have a list of Sim numbers. I want to change it to inventory report. eg. list 894100320533121 ...
A: where are the numbers? in access? are they stored somewhere? where is the list. how can we pick up ...
|
| ADODB | 7/14/2006 |
Q: i dont know how to use the ADODB, can you pls help me, from basic connection to coding, i dont have ...
A: cannot teach you so many things in this forum. using ADODB sample: you need to use DAO or ADO to ...
|
| About FlexGrid Control in VB | 7/14/2006 |
Q: sir,i am using flexgrid control in vb application the data's are fetched into that control but it ...
A: you have to specify the number of columns in its properties. also if you have a fixed column have an ...
|
| ms-excel connectivity with vb6 | 7/13/2006 |
Q: i m still in learning phase of vb6...so wat shud i do in order to connect a table in excel into ...
A: 'close other running applications. this takes much system resources. 'put a check mark on Microsoft ...
|
| visual basic ado & listbox | 7/13/2006 |
Q: Sir, Iam a Second B.Sc Computer Science Student .I ...
A: what you are referring to is the Visual basic IDE where after the . you will be given choices. this ...
|
| vb | 7/13/2006 |
Q: i have 2 form fields called text1 and text2 in a ms word document when i click on the form field ...
A: i am getting tired of telling people that if they are in excel then it is NOT Visual Basic but ...
|
| macros | 7/13/2006 |
Q: thanx.... this macro works fine in MS access.... actuall what i want to do is that....to import data ...
A: there is no VB code. remember that if you are in access, it is VBA, visual Basic for Applications , ...
|
| macros | 7/13/2006 |
Q: i have created Macro in MS Office Access 2003... so from there i generated code of VB. Now i want to ...
A: vb has no docmd.object. you need to enter excel/access application and call for these objects. i ...
|
| data entry in visual basic. | 7/13/2006 |
Q: i have created a from and want to enter data in various text boxes. my backend is sql. so how to ...
A: you need to use DAO or ADO to connect to the database. better study both but since ADO is current, ...
|
| ADODB.Connection | 7/13/2006 |
Q: I made a log in form (now using Visual Basic 5.0) and MS Acces. But i get a error msg about ...
A: you need to use DAO or ADO to connect to the database. better study both but since ADO is current, ...
|
| B6 GetSaveDialog (simple example please?) | 7/12/2006 |
Q: I am a beginner and I am having problems with GetSaveDialog when I provide the FileName: VB6 crashes ...
A: which file are you trying to save? sometimes, if your source CD for visual basic is improper, or ...
|
| Visual Basic Macro to Copy from Excel to Power Point | 7/11/2006 |
Q: I'm generating reports (tables and charts) on excel in daily basis, with that reports I create a ...
A: do you have Visual basic installed? or are you referring to operations in Excel? that is VBA and NOT ...
|
| Access Report in VB | 7/11/2006 |
Q: I saw the qustian and answer related to the above subject (which ws posted on 4/28/2004 - The both ...
A: you cannot create a report from VB but can open and print the same. in access create a query and ...
|
| match login and Password | 7/11/2006 |
Q: I have a table and filelds are login and password. My form have two text box so I wants to go to ...
A: have two tables. first say LogPwd with fields Name and PWD. second table, fields Name,PWD ...
|
| Database connectivity | 7/11/2006 |
Q: hope doing fine.I just want to make a simple program,connectingVB 6.0 with MS-Access.I have done ...
A: private sub command1_click() if not rec.eof then rec.movenext if rec.eof then rec.movelast end sub ...
|
| Copying and pasting material from one sheet to another using macros | 7/10/2006 |
Q: My problem is copying and pasting specific material from a large report in excel from one sheet to ...
A: try this after making suitable changes: Sub Copy2NextSheet() ' '' now you are in the first sheet ...
|
| BASICS OF VB 6.0 DETAILS | 7/10/2006 |
Q: 0 and vb.net please suggest any book that u like to tell for the beginners. i mean to say send the ...
A: one of the finesh books is Programming Visual Basic ^ by Fransesco Balena.Microsoft Press. But to ...
|
| conneting MSaccess with VB | 7/10/2006 |
Q: i hav worte follwing code.. but getting error.. '''code''' Set con = New ADODB.Connection ...
A: if you don't use plain and clear english, i don't follow the question. what is the meaning of ...
|
| Excel and Access VBA | 7/10/2006 |
Q: Visual Basic seems KEY here.... From a GUI, do you know of commands to call macros and modules? Or ...
A: What do you mean by GUI? it can be in VB or in excel or access. anyway, guessing your question, in ...
|
| Excel and Access VBA | 7/10/2006 |
Q: I have many modules, queries, macros in BOTH Excel and Access. This 'app' is run monthly by ...
A: each has its own plus and minus. it depends on the use. excel is good if you want to look at the ...
|
| ActiveCell.Activate | 7/9/2006 |
Q: Let me try to explain alittle better.... I have copied a row of data and the first item is a date ...
A: try out this macro: Sub FindDate() ' Dim adu As String Range("A60").Select adu = Format(Cells(1, ...
|
| MS-Access 2000 MDB to VB6.0 | 7/9/2006 |
Q: I created a database in MS-Access 2000 mdb as 2000 file format. When I open it in VB 6.0 at Add-ins ...
A: visual data manager opens .mdb saved from access 97format. before you use any tool, you must do ...
|
| Where to find the | 7/9/2006 |
Q: I read one of your past answers; and i kinda have the same problem. I'm looking for the 'timer ...
A: you are not in visual basic but in VBA which are two completely different programming environments. ...
|
| ActiveCell.Activate | 7/8/2006 |
Q: I want to active the cell that is equal to A60 (which is date) I want it to find the same date in ...
A: your code makes my head reel. so much for just finding a value. don't know where you get these ...
|
| Data comparison | 7/8/2006 |
Q: I am new to VB 6 and learning the basics. I have created a form which uses a table from Ms Access ...
A: for a beginner i'm afraid there are too many things to learn. 1) first the access table design is ...
|
| Multiple IF conditions | 7/8/2006 |
Q: I am using Using MS Office (Excel) and when i do ALT+F11, it opens Microsoft Visual Basic 6.3 When i ...
A: you are in VBA and by no method you can call Visual Basic if you do not have it installed. if you ...
|
| Visual Basic Database Access | 7/8/2006 |
Q: I am facing a problem when connecting to my ms access database using visual basic 6 using DAO or ...
A: app.path is the better choice and make a habit of locating the mdb file in the same directory as the ...
|
| VB 6 MS-Access (inter). VB MS-Access | 7/7/2006 |
Q: how to add the datas in to the mdb file column?
A: you need to use DAO or ADO to connect to the database. better study both but since ADO is current, ...
|
| ADO and Tab delimited files | 7/7/2006 |
Q: i am using ado to open a tab-delimited text file and read it into a recordset. all that works fine, ...
A: this is quite a problem not only for " but for ` character in names and some databases get confused. ...
|
| refreshing data | 7/7/2006 |
Q: hallo i am using vb6 as my front end and ms access97 as my back end i am a beginner. the program ...
A: no need to create new access files every time. obviously the changes to data can be saved but why ...
|
| VB6 SQL Query | 7/7/2006 |
Q: I am a beginner with VB6 and this is the source code i have written. I am trying to open up a ...
A: there are many errors in your code but the major one is: newrec.Open "select * from Lienholdera ...
|
| How to count records in Access 2003 VBA | 7/6/2006 |
Q: Yes I'm a beginner with Access 2003 VBA, but enjoying learning something new. I'm trying to ...
A: i also enjoy learning something new, but ONLY if it has some purpose. no point in reinventing the ...
|
| Data report in VB | 7/6/2006 |
Q: the last record in an access table is not shown on the report in the vb project.
A: where is the report? it cant be in vb. it is still in access. i don't know how you have coded the ...
|
| VB6 Datagrid with combo box | 7/6/2006 |
Q: 1. How to use the combo box to set the value of one of the datagrid cell?. I can able to place it on ...
A: the datagrid does not take a combobox by itself. by placing a combobox just to coincide witht the ...
|
| retrieve data for search form use access ( VB6) | 7/6/2006 |
Q: im a beginner in use the vb 6. i have problem in retrive data from access. firstly i created search ...
A: you need to use DAO or ADO to connect to the database. under Menu Project_References, put a check ...
|
| VB5, Beginner, Custom Dialog. | 7/6/2006 |
Q: Can you tell me how to bring up a custom dialog box,(a form to get info from the user), without ...
A: in vb, the moment you ask for user input, the focus shifts to that control(input box, or msgbox or ...
|
| code for Calling access2000 report from VB6 program | 7/6/2006 |
Q: hv developed a prog. in vb6 using backend as ms access. I hv created reports in ms access. i want ...
A: 'put a check mark on Microsoft Access objects libray (under project_references option explicit Dim ...
|
| Opening different type files in visual basic | 7/6/2006 |
Q: I a developing a project.In my project i have to open some different data type files in vb window or ...
A: for each type of file you need to shell open the viewer programme and add the file.also watch out ...
|
| Excel if statement using VB | 7/5/2006 |
Q: Im using excel VB and trying to use an if statement to find a row in a column that is equal to zero. ...
A: for this you need create a loop which checks the value of row, if it is =0 action 1 else move to ...
|
| sql queries for adodb connection | 7/5/2006 |
Q: I am using VB6 and an inter my problem is that I cannot run sql queries,I wrot the following codes ...
A: even if there is a slight error in your string the connection fails. better use DSN and then you ...
|
| Update Excel Sheet | 7/5/2006 |
Q: I have a VB6 program and I want to update an Excel Sheet found on my Desktop (BUT it is closed). ...
A: 'check mark for project_references Microsoft Excel Objects Dim xl As Excel.Application Private ...
|
| How to create a user login and password function | 7/5/2006 |
Q: I hope that you can help me with the following; But first let me give you some background ...
A: add a logon form (available from form menu ) and add this code: have a table with 4 fields, ...
|
| Open MS Word with VB6, insert text and pictures | 7/5/2006 |
Q: Not sure why you would say this is not a VB question... the picture is inserted from VB6 ...
A: vb does not include formatting of office documents (which is VBA and different from VB). picture ...
|
| Open MS Word with VB6, insert text and pictures | 7/4/2006 |
Q: In this application we need to also put a picture into the document from VB. I see that it's also ...
A: though this is not a vb question i am giving the way. after inerting the picture run a macro ...
|
| Go to a particular field on a User Form | 7/4/2006 |
Q: I have a user form writting to a speadsheet, on clicking a command button, I am checking that ...
A: if you are not a programmer then what are doing with the code? only if you are a programmer (however ...
|
| VB6 with sqlserver | 7/4/2006 |
Q: how we connect the form fields with database(sql)? by suba
A: this is a guideline only. you need to make changes to suit your needs. Option Explicit Dim cn As ...
|
| Open MS Word with VB6, insert text and pictures | 7/3/2006 |
Q: VB 6 + MS Word Mitch Covington Intermediate VB6 programming. Application: for school teachers to ...
A: ------------------------------------------------------- ' Microsoft Word 97 document format. ' ...
|
| date convert | 7/3/2006 |
Q: i am using v.b to produce excel reports and sql server for data base my problem is the date keeps on ...
A: you mean the display in excel keeps changing? i do not know how you have used, vb,excel and sql ...
|
| List View columns value add | 7/3/2006 |
Q: Sir give me solution of listview control where i put the values in a column and need sum of these ...
A: it is not such a good idea to have the column values totalled from a listview. anyway the method ...
|
| Crystal Report not found in VB 6.0 | 7/2/2006 |
Q: my name is Muhammed Hareef and I am an intermediate programmer of VB 6.0 I have been programming VB ...
A: crystal reports is not a part of vb now. you need to get it from seagate software on payment. if you ...
|
| vb | 7/1/2006 |
Q: what is a runtime error
A: runtime is error is a flaw in the code and the programme is interrupted during compiling. First ...
|
| Multiple field filtering | 6/30/2006 |
Q: I am using VB6.0. I want to execute multiple field filtering at one go using adodc. Below is how I ...
A: the problem is with concatenation of different data types. no brackets needed. field name within ...
|
| EXCEL AND VB | 6/30/2006 |
Q: IN VB 6.0, I WANT TO KNOW HOW MAKE A CODE FOR NEXT: WITH A MENUFORM, CHOOSE A SUBCLASS THEN PUT THIS ...
A: when use keywords like MenuForm, Subclass it means something else. so, if you want answers, stick to ...
|
| Making Visual Basic 2005 output to a .txt file | 6/30/2006 |
Q: How do you do it in VB6?Im currently interning at a large company's IT department, and have decided ...
A: vb6 code: Dim arra(1 To 6, 1 To 6, 1 To 6) As Integer Private Sub Command1_Click() Open ...
|
| VB6 Accessing Access Database | 6/30/2006 |
Q: I've removed the error handling if that helps. As for the error handling (she blew it) was just ...
A: little better. sSQL = "SELECT * FROM tblVSep30 WHERE FldFName='" & sFileName & "'" change this to ...
|
| VB6 Accessing Access Database | 6/30/2006 |
Q: I'm Jonathon Baddock, a beginner using VB6. Trying to access an Access database and return results. ...
A: half knowledge is dangerous. your code does everything wrong. first you want the data in a text ...
|
| How to find out which textbox has focus to determine caret postion | 6/29/2006 |
Q: Instead of using the tab key, if the user uses the mouse click, how do I find out which text box the ...
A: once you click with the mouse, th focus moves there. there is nothing to find out. don't use the ...
|
| How to find out which textbox has focus to determine caret postion | 6/29/2006 |
Q: I have just started coding in vb6 so this question may seem very premature. I am currently working ...
A: the order in which the focus moves in controls is decided by the Tabindex property. in properties ...
|
| Database programming | 6/28/2006 |
Q: in computers. i have one .dbf file which is originalyy from Foxpro 2.x versions.i want to create a ...
A: it will be possible if your system has oledb driver for foxpro.check it out in control panel oledb. ...
|
| how to creat help file and attache to help menu | 6/28/2006 |
Q: how to creat help file in a vb 6and attache to help menu ? please send me a code thank you very ...
A: Tutorial: Creating a Windows Help file The objective of this tutorial is to learn how to ...
|
| excel n vb | 6/28/2006 |
Q: i need ur help........ i'm doin a project..... my project is almost like a reminder.. that one i ...
A: question unclear to me. we were doin service on a machine monthly.the date is fixed.only the ...
|
| Plotting in Excel With VBasic | 6/27/2006 |
Q: First time using this site. Im using VBA in Excel2000 for a simple macro to print, then close ...
A: if there was a number then a loop would work. here make it a function and call it 3 times eg: ...
|
| visual basic 6.0 editing in existing tabular data | 6/27/2006 |
Q: how to write commands to edit existing data in an existing table in dtabase programming? ex:items ...
A: put a control called Microsoft ADOData control on the form.(available from components.. (rt click ...
|
| date/time | 6/27/2006 |
Q: i am using VB 6 with MS access 2003 I want to retrieve the records from MS access based on the ...
A: dates are tricky in the sense that it has to match the format of the stored values. Concatenation ...
|
| can i have a code? thanks | 6/26/2006 |
Q: ------------------------- hi, im here again asking for your full support. i have a command button ...
A: suggest moving over to ado anyway here's the code: for edit and update recordset.edit ' .... ...
|
| Converting Microsoft Office VBA Macros to Visual Basic 6 | 6/26/2006 |
Q: Sir, I have made a macro for font change in MS word. I would like to distribute it as an exe file ...
A: under project _references check Microsoft Word Object Library dim strFileName as string, appWord as ...
|
| Returning an ADO recordset using the SQL 'Like' operator | 6/26/2006 |
Q: I am a software engineer working in the UK using VB6. I am trying to retrieve records from a Access ...
A: these are called concatenation errors. you need to use correct syntax.should not use select all * ...
|
| VB 6.0 report | 6/25/2006 |
Q: im a beginner- inter in VB i got some problem with vb report. how to generate report based on the ...
A: 1) i don't use datareports. 2)the date format must match the one that is stored in the table. the ...
|
| req coding for mi tool | 6/25/2006 |
Q: sir i wnt to develop a new tool containing these deatils(name,age, address,reprt date,royal ...
A: have a form with textboxes and a command button. then you need adodc or adodb to make the record ...
|
| visual basic 6,inter,abhishek jain | 6/24/2006 |
Q: i m unable to access run time controls with there name i added it as follows: Set a = ...
A: you cannot do what you want. you must follow the rules. set a= controls.add... does not make any ...
|
| VB 6 reading data from text file | 6/23/2006 |
Q: Ravindra, Here is the exact code:: Dim MailFileName As String MailFileName = App.Path & " ile1.txt" ...
A: corrected code: errors: mailfilenam and myfilenme should be same str, text are reserved words ...
|
| VB 6 reading data from text file | 6/23/2006 |
Q: I am a beginer in vb. I am trying to read data from a text file using Open MyFileName For Input As i ...
A: the file is open does not mean open to view, it means it is opened for data input. you need to code ...
|
| extract date details from access into vb | 6/23/2006 |
Q: 'date' is a field of my db.i want to access this field's details into vb's textboxes! how can access ...
A: the simplest method is to have an ADODC control on the form (choose from Components rt click on ...
|
| generate 10 random 6-digits numbers in the same time with one click | 6/22/2006 |
Q: can you tell me, please, what is the code to generate, at the same time with one click, 10 6-digits ...
A: have 5 textboxes on the form as control array. copy and paste the first text1 and paste 5 times so ...
|
| VBA | 6/22/2006 |
Q: basically for each software program there is a list of its license keys. these keys are displayed ...
A: if you want the license no for the software selected, you could use a recordset its field to be ...
|
| VB password | 6/22/2006 |
Q: Im sarah again, last week I did ask you about how to retrieve a username and password from ms ...
A: it s not data contrl but should be option Microsoft ActiveX Objects 2.8 Library. or 2.0 onwards. if ...
|
| VBA | 6/22/2006 |
Q: I am creating a software DB that keeps track of all software and the license #'s for each one. On ...
A: you want the informtion of the subform to be displayed in the main form? i don't know how you have ...
|
| can i have a code? thanks | 6/22/2006 |
Q: i am currently an IT student in our university! we have our project.our project has a command button ...
A: Option Explicit Dim db As Database, rec As Recordset, esql As String Private Sub Previous_Click() ...
|
| common dialog box | 6/22/2006 |
Q: Am using common dialog box. i have placed the control on my form. I want to get all powerpoint files ...
A: the commondialog does not automatically open all programmes. it is more for opening the file ...
|
| VB combo boxes to display in a text box | 6/21/2006 |
Q: I have a really stupid question but I can't find any answers. I all so have no idea on Visual Basic. ...
A: are you working from VIsual Basic6? or in access itself. since you are a beginner there is a ...
|
| Database VB 6 | 6/21/2006 |
Q: First of all I would like to thank you for your cooperation for my questions. I am a graduating ...
A: data from two databases cannot be obtained in one sql as there are no common fields. the tables ...
|
| VB - Acess form | 6/20/2006 |
Q: Yes i am relatively new to Visual Basic and am trying to further develop my skills in it. I probably ...
A: you are mixing up 2 things. VBA and VB. the code to use docmd etc is in VBA and meant to be used ...
|
| VB - Acess form | 6/20/2006 |
Q: I am currently using VB to create forms for an access database using the data control tool. My ...
A: first of all you must know that data control is old hat. move over to ADODC or ADODB. data control ...
|
| How to connecting vb with ms acess using recordset | 6/20/2006 |
Q: i'm using vb 6.0 i'm beginner@still new in vb database:ms access hi... My name is Aminah Huda,just ...
A: for a beginner, you are on the wrong track to learn the connection. the latest and proper method is ...
|
| Visual Basic Carpark system | 6/19/2006 |
Q: I'm creating a carpark system as shown in the image below.. ...
A: i do not know the logic of your gif image etc. here i have put 5 pictureboxes and assigned pictures. ...
|
| Password in VB | 6/18/2006 |
Q: my problem is that i dont know how to create a password form that connected to MS access. I need to ...
A: have two tables. first say LogPwd with fields Name and PWD. second table, fields Name,PWD ...
|
| Multifunctional Command Button | 6/16/2006 |
Q: I'm actually using this set up in excel but it does not recognize the "Form1" statement. For some ...
A: you asked me stating that it was visual basic. now you say it is excel. excel uses VBA which is ...
|
| Multifunctional Command Button | 6/15/2006 |
Q: Is there a way for a command button (after clicking and executing its sub) to change color/name so ...
A: Option Explicit Dim adu As Boolean Private Sub Command1_Click() If adu = False Then Call falser ...
|
| Access vba references | 6/15/2006 |
Q: Ravindra I have an Access application with lots of VBA. Developed in 2000 interfacing with Office ...
A: you cannot reference an office 2000 project in office 2003. if your client wants it in office 2003, ...
|
| VB in making setup of the project which uses Cystal Report, Database MS access | 6/15/2006 |
Q: I have developed project in VB6, MS Access and uses Crystal Report for developing Reports. I have ...
A: naturally. the crystal reports is not a standard component in vb. so the setup cannot load the path ...
|
| Application Development Problems | 6/14/2006 |
Q: ------------------------- Sir, Many thanks for your valued reply. Sir, I am a Low level developer. ...
A: okay one question at a time. 1) connecting to any database requires the ODBC driver to be ...
|
| auto scrolling... | 6/13/2006 |
Q: don't know if you can help me or not... THis is an Access 2000 question and I notice that there is ...
A: the access form opens at the previously saved place. before closing the form, drag it to the top of ...
|
| vb access(vb 6 & beginner) | 6/13/2006 |
Q: The code's fine but perhaps i did not express myself clearly enough. I'd like it to be in such a ...
A: your question was for delete, now you want accessing records, how can they be wrongly expressed? ...
|
| vb access(vb 6 & beginner) | 6/12/2006 |
Q: I've succeeded in linking my database and visual basic using the recordsource option. I've also ...
A: Option Explicit ' data control is out of date. switch over to ADODC or better ADODB. the code to ...
|
| Application Development Problems | 6/11/2006 |
Q: "Dear Sir/Madam,I beg to ask for a help for the problems listed below and also being sent as an MS ...
A: your code is unclear to me. you want a connection string to oracle database? ODBC Driver for ...
|
| Storing and retrieving image files | 6/9/2006 |
Q: Level of knowledge : Intermediate Subject : vb6.0+Informix Database Name : Anita Mallick Hi, I ...
A: the data types do not match. cannot store pictures in byte data type. i do not ue Informix, surely ...
|
| Excel 2000 Visual Basic Question | 6/9/2006 |
Q: I am somewhat troubled by your answer. You say "say you want the search to start after A10". That's ...
A: i don't see why you should be troubled by my statement. also you need to do some visual inspection ...
|
| Excel 2000 Visual Basic Question | 6/9/2006 |
Q: I have used VBA in Excel 2000 for 2-3 years and have written several macros, mostly complex ones. I ...
A: use this ploy. say you want the search to start after A10 Dim whats As String whats = ...
|
| Name/arguments of current procedure/function at runtime | 6/8/2006 |
Q: I need help regarding something similar to the "this" object in JavaScript. My VB code has n number ...
A: things happen so fast in the procedures, i wonder if it helps logging on step by step. anyway here ...
|
| ListBox MultSelect | 6/8/2006 |
Q: It works great. But then how do I do to delete the selecteditems from List1? Thx and regards; ...
A: for removing the items in multiselect: Private Declare Function SendMessage Lib "user32" Alias ...
|
| vb excel | 6/7/2006 |
Q: I copy your code into a word document but i am getting errors for names being undefined. Do i have ...
A: under Tools_references menu item, check mark on Microsoft OFfice 9 object library and microsoft ...
|
| Excel 2000 VB 6.3 - Very, Very Beginner | 6/7/2006 |
Q: I have perused almost every forum, Excel MVP, tutorials and other websites as well as John ...
A: if you want to insert special calculations, the simplest is to store these macros so that it is ...
|
| vb6 | 6/7/2006 |
Q: i am a begginer for vb6 i am using vb6. i have 7 command buttons and 1 label. i want to be able to ...
A: Option Explicit Private Sub Command1_Click() Label1 = Val(Label1) + 1 End Sub Private Sub ...
|
| vb6, access 2000, and sql | 6/6/2006 |
Q: I have an Access 2000 database with 8 tables and 2 stored queries (procedures?). In vb6, I have a ...
A: when you want data from 2 tables, you need to use SQL with inner or outer joins. to get the string:. ...
|
| vb excel | 6/6/2006 |
Q: how would you use a Word template with vba - if NECESSARY, calling an instance of Excel to get some ...
A: you have many options: you could use these as macros in word. create a blank macro and copy this ...
|
| vb 6.3 finding macro, export and import | 6/6/2006 |
Q: I created a macro for a word document that I use daily. I am giving this assignment to someone else ...
A: you mean you want to activate this word macro in another machine? the way is to copy the macro code ...
|
| VB6 | 6/6/2006 |
Q: Actualy what I want to do is search for a phone number (which will be in a text box)in a acceaa data ...
A: you keep changing the question and say follow up question. the way to check for phone no is same as ...
|
| Running a Crystal report from a VB5 application | 6/4/2006 |
Q: I am trying to run a report I've created using Crystal Reports 4.6.1 from my VB5 application via the ...
A: crystal reports is not a free report and it requires license. so i don't use it. but to use it open ...
|
| Code Cipher/Decipher | 6/3/2006 |
Q: I am trying to make a program using VB 6 that will convert a word into code using a simple ...
A: put a textbox,label and a commandbutton on form and code: Option Explicit Dim arra(25, 1) As ...
|
| vb program | 6/3/2006 |
Q: I am developing a program in VB and i have a problem searching to arrays. I have 2 list A and B. I ...
A: Option Explicit Dim a As Integer Private Sub Command1_Click() Call ListAddItem(List2, List1, 0) ...
|
| set focus problem in MS ACCESS | 6/3/2006 |
Q: Here is my code on save button cbopono.SetFocus strpono = cbopono.Value ...
A: i do not follow your code. you are not supposed to assign tabindex in this fashion. this has to be ...
|
| Forms and Comboboxes | 6/2/2006 |
Q: This might be a newbie question, but to give you a scenario, i want to create a form in vb. This ...
A: first, how have you linked the combo to the table? adodc,adodb or DAO. you cannot simply link ...
|
| ADO and access database | 6/2/2006 |
Q: I am a beginner to vb6. I am trying to set up a form with 5 textboxes. The user would enter ...
A: first you need to make a connection to the database say using ADO. under Menu ...
|
| Data manipulation from a subform in Access VB | 6/2/2006 |
Q: Ravindra, Thanks for your rapid response, but I'm still a little confused. I'm not that great with ...
A: it is better to approach the problem with the eyes of a beginner. that is why it pays to split the ...
|
| set focus problem in MS ACCESS | 6/2/2006 |
Q: I hv developed a module in Access. I hv prepared a form and after entering the data I am saving them ...
A: you need not go to the control to get its value. for say textbox1 variable1=textbox1.value will do. ...
|
| Data manipulation from a subform in Access VB | 6/2/2006 |
Q: I'm having trouble right now manipulating some data. I've pasted the sub routine below: what I want ...
A: the concatenation used in your sql is confusing to the computer(and me,too). first: split your sql ...
|
| Excel XP VBA | 6/2/2006 |
Q: I have managed to gather together some excel VBA coding which continously logs real time values from ...
A: excel is not the ideal programme to have the continuous updating of records. this would also require ...
|
| how to generate two lines from a block in Visual Basic 6.0 | 6/1/2006 |
Q: i would like to create two lines from a diamond shape... which can represent "Yes" and "No", just ...
A: there are many methods. simplest is to put 2 line controls on each side of your Diamond. and have 2 ...
|
| user forms | 5/31/2006 |
Q: sorry to bother you. regarding my previous qns:- 1. "when using the "cells.find" function, how do ...
A: put 2 labels on the userform and add this code: Private Sub CommandButton1_Click() Dim adu As ...
|
| Select query in VB | 5/31/2006 |
Q: I am working on a MS Access Database and want to run a select query (Select * from Table1....) by ...
A: you need to use DAO or ADO to connect to the database. better study both but since ADO is current, ...
|
| vb6 + mysql issue (my experience: advanced); Jose de Jesus Ramos Robles | 5/30/2006 |
Q: I've a mySQL server in my network (in 192.168.1.112), i'm trying to connect to it by using ADO ...
A: your connection string needs to be changed. To connect to a local database (using MyODBC Driver) ...
|
| I am having a problem getting a macro to work | 5/30/2006 |
Q: ------------------------- This is the line that is giving me the problem Selection.MoveLeft ...
A: because of extended followup and unclear proble statement, we have got into this confusion. sorry, ...
|
| I am having a problem getting a macro to work | 5/30/2006 |
Q: I had to Modify your answer to get it to work But I am still having a problem with the Selection ...
A: what are the changes you have made except msgbox, which is unnecessary. instead of activedocument ...
|
| clarification in Excel Macros VB+excel | 5/30/2006 |
Q: I am working in a stock broking company.. To follow day by day debits from branches for debit ...
A: question ambiguous. which rows should these comments be pasted? ie. clients name, or number etc. as ...
|
| Reports | 5/30/2006 |
Q: I am working on a project. I want to print out idcards for staff from my VB6 program. I want my ...
A: most of the reports like Crystal Reports which are good for printing reports with 4 or more photos ...
|
| I am having a problem getting a macro to work | 5/29/2006 |
Q: I put the clients last name in B2 of the spreedsheet in A1 there is a number 1400 (ever time i add ...
A: no need to count the characters. only make sure that the name is the last word. (word adds another ...
|
| I am having a problem getting a macro to work | 5/29/2006 |
Q: Set Wdoc = GetObject("D:Client Note Files todo list.doc") With Wdoc.Content ...
A: let me guess the process. *you add a client's name to a spreadsheet. * add this name to a word ...
|
| user forms | 5/29/2006 |
Q: i have tried your solution below. however i encountered some problems. when using the "cells.find" ...
A: the trouble here is for a beginner you are trying options about which you need to know the ...
|
| VB 6 and ACCESS | 5/26/2006 |
Q: I keep gettin error on these lines of your code: if username = rec.fields(0) then msgbox "user ...
A: i get irritated when you send half questions. i asked you to understand ADO. now you say you get ...
|
| VB6, .mdb file, beginner | 5/26/2006 |
Q: I would like to view, edit, save and print a few tables (from a Microsoft Access database file ...
A: that means you need to learn almost the major things in VB. you are advised to go thro' a book ...
|
| VB6, .mdb file, beginner | 5/26/2006 |
Q: I would like to view, edit, save and print a few tables (from a Microsoft Access database file ...
A: this is a duplicate question. the toolbar is available under forms components Windows common ...
|
| MS Word Macro | 5/23/2006 |
Q: I'm trying to create a MS Word document that has guidelines and instructions for how to complete it ...
A: i don't think what you are aiming could be done in a simple manner. first of all where are the extra ...
|
| Binding query(with agreegate function) data in a list box -VB6 | 5/23/2006 |
Q: I have read ur solution for above in following link ...
A: date field is a tricky one. use this method, alter the field names and range. instead of between ...
|
| ListBox | 5/23/2006 |
Q: How do I get only my selected items using a loop in a listbox. I tried but there is something wrong ...
A: since you are starting from 0 you need to reduce the selcount by 1. Private Sub Command1_Click() ...
|
| Programming | 5/22/2006 |
Q: How can I insert data into an access database using vb6 form? How can load a picture ...
A: you need to use DAO or ADO to connect to the database. better study both but since ADO is current, ...
|
| i want to use the datagrid only | 5/22/2006 |
Q: I want to take the Print out of the data in the datagrid in VB 6.0,Print Function Can u give any ...
A: private sub command1_Click() Dim RRow As Integer, CCol As Integer printer.print "" DataGrid1.Row ...
|
| I want to take the Print out... | 5/22/2006 |
Q: I want to take the Print out of the data in the datagrid in VB 6.0,Print Function Can u give any ...
A: you could use printer.prnt "" printer print Msflexgrid1.Textmatrix(rowval,colval) ' this line could ...
|
| How to get fieldnames + Access + Vb6 | 5/18/2006 |
Q: How do we write an slq statement to get the column names of a table in MSAccess using VB6 language? ...
A: you mean SQL statement? private command1_click() Dim i As Integer connect ' routune ...
|
| Excel macros | 5/15/2006 |
Q: I have an Excel spreadsheet which has one coloumn of expiry dates. I need to create a macro to ...
A: Sub monthBefore() Dim adu As Date, idu As Date, rowval As Integer, colval As Integer colval = 3 ' ...
|
| user forms | 5/15/2006 |
Q: . how do i write a form which has a search function? the form has 1 textbox & command button. ...
A: create these two macros and run. Sub UF4() UserForm4.Show ' End Sub Private Sub ...
|
| reports | 5/11/2006 |
Q: vb 6.0 access is my database file, am a begginer. vb+access. How doin i create a query report in a ...
A: you cannot create a report from VB but can open and print the same. in access create a query and ...
|
| passwords | 5/11/2006 |
Q: vb 6.0, database Access. Knowledge beginner: vb+access. David kuria gitau. Am developing a visual ...
A: passwords in access and vb are a bit complicated and likely to freeze the database. attempt this ...
|
| manipulation of textfiles... | 5/9/2006 |
Q: 1st of all im not good at english. LOL! ummm... i have a problem in opening some textfiles... the ...
A: Private Sub Command1_Click() 'writes to text file Open "C:\growth.txt" For Output As #1 Print #1, ...
|
| vb 6 question on datagrid (inter) | 5/9/2006 |
Q: in datagrid only by coding not by drag and drop also i wanted one of the column in datagrid to have ...
A: i suppose you have used ADODC for getting data into Datagrid. use this to filter data Option ...
|
| Client/Server Connection | 5/9/2006 |
Q: I am working on a VB 6.0 project with Ms Access-2003 as my back end I have worked on a couple of ...
A: it is not as simple as connecting to database on the same computer. first you have the internet ...
|
| Data Report for Master Detail Database | 5/8/2006 |
Q: In one of the appliation, I'm using MSAccess as a database, where Purchase Order (as a Master) PO ...
A: i believe that are still new tot VB. the string you have chosen is not correct. you need to make a ...
|
| Pictures in Datareport | 5/5/2006 |
Q: Please I have 2 problems. I am working on VB6 on Ms-Access as ny backend. 1. I have a report and I ...
A: there are many options of display of graphics. i choose the access table with a ole field to display ...
|
| vb 6 question on datagrid (inter) | 5/3/2006 |
Q: in datagrid only by coding not by drag and drop also i wanted one of the column in datagrid to have ...
A: make a query and include the count and use an sql like SELECT Wardrobe.Warno, Wardrobe.Warcatno, ...
|
| Access Database forms | 5/1/2006 |
Q: I am using Access 2003 - I have created a "Instructor" subform within a "Class Information" form. ...
A: select properties for the field showing error and manually select the record source drop down list. ...
|
| SQL | 4/29/2006 |
Q: meaning for: a)adOpenDynamic b)adOpenForwardOnly c)adOpenKeySet d)adOpenStatic
A: the differences arise if multiple nummber of people are accessing the database and how the changes ...
|
| sequential Write and read | 4/27/2006 |
Q: I've been having hard time with this problem: the instruction take three textboxes name ...
A: Option Explicit Private Sub Command1_Click() Open "C:\growth.txt" For Output As #1 Dim adu As ...
|
| ANimation in VB FORMS | 4/26/2006 |
Q: How to incorporate animation GIF or Flash files in a VB 6.0 Form..
A: put webbrowser control on vb form and add this code: Option Explicit Dim PicPath As String Private ...
|
| ByVals and ByRefs | 4/13/2006 |
Q: You're post at http://experts.about.com/q/Visual-Basic-1048/ByVals-ByRefs-1.htm is incorrect. I ...
A: i was right and you are wrong. the default in vb is byval. instead of taking up the issue with me ...
|
| Group BY Month/Year + VB6 | 4/13/2006 |
Q: I have a small problem regarding a query. PLease take a look at it below : SELECT ...
A: i've already told you that you need to store the values in the table first which matches the format ...
|
| Loop with incremental range change | 4/3/2006 |
Q: What command to use in order to repeat this series? The last range is ("A1546:A1553) ...
A: not necessary to keep coding a9:a16 etc have a variable 'call this macro from excel sheet ' you need ...
|
| 2 questions | 3/25/2006 |
Q: and how are you? I hope you are well. I'm pretty new to the VB world and have been experementing ...
A: code is ok but the hex editor adds characters to define byte, block size etc. making progress bar ...
|
| Access 2003 - Duplicate found message box | 3/21/2006 |
Q: I'm a beginner with VBA. Thanks for you patience and professionalism. My question is "How do I ...
A: your question is not fully clear to me. the Order no needs to be unique so there can be no ...
|
| Ms Access Security | 3/16/2006 |
Q: I have created an Access Database at work.Which is used by alot of staff and is in a shared network ...
A: once you create the security with one database, Access requires your logon for every database. to ...
|
| calendar | 3/13/2006 |
Q: Please how do i get a formula that gives the day any date falls on? Thanking you in advance.
A: Option Explicit Dim aam As Date Private Sub Command1_Click() aam = CDate(Text1) 'it will be in the ...
|
| Minimize app to tray | 1/23/2006 |
Q: In VB6, is there a way to minimize the app into tray instead of to the bottom bar? or alternatively ...
A: this is for advanced programmers only. do not attempt it if you are new. in a .bas module ...
|
| VB6.0+(MS-Access(Macro+parameterized query)) | 1/23/2006 |
Q: Please check the following table: employee fields: EmpName text Empno text Desig text DOJ ...
A: this code is executed from VB Dim xl As Excel.Application, yaavadu As String Private Sub ...
|
| VB6.0+(MS-Access(Macro+parameterized query)) | 1/23/2006 |
Q: I have seen your repsonses and I thought you are the person who can help me out. Iam developing as ...
A: give me the details of the table to be queried ( sample fields) date parameters .. are they ...
|
| VBA Help | 1/19/2006 |
Q: I have many MS Word templates that have the vb projects protected which I want to unprotect using ...
A: your question uses terms rather loosely. there are no vbprojects involved and the vb projects cannot ...
|
| Exporting formatted text | 1/19/2006 |
Q: I'm using EXCEL 2003. I want to create a text file in which text is formatted in exact spaces ...
A: Sub Export2Txt() Dim DestFile As String Dim FileNum As Integer Dim ColumnCount As Integer Dim ...
|
| MS Access VB | 1/18/2006 |
Q: I am developing a program in Visual Basic where i need to know the Field Names and there Datatypes ...
A: i have put 3 listboxes and used this code: in a bas mode Public conn As ADODB.Connection, rec As ...
|
| SQL not working | 1/16/2006 |
Q: This is the query that was giving me the error After the SQL below runs I get a run time error: ...
A: your esql is not clear to me. are you takingfields from 2 different tables/ ...
|
| VBA for Excel | 1/14/2006 |
Q: I know almost nothing about VBA, so please bear with me - I want to make a simple macro that will ...
A: you can call another macro from within a macro * to get only paper use ...
|
| API integration | 1/11/2006 |
Q: hey i would like to know what is API integration used for what i think of API is that if we have ...
A: API (Application Program(ming) Interface )code uses a given programme to react with Windows, the ...
|
| Mask Edit Control | 1/10/2006 |
Q: Am using a mask control to input time in the format hh:mm AM/PM. How to set the properties of the ...
A: put the mask edit on the form and in its mask property clipmode =1 enter ##:##?M the # allows ...
|
| Convert Date Format | 1/9/2006 |
Q: I'm using EXCEL 2003.Please assume you have a column with dates in format dd/mm/yy? How can you ...
A: attach this code to a macro button in the excel sheet after saving the macro: Sub Export2Txt() ...
|
| Comparing 2 files | 1/4/2006 |
Q: I'm using VB 6 and would like to compare 2 .csv files. If there are any differences I would like to ...
A: Option Explicit ' have two textboxes on the form with multiline=true.you can use this or load 'them ...
|
| vb+excel Custom functions | 1/3/2006 |
Q: I'm an advanced User of Excel VBA. Myin a worksheet, when using the wizard for inserting a ...
A: one of the methods is to have an userform with textboxes or labels. the userform's textboxes ...
|
| Mail Merge using ODBC | 12/28/2005 |
Q: I have an Access 2000 database which requires information froma query to be output to a Word ...
A: i use this method. i create a table based on the parameter and link the table to the word document. ...
|
| help | 12/26/2005 |
Q: I have written a simple software with vb6 enterprise, the software is an access database front end. ...
A: access does not allow an exe file as used in VB, which hides the access forms etc. what you can do ...
|
| Query Two Databases | 12/23/2005 |
Q: I am (still) developing with VB 6.0 and MS Access 2000 on Win98-R2. Is it possible to ...
A: you cannot open the two in the same recordset but can have two separate connections and recordset ...
|
| String Functions | 12/22/2005 |
Q: Please take a look at the following string. MW-10-TF 10 2.1 In fact it is divded into 3 sections ...
A: Option Explicit 'i have put the string in a text box. you could use a string variable Private Sub ...
|
| ADO auto update | 12/20/2005 |
Q: is it possible to disable the auto update function when working with Microsoft Access Datatbase ...
A: Option Explicit 'run a query to check if specific record exists: Private Sub form_load() Set conn ...
|
| How to print a BMP | 12/20/2005 |
Q: If you can please help me. I am trying to print out a bmp file straight to the printer. I am not ...
A: try using Printform you can hide other objects like text boxes, change background to white , hide ...
|
| Create ADO database in VB6 | 12/18/2005 |
Q: I use VB6.00 I would like to know how to create a ADO db in code using VB6 from scratch. My level ...
A: this is the correct method to get the records: you need to know a bit about ADO. here's a sample ...
|
| Replace item in ListBox | 12/16/2005 |
Q: How do I do to replace an Item in ListBox. Basically I select and item in the ListBox. When I click ...
A: Dim adu As Integer Private Sub Command1_Click() List1.AddItem Text1, adu End Sub Private Sub ...
|
| 2 columns in ListBox (Vb6) | 12/15/2005 |
Q: I have a database table (access) with two fields ("FName",Surname"). I want to display these in a ...
A: see the code below and alter it to suit your needs. Option Explicit Private Declare Function ...
|
| VBA - reading date format | 12/8/2005 |
Q: I'm a beginner in programming. I'm working on excel macro. How do I use the following function using ...
A: your declarations are wrong. use this basic code in the macro Sub MG() Dim adu As String, udda ...
|
| vb 6 beginner +sql Anju Choksi | 12/4/2005 |
Q: Vb 6 used to create add/update form Sql table created with members personal profile - memberid, ...
A: your code does not make sense to me. here's the way to fill up textboxes(better change them to ...
|
| ListBox (Change Position) - Vb6 | 12/3/2005 |
Q: Can you tell me how to change position of items in a list box. Thx
A: normally one cannot move the items except for sorting. but you can use:remove the selected item ...
|
| VB6 Loop | 11/30/2005 |
Q: Hy; Am having probs with my loop in the Change Event of DTPicker. I have a form with 8 DTPickers ...
A: you should not assign the value to dtpicker(vartime1). declare variables and assign these values to ...
|
| SQL Statement | 11/24/2005 |
Q: GOOD = Chr(35) date1 = Format(#11/08/2005#, "MM-DD-yy") SELECT tblMarket.Market_Name, tblATR.ATR, ...
A: as i have told you tblATR.ATR, tblATR.ATR does not make sense.it gets the same field. to get ...
|
| SQL Statement | 11/22/2005 |
Q: Please take a look at my SQL Statement. SELECT tblMarket.Market_Name, tblATR.ATR, tblATR.ATR FROM ...
A: i am surprised that your naming is still not OK. what do you mean by tblATR.ATR, tblATR.ATR your ...
|
| Question | 11/21/2005 |
Q: I have a table in MS access 2003 databse includes these fields: ID " Primary Key" , NAME, Telphone. ...
A: first have the combobox loaded with data from Name field. put in the rowsource SELECT ...
|
| Random Access File | 11/20/2005 |
Q: I'm Ali from Iran. I have a problem in my work for reading a txt file contains to variables each has ...
A: Private Sub Command2_Click() 'have the correct path to the textfile here Open "C:\growth.txt" For ...
|
| data report | 11/19/2005 |
Q: i am user msaccess as back end. my table name is student and it has following fields stno, stname, ...
A: have two dbcomboboxes which get the fields from ADODC1 say studentID ,marks,et have a textbox with ...
|
| VB6 & Ms-Excel | 11/18/2005 |
Q: i'm developing an application in which i need to transfer some data from database (ms-access). what ...
A: flexgrid is good enough. why shift to excel? you could also use Reports in access or Word. what is ...
|
| VB 6 sub procedure problem | 11/18/2005 |
Q: I am using VB6 one of my project I got the compile error: Procedure too large. Therefore I broken ...
A: normally procedures can call other procedures and if the lines of code are clear with no if and else ...
|
| Forms and lookups | 11/17/2005 |
Q: I am generating a form in excel whereby the results will need to be linked to each employee. If ...
A: you have said Topic Visual Basic. Are you using VB or in Excel only. i do not clearly understand ...
|
| Visual Basic 6 Listview Mouse scroll | 11/16/2005 |
Q: After creating a Listview, mouse scrolling only works after I have manually selected an item in the ...
A: try this code: Private Sub Form_load() On Error Resume Next Set ravi = ListView1.ListItems.Add(1, ...
|
| backup & Restore | 11/10/2005 |
Q: Please can u help me find a program written in Visual Basic that can make Backup of Data (Databases ...
A: 'check Microsoft access objects Private ...
|
| pass parameter to parameterized query | 11/8/2005 |
Q: How can i pass parameter to parmeterized query in run time? - I'm using Visual basic 6 and access ...
A: 'first under programmes,references, choose Microsoft ADO, check it. under general declaration dim ...
|
| vb6 Sijo Alex | 11/5/2005 |
Q: In my application there is one list box having 5 values and there is a text box also. My question is ...
A: when you press the letter in the list box, the selection goes to the letter, so it is unnecessary to ...
|
| How to make 30 days trial package s/w. | 11/2/2005 |
Q: I want to know how to make an installation which works for exactly 30 days and then ask to buy it or ...
A: there are several methods. one of this is to have the start time when installing recorded in a .dat ...
|
| Developer's Productivity | 10/25/2005 |
Q: I am a dotnet developer, I was working in a good company but the only problem there was the ...
A: at a start you need to back off and observe the type of work. you know that 80% of work relates to ...
|
| Find record In a database | 10/24/2005 |
Q: Please i need code on finding record in a database using either Name field, ID field and absolute ...
A: you need to know a bit about ADO. here's a sample code: Put a check mark on Microsoft ActiveX Data ...
|
| Dynamic Charts (VB6) | 10/20/2005 |
Q: I've been able to do the secondary axis issue. Now the prob is with making the chart dynamic. ...
A: have a timer that updates the values in the chart. if you use 2 secs then there will be flicker. ...
|
| VB.net | 10/19/2005 |
Q: I wrote an application for a game in Vb.net. I am getting a final score. I want to save that score ...
A: first add the line Imports System.IO at the top of the page and then add Dim adu As Int16, ...
|
| Chart (Vb 6.0) + Access | 10/19/2005 |
Q: Am having probs with MSChart. In fact I have my database with 4 columns (Date,Col1,Col2,Col3) I ...
A: in the mschart choose chart type =3 (or other if you like) border style 1 col count =1 data =41 and ...
|
| VB and excel | 10/12/2005 |
Q: How can a value in a cell in excel sheet passed to a text box on a form in vb?
A: Dim xl As Excel.Application, yaavadu As String Private Sub Command1_Click() Set xl = ...
|
| table in Visual basic (VB6.0) | 10/7/2005 |
Q: I would like to know if there is a way to display data from a database to a Visual Basic form as a ...
A: for display in the form, you have Labels, TextBoxes, RichtextBox, Grids, Treeview, Listview, ...
|
| vb6 data report from input | 10/3/2005 |
Q: My level of knowledge is intermediate. I'm working with VB 6.0 with an access 97 database. I have ...
A: the idea of using non relevant records to generate a report seems funny to me. but since you have ...
|
| sensor-thesis | 9/26/2005 |
Q: sorry sir.. i wana get some advice from experts on my final year thesis... i am familiar with ...
A: your idea is very good and for the sensor and operations better you seek advice from electronics ...
|
| Software Intallation | 9/26/2005 |
Q: I have a problem on software Installation. I have compiled my project and developed a setup disk ...
A: because of the version of files, this problem is likely to arise. the XP files do not match win98 ...
|
| Excel 2003/Visual Basic | 9/14/2005 |
Q: I was thinking I must have to do something along those lines. My programming knowledge is very ...
A: here is a sample of such a macro. selec the first cell and click the macro Sub checkChar() Dim ...
|
| MS access mining | 9/13/2005 |
Q: I am working on an access table I am trying to calculate the diference between one record date and ...
A: there is no simple procedure since you want filtering on dates for each identifier number. you need ...
|
| label control names | 9/12/2005 |
Q: I am a beginner using Visual Basic.Net and I find myself needing to populate a lot of label controls ...
A: if you are new to vb.net you need to learn quite a bit before you get to grips with all aspects of ...
|
| VB6 | 9/7/2005 |
Q: I want to make my month & day combo boxes fill in with today's date when a form loads. I.E. (month ...
A: the combo box is generally to be chosen by user. if you want an automatic choice, have a text box or ...
|
| Automation: Inserting a table in an MS-Word document | 8/31/2005 |
Q: I want to write a program that inserts a new table of n-rows and m-columns in an MS-Word2000 ...
A: you choose the Menu Item Table_Insert_Table and choose number of rows and columns. you navigate ...
|
| Using VBA to update a subform based on a change to the parent form using a combo box | 8/31/2005 |
Q: It is VBA 6.0, I mistyped originally. The names don't matter, the situation is as follows: I have a ...
A: you are still as unclear as before. Anyway here is the direction for you to move: the way to filter ...
|
| Using VBA to update a subform based on a change to the parent form using a combo box | 8/31/2005 |
Q: Sorry, I thought I had been clearer. I am using VBA 6.0, with MS Access 2000. I have a form for ...
A: i am afraid i cannot understand your question. you use terms casually, first you said VB6, now you ...
|
| Using VBA to update a subform based on a change to the parent form using a combo box | 8/30/2005 |
Q: I am using MS Access 2000 with VB 6.0. I have a form that links to a subform (for POCs) with an ID ...
A: your question is not clear in many ways. do you use VB or VBA? in VB, the child form means a MDI, do ...
|
| vb+ms access | 8/28/2005 |
Q: Hai Friend, How to Connect the access database in vb using ADODB connetion. thank you
A: this requires Microsoft Data access components 2.6. check under vb projects references. if you don't ...
|
| Octal calculator | 8/23/2005 |
Q: The DecimalToOctal function works well but there is one problem. When I click on Command 3 a second ...
A: it works ok here but may be some error in copying the code; add the new code line numb="" at the ...
|
| Saving MSHFelxgrid to Access | 8/23/2005 |
Q: Please help out thx
A: this is like the cart before the horse question. how did the MSHFlexgrid get the data in the first ...
|
| Business Scenario | 8/23/2005 |
Q: Plz. tell me a few business scenarios where the triggers can be used. what is the difference ...
A: 1) the triggers are used to Insert, Update, or delete records based on inputs. say the discount is ...
|
| VB6 + Writing info to text file | 8/22/2005 |
Q: I'm able to create a text file with the following code but none of my list items show up in the ...
A: have a listbox and a command button. you select an item from the list and click the command button ...
|
| Octal calculator | 8/22/2005 |
Q: Hey, thanks a lot. It works perfectly. But what about the other way out, converting DecimalToOctal ...
A: Private Function DecOctConverter(valli As String) Dim arraNum As Integer If valli = "" Then Exit ...
|
| Octal calculator | 8/21/2005 |
Q: I've just started working on VB 6.0 and been asked to create a function, called OctaltoDecimal, that ...
A: here's the function Option Explicit Dim langa As Byte, gudi As Long, n As Byte Dim arra(1 To 7) As ...
|
| VB 6 + Word (inter) | 8/20/2005 |
Q: Here are a couple for you. 1. If I am adding items to a listbox from a textbox, how do I check the ...
A: 1) checking for duplicates in list before adding item: have 2 listboxes or text and list box add ...
|
| vba with excel sheet as object to be linked | 8/19/2005 |
Q: this is the second time i m asking u for some help. thanx for the earlier quick response.today, i ...
A: your programming is a bit out of sync with my logic. either you use Excel and VBA or VB only. why ...
|
| Data Report | 8/18/2005 |
Q: I have a list with a long list of numbers. Actually am clicking on one number to display a data ...
A: when you want a filtered list, you need to select the item from a list. or you can have a flexgrid ...
|
| VBA+Access, Beginner. | 8/12/2005 |
Q: I want to know is there any way that I could control my Form objects in MS ACCESS Database' form. ...
A: first make a form with wizard depicting all fields that you want. put a commandbutton on form and ...
|
| Manipulating Files in VB | 8/9/2005 |
Q: VB 6.0 Microsoft Windows ME Well, I have a need to download Excel files from a weather website ...
A: Dim xl As Excel.Application Private Sub Command1_Click() Dim dimm As String Set xl = ...
|
| Excel Dynamic cell | 8/5/2005 |
Q: I have one Dynamic cell in Excel (Say "A1"). Its value is dynamically changing every 2/3 seconds. ...
A: put this code and assign this to a macro button. after entering the value in A1 you need to click ...
|
| treeview control issue... | 8/4/2005 |
Q: I am really new to the treeview control and I have been unable to find what I am looking for on the ...
A: this code would make it clear. copy and paste this code and later make your own code to suit the ...
|
| DateAdd problems | 8/4/2005 |
Q: I am trying to create this module in Access. The problem i am ahving is that in the current code it ...
A: the problem here is not the dateadd portion but your Call DoCmd.TransferText(acImportDelim, ...
|
| on error | 8/2/2005 |
Q: i have a visual basic 6.0 project.i need to use ,on error go to .... what i am asking that is there ...
A: there is a utlity available at MZtools.com. this can be downloaded free. With each procedure, you ...
|
| on error | 7/28/2005 |
Q: i have project written with visual basic 6.0 ,using sql data base. when there's an error ,the system ...
A: add this line at the beginning of the procedure which makes the system close. on error resume next ...
|
| Pic | 7/27/2005 |
Q: can u tell me how to display a picture on form using VB 6.0 while the picture's name (file) is ...
A: try this method: have a picture box and a command button (or use form click) Private Sub ...
|
| VB + internet explorer | 7/25/2005 |
Q: I am using Microsoft Visual Basic 6. I am still a beginner in VB. I just want to ask how can I fill ...
A: vb is not the ideal thing to use for filling in details. there is a sendkeys function which ...
|
| FLexGrid Problem | 7/22/2005 |
Q: Sorry but I don't understand what you mean?Hi Am actually facing probs with a flexgrid to display ...
A: for concatenation, i had asked you to use dim ravi as string ravi =chr(39) esql="select * from ...
|
| Find invalid date in Excel | 7/22/2005 |
Q: I have an Excel VB macro that reads a date from a cell and do some stuff. The dates are entered as ...
A: first you are converting the values from strings. you mean the values have been wrongly entered in ...
|
| VBA + Access (ie. knowledge = Inter) | 7/19/2005 |
Q: I want to ask a follow-up question. What is a DSN?
A: DSN: Data Service Name in control panel , choose odbc32. click Add. choose the driver based on ...
|
| VBA + Access (ie. knowledge = Inter) | 7/19/2005 |
Q: I am working on a project on access. Regarding to the security concern, I have to create a log-in ...
A: this is not simple. you can get over this if you are using vb, by creating a DSN and giving a ...
|
| How to use dos command thru VBA and resoultion problem | 7/15/2005 |
Q: 1st question How to use dos command(like type filename>prn) thru VBA .(as per my knowledge it can be ...
A: some dos commands are not available but filecopy, kill, etc are available and using MSDN help you ...
|
| Msflexgrid and access | 7/14/2005 |
Q: 1] how can i merge empty columns of 1 row with a mshfflexgrid. 2] how to design a vb dbms project ...
A: can merge col or rows with data. for links: http://www.codeguru.com/vb/ http://vbnet.mvps.org/ ...
|
| Scroll in FlexGrid (VB6.0) | 7/14/2005 |
Q: Ya i tried it but it is not working. I clicked on the scroll bar to getFocus but when I scroll with ...
A: checkout these links, they will give you the answer: ...
|
| Msflexgrid and access | 7/13/2005 |
Q: 1] how can i merge empty columns of 1 row with a mshfflexgrid. 2] how to design a vb dbms project ...
A: you could use MSFlexGrid1.MergeCol(1) = True or MSFlexGrid1.MergeRow(3) = True or you could choose ...
|
| Scroll in FlexGrid (VB6.0) | 7/13/2005 |
Q: How do i do to sroll down/up in a Hierarchical FlexGrid using the scroll button in the mouse. Thx ...
A: scrolling is the same, if the vertical scrollbar is visible, then just use the scroll button after ...
|
| Form Deformation | 7/10/2005 |
Q: I was wondering how you could make a form the shape of a circle instead of the normal rectangular ...
A: i wish you would stop wondering on such lines. Better to focus on internal programming than external ...
|
| graphical user interfaces | 7/4/2005 |
Q: I am programming in C#, but l have also used VB as well. All the windows applications I create ...
A: to create good and startling colours,gradients etc, you need to creat a class and use the code. the ...
|
| VB 6.0 Data Stores | 6/29/2005 |
Q: When I open my Visual Basic Editor, it is automatically linked to a bunch of tables. I want to link ...
A: i suppose you are using ADO. here's the method. 'conn here you use the connection string to ...
|
| VB | 6/28/2005 |
Q: I have a form in Microsoft Access that has a checkbox and a date field on it. If the checkbox is not ...
A: it does not seem to be a good idea to use a check box and a datefield for entering date. also is it ...
|
| Database timeout | 6/28/2005 |
Q: I am inserting a flat file to table in my database. After a while, d application flag an error. ...
A: if you are using sql server increase the timeout property which you can set. normally, there must ...
|
| Visual Basic | 6/27/2005 |
Q: When someone runs my program, they can add stuff into textboxes and stuff. Like notepad or microsoft ...
A: please be clear when asking questions. what do you mean by they can add stuff into textboxes and ...
|
| Question | 6/23/2005 |
Q: How, are you. I hope that you are fine and working hard. Dear, I am doing Bechular in Computer ...
A: try these links: www.chuckeasttom.com (for a good tutorial) tanner'sVb garybeene.com vb-helper.com ...
|
| vb programming | 6/22/2005 |
Q: 1- hi 2- i have a project with one MDIForm and 5 Forms , the MDIForm has a menu , by clicking on the ...
A: try this one out ' here f1,f2,f3 are menu items in MDI page Option Explicit Dim fv1 As Boolean, ...
|
| Run-time error 545 | 6/22/2005 |
Q: I am new to VB programming. I created a simple program which connects to mssql database. I used the ...
A: it depends on the controls you have used in your project. have you used a datacontrol or adodc? then ...
|
| Split cells | 6/22/2005 |
Q: Iam working on a project in word VBA which requires me to select a table's first row and apply ...
A: create a macro or run code in word as below: Sub MChangeTableRowStyle() ' Selection.GoTo ...
|
| Create a form in word 2003 with visual basic | 6/22/2005 |
Q: i would like create a document with a text field for to introduce the user , correct information. ...
A: in word create a macro called CreateTextBox with this code. save it in say c:\my ...
|
| using an Excel like grid... | 6/21/2005 |
Q: Ravindra, I don't want to simply import the file. I am building a new app with tons more ...
A: if your needs are special you could construct an ActiveX control and assign all the properties that ...
|
| Access-VBA | 6/19/2005 |
Q: I am an intermediate level programmer at best. I am currently running Windows XP with ACCESS and ...
A: in access, open a module and enter this code: 'under references, check Microsoft Excel Objects. ...
|
| How to connect multiple "mdb" files | 6/18/2005 |
Q: , I have many access database files, that the appropriate file only be connected with program that ...
A: Option Explicit Dim conn As ADODB.Connection, rec As ADODB.Recordset Private Sub Command1_Click() ...
|
| .recordset.recordcount | 6/17/2005 |
Q: I am working with VB 6.0 with Service Pack 6. The fact that I am working with VB 6.0 and Microsoft ...
A: your line strSearchString = "SELECT " & _ "shippingLineItems.* " & _ is wrong. what is ...
|
| rtf to hlp | 6/17/2005 |
Q: Please how can access a help file. I have a file with extension hlp. Can u help me know how can ...
A: first you need to download Helpwriter32.exe for windows from the web(available free). using this ...
|
| vb for external application | 6/17/2005 |
Q: intermediat user i use vb6. i would like to know whether it is possible to fill text boxes/dropdown ...
A: can pick data from excel sheet. to find cell which stores "Ravindra" .. first create the macro ...
|
| "Find" cell values in excel sheet | 6/14/2005 |
Q: but that is not what I'm looking for. The code you provided is only making the Excel application ...
A: if you don't want to view the sheet set visible=true. if you had studied my code, i have written you ...
|
| VB 6 w/ access, Date Function | 6/13/2005 |
Q: I have a application where the user can input a date and select the number of days before they must ...
A: you cannot get the programme to work that way. an access table value cannot remind any programme to ...
|
| Using the Shell function | 6/12/2005 |
Q: I am creating an application using VB6. I know how to use the Shell function to open an application ...
A: this needs the use of windows API , which i do not prefer. anyway here is the code which will do ...
|
| Problem Visual Basic 6 register DBGrid32.ocx | 6/12/2005 |
Q: I have Visual Basic 6 Prof.Ed., Windows XP with SP2. Intermediate. I have a program developed in VB ...
A: the DBgrid was not a loaded control. when you change the programme remove the old dbgrid and install ...
|
| RE crystal reports | 6/12/2005 |
Q: Please help me in crystal reports 4.6 and vb6 ado how to source a report from sql query with ...
A: first, you need to create the query in access, join the tables based on common field and filter on ...
|
| "Find" cell values in excel sheet | 6/11/2005 |
Q: I'm using VB6.0 to open an excel file and need to find cell values in the activeworksheet from VB ...
A: Dim xl As Excel.Application Private Sub Command1_Click() Set xl = ...
|
| VB code to open a html page | 6/9/2005 |
Q: How do i proceed about it? Thx
A: to open a html file from the hard disc you can use this method put a textbox +commandbutton and ...
|
| Migration from Access to SQL Server | 6/9/2005 |
Q: and thus am having much probs with my SQL Statements in my vb program. Pleasel let me know how to ...
A: for dates use this concatenation method. modify the paths as needed. Dim GOOD As String, date1 ...
|
| store image in database | 6/7/2005 |
Q: i am a programmer in VB 6.0. I am trying to write a code dat will insert pictures in SQL Server 7.0 ...
A: have the datatype as string. and when opening it in vb in a picture box use picture1.picture= ...
|
| Visual Basic Errors | 5/26/2005 |
Q: How do I find Errors in Visual Basic and how do I handle the Errors. Thank you in advance Siv
A: if you are referring to the error numbers etc, try downloading from one of the vb sites. ...
|
| Checking for Duplicate records | 5/26/2005 |
Q: I can't figure out whats going on? Am I missing something? ...
A: code works here alright. try these: for concatenation use dim ravi as string ,esql as string ravi ...
|
| Checking for Duplicate records | 5/25/2005 |
Q: I modified the code by inserting the piece of code u gave me..but i find it still duplicatiing all ...
A: this code wiorks fine:. no duplication at all. keep the rec and rec1 = new adodb.recordset in the ...
|
| vb | 5/16/2005 |
Q: I've built a simple programme in vb that saves a list of X numbers to file1 and a list of Y numbers ...
A: by file i suppose you mean text file or is ita .dat file? the better option is to use an access ...
|
| Prob in VB 6.0/Access | 5/16/2005 |
Q: Please help me with an idea how to do the following. My Access table is as follows: ID Broker ...
A: can have a simpler procedure. first create a query in access called qAshwin2 with sql SELECT ...
|
| vb | 5/14/2005 |
Q: How can I make a text box or a label that only accepts specific letters e.g. A and B only So If I ...
A: Private Sub Text1_KeyPress(KeyAscii As Integer) If KeyAscii <> 65 And KeyAscii <> 97 Then KeyAscii = ...
|
| VB6 Saving Data | 5/13/2005 |
Q: Followup To Question - I am making a progam which has lots of text boxes for the user of the ...
A: also you need to see things from a programmers point of view, what works for one text box should ...
|
| VB6 Saving Data | 5/12/2005 |
Q: I am making a progam which has lots of text boxes for the user of the program to put words in, like ...
A: when you are a complete beginner do not ask questions that solve problems in a specific way like ...
|
| VB6 Saving Data | 5/11/2005 |
Q: I am making a progam which has lots of text boxes for the user of the program to put words in, like ...
A: Private Type ravi name As String * 20 age As Integer End Type Dim ravi1 As ravi, counter As Integer ...
|
| excel face sheet for data entry advance cells without enter key | 5/11/2005 |
Q: Excel 2000 (Beginner) I would like to allow the user to advance to the next cell( vertically) simply ...
A: yes, you can manipulate excel from vb, run any macro, go thro' any procedures, without any ...
|
| Crystal Reports | 5/11/2005 |
Q: Visual Basic 6.0 Ms Access 2000 crystal reports 8.5 Level of Knowledge-Intermediate 1. we are using ...
A: 1) make the query as below to get records between 2 dates. Dim GOOD As String GOOD = Chr(35) date1 ...
|
| Excel by BV | 5/10/2005 |
Q: I'm having a big excel file with formulas and etc...But what I wanted to do is to copy all the ...
A: there is a problem with this: when you copy and paste an excel sheet, all the contents of a cell ...
|
| VB 6 | 5/10/2005 |
Q: i am using VB 6 and my level of knowledge is inter. Aljay Millares i would like to ask on what ...
A: you could use code like this: Private Sub Command1_Click() If Check1.Value = 1 Then accFact = 1 ' ...
|
| display hyperlink column in Vb datagrid | 5/9/2005 |
Q: , Thanx a lot for ur assistance,! well, im using VB 6.0 and access. I have a access table with a ...
A: the hyperlinks come out in the datagrid but separated by the # sign. and the links are not ...
|
| open a result with hyperlink | 5/8/2005 |
Q: , Im using VB and access, I have a access table with a field with Hyperlink, from Vb programming, i ...
A: use this strategy to make a new table and later delete the same: Private Sub accessFam(buda As ...
|
| vb | 5/8/2005 |
Q: How can I calculate the total of numbers that are stored in a text file using a command button and a ...
A: Private Sub Command1_Click() Open "C:\my documents\growth2.txt" For Input As #1 Dim tempo As ...
|
| vb | 5/7/2005 |
Q: How can I display numbers that stored in a text file on a text box or label using vb 6 or vb.net ...
A: Private Sub Command1_Click() Open "C:\my documents\growth2.txt" For Input As #1 Dim tempo As ...
|
| Writing & Launching Help Files | 5/7/2005 |
Q: Ravindra, a lot. Could you please guide me on the remaining questions I had listed? BilalI am a ...
A: 3) to open a access report from VB: to a click event add this code: dim ravi as string ...
|
| Writing & Launching Help Files | 5/5/2005 |
Q: I am a small time developeer in VB6. I need to know: 1. Which Help authoring tool is the most user ...
A: first you need to download Helpwriter32.exe for windows from the web(available free). using this ...
|
| SQL Statement (VB6.0,Access) | 5/5/2005 |
Q: Take a look at my table structure in my DB (Access) ID Broker Currency Fees PL 1 JPM ...
A: your sql would be like this: ' ashvin is the name of table, Broker,currency,fees, Pl are fields dim ...
|
| datetime | 4/29/2005 |
Q: I am facing a problem. I am developing a database system using microsoft SQL Server 2000 and using ...
A: no this is not the way to display dates. use like this: dim date1 as date ...
|
| vb6 level(inter),sub vb+excel | 4/27/2005 |
Q: sir follow up i am storing(Ms Acess) a text thru a vb form and printing it on a excel file ...
A: how do you get the data into excel.there is no report in excel, so your words confuse me. unless you ...
|
| Timer Countdown | 4/26/2005 |
Q: I have made a program that counts down from 2 hours in visual basic 6. I was wondering how you ...
A: put a command button, timer(1000 as interval and enabled as false), 3 labels on the form Dim ...
|
| Runtime Error 13 in Windows Xp Service Pack 2 | 4/25/2005 |
Q: I use Visual Basic 6.0 Enterprise Edition. my projects don't have any problem in Windows NT, 9x , Me ...
A: does the m/c with XP have VB 6? and are you using any MSoffice components which are of different ...
|
| vb6 level(inter),sub vb+excel | 4/24/2005 |
Q: sir I am using excel (office 2000) with VB6,for reports.My problem is when i am storing a text ...
A: you say that you are inter in vb. then you must know for reports, excel is not the ideal, you need ...
|
| Save Colour in FlexGrid | 4/20/2005 |
Q: I am changing the colour of cells of flexgrid at run-time. Is there another way so that I can save ...
A: create the grid with more than 8000 rows,colour it and open it in form load event. naturally this ...
|
| Error VB 6 Developed Program in Windows XP SP2 | 4/19/2005 |
Q: I used VB 6 Prof. Ed. in Windows XP Professional Edition (SP2 not installed) to develop a program. ...
A: without knowing the programme, components used, cannot comment with authority. looks like version ...
|
| Error VB 6 Developed Program in Windows XP SP2 | 4/18/2005 |
Q: I used VB 6 Prof. Ed. in Windows XP Professional Edition (SP2 not installed) to develop a program. ...
A: this appears to be a version conflict between the objects in the computer where you developed the ...
|
| APPLICATION OF VISUAL BASIC | 4/16/2005 |
Q: WHAT ARE THE APPLICATION OF VISUAL BASIC?
A: mostly data management, computer file management, automating letter writing with specific details, ...
|
| TextBox event | 4/12/2005 |
Q: I have around 35 textboxes (not in array), on a form. All textboxes have a default value of "0". I ...
A: yes you need to enter Private Sub Text1_GotFocus() Text1.SelLength = 1 End Sub Private Sub ...
|
| How to concatenate picture files into a single picture file? | 4/10/2005 |
Q: I have 2000 picture files (*.jpg) and i want to concatenate all of them in a single picture file and ...
A: there is no such method. but you can have the paths loaded into a textfile and open one picture at a ...
|
| Flexgrid | 4/5/2005 |
Q: I have a flexgrid displaying data from a table in my db. One of the columns displays time. I ...
A: first of all, are you sure that you have mastered the grid? anyway here is the code. modify to suit ...
|
| Flexgrid | 4/5/2005 |
Q: Hy Yes But how do i do to identify the second column of the FleXGrid and then put all the rows of ...
A: when you use a control, at least you must learn the basics. how did you get the data into the grid ...
|
| Generating Dynamic Report using difference between two dates | 4/1/2005 |
Q: I want to generate a report on the basis of date difference in VB 6.0. I am using DTPicker for date. ...
A: c1 and c2 are 2 calendar controls dim date1 as date,date2 as date Private Sub C1_Click() date1= ...
|
| autofill textbox from database | 3/31/2005 |
Q: I am learning Visual Basic and am writing a small database program in VB6. I have an Access ...
A: you cannot have autofill the numbers in the textbox. you can find out if the particular item is in ...
|
| sql statement | 3/30/2005 |
Q: PLease see the sql statement below.Am using it to display data from a database to a MSChart. str = ...
A: in this there is a likelihood of a concatenation error. use this method: Dim GOOD As String GOOD = ...
|
| Hierarchical FlexGrid (VB6.0) | 3/30/2005 |
Q: Sorry perhaps I have not been clear enough in the explanation. In fact I want to completly delete ...
A: you must know that the grid is a tool for display and not the holder of data. hence there is no ...
|
| Entering a formula into Excel from VB6 | 3/29/2005 |
Q: How do you enter a formula from inside VB6 into Excel. I'm using Office XP pro if it makes a ...
A: use this code: 'check the excel library under project_references Dim xl As Excel.Application ...
|
| vb+sql server | 3/28/2005 |
Q: Working with VB6 and Sql Server 2000. I want to develop a multi-user application of Library ...
A: you need to create the multiuser permissions and the scope in sql server for each database and table ...
|
| Creating and editing Excel Worksheets in VB6 | 3/26/2005 |
Q: I would classify myself as an Intermediate programer in vb 6 I'm writing a program in VB6 were I ...
A: better to declare the variables rowval, and colval as integers and the code. Otherwise it assumes ...
|
| Package Deployment | 3/21/2005 |
Q: Re: VB6, Package Deployment, I am a beginner. Windows 98, second edition I have created an ...
A: 1) you can install in any folder, once you make the package. you can go to the folder where you want ...
|
| Set margins in Access | 3/21/2005 |
Q: I have created an report in access that show me the total sales per month per customer. The report ...
A: first make the query and then base the report on this or a special table which is created with the ...
|
| sql | 3/21/2005 |
Q: sir pls tell the query in mssql database structure: tablename= record id name 1a ankit 1b ...
A: 'do not use tablename as record, may be Recorder or such esql="select * from tablename" do while ...
|
| to open word in vb | 3/20/2005 |
Q: VB 6 INTER VB+WORD HOW TO MERGE THE CONTENT OF MORE THAN ONE WORD DOCUMENT INTO A SINGLE RICHTEXT ...
A: i am puzzled by your question. the procedure is to have to mail merged letters, insert one into ...
|
| Security and Access | 3/17/2005 |
Q: I have a huge problem. I have an application that reads and writes data to an Access database. Each ...
A: this requires the setting up of permissions etc, and this creates a file showing details. only then ...
|
| no records form | 3/17/2005 |
Q: access 97 Hello, I am creating a user interface that searches through a set of records and produces ...
A: create a form and add code: Private Sub Command13_Click() DoCmd.OpenForm "recipe_entree", ...
|
| Checkn whether table exist in db | 3/16/2005 |
Q: Am using VB6 and Access as db Hi I want to check whether a table exists in the database. How to do ...
A: 'under project_References, check Microsoft ADOX ext Dim conn As ADODB.Connection, cmd As ...
|
| LIstbox | 3/16/2005 |
Q: Intemediate vb 6.0 programmer Stash Wong Hello, I am stuck on a simple problem of saving the ...
A: Private Sub Command1_Click() Dim i As Integer, adu As String, linecount As Integer Open ...
|
| set datagrid value as database | 3/16/2005 |
Q: I have a filtered data in my datagrid, so, how can i set that filtered data(may be 10or100,1000 ...
A: for this the datagrid must be fully visible on the form else you need to alter the code. put ...
|
| select statement | 3/15/2005 |
Q: i hv a table with 2 columns (country,zone),then i need get the zone for that input country(through ...
A: it is not clear which method you are using, dao, ado, adodb,adodc etc. here it is for ADODB. ' you ...
|
| vb6 comboboxes | 3/15/2005 |
Q: i'm a vb6 beginner, im trying to work on an aplication that will ask input from the user, Im triyng ...
A: you can preload the comboboxes ( one for make,one for the year etc) this can be using the list ...
|
| Selecting Records from a Record set based on a range of given variable dates. | 3/14/2005 |
Q: I am a tyro VB6 programmer I am experiencing difficulties selecting records from a record set based ...
A: for a daterange between two dates for dates: Dim GOOD As String GOOD = Chr(35) date1 = ...
|
| Listbox individual item | 3/14/2005 |
Q: I'm using VB6 with an Access 2002 database. I am about intermediate (new to VB and Computer Science ...
A: use this sort of a loop which check the previous click.. Dim arra(4) As String, adu As Integer ' ...
|
| convert type | 3/13/2005 |
Q: , im using VB6 and access 2002. i have a autonumber field in access. In the front end i want to ...
A: this is the type of esql you need to use: put an adodc on form and connect to table. for ...
|
| find and replace text in MS Word | 3/12/2005 |
Q: Ravindra, I am working on a piece of VBA code in a MS Word document and need to find all instances ...
A: question unclear. what do you mean 2005@#### and 2005@xxxx ? also your code :="2005^064????", _ ...
|
| ms chart | 3/11/2005 |
Q: Ravinder! i wud like to show my result in as Graph. but, how can i apply my output record as my ...
A: for this the datagrid must be fully visible on the form else you need to alter the code. put ...
|
| SQL optimization | 3/11/2005 |
Q: The query must only select the fields if each of the fields exist in another select statement and ...
A: as i have told before, you need to split the query. in the above case, the query will not run even ...
|
| VB and flash, Tree view | 3/10/2005 |
Q: iam doing project in VB and flash iam unable to communicate from VB and flash. and iam using tree ...
A: try this out: Private Sub Form_click() Dim nodX As Node Dim nodY As Node Dim adu As String adu = ...
|
| SQL optimization | 3/10/2005 |
Q: Is there any way to optimize this query so that performance will be better? (ie. rewrite better?) ...
A: without knowing the details of your table, field names, datatypes and the need for the filter, i ...
|
| Text Box contents | 3/10/2005 |
Q: I am using VB6 to write a small programme that allows the user to input numerical data to determine ...
A: try this out: Private Sub Command1_Click() Dim adu As Single adu = (Val(Text2) - Val(Text1)) / ...
|
| VB6 Scroll bars | 3/9/2005 |
Q: I have a text box with an ability score inside. I have placed a tiny scroll bar to its immediate ...
A: next to your textbox insert the updown control using the windows common controls 2 6.0 under ...
|
| ms chart | 3/9/2005 |
Q: Ravinder! i wud like to show my result in as Graph. but, how can i apply my output record as my ...
A: try this out on the mschart control: have 9 rows and 3 columns the fixedcolumn to 0. Private Sub ...
|
| Combo Box | 3/9/2005 |
Q: Please guid me about easy combobox filling : A combobox that have Client Name. When user press any ...
A: put an adodc on the form, point it to the database and for the recordsource, choose commandtype as ...
|
| vb | 3/9/2005 |
Q: Private Function filterfunc(adofilterRS As Recordset) As Recordset Dim andstring As String ...
A: i do not follow the logic of your function. also how can i guess the datatype of state_code? what ...
|
| VB 6.0 : AVG Function in SQL Statement | 2/28/2005 |
Q: I am using the AVG function in an SQL Statement so as it displays the results in a Data Report. But ...
A: for getting the avg function you need to restrict the fields first and then join with another query ...
|
| VB6.0 Flexgrid Inter | 2/26/2005 |
Q: I want to solve two queris: a)If say I want to put a condition that say if flex1.textmatrix(i,5)=0 ...
A: a) i have here a code for colouring the rows alternatively and with a little testing and feedback ...
|
| Problem with VB in Excel | 2/25/2005 |
Q: Revindra I am using Excell 2000 and I am having a problem with VB behind a Combobox on a ...
A: your macro runs with If fltid = "" Then GoTo sect1out Else ...
|
| Command Functions | 2/25/2005 |
Q: I am working with vb+excel and would like to have fillable fields and then a command button that ...
A: though it is not completely clear to me why you should feed the data from vb.. why not from a form ...
|
| getting data between two dates | 2/25/2005 |
Q: i HAVE A set of data in Ms access 2002, have a field called "Date" I must getting the data between ...
A: Dim GOOD As String, date1 as string GOOD = Chr(35) date1 = Format(#10/3/2000#, "MM-DD-yy") 'change ...
|
| searching database | 2/25/2005 |
Q: im using vb6.0 and access 2002. plz provide some querry string example that gettig datas(multiple ...
A: obviously you do not believe in fullying reading my reply.are you familiar with ADO? if not you ...
|
| searching database | 2/24/2005 |
Q: Im from malaysia, my question is, i want to develop a UI, that is mainly retrieve the data from the ...
A: i do not know the versions of VB,access you are using. you could use ADODC or ADODB along with a ...
|
| Populate an Excel Spreadsheet with VB | 2/24/2005 |
Q: I am using whatever VB comes with Excel 2002. I am trying to populate a report formatted spread ...
A: first, vb does not come with excel, it is vba, a different cup of tea. also what is SAS v8? where ...
|
| Flex Grid problem | 2/24/2005 |
Q: I'm required to allow user to enter value to the form 2.0 combo box instead of user select.As i'm ...
A: one uses a textbox and not a combo box for user entry. but if you are filtering the records based on ...
|
| visual basic form designing? | 2/24/2005 |
Q: i'm using VB6.0 and a beginner in it.its about visual basic.my full name is pankaj chaswal.well i ...
A: it is not such a hot idea to beautify the form. by using special API codes, it is possible to open ...
|
| Cummulative | 2/24/2005 |
Q: Am using MSAccess and VB6. I actually have a table with structure show below: Trading_Date ...
A: make a query on the table using this sql: 'testable is the name of the table with trading date and ...
|
| programing | 2/23/2005 |
Q: i have textbox1, textbox2, textbox3, textbox4. the user will input numbers into the 4 textboxes. and ...
A: this cannot be called for a simple random function. use the code below: Dim adu As Integer ...
|
| VB 6.0 Listbox | 2/23/2005 |
Q: Hey Ravindra, Regarding VB 6.0 Listbox, how can I update the data in my listbox. (I have a list ...
A: it appears funny to have textfile, listbox, new table etc. it is a good procedure to have all in ...
|
| Calling MSSQL Stored Procedure from VB | 2/22/2005 |
Q: How do I call a SQL stored procedure from VB6 and store the return value in a variable? This stored ...
A: The following Visual Basic code connects to a SQL Server, creates a stored procedure that has a ...
|
| Generate runtime report using DataEnviroment | 2/22/2005 |
Q: How Do I generate a run time report . for eg i have to generate a report based on SQL query ...
A: The following Visual Basic code connects to a SQL Server, creates a stored procedure that has a ...
|
| Where can a beginner get vb dotNet help? | 2/22/2005 |
Q: I see it's your ambition to learn VB dotNet. Are you already able to help on questions about dotNet ...
A: for a beginner, vb.net is not the right thing to take up. it is a bit slow to follow and by the time ...
|
| How To | 2/22/2005 |
Q: I'm using VB6 and i'm trying to create using a command button to export a Recordset from SQL ...
A: for pushing values into a textbox from your database use this after modifying the connection ...
|
| programming | 2/22/2005 |
Q: i have textbox1, textbox2, textbox3, textbox4. the user will input numbers into the 4 textboxes. and ...
A: this cannot be called for a simple random function. use the code below: Dim adu As Integer ...
|
| Print Form | 2/22/2005 |
Q: I am setting focus on the other two forms to print them as well. It is printing but on separate ...
A: printer.print "abcde" or printer.print form2.text3.text or printer.print recordset.fields(2) etc ...
|
| Vb6 | 2/22/2005 |
Q: I developed a billing software in VB6 with Access2000 as backend. My Question is whether it will run ...
A: if you make an exe file or a package using package and deployment wizard and have the database in ...
|
| multiple keyword search | 2/21/2005 |
Q: Access 97 Multiple Keyword Search I would like to create a search engine that will search for more ...
A: are you searching for consecutive words? to search the words must be single not one here and the ...
|
| Complicated (VB6.0) | 2/21/2005 |
Q: Please help me ! I have a table in Access which goes as follows: ID Market Amount ...
A: the problem has arisen because of the basic mistake that you have made. the table is meant for ...
|
| Learning VB | 2/19/2005 |
Q: Where on the web(online) is the best way to learn VB and fast? We are going to use it next week and ...
A: vb is a full programming language and vb script is a small language which is used inside a browser ...
|
| Excel VBA | 2/19/2005 |
Q: I am not an programmer, but can use VBA (Excel 2003, VB 6.3)for processing the values in a excel ...
A: this can be solved in excel itself without any VBA. in colC enter say in cell 60 JOHN ...
|
| Encryption and Decryption | 2/18/2005 |
Q: I'm writing a program, in VB 6.0, that parts of which requires a password to gain access too. These ...
A: if you use a log on form the password is shown as * if you want to encrypt and decrypt you need ...
|
| scope of the variables | 2/18/2005 |
Q: I want to set a login name and password facility in my project.However i do not want to store them ...
A: try this out and make suitable changes: first you need to enter the username and password. then ...
|
| refine a search from a query | 2/16/2005 |
Q: Refine a Search from a Query I have a search engine that searches a keyword and returns the matching ...
A: from your question it is not clear how you are filtering the records. as an example put a ...
|
| Printing a FlexGrid | 2/15/2005 |
Q: hye. I have been able to print a whole flexgrid but now I want to print a SELECTION of a FlexGrid ...
A: try out this code and make adjustments to suit your needs. g is the name for msflexgrid Option ...
|
| ADODB wit SQL Query in VB6 | 2/15/2005 |
Q: i am using the VB6 with MSAceess i am using ADODB with SQL query as follows... i am tryting to get ...
A: here is the corrected code Set rsDelGetRec = New ADODB.Recordset SQL6 = "SELECT * From PurchaseOrder ...
|
| How to scroll datagrid programatically. | 2/11/2005 |
Q: I am using VB6 to read data from Access for Reporting in Excel. While writing data excel I noticed ...
A: basically i do not follow your scheme of getting the report you use access, datagrid, excel etc. i ...
|
| RichTextBox font display problem | 2/11/2005 |
Q: I have experimented for the problem both on VB 6 and .net. I'm trying to input/display some Hindi or ...
A: all fonts do not behave in the same way. some trial and error is required. better to consult the ...
|
| Flexgrid decimal pt | 2/11/2005 |
Q: I've got a flexgrid with some data loaded into it. However the data in my database is to 2d.p but ...
A: if you are in excel, why go to vb for formatting? either you can format cells to number with 2 ...
|
| Printer Problem | 2/10/2005 |
Q: i am working with vb.net and i want when use prindocument.print and my string (that it can be one ...
A: cannot stop the printing like that. you need to complete the document and then print. once printer ...
|
| Flexgrid Print | 2/10/2005 |
Q: Just wanna know if it is possible to print a FlexGrid with all the data that has been loaded into ...
A: it is quite a simple matter to print from flexgrid Private Sub Form_Load() MSFlexGrid1.Rows = 60 ...
|
| One to one relationship | 2/9/2005 |
Q: I am speaking in an investment context, so the three types are fixed, variable and asset based. The ...
A: here's the method. i hope you are in access.. (you haven't mentioned the database type) create a ...
|
| vb | 2/8/2005 |
Q: first of all thank you for your previous guides about my problems. everything is fine in my project ...
A: you are back to chicken and egg situation. here's the scenario. first you add records then you ...
|
| VB 6, access, intermediate, ADO + SQL | 2/8/2005 |
Q: I have what i think is a simple but infruriating problem. I am using ADO to connect to a database ...
A: this sort of code works OK in VB 'connect ... using the connection string, rec as new ...
|
| printing vb6 | 2/8/2005 |
Q: i am working on a project which prints several pages using the printer object. my question is can i ...
A: whatever you put after the printer.endoc has no effect on the printer. better to insert a footnote ...
|
| Object Disconnecting From Clients | 2/5/2005 |
Q: I am (still) developing with VB 6.0 and MS Access 2000 on Win98-R2. When my application runs on ...
A: perhaps the time settings of some of the connecting programmes may be triggering this. it is not ...
|
| VB to Access problem | 2/4/2005 |
Q: would like to seek your help regarding some problem with access my DB. I have created 2 Reports in ...
A: End Sub ** in access create the macro Macro2 open report Report2 view print preview save it in vb.. ...
|
| Multiple Selection | 2/4/2005 |
Q: Access 97 I have a list from which a user can choose one or many. The selection is made and read ...
A: your question not clear. are you in vb,access ? better rephrase your question. "I now wish ...
|
| VB beginner | 2/4/2005 |
Q: Access 97 How do I display a No Records Found rather than an empty set of records I have tried the ...
A: question not completely clear. anyway try this: Private Sub Command1_Click() On Error Resume Next ...
|
| ADO Connection module | 2/2/2005 |
Q: When i write codes every time i have to write connection, command, and it's parameter it goes very ...
A: the simplest way to is to create an ODBC connection (control panel_ODBC_Create new.. point to jet ...
|
| timing? | 2/1/2005 |
Q: now i have my programme.... in vb6.0 but i like to limitate the usage of the software.. just like..a ...
A: this can be done by several methods. one of the options is to create a registry key. ## add code ...
|
| Installation Help | 2/1/2005 |
Q: I want to install a software that I developed using VB as front end and oracle as backend. Should ...
A: it is better to locate the database in the same directory as the vb.exe use App.path & "\yourdb.mdb" ...
|
| Generate Reports in VB Data Reports | 1/27/2005 |
Q: I have written a code in VB to generate output in the VB Data Reports. I just uesd a basic query ...
A: for datareports use a dataenvironment and put a sql like select * from tablename into a command ' ...
|
| portable program | 1/27/2005 |
Q: is there a way to create a portable vb program that i put into a thumb drive and use it in another ...
A: you can make an exe file or use a package and deployment wizard and make a stand alone programme ...
|
| Form customization | 1/26/2005 |
Q: I am develop a form in visual Basic Project. This form has three text box. These text boxes are ...
A: for pressing tabkeys to movenext, does not require any coding . just set the tabindex consecutively. ...
|
| VB Reports | 1/26/2005 |
Q: "Hi! Let me explain you what i want to build and help me out in doing this. Please use the same ...
A: this requires Microsoft Data access components 2.6. check under vb projects references. if you don't ...
|
| showing multiple records | 1/25/2005 |
Q: i am making a student record system in visual basic and i would like to show users the course a ...
A: what is your question? the coursenames should be unique and need to be entered just once in a table, ...
|
| Search | 1/25/2005 |
Q: I've tried your piece of code. It helped me to learn smth new. But what I need is smth different. ...
A: you can follow the same steps for additional combo selections by using esql =esql & " where ...
|
| Runtime error 3251 | 1/24/2005 |
Q: I am using vb 6 and ms access 2000 as the backend The connection with the database is properly ...
A: * the trouble lies in the properties for your connection. private sub cmdADD_click() connect esql = ...
|
| Search | 1/24/2005 |
Q: Am actually doing a search module but having much difficulty with it. I have 8 combo-boxes, each one ...
A: to search by fields, instead of having 8 combo boxes ( which confuses the user) have just one ...
|
| vb listbox | 1/23/2005 |
Q: "Hi I am working on aproject vb6 and access(database) I have difficulty in listbox.when I connect ...
A: use this code; Private Declare Function SendMessage Lib "user32" Alias "SendMessageA" (ByVal hwnd As ...
|
| SQL Statement | 1/18/2005 |
Q: I have a problem. I cannot figure out how to write a SQL statement. Consider tblTest in my Database ...
A: ' connection open here dim esql as string, what as string, ravi as string what="Band" esql= "select ...
|
| Reports - VB | 1/18/2005 |
Q: , The Date Formatting worked in VB-MS ACCESS I have a different error now, i have designed a Form - ...
A: it is difficult for me to assume datatypes, cursor needs etc from your code but you can use simpler ...
|
| running a text box | 1/18/2005 |
Q: hai ravi I think so my question is correct.What i mentioend is the control may be either label or ...
A: in such cases, you need to do a few trial runs to get the figures right. have these exactly as ...
|
| how can i print numbers of forms on one click | 1/17/2005 |
Q: im using vb6.0 the problem is i dont know how to print numbers of forms in just one click.. i have a ...
A: from the code, i see that you are new to programming. when you say print, there are two things, one ...
|
| Data Report in Visual Basic 6.0 | 1/17/2005 |
Q: Because I am actually clicking on a command button to obtain the report.Hi help me with data reports ...
A: basically, i do not like a complete tutorial like service, since it is free. i am a busy freelance ...
|
| Here is code - of previos doubt | 1/17/2005 |
Q: Option Explicit Dim cn As New ADODB.Connection Dim rs As New ADODB.Recordset Dim EKG As Integer Dim ...
A: what is your question? i don't keep track of previous doubts as i get a large number of questions. ...
|
| VB - MS Access | 1/17/2005 |
Q: , I am Creating an application. my front end VB has a Field where the user input the DATE, I have ...
A: firstly change the name of the field "Date" to say Start_Date or whatever to differentiate from Date ...
|
| vb | 1/17/2005 |
Q: sir , How can link vb & database(RDBMS),and give me some vb projects(for free web sites)
A: you could use ADODC and set the connection property which is a wizard. then have a datagrid and set ...
|
| Recordset Validation | 1/16/2005 |
Q: Hello I am trying to retrieve records from SQL server with this Query : ...
A: looks like you are new to the SQL. to avoid errors in concatenation, use this strategy. dim god as ...
|
| Data Report in Visual Basic 6.0 | 1/16/2005 |
Q: i've run the codes below but it is actually giving me no errors but the report is blank. Prob with ...
A: Data report to be used with dataenvironment. first set the command property of dataenvironment ...
|
| Data Report in Visual Basic 6.0 | 1/14/2005 |
Q: Can you please let me know site where I can have good tutorials on Data Report Designing. Thx
A: try any of these links: http://www.codeguru.com/vb/ http://vbnet.mvps.org/ ...
|
| printing datagrid results 1 at a time in vb6 using access | 1/12/2005 |
Q: I was wondering if there is a way to wrap the text w/ the cell on the data grid so that when it ...
A: as suggested before, msflexgrid is better than the datagrid by setting the wordwrap and the ...
|
| Loop through textboxes | 1/12/2005 |
Q: I have about 50 textboxes on a form (Visual Basic 6.0) I actually want to check if the numbers in ...
A: to give the loop an access to the textbox names:(in case you don't want to number the them as an ...
|
| creating table during run - time | 1/12/2005 |
Q: I am using Visual Basic 6.0. Can you give the coding for the following actions to take place 1. A ...
A: (' when you are asking a question cant you at least check out the name? you are not a foreigner and ...
|
| Filecopy | 1/11/2005 |
Q: When I try to use the copyfile function in copying one data base to another sometimes it works and ...
A: FileCopy "c:\confine.mdb", "d:\confine.mdb works fine. why copy when there is a import wizard. Also ...
|
| printing datagrid results 1 at a time in vb6 using access | 1/10/2005 |
Q: This worked great! Thanks so much. Now I'm wondering if there is a way to print the headers with ...
A: Private Sub Form_click() Dim Col1, Col2 As Column Set Col1 = DataGrid1.Columns(0) Set Col2 = ...
|
| Disable columns in a flexgrid | 1/10/2005 |
Q: On my form in VB6 I have an MSFlexgrid. Is there a way to disable specific columns in the grid? For ...
A: i do not know if the individual columns could be disabled but try this method ' F is the name ...
|
| Doubt in treeview control(i mentioned with comments as u told already) | 1/9/2005 |
Q: HAI Below is my codings for treeview control. I had added all necessary comments and the error that ...
A: your code is ambiguous what do you mean by Rfund.Open "select fname,fid from fund where availid ...
|
| copy a record | 1/9/2005 |
Q: I am working on a project with VB6 and ACCESS. How I can copy a complet record from a table to ...
A: it is not a good idea to copy a record to another table. the idea is that the records entered are ...
|
| Debugging | 1/7/2005 |
Q: Sorry to make you wait for weeks. I was on vacation. Happy new year! Here is the code with ...
A: since i answer 100s of questions i do not remember the previous references unless you do it in a ...
|
| A loop (on VB Excel) | 1/6/2005 |
Q: (I am just a beginner, trying out programing on Excel VB). On sheet1, I have a bottom ("INSERT ...
A: i assume that you are using this userform for inserting data into the sheet. also your reference to ...
|
| printing datagrid results 1 at a time in vb6 using access | 1/6/2005 |
Q: I am using VB6 and connecting to an Access 2003 database. I have a search page for the user to ...
A: locate the adodc and the datagrid in the second form. you can have a commandbutton which takes the ...
|
| VB 6 | 1/6/2005 |
Q: I entered the following code to create commandbuttons at run time. I succeeded. Now I want to ...
A: ' first create a commandbutton. copy and paste this button and you will be asked to make an array ...
|
| vb6 sql query for access database | 1/5/2005 |
Q: I am trying to do a search in an Access 2003 DB using a sql query in VB^. Below is the code. I can ...
A: there are minor mistakes in your code: *dim sql as string ' not variant ** adoconnection.Open ...
|
| Sum of Amount from Database | 1/4/2005 |
Q: the Access database goes somewhat like this : ID Market Amount 1 DAX 12 2 DAX 0 3 ...
A: note that you are making an error stating that the database goes something like this. it is not ...
|
| Save button | 1/1/2005 |
Q: The DO-While loop to check for duplicate values in a database does not work, Please help with some ...
A: you have not used the do while loop. so how can you say it wont work. i have given a sample code ...
|
| Visual Basic 6, displaying SQL query result | 12/30/2004 |
Q: I've got a little access database about books: book name, isbn, publish date etc. What I want to do ...
A: the problem is in concatenation of the character "" etc. use this ploy to overcome this: 'under ...
|
| SQL | 12/30/2004 |
Q: Hey thks for the codes.It works really cool. Now if you could please help me out wiz some SQL ...
A: 'under general declarations Dim esql As String, conn as ADODB.connection, rec as ADODB.recordset ...
|
| Copying Files | 12/29/2004 |
Q: I have made a succesful program. I want to make a program so i can install the file onto a computer ...
A: question unclear. you mean you need to install in another computer from yours? are they connected? ...
|
| VB5 - Beginner Question | 12/29/2004 |
Q: I am a beginner in the Visual Basic world, and need help in regards to something I'm trying to do ...
A: since you are a beginner , you could be excused for not understanding the error message: you have ...
|
| Inserting values in a database. (VB 6.0) | 12/29/2004 |
Q: Need your help.. Having problem with inserting values in a database. The database is as follows : ...
A: are you in access or sql server or which database? in access you use: first of all it is not ...
|
| VBA for Excel | 12/28/2004 |
Q: Many thanks for your quick response. It worked well where sheets have not been renamed. In my case, ...
A: first of all for a beginner, it is always a bit risky to delete worksheets. if you are doing it ...
|
| VBA for Excel | 12/27/2004 |
| Q: I was se |
