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 strongm 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. KMdouglas

    controlling order of execution

    Here is the full code for the event ============================================================ Option Compare Database ----------------------------------------------------------- ''Subroutine to create the pipe delim file from the 9000 using text box input Public Sub createpsv(client_name...
  2. KMdouglas

    controlling order of execution

    I have an on click event the calls three separate subroutines, subA subB and subC. I need to make sure that subA ends before subB beging, and subB ends before subC begins. Currently, when running the on click event all three subroutines run simultaneously with disasterous results. Does anyone...
  3. KMdouglas

    Voice and Data over one CAT5e wire

    I am new to an office that shares a single POTS line with five phones connected to it. We also have one PC with a cable modem, and 4 pc's with no internet connection. I did a little digging into the walls and found that the phone extensions are all wired with CAT5e wires, using only a single...
  4. KMdouglas

    ASP Form and MySQL

    Answered my own question. I checked the option "Don't Optimize Column Width" on the MyODBC Data Source I am using and can write to the db with no problems. Kevin M. Douglas kevin@easternresearch.com http://www.easternresearch.com
  5. KMdouglas

    ASP Form and MySQL

    Using Frontpage, I am tying to create an asp page with a form for inputing data to a MySQL db. Things seem to be working except for one curious problem, records entered with a length greater than a record already established in the database are not stored. For example I have a TEXT field...
  6. KMdouglas

    Select top X records in a query

    I have a table from which I want to select the X most recent entries. Usually this is not a problem, I can set the query to select the top X records. My problem is that I want to select more entries based on the number of records in the table. Specifically here is what I want. 1 to 6 records...
  7. KMdouglas

    Applying Filters to Controls in Subforms

    I have a combo box (cboStudyCode) in a subform (named ProductionSubform)that runs off of a query. The Query has two fields JobNumber and Study Code The criteria for this query is taken from the input of a text box (txtJobNumber) on the same form. [Forms]![ProductionSubform]![txtJobNumber]...
  8. KMdouglas

    EXPORTING .CSV WITH FIELD NAMES

    I am trying to export a table to a csv file with header names. I have one field which is named "FILE #" When I export to csv (or Excel for that matter) the name of that field is changed to "FILE ." Does anyone know why this happens, and what I can do to have the field name...
  9. KMdouglas

    DAPs and Frames

    In a data Access Page using frames I can filter records for viewing purposes. I would like,<br> however, to set a value on the target page based on the source frame. When<br> adding a new record, the field in the target should be set automatically to<br> the choice in the source frame. Is this...
  10. KMdouglas

    Using frames to set value of New Record

    Using frames I can filter records for viewing purposes. I would like,<br> however, to set a value on the target page based on the source frame. When<br> adding a new record, the field in the target should be set automatically to<br> the choice in the source frame. Is this possible? If so...
  11. KMdouglas

    Weeknum Function in Access

    I need to find a way to automatically caluclate what week of the year a date is contained in. Excel allows a WEEKNUM function to do this, and according to Access Help, access should too. However, when I try to the use this function I get a &quot;Undefined Function&quot; message. Could someone...

Part and Inventory Search

Back
Top