Search results for query: *

i realize SQL Server doesn't have forms....hence my opening statement: what i was hoping for was someone here who has used SQL Server and access together who might have run into a similar experience. if the answer is no, then i have exhausted this forum by trying Access Forms and SQL Server...

i posted similar questions in the MS Access Forms forum with no help....hopefully someone here can lend some guidance. i have two files: "test" and "master". in the test file i create new forms, queries, etc and if they work properly, i import them into the master file. recently, i created 2...

the global variable is in a module...i imported the module as well...there are three things working here: form1, form2 and module1...i imported all three from test to master...it still doesn't work...please help. [sadeyes]

i have two files: "test" and "master". in the test file i create new forms, queries, etc and if they work properly, i import them into the master file. recently, i created 2 forms in test - one form list all rooms for all buildings we manage. when the user selects the room in the proper...

i am using Access as a front end on our MSSQL server. i have 2 files - a test and production. in the test file i have 3 forms and global module. the first two forms (a form and a subform) are used to select which area you would like to go. when you select (click) on the area in the subform, it...

it keeps returning 2. like i said....it is setup to start at 1 and add 1. thus, i assume it keeps getting 1 and adding 1 to it, not the next number in the list...which is around 110 now. ?????

they were put in using the identity. they started at 1 and counted up to 100 using the identity increment 1.

does anyone know of a good book that incorporates php and mssql. everything i have been able to find shows mysql but nothing with mssql.

i tried using the scope_identity() but it is not returning the correct value. the identity is set so that it starts at 1 and adds 1 - essentially being an autonumber that is found in Access. I currently have 100 items in the database. when i execute the next INSERT and select the...

i know what the function does....i'm trying to implement it into PHP. i didn't have the quotes around it....i'll give that a try. thanks.

I have an online form people fill out and their info is put into our database. I have two tables - tblPerson and tblInfo. The primary key from tblPerson is a foreign key in tblInfo. The way it is setup now is: Query1 = Insert into tblPerson (fname, lname, phone) values ('fname', 'lname'...

yes ID is an identity. thus, should i use "SELECT scope_identity()" or should i use "SELECT @@IDENTITY"? i have never used either one of these but after looking at my Books Online documentation, it looks as though i should use the latter. and the value will be stored in the variable Query2. am...

I have an online form people fill out and their info is put into our database. I have two tables - tblPerson and tblInfo. The primary key from tblPerson is a foreign key in tblInfo. The way it is setup now is: Query1 = Insert into tblPerson (fname, lname, phone) values ('fname', 'lname'...

is there a way to check to see if the referring page is Question_2_correct.php, despite the fact that it is redirected via javascript? based on what sleipnir214 stated, i have narrowed it down and actually the pages with the javascript are the only pages giving me problems. any thoughts...

hhmmmm....this is interesting. i didn't realize all the intricacies of $_SERVER['HTTP_REFERER']. here may be one of my problems...one page has some javascript code (see the very first post in this thread). so based on what sleipnir214 says, this does not pass a value, correct? maybe that is why...

sorry, what i was trying to say was, i want the other two pages to be able to access the page as well (all three in the conditional statement should have access and not be redirected), however, only the first one works. the other two pages send me to the 404.html page.

here is what i've come up with based on sleipnir214's suggestion: <? if ($HTTP_POST_VARS['Submit']) { if ($HTTP_POST_VARS['Q2'] == "B") { header ("Location:Question_3.php"); }else{ header("Location:Question_2_correct.php"); } } ?> <?php if($HTTP_SERVER_VARS['HTTP_REFERER'] ==...

when i had an "OR" statement, no matter which page i came from it did not work. when i changed it to an "AND", it worked.

I have a header to check where the individual is coming from before they proceed. <?php if($_SERVER['HTTP_REFERER'] != "http://www.mysite.com/Question_1.php" && $_SERVER['HTTP_REFERER'] != "http://www.mysite.com/Question_2_correct.html"){ header("Location: http://www.mysite.com/404.html"); }...

i was using php, and not javascript, because i do not want them to be able to "decipher", or see, what the url's are before they make their selection. by using javascript they can view the source code and view the url's. they need to be hidden. any other thoughts?