No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
46 Posted Topics
 | Here is one that is stumping me. I have an Access 2000 database backend. It got corrupted. It is a large database. I compacted and repaired it and a record came up corrupted. There was a compact error table created that has a binary column in it. The binary column …  |
 | Try looking at the InStr function examples on this page: [url]http://office.microsoft.com/en-us/access/HA010547271033.aspx[/url] Chester |
| | Okay, first things first. What type of calculation are you attempting to do in the query? Are you calculating across multiple fields? Please provide a little more information about the calculation and the table structure if any the calculated fields are based upon. Chester |
| | Does anyone know how to add a new user created tool to the toolbox permanently? Everytime I start a knew solution, I have to go and add my customized tools back into the tool box. I would like to add the custom tools once and then they be there everytime … |
| | Try adding these imports statements at the top before anything else: Imports System() Imports System.Data() Imports System.Data.Oledb() If you do not add those imports statements, then when you declare your dataadapter you will have to do something like this: Dim MYDA As System.Data.Oledb.OleDbDataAdapter1 = New OleDbDataAdapter() Chester |
| | I am trying to learn VB .NET again. Have not used in a long time. I have bound my controls to my datatable and then I put values into the controls, I then have a button that I am trying to get to add/update the rows to the database. It … |
| | You may want to use Select Case or If, ElseIf statements. Chester  |
| | Re: option strict on [QUOTE=april_er]anyone knows what is option strict on is used for? or it means wat?[/QUOTE] With VB, you can implicitly declare variables, which means that you do not have to declare your variables prior to using them. This statement forces you declare all variables prior to using them. If you do …  |
| | I have a parent form that has a combobox. Whn the form loads I get the data from the db and bind to the combobox. that works fine and here is the code I use in form load to cause this to happen: [code] conn.Open() cmd.Connection = conn da = … |
| | Okay, it has been a while since I have used Vb .Net and I have now downloaed and installed Vb .net 8 express. I have setup a relational database in sql compact. I am trying to get a compbo box that will show values from one table and when an … |
| | Re: Dual hard drives Have you also considered running the games in XP in 98 mode? Right click the program and then click the properties, under compatibility you can select Windows 95, Windows 98 and others. Chester  |
 | Yes, ING is good. I have had a savings account with them for quite sometime now. However, their turnarounds are really slow. I have had it take up to a week and a half to get my money deposited into my checking account from ING. Their minimum is 3 days, … |
