cpopham

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 …

Hi, I am using MS ACCESS. I want to validate a particular field. To check whether if its a valid email address with a @ So anyone have tutorials or website to reccomend or even reply off hand with the expression to check for @ in a string? Thanks alot.

I can't figure out how to perform a calcuation in a query and have the result output for use in a chart within a report. Forgive me I'm a newbie

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 …

any1 help, basically iv wrote the code to search for a client name in a database(in access) and this is the code:[quote] Private Sub BtnSearch_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) 'search If txtSearch.Text = "" Then MsgBox("Please type Client Name", MsgBoxStyle.Critical, "Enter Text") : Exit Sub Dim MYDA …

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 …

hello,i need to make an if statement for a mortgage application in vb.net, basically i have a list box for the DOB called cmbDOB, and a label to show the maximum mortgage. But i dont know how to make the if statement-it has to show the maximum mortage in the …

anyone knows what is option strict on is used for? or it means wat?

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 …

I have 2 hard drives in my pc. One is xp pro, the other win 98. I just switch ribbons & reboot to a HD. Both set on cable select. I would like to have them perminantly hooked up and when I start my pc, have a choice of which …

I like the idea of receiving a return on what I keep in my PayPal balance, but how safe is doing this? Is it safe to keep a lot of money in my PayPal account (which I have had hooked up to two credit cards and two bank accounts for …

What event can I use that will: Retain value when leaving field: Lostfocus, leave, enter, etc, Value works with the exception of Tab, also fires with every keystroke, lostfocus & leave will not work with all ways of leaving field. Help

I have a field on a form which is calculated (A minus B). It displays properly on the form with the correct answer. I can't figure out how to get it to pull into a query? My query is pulling any record with that field criteria >0 and no records …

hi! i am creating a database to do with a bank enterprise i have a CUSTOMER table and an ACCOUNT table. their relationship is many to many. i had to create an intersection entity in between them (so that it is one to many, many to one), but i dont …

Hi, I forgot my Ms. Access Database password. :eek: Is there a way that I can recover it..? For your information, I split the database into two files, the front end and the back end. Now, I can't open the back end, although the front end still works. Help.... :confused:

I need to create an environment that allows a data-entry person to change the default date for records on the fly. i.e. she's entering row upon row of historical data, and the date changes. I don't want her to have to manually enter the date for each record but I …

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 …

hi how can i create a splash screen using NB.Net ? it was easier using VB6 .:rolleyes:

hi, I have used a combobox to display a list of options like 1 Month,2 Months,3 Months and last option Other. Wen i click on "Other" , calender opens and i have to select the date. The problem is after i select the date and the calender closes i am …

Hi I m a final yr comp Engg student. I m working on .NET,i m usin mssql with ASP.NET,VB.NET for creatin online banking site.I hv a problem: Hw i can [B]record the transaction made [/B]by client for report generation. shal i use database for [B]report generation[/B]?if yes then hw? otherwise …

Hello all i am in need of some help with a datatier layout. I understand the gui, bussinessRules, but i am really not making any progress on the data tier. i have been tring to get a grip on the this one for over a week. I completely understand the …

wrdMailMerge.Destination = Word.WdMailMergeDestination.wdSendToPrinter This line of code gives an error saying requested object is not available Does anyone know why? If so can you point me in the right direction to fix it.

I read that session variables in ASP were a security threat. Is this true for session variables in .Net? thanks, ed

how i can make connection with acces database from three location like, lahore, london and usa . i m using application software and , can u guy suggest me any other way to solve this prob or make is sufficent , might eb webbased ..? if one updation occur on …

I would like to create a deployment project for my application. And my application need mysql as database, my deployment package will package the mysql installation. How to use VB.net to check whether mysql had been installed in the client PC and if not install, mysql installation will be initiated …

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 …