Recent content by work4free

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...