Search results for query: *

Below is the code I use to check to see if there has been and email associated with a companies account if so it gives them and error to enter another email. It works great however if the person has a number in there email such as abc123@abc.com it does not notice the email even if its in the...

IN access when you start typing a value in say the Name Field the system generates an auto id while you’re in the record. In SQL however it makes you wait until the editing is done. Is there any way to change the way SQL handles this so that you know what the auto id is before you finish the...

I caused this error on our development server because I wanted to see how and what information would be given regarding such an error. This is what it gave: "An error occurred on the server when processing the URL. Please contact the system administrator" I need it to be something like this...

I caused this error on our development server because I wanted to see how and what information would be given regarding such an error. This is what it gave: An error occurred on the server when processing the URL. Please contact the system administrator On our server it doesn't do that, it...

The calculation is as follows: I am trying to build a new system out of MS SQL with a totally web based ASP front end and before I start I want to figure out which calculation produces the most accurate data at high figures and to the penny. It appears the fraction is more accurate when dealing...

First we host our own servers so the code below is what I am use to but we are wanting to upgrade to sql express 2005 from access I am trying to figure what my connection string is for the sql? Any help would be great. dim conn, rs, sql, intTelephone, intMobile set rs = Server.CreateObject...

The code below gives no error. But it don't update the record like it is designed to? Any help I have used this type of code before adn its worked great. Set rst = CurrentDb.OpenRecordset("SELECT * FROM [CreditFile] Where [CreditFile].[ProjectID]=" & Me.[ProjectID]) If Not...

Below is the code I posted in the access form and ACMan1 was really helpful but I still can't get it to work. I also posted it in VB Scripts and was told that was the wrong form. My final attempt is here. I am tring to have the code upon on click of the payment button give an error message...

Ok, let me see here. The code below is not working but what I am trying to do is have this code on an asp page to get the results of the to tables and calulate them. Any help I am stuck on this. There is no problem with just one select getting the data its only when I try to union the other...

Below is the code I posted in the access form and ACMan1 was really helpful but I still can't get it to work. I am tring to have the code upon on click of the payment button give an error message if the record is being edited. I am stumped! Private Sub MakePayments_Click() If Not...

The code below is supposed to work like this. I have a payment button that is located on a form and when the record is locked I don't want an employee to be able to access the make payment button. It don't work right and help? Private Sub MakePayments_Click() If Not...

Ok first sql is new to me. I am trying to get an asp page to connect to the the server but am having problems. Any thought on this would be great. <% dim conn, rs, sql, intTelephone, intMobile connectstr = "Provider=SQLOLEDB;DATABASE=AS_Data;SERVER=SQLEXPRESS; Integrated Security=SSPI;" sql...

The code below is giving a over flow error when the attorney cost has a zero balance. I have and Idea why I am getting the error but can't figure it out how to fix it? Me.PaidAttorneyFee = (Me.AttorneyCost - Me.AttorneyPayments) / (Me.TotalPlus - Me.CCRefundSum - Me.NSFChargeDue)

I have this code in a value list drop down menu and it works fine on another form but I can get it to work on client form now if the record is filtered the show all records works to unfilter the records. ANY HELP!! Private Sub myComboBox_Change() Dim sFilter As String Select Case...

I have the code be low that is giving me an error "The SELECT stament encludes a reserve word..." I am trying to get this code to pull a report on the employees and list them and there time to make it easy for accounting. HELP SELECT DISTINCTROW Employees.SSN, Employees.Name AS Name...

I need some help deciding our new system. I want to build our system so that it is completely online with a MSSQL backend. I want the front end to be entirely web based! The questions below are what I need answered and if you have any concerns that I haven’t thought of please input them. It...

I am tring to join two queries. I know the UNION SELECT doesn't work for this and I am tring to figure out how to query two tables with different field values. The code below is as far as I have got any help would be great> SELECT DISTINCTROW AS_Projects.ClientID, AS_Projects.CName...

I have a list of clients that need to get updates from time to time on our Terms Of Service Agreement. I have a form called eMail Clients. The form hase two fields called Subject and Message and a command button called eMailAll. I want to be able to onClick have the code open the client...

Ok can anyone give me and example? Here is what I am trying to do. I need to create an onclick function that will open a table look at the table check the field name letterset if its unchecked then print all the unchecked records?

Below is my script and it doesn't work right. What I have is a report in a access database that I want to be able to print without acually having the data base open. The script below shows an error when I run it. Any help please? dim conn, rs, sql, intTelephone, intMobile set rs =...