94 Posted Topics
 | Passing a connection string as a query string is extremely Dangerous... Passing a value of 1,2,3 or a,b,c which maps to a corresponding connection string is much safer. Microsoft enterprise library methods take a connection string as a paramter, so pass them all a variable of say strConnectionString, and on … |
| | instead of Eval("f.name") try Eval("name") You shouldn't need the table alias to select fields. If there are duplicate fields, like forumid, use a field alias, like "Select f.forumid as forumID_1, s.forumid as forumID_2.....". |
| | Sounds like, sir, that you need more than a Forum. A specific item can certainly be addressed, but you really can't expect to learn how to create websites from a forum. [URL="http://aspalliance.com/1750_Building_Web_Sites_with_ASPNET__Part_1"]May I suggest this link a starting point?[/URL] |
 | Use a Masterpages in asp.net. [URL="http://msdn.microsoft.com/en-us/library/wtxbf3hh.aspx"]http://msdn.microsoft.com/en-us/library/wtxbf3hh.aspx[/URL] |
| | I'm in the process of building a new menu editor for someone at work. I don't know if I've been at this too long or just can't see the forest for the trees.... The database structure's menu items like id, title, parentid, listorder, link, etc I'm trying to write this … |
| | Re: datagrid [URL="http://www.dotnetjohn.com/articles.aspx?articleid=83"]Google is your friend........[/URL] try that link for starters. |
| | I've used [URL="http://www.fckeditor.net/"]FCKEditor [/URL]alot and I'm moving to [URL="http://www.wymeditor.org/"]WYMeditor [/URL]now. FCKEditor is good, but not quite standards compliant, hence the switch. Both are good editors though.  |
| | Ok, first off, is the database connection working? What technology are you using for database connectivity? DAO or ADO? You build your query by including a text box value in the query string and then send the query via recordset or command object to the database. So if you have … |
| | so apparently you can't call a page containing ajax from an ajax script. So I hear. I've also heard about a work around. Something like having all the ajax on the parent page or something. Does anyone have more information on this? |
| | Can anyone identify which editor/program/ide this ASP generated code may have come from? Thanks a million if you can! [CODE]<html><!-- InstanceBegin template="/Templates/standard.dwt.asp" codeOutsideHTMLIsLocked="false" --> <head> <!-- InstanceBeginEditable name="doctitle" --> <title>*sniped*</title> <!-- InstanceEndEditable --> <link rel="stylesheet" href="Assets/css/layout.css" type="text/css"> <!-- InstanceBeginEditable name="head" --><!-- InstanceEndEditable -->[/CODE] |
| | Hi, at url [url]http://lowellbonnell.ca/index.php?view=Markets[/url] my ajax will only work if you insert the www in firefox. IE is fine either way. Any ideas?  |
| | A client has asked me to add a data mining module to a database of customer orders. I'd appreciate if anyone can point me to an algorithm which can help find trends and order patters from a group of dates. Does something like this exist? I'm stuck with VBA as … |
| | Need more info for this one. Are you talking about a networked chat application, web chat application. [QUOTE]like is using a many textbox good or a Big Nono,[/QUOTE] If I understand this right, are you suggesting using a bunch of text boxes??? If so, you should only need two text … |
| | To build on what the previous two posters said, you basically want to use your textbox as a variable. So in the on_click code of your command button put something like: [CODE] Form1.recordsource = "select * from tablename where columname like '" & textbox1.value & "*';" form1.requery [/CODE] This will … |
| | I've developed a quote/order database in access 2003 for a customer, so this is primarily a VBA solution, but I'm mostly after theory today so vba or vb is irrelavant. I have of course normalized tables containing historical and current orders. Right now, I have a reminder type form that … |
| | There is a program called EasyRecover which I have used in the past. It's really good. However, if in restoring you computer you wrote over the areas which your program was on your hard drive, its probably gone for good. Try running the recover software on your thumb drive too. |
| | Hey, I've taken over a php based website from another developer (ugh!)... The website uses two include files to display ads down both sides of the page. Now the client wants these ads to display in Random positions.... So, Its easy enough to take the ad text and place it …  |
| | Re: CommandList Your best off finding a dedicated VBA forum, as Visual Basic 6 and Visual Basic for Applications are two different things. Similar, but VBA is quite limited as I found out when I started VBA programming in Access and Excel. Best way to learn VBA IMO is to drop some … |
 | Re: Java IDE(s) I downloaded JCreater the other day and deleted it 50 seconds later. I'm no pro at java but i'm not an absolute beginner either. I've settled on use Notepad++ to edit and command line to compile and run. A simple bat file takes care of compiling and running for me …  |
| | I've revived an old java project I did in college. Basic chat type program like ICQ which stores offline messages and users in a database etc, etc. I've recently switched the database from Access to MySQL and am considering some other alterations. I've been reading a bit on RMI. I … |
| | I've added a vbscript to an asp page in order to print without showing the print dialog box. Everything works fine when you first load the page, but when you try and navigate away from the page, you get the "A script on this page has caused internet explorer to … |
| | I'm wondering what thoughts people have on the best way to implement a 3 tier application. I'm playing with the idea of multiple clients <---> server <----> database server <----> mysql database. I'm not sure if the database server is a necessary step though. My previous foray into java network … |
| | I have a Access 2003 database which has a table we'll call orders. There are 10 other tables linked to orders through Order_ID. I'd like to be able to create a duplicate of a record and all the associated records in the linked tables. I've read it possible with an … |
| | I'm trying to filter a subform based on combobox selection and getting a runtime error '424' - object required. I downloaded the code from [URL]http://www.techonthenet.com/access/forms/filter_form.php[/URL] and verified that it works in the provided sample database. I copied the example and I'm getting the runtime error. I tried copying everything to … |
| | What if you always add a set number (say 5) blank rows to your database table. There would always be 5 (new) rows which a user could edit. |
 | [quote=StatiX;246917]I'm new to VB so my question is probably very simple. anyway here it is.. I want to make a side bar showing one form that is like a sidebar in a web page such as on the left side of the MDI form. Which holds the programs main functions … |
