Search results for query: *

I have an access project which connectes to a sql database. I want to create a texbox in my report that calls a stored procedure that takes two parameters and returns a value and I want the text box to show the result value from the store procedure. Does anyone know how to do this.. or if it is...

I am using Access Project with a SQL backend. I am running a report and in a the control source of a text box I am trying to calculate: =Sum(IIf([ethnicity]='X',1,0)) My Report Record Source is: SELECT dbo.AppPos.AppPos, dbo.AppPos.Status, dbo.AppPos.APAppID, dbo.AppPos.APPosID...

Hi, I am having the same problems you had in October. I waswondering if you could tell me how you solved your problem. One other question. Does the SMTP server have to be on the same server as your asp scripts. The two servers are on the same network. Thanks Margarita

I put a constraint on a table so that the database only accepts unique Social security numbers. The problem is that If I have a <NULL> value in the database I cannot insert another <NULL> value. I thought that this UNIQUE contraint ignored <NULL>'s. Any ideas?? This is how I created the...

Hi, I have a form that allows a user to enter their login and password. I am using a perl script to submit queries based on the form info. How do I validate a users login? Is there some type of function that I can use that will return a boolean so that I can let the user know that their login...

I just graduated and am new to SQL so any (detailed) help would be appreciated. Thanks I have a customers table such as this: Customers --------- CustomerID FirstName LastName MI 3748 Margarita Perez B I also have a function that given the above information will generate a string...

I need to create a primary key with the following format: TABLE ---- ID Firstname MI LastName I want ID to be automatically generated the ID to contain first letter of first name first letter of MI (or add a &quot;-&quot; in non available) first letter of last name and 4-6...