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: *

  1. anthony777

    unbound txt boxes

    thanks I am still having one problem the syntax to update the table here is my code Option Compare Database Option Explicit Dim TotalElapsedMilliSec As Long Dim StartTickCount As Long Dim strsQL As String Private Declare Function GetTickCount Lib "kernel32" () As Long Private Sub...
  2. anthony777

    unbound txt boxes

    user enters the custid they then chose whether its a worksheet or invoice by putting y in either of the txt boxes one for worksheet one for invoice when they are finished they click stop the timer on the form stops then they click finish and the timer populates the finished time in the finished...
  3. anthony777

    unbound txt boxes

    thanks because the custid could be a new one. Maybe I am missing something could all the fields be bound and still allow new data entry because the table would start off fresh no data
  4. anthony777

    unbound txt boxes

    I have five unbound text boxes custid starttime finishtime worksheet invoice one unbound txtbox box is called elaspedtime which is the time from start to finish that calculates I need when I click the finish button need the custid, starttime,finishtime,worksheet or invoice depending which task...
  5. anthony777

    User form txt box to update database

    I have a form with txtboxes that the user is going to enter I need the data they entered to fill the table. I know I should know this but slipping my mind now lets say one txt box is custid once they enter I need that to fill the database table. Thank You
  6. anthony777

    acess 2007 data collection from emails

    I been assigned to use the new feature in Access 2007 the problem is not all have info path and html is to large. Is there away I could have employees hyperlink and use the database on sharepoint and alert certain employees when the request for updates have been sent?
  7. anthony777

    Acess templates

    I am looking for an access template that would closely include the followng fields employee name: date of hire: current location: current job title: immediate supervisor: postions held at this company:(last three) postions held at other companies(last three) all degrees earned: education in...
  8. anthony777

    updating database through emails feature

    I been assigned to use the new feature in Access 2007 the problem is not all have info path and html is to large. Is there away I could have employees hyperlink and use the database on sharepoint and alert certain employees when the request for updates have been sent? Thank You
  9. anthony777

    query to export txt on 1 line

    BTW no I did not create the function I do not know the code to put in the function?
  10. anthony777

    query to export txt on 1 line

    d hook up I am a newbie kind of what do I put in the function and how can I run it from a query for example where does this code go? Function it gives error> SELECT Concatenate("SELECT [Customer ID] FROM tbl0316Cust") AS CustomerIDs FROM tbl0316Cust GROUP BY Concatenate("SELECT [Customer...
  11. anthony777

    query to export txt on 1 line

    Access keeps telling me the following syntax is wrong can some one help SELECT[customer id], Concatenate("SELECT [Customer ID].tbl0316cust")'
  12. anthony777

    query to export txt on 1 line

    Expr1: SELECT[customer id], Concatenate("SELECT [Customer ID].tbl0316cust")' I am trying to have all the custid from one column come out in this format b2018, b2727, b324b can anyone show me how thanks
  13. anthony777

    access to print ms message attachments only

    I need to create a macro in access that will grab the highlighted records in ms outlook and print only the attachments please help
  14. anthony777

    query to export txt on 1 line

    I have a column with custid b2018 b2727 b324b I need it to export to txt delimited in the following format b2018, b2727, b324b there is a space after each coma
  15. anthony777

    Vlookup excel

    I have a spreadsheet book 1 with a list of customer id in field custid I have another spreadsheet called June 2009.xls with cust id I want to see if the custid in book 1 does exist in June 2009.xls cust id. I am trying to use this forumula but having trouble can anyone help with the syntax...
  16. anthony777

    Vlookup excel

    the question is how do I list my cust id in one spreadsheet and do a lookup to see if they are in the other spread sheet. I need to know if the cust id I have already exist in the other spreadsheet. I was looking at the vlookup
  17. anthony777

    Vlookup excel

    I have a spreadsheet that I cannot alter it has a Cust ID field in field C I want to list all my cust id that I am searching for in another spreadsheet in column a and then search the other spreadsheet called may.xls to see if any of my cust id are in spreadsheet May.xls column C cust id field...
  18. anthony777

    the search key was not found in any record

    I get this error while trying to import an excel spreadsheet how can I get around this error it is very important thank you
  19. anthony777

    calculating off of the year date

    I have a contract that is sometimes annual from the anniversity date sya there anniversary is 03/08/99 I need to know how many months left if the contract expires 09/30/09 they pay annually.
  20. anthony777

    query from 2 columns into multiple columns

    yes that is right the problem is I have to separate each bill code into its own column and the rate for that code next to it for example bill code rate 334 2.52 660 1.70 220 15.30 so the query has to...

Part and Inventory Search

Back
Top