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!

  • Congratulations John Tel 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: Mke85
  • Content: Threads
  • Order by date
  1. Mke85

    VBA, SQL to select and then delete records

    Good day all, Hoping for some help develop a vba sql statement within Access. This is what i'm trying to do: I have a query which identifies records that are present in one table [TRACKER] and not in another [CF]: This is the sql statement from the design view: SELECT DISTINCTROW Tracker.CF...
  2. Mke85

    Search as you type

    Hello, I have a problem here that I can't quite figure out as I'm no VBA expert. I have setup a search as you type engine on a form and it is currently working but the I cannot type any spaces to search for multiply words. Maybe I have approched this incorrectly from the start but here is my...
  3. Mke85

    Store File or Folder Location in Text Field

    Good Morning, I am attempting to store a file or folder location in a text field from a dialog box. I would like the ability to choose lets say a .pdf file and store the file path in a text field or just choose a folder and store that folders file path in a text field. Here is my code so far...
  4. Mke85

    Advanced Error Handling

    Good Morning All, I have an error handling problem here that I can't quite wrap my head around. What my code does so far; When the cmdView button is clicked, I have used various fields to compile a string which is used to open a pdf file directly in the main Electronic Pub directory. Error case...
  5. Mke85

    Search While Typing Value Errors

    Good Morning All! I have come up with some code here to perform a "search while typing": Private Sub txtSearchDescription_Change() Dim SCriteria As String SCriteria = "(CFTO." & Me!cboSearch & " LIKE '*" & Me!txtSearchDescription.Text & "*')" Me.Filter = SCriteria Me.FilterOn = True...
  6. Mke85

    Auto Tab Control Based on If Value is Present

    Hello! Having troubel figuring this one out. My main form is called "Loans". Within that form I have a Tab control called "LoanDetailsTabs". Tab one is called "IndividualItemsLoans and has a subform called "Loandetails. Tab two is called "DeployableKitsLoan" and subform called...
  7. Mke85

    Access 2003 Left join between a Table and Query - Unable to select entrys from combo box

    Hello! I have been beating my head off the table on this one and can't seem to come up with a work around or figure out why this is happening. I am some what new to access databases but here is what I am trying to do. I have 3 tables which store information about Radios, Laptops, and Audio...
  8. Mke85

    CallPilot Voice Menu - No Response Problem

    Good Day All, I am having a bit of a problem with a Callpilot voice menu I have built. The menu start with an annoucement block and from there it proceeds to a menu block. The menu is setup to allow for three retries after no response. Once those three tries are up, it should proceed to a...
  9. Mke85

    2 Digit Conference on M3904

    Hello All, Help is greatly needed with this topic. I am trying to tie a m3904 into a radio system. I need to give the ability to conference a normal phone line to a radio channel. I have setup the route with a acod of 61 which then grabs a tie trunk to a radio. When I try to conference a...

Part and Inventory Search

Back
Top