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 Rhinorhino 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. kevinwilson

    subform select case from main form?

    Thanks to all the would be responders ;) , but I managed to resolve my problem! SELECT Inventory.[UPC Code], Inventory.[Item Number], Inventory.Description, Inventory.Model, Inventory.[Serial Number], Inventory.Critical_flag, Inventory.Room, Inventory.Building, Inventory.[Status Code]...
  2. kevinwilson

    subform select case from main form?

    hello all, i have a problem with a subform retrieving recordsets based on combo box on main form (IMS_frmTR) My subform (query) consists of these fields: SELECT Inventory.[UPC Code], Inventory.[Item Number], Inventory.Description, Inventory.Model, Inventory.[Serial Number]...
  3. kevinwilson

    simple SQL statement?

    Many mahalo's for the quick response! Drexor, your suggestion was right on...I removed the quotes and all worked perfectly. Funny, I thought I tried every possible scenario with the true, false, 1, 2, w/quotes, w/o qoutes? ToddWW, I even tried your suggestion prior to this post but it seems...
  4. kevinwilson

    simple SQL statement?

    ...The fieldname is "Active" and is y/n type. this works but retrieves all records, active and inactive. strSQL = "SELECT " & strDBTable & "SysID.*" _ & " FROM " & strDBTable & "SysID " _ & " ORDER BY " & strDBTable & "SysID.SystemID " in the statement below i'm trying to retrieve only...
  5. kevinwilson

    Disabling the mouse wheel

    4321z, Try this... forgot where I got it. Private Sub MyButton_Click() ' Turns the Mouse Wheel Off Dim blRet As Boolean blRet = MouseWheelOFF End Sub
  6. kevinwilson

    Trying to Change field properties

    I have a similar problem where I want to update a fields datatype. My field name is "Tech2Notes" and it's datatype is "text", I want to change the datatype to "Memo". I tried modifying the above syntax but kept screwing it up! I would imagine this is simple to do but I'm pretty brain dead...
  7. kevinwilson

    auto update tables data type via external app

    Tom, thank you. I will concentrate my efforts there. Mahalo.
  8. kevinwilson

    auto update tables data type via external app

    Hello all, Hoping someone can assist in my problem. I have 10 Access applications (front/back end) scattered about the Pacific, each app is the same. I have recently modified fields (data type) in the back end tables and want to field the update via automated script that would update the...
  9. kevinwilson

    Single IE Scroll bar for multi frame page, how?

    Chris, Thank you for being frank, thus far I really haven't had much problems with my frames but I'll explore other alternatives. Thanks again, Kevin
  10. kevinwilson

    Single IE Scroll bar for multi frame page, how?

    Chris, Being a novice at web design I appreciate most replies, even sarcastic ones like yours, but can you at least elaborate on why I shouldn't use frames? Thanks, Kevin
  11. kevinwilson

    Single IE Scroll bar for multi frame page, how?

    Hello, I have a web page (index.asp) that consists of 4 frames pages; top_banner.asp, leftFrame.asp, mainFrame.asp, and rightFrame.asp. I want "index.asp" to display a single scroll bar for the entire page, I do not want the individual pages to display their scroll bars. The following disables...
  12. kevinwilson

    text to decimals

    [ponder]D'oh, thanks for the clarification! Will give that a try. mahalo, kevin
  13. kevinwilson

    text to decimals

    Golom, thanks for the quick reply. I understand the summing portion of your statement, this will help me alot once I can get the text field converted to number. In your second option: Select (Val(Left([TextTime], Instr([TextTime],":")-1)) + Val(Mid ([TextTime]...
  14. kevinwilson

    Format for hrs:mins input

    Gonna give it a try! Mucho mahalo's kevin
  15. kevinwilson

    text to decimals

    aloha all, need some serious help here ...been stuck on this problem for two days now! here's my problem, i have a populated text field within my access mdb that i need to convert to a number field. the text field displays: 24:30, 6:45 (w/out leading 0's), etc., representing the total hours...
  16. kevinwilson

    Format for hrs:mins input

    I have a similar problem and hope someone here can help. My table consists of two NUMBER fields that represents HOURS and MINUTES, where users input total hrs worked on a project ...in many cases hours worked are in excess of 23:59 hrs/mins. I would like to sum the two fields into a HH:NN...
  17. kevinwilson

    Query Multiple Fields

    Scriverb, Worked like a charm, much mahalo's!
  18. kevinwilson

    Query Multiple Fields

    PauloRico, thanks for the quick response. My table design however requires multiple technician fields as there can be as little as one technician or as many as five technicians working a single job. Additionally, for each technician responding to the job there are corresponding...
  19. kevinwilson

    Query Multiple Fields

    Aloha and mahalo to all that respond: Here's my dilemma, I'm trying to query multiple fields in a single table to produce the results below. The following resembles my table (fields are in bold): jobID tech1 tech2 tech3 tech1remarks tech2remarks tech3remarks 1 joe...
  20. kevinwilson

    MDE WOES

    Once again Aloha everyone! I'm encountering the "...unable to create a MDE database" error msg. so of course I can't convert my mdb into mde. I'm using Access 2k. I tried opening a form and viewing the code in VB to compile since that's what everyone recommends however the...

Part and Inventory Search

Back
Top