| | Declare your variables at the form level, if you declare in the procedural level, they get reset each time the sub or function runs.  |
| | Would anyone know how, if it's possible, to pass a user defined type through a network connection say using winsock? For example: [CODE] type tExpl name as string address as string phone as string end type dim myExpl as tExpl winsock1.send myExpl [/CODE] As far as i know, winsock only …  |
| | [quote=shalini_roy]how do i add items to a combobox from a listbox that is in another form??[/quote] You can reference the listbox directly using: [code] combobox.additem frmOtherfrm.listbox1.index(frmOtherfrm.listbox1.listindex) [/code] This code will grab the currently selected item, and will cause an error if there is no selected item. You probably want to … |
| | Re: to carry tables I havn't done Oracle since ver. 7, but I know most mainstream databases have an SQL dump or export ability which will allow you to export table structures and data. You may need a third party database explorer to do it, but it's always possible. I use EMS SQL Manager … |
| | [quote=Comatose]I don't see the problem.... VB is reading data from the serial port right? So should it matter if the form's .visible property is true or false?[/quote] I wonder is it possible the application doesn't have a proper hook on the serial port? Is a third party control being used … |
| | [quote=shalini_roy]how do i add the numbers in a listbox and display it in another textbox?[/quote] Create new project, add list1 and txtText1 to the form1 and paste: [code]Option Explicit Private Sub Form_Load() Dim x As Integer Dim inx As Integer 'counter List1.AddItem "1" List1.AddItem "2" For inx = 0 To … |
| | [INLINECODE]Do Until deathcounter = 9 DeathCount Loop[/INLINECODE] This seams to be where it locks up. You don't increment deathcounter anywhere in the loop or in the deathCount sub. Look at your code and decide if you really need this function call in a loop. |
| | Re: MDI Forms Sure. Create a new project, add an MDI form and 2 or more MDI Child forms. in the MDI Form code window paste: [CODE] Private Sub MDIForm_Click() MsgBox Me.ActiveForm.Caption End Sub[/CODE] Click on the MDI form to see which child form is currently active. The .ActiveForm property gives you complete … |
| | Re: MDI From Query hmmm . . . thats a neat technique, though for the record, if you have [inlinecode]Option Explicit[/inlinecode] in your module you will need to [inlinecode]Dim Xfrm as Form[/inlinecode] in that procedure. |
| | Re: VB6 and Directx [quote=sosco]yes it is! any shape you want, how many form you want.... look here: [URL="http://www.planet-source-code.com/vb/scripts/ShowCode.asp?txtCodeId=50793&lngWId=1"]http://www.planet-source-code.com/vb/scripts/ShowCode.asp?txtCodeId=50793&lngWId=1[/URL] or here: [URL="http://www.planet-source-code.com/vb/scripts/ShowCode.asp?txtCodeId=12991&lngWId=1&txtForceRefresh=627200610312635313"]http://www.planet-source-code.com/vb/scripts/ShowCode.asp?txtCodeId=12991&lngWId=1&txtForceRefresh=627200610312635313[/URL] it's easy![/quote] Neither of those projects have references to DirectX, so don't waiste your time trying them. They deal with custom form shapes. Here are some tutorials on programming with DirectDraw. [URL="http://francis.dupont.free.fr/coindev/english/"]http://francis.dupont.free.fr/coindev/english/[/URL] |
| | Use a timer control instead of a loop. This should all but eliminate your CUP Usage. Just a a quick test, I created a new project, set form1 to open form2 every 2 seconds via timer control, and put a timer on form2 which unloaded from memory every 1 second. … |
| | Re: Text to Speech [quote=robertlees]I just want a simple text-to-speech facility. I just want a digit to be spoken. I'm sure it can be done with an OCX. Could play a wav file, but want this ability within an exe.[/quote] Look up the Microsoft Agent API. It's a fast and easy way to get … |
| | [quote=Smooth_411_2000]How would i make visual basick remember selections from other forms so it will excute the disired outcome at the end of my process.[/quote] It also depends on what you mean by 'process'. If you trying to create a wizard type application, save the form selections in variables for easy … |
| | Why not use a control array and a counter? Every time someone guesses wrong do: count = count + 1 if NOT controlarray(count).visible and NOT count > Ubound(controlarray()) then controlarray(count).visible = true end if Thats how I did a hangman game back in 98 on my brother's laptop while driving … |
| | [quote=Comatose]Soooo...... You Want Someone To Do Your Homework For You?[/quote] If i write the script, can i have his degree?? |
| | I'm sure it's just something simple, like maybe try refreshing the report after you set the label value? If your really desperate, create a table linked to the table which your report is pulling from to hold different title values and update the table prior to calling your report. Base … |
| | I'm developing a custom instant messenger for the office as we have need of rather unique IM needs. So far I have two groups of users: Group and Individual. The group users can comunicate with their group and all other types of groups. Individual users can only communicate with one … |
| | OS, yeah no go with VB. Now a custom SHELL would be cool, and that CAN be coded in VB... |
The End.