| | Re: ComboBox Events You can set up one sub and then set it to handle all of the events such as on lostfocus on mouseleave, etc. Then you could assign the row value to a variable possibly... Chester  |
| | Calculated fields in forms only exit in the form. You cannot query a calculated field from a form. You can regenerate the calculations in a query based on the same table the form is base on. Chester [QUOTE=shar164;325185]I have a field on a form which is calculated (A minus B). … |
| | Generally a joint table should contain the names of both tables, such as ACCOUNT_CUSTOMER. |
| | There are several apps depending on the ver of access that you are using. Do a search on google and you will find several. |
| | You could use a variable. Put a form level variable that is set to the current date on form load and assigns the variable date to the field. Then on the field on the BeforeUpdate assign the date that is entered from the field to the form level date. In … |
| | I am wanting to know what ways to attempt to do this. I want to set up an ASP >NET database service. The database (MySQL) will be hosted by a web hosting company which mya not be secure. I am thinking the best way to store clients' data would be … |
| | I am building a website. I have a database table that contains tips. The tips table is simple, it contains an ID column and a Tip column. I have a datareader to read the table and fill a datatable, however, I would rather have the datareader create a cached xml …  |
| | Re: Splash Screen You will need to use a submain procedure. Create a splash screen form and create a timer event. Set the timer to how long you want the splash screen to stay visible. On you submain, set your splashscreen to open first and then yoru main form to open second. When … |
| | Are you setting the m_strExpDate vairable to the date the user selected on the calender? Chester [QUOTE=vrushalinz1]HI, Here is the code u asked for, Private Sub cboExpiryDate_SelectedIndexChanged(ByVal sender As_ System.Object, ByVal e As System.EventArgs) Handles_ cboExpiryDate.SelectedIndexChanged If cboExpiryDate.Text = "1 Month" Then 'do something elseif cboExpiryDate.Text = "2 Month" Then … |
| | How rae your tables setup in the database backend? In a accounting / banking type of application, you should use a transcation table, which will be a bridge entity. I would put a time stamp in the transaction table that would show when the transaction was made. If you use … |
| | Re: Data Tier help Well, it depends on what you would like to do. The main thing the datatier should do is keep the data access seperate from the rest of the application. I most often use a module and then pass a dataview between the layers. I somtimes will pass a dataset. It … |
| | Have you set your references to include Word? If not then the code will not understand what you are doing. Have you used Word in other parts of your code and it work? It might help put the code up so we can see it. You may have a problem … |
| | If someone can gain access to your computers memory where the session variables reside, you have a lot more to be concerned about than the session variables. Now in asp where you are going over the internet, I can see where this would be a concern. Chester  |
| | If I understand what you are asking, then the database backend will take care of the updates and you would be able to see the changes immediately no matter where you are connecting from. Now is this Access backend going to be on a web server or in some other … |
| | Why are you needing mysql installed on all of the local machines. This would create many servers, which can be a security risk. A major point of having a database server is to bring all of the data to a central location. Chester |
| | I have a general user account which has all of thr rights and priveleges that I wan all of my users to have. Is there an easy way to copy this account to create new users with the same priveleges? Thanks, Chester  |
| | Okay this is a good one I believe. In a dataset, you can create single relations (ParentTable.PrimaryKey to ChildTable.ForignKey) using the dataset.relations.add method. You can use a string variable something like this: Dataset.Relations.Add("relationName",Dataset.ParentTable.columns(strParentKey),dataset.ChildTable.columns(strchildForeignKey) This method works fine for single to single keys generated dynamically using schema info. Now if there … |
| | Okay, I have been working with MySql for quite a while on Windows and can generally do what I need. I use Navicat to do a lot of the work because it is a lot faster than working it from a prompt. Anyway, I got permission to set up a … |
| | I am a student and am developing my knowledge of MySQL and am practicing using it as a backend for some of my apps. I can run MySql on my laptop (Windows XP Pro) and use my apps referring to the local host. We have a wireless network in our … |
| | I have created a program to monitor a network folder for file additions based on this link: [url]http://abstractvb.com/code.asp?A=1081[/url] It works fine on my local drive, but does not work for a Novell Server. Does anyone have any ideas of how to get it to monitor a Novell folder? If not, … |
| | [QUOTE=shelly121]hey ppz! im havin problems wiv my code on vb.net! it dopesnt recognise the "ADODB connection()"-it says its not defined?? i have added the data adapter and connection, so why doesnt it work??? [PHP]Imports System.IO Public Class frmClients Inherits System.Windows.Forms.Form Dim CN As New ADODB.Connection() Dim RS As New ADODB.Recordset() … |
| | If you just learning, the educational edition of he suite is a cheaper alternative to the full license. There are items and things that you can do with the suite that are very limited or nonexistent in the individual languages. This is Microsoft's way of attempting to get people to … |
| | This is pertaining to executables. If you put an executable on the network and then allow the users to execute it from the network drive, then allow your users to execute it, you would have downgrade your network security. This would be serious problem because then malicious code could be …  |
| | Some public holidays vary from state to state and some public holidays are celebrated at different times. For example WV had the Monday off following New Year's and GA had the Friday off before New Years. Now are the weekends work days or are they non work days. Also, what … |
| | Okay, you can just install Access on your computer. Yes XP will operate faster than 98 when you have the .net 1.1 framework installed, but you do not have to have office 2003 installed. We have Windows XP with .net framework 1.1 installed and using backend Access 2000. The .net … |
| | Re: Validation rule What database are you using? You can usually set a field size limit when you design you table in most DBMSs. Chester  |
| | Re: More Questions First Question: Yes you can do that. You would need to use the sub main procedure. The sub main is usually used for things like a splash screen, but you could use it to start two seperate threads. Second Question: You would need to import file IO, but yes you … |
| | expression.length will give you the number of characters. [code] Dim intLetCount as integer intLetCount = me.textbox.length If intLetCount < 160 Then Do Something Else Do Something Else End If [/code] Hope that helps. Chester |
| | No you do not need a component or anything. The .NET includes the JET driver for Access. This can be pretty handy if you want to create a database in Access and then create the frontend using .NET and not worry about your users messing with the database (if they … |
| | No, you will need to create an object variable for the form you wish to open. Somthing like this under the button sub should work: Dim objNewForm as New NewForm() objNewForm.ShowDialog() Chester |
| | What will it involve? Will you be using a Database as the backend? If you do have a database as a backend will it be access or something else? If you are not using a db as a backend, will you be storing your information in a file? If it … |
| | Re: Kinda new The .net suite is also more centered around RAD (Rapid Applications Development). You can go from scratch to having a fully blown program pretty quickly in the .net enviroment. Chester |
| | Hello to everyone. I am new here. I program in vb .net and love to work with databases. I work full time, go to school full time, been married five years and have two kids. I am working toward a degree in MIS. Chester  |
| | I am new to working with files in vb .net. I have worked with basic text files. I want to read a file such as a word document or pdf file in through a binary reader and then convert it to a jpg image. Does anyone know how I could … |
The End.