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

    Input mask to include year and an auto number?

    I have inherited a table that includes a text field called "UTC #" Currently, for data for this field is manually entered in this format: Four digit year + an ascending three-digit consecutive number. Example: 2002-159; 2002-160; 2002-161 First, I don't know if it is possible...
  2. kdowney

    Command Button to Find Text Within a Date Range

    Sorry for being so dense, but I'm still not sure I'm understanding this code. for "strField" ----- I want this search to work on ANY text field on my form ..... if the cursor is in a field, I want the search to be perfomed on that field. I think what you're telling me is that I need...
  3. kdowney

    Command Button to Find Text Within a Date Range

    Sorry for being so dense, but I'm still not sure I'm understanding this code. for "txtFieldOnForm" ----- I want this search to work on ANY text field on my form ..... if the cursor is in a field, I want the search to be perfomed on that field. I think what you're telling me is that I...
  4. kdowney

    Command Button to Find Text Within a Date Range

    I added the code you sent, but got a compile error. The first place Access stopped was at "txtFieldOnForm" Any suggestions? Here's what my code looks like now: ****************************************************** Private Sub Find_Record_With_Date_Range_Click() On Error GoTo...
  5. kdowney

    Command Button to Find Text Within a Date Range

    OK, my knowledge of VBA is EXTREMELY limited, and I need help, please. I have an existing database form where a command button already exists that searches for data on any given field. Here's the "event procedure" text that shows up for the "on click" properties (I didn't...
  6. kdowney

    Make Table Query for Last Record Entered

    I need to export data to an MS Word mail merge format. I'm assuming I need a make table query; the data from which I will then export. Because of the nature of the data entry (sometimes one record entered in a day, sometimes more), this needs to be done one entry at a time. I can create a...
  7. kdowney

    Macro runs a Make-table query - How to answer "Yes" every time

    I have a number of macros that run make-table queries and then display a report basedon those tables. After the first step, which opens a query, Access prompts me that the existing table will be over-written, do I want to proceed. How to I incorporate a step to answer "YES" to this...
  8. kdowney

    Specifying Data Type in Query

    Help!! I'm having trouble with a created field in a make-table query that is creating the wrong data type! The statement in the query is: Pick-Up: IIf([ES]<[Forms]![Form1]![Text0],IIf([CAL]<>97,IIf([CAL]<>52,&quot;1&quot;,&quot;&quot;),&quot;&quot;),&quot;&quot;) So, the query looks for a...

Part and Inventory Search

Back
Top