Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: tekyge
  • Content: Threads
  • Order by date
  1. tekyge

    Time Clock Help

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

    Time Clock Issue

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

    Image Prints Bad Quality

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

    Metro II Format For Credit Reporting

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

    Bad Mail Folder

    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?
  6. tekyge

    Record Sorting

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

    Record Sorting By Last Name

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

    Help With a Null Problem?

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

    Question About SQL Express

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

    SMTP Question

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

    Code Help

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

    I have the code below works great i

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

    Record Set

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

    Syntax error (missing operator)

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

    Sum Of Recordset

    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?
  16. tekyge

    Adding To Recordset

    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"))
  17. tekyge

    Database Search

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

    Record Sorting

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

    Searching Access Database

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

    Logout Of Session

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

Part and Inventory Search

Back
Top