Search results for query: *

I am building a time clock system where the employee can type there ssn and clock in or out using only one button. Ok everything is working except that I want to have the code below give me a updated total in hours and minutes of the total time an employee has worked but nothing is showing in...

Below is the code I have that adds a new record each time an employee logs out or in. What I am tring to do is rather than it adding a new record I want it to edit the time record of the employee clocking in or out. I am having a problem figureing out how to find and edit the record I need...

I have an access report linked to an image on the server and it displays on the report great but when I print the report letter the linked image qulity is very poor. Any help with this? Thanks guys

Can anyone tell me what the extension (.***) is for the metro II format and can access out put using it?

Is there a way in the windows 2003 mail server to restrict any incoming mail other that the designated email accounts. The reason for this is the number of bad mails we receive in a given day. I would rather they be undeliverable than to go to the bad mail folder?

If there way to sort a record by last name? Like the example below would sort by first is there a way to do it by last name? example ORDER BY [Projects].[ProjectName] ASC

I am trying to get this sql stament to sourt a record via last name? Any help? Thanks guys sql = "SELECT Projects.ProjectID, ProjectName, LastPaymentDate, Paid, Total, Mid([ProjectName],InStr([ProjectName]," ")+1) & ", " & Left([ProjectName],InStr([ProjectName]," ")-1) as LstFrst FROM...

I need some help? I am tring to have an asp called continue, now when the client clicks the link it takes them to the page where it checks to see if the value of a record is 0. Basicly it works if there is a value but if there is no value it give an error. Any help? Microsoft VBScript...

I have a question on rather anyone can point me in a direction of what is better access or sql express? Access is doing great at this point but I was going to go threw all the code to streamline it to make it work more effectively. However, I was thinking rather than redoing the code for...

We have a virtual smtp server setup to handle incoming and outgoing mail. Our connection is set to all computers and our relay is set to just our internet IP address. First question, Is that a good way on a security aspect of it? Second question, If I am on my laptop and dial up to access the...

The below code works but it shows all the records or none, and I would like it to show only the records after the current date. Any help? sql = "SELECT * FROM [Projects] WHERE [Projects].[ActID]=" &Trim(session("myvar1"))& " AND [Projects].[CDate]>Date()" & " ORDER BY [Projects].[ProjectName] ASC

I have the code below works great if the CDate Value is True but if I change it to >Date it gives the below error? '-- sql = "SELECT * FROM [Projects] WHERE [Projects].[ActID]=" &Trim(session("myvar1"))& " AND [Projects].[CDate]>Date" & " ORDER BY [Projects].[ProjectName] ASC" rs.open sql, conn...

I am trying to update a record in an access database with the following code but I keep getting and error? '-------- sql = "SELECT * FROM [Clients] WHERE [Clients].[ClientID]=" &Trim(session("myvar111")) rs.open sql, conn, 3, 3 '-- strPassword=Trim(Request.Form("password")) '-- rs.Edit...

Here the code I am using to verfy a user name and password but I keep getting this error. Any help? Code sql = "SELECT * FROM [Clients] WHERE [Clients].[ClientID]=" &Trim(Request.Form("accountid"))& " AND [Clients].[Password]=" &Trim(Request.Form("'password'")) rs.open sql, conn Error...

Is there any way to have the asp page calulate the sum of a field like you do in VB? Example in vb you would =sum([paid]) but in asp <%= FormatCurrency(rs("Paid")) %> how do you get asp to calulate correct?

Does anyone know how to add two recordsets togather for calulation. Want the two below to add and give one figure. FormatCurrency(rs("Payment + APayment"))

Below is the code we use in but would like to be able to add search capabilities to the sql string based on a search criteria? dim conn, rs, sql, intTelephone, intMobile set rs = Server.CreateObject ("ADODB.Recordset") Set conn = Server.CreateObject("ADODB.Connection") Conn.Open...

Below is my statement anyone know how I can get it to sort by last name record set [ProjectName]. Thanks for help sql = "SELECT * FROM [Projects] WHERE [Projects].[ClientID]=" &Trim(session("myvar1")) rs.open sql, conn

Below is the code and the error I am getting. Can anyone tell me what I am doing wrong? I want this search page to be able to search the database based by client. Searching the table named "projects" field name "ProjectName" and display the results. My error message is as follows: Microsoft...

I want to creat an hyperlink to abandon a session? Any help? Thanks