...

View Full Version : database admin - many users?



startbar
07-18-2004, 09:43 AM
hi, im looking for some code so that i can create a form that users can sign up with and create an entry into an access database but so they can edit it aswell, but obviously only their entry - is this possible?

thanks

Spudhead
07-19-2004, 01:56 PM
Yes, I believe there are some excellent tutorials on the matter at www.4guysfromrolla.com and www.w3schools.com

angst
07-19-2004, 06:57 PM
http://www.aspfaqs.com/aspfaqs/ShowCategory.asp?CatID=8

and

http://www.aspfaqs.com/aspfaqs/ShowCategory.asp?CatID=12

thoes two will help you.

Bullschmidt
07-20-2004, 09:05 AM
And/or you may want to search here:

HotScripts.com
http://www.hotscripts.com

Planet Source Code
http://www.planet-source-code.com

Scripts.com
http://www.scripts.com

The ASP Resource Index
http://www.aspin.com

Morgoth
07-22-2004, 02:00 AM
Every link above is excellent!

My favourite for all code is The ASP Resource Index http://www.aspin.com

When you finish your form, you will want to make sure it works before you add stuff like checking if a username is already in use, checking if they entered the same password in two text boxes, and same with e-mail with validating the e-mail.

A great function for validating e-mail is this one I was given by whammy (I think).


Function ValidateEmail(strEmail)
Dim strPattern
strPattern = "^[a-z0-9]+([-_\.]?[a-z0-9])+@[a-z0-9]+([-_\.]?[a-z0-9])+\.[a-z]{2,4}$"

Dim objRegExp
Set objRegExp = New RegExp
objRegExp.IgnoreCase = True
objRegExp.Pattern = strPattern

ValidateEmail = objRegExp.Test(strEmail)
Set objRegExp = Nothing
End Function

startbar
07-22-2004, 10:06 AM
thanks, ive been having a good read of those.

is there any really easy to follow guides (for this subject) for newbies! i dont know much about asp!

thanks

Morgoth
07-22-2004, 10:20 AM
I did a search in aspin.com, and found these two articles in a tutorial search.

http://www.planet-source-code.com/vb/scripts/ShowCode.asp?lngWId=4&txtCodeId=7225

http://www.planet-source-code.com/vb/scripts/ShowCode.asp?lngWId=4&txtCodeId=6948

Look at these, these might help you.



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum