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

  • Users: gd
  • Order by date
  1. gd

    Postoffice Icon does not exist in control panel

    does anyone know how to get the Postoffice icon to show up in the control panel.  I reinstalled Office 97 and now it's gone.
  2. gd

    Remove trailing characters from a string

    Thanks to the both of you I new it had to be something really simple that I just wasn't thinking of.
  3. gd

    Remove trailing characters from a string

    Does anyone know of a function or other solution to remove a set number of characters from the end (right) of a string.  The string as a whole has no set length.  the only thing that is consistent is the last 3 characters.  I wish to remove the three characters and...
  4. gd

    Sendkeys Statement produces strange results

    this is the code where the NumLock is being toggled:<br><br>Private Sub Form_Resize()<br>SendKeys &quot;{F9}&quot;, False<br>End Sub<br><br>Here is the code in the other place where the Sendkeys is being used Here the NumLock Blinks but stays on:<br><br>Private Sub Form_Current()<br><br>If...
  5. gd

    QUERY RESULTS NOT RIGHT- PLEASE HELP

    Look at the query in design view.&nbsp;&nbsp;For each column in the query there should be a line for criteria.&nbsp;&nbsp;The line below that has an &quot;or&quot; label.&nbsp;&nbsp;Make sure that both criteria for &quot;Date shipped&quot; and &quot;Status&quot; are entered on the criteria...
  6. gd

    Sendkeys Statement produces strange results

    I'm using the following line of code with the desired results hopefully a refresh on whichever form happens to be open:<br><br>SendKeys &quot;{F9}&quot;, False<br><br>Seems to work great however it also toggles the NumLock.<br><br>Anyone have ideas as to why this may be happening?
  7. gd

    Can't import files into access from excel

    Ok I should be able to import an excel spreadsheet into access by using the File...Get External Data...Import...<br><br>Problem1: Excel is not one of the file types I can import<br>Problem2: When I go to add/remove programs and try to add excel as one of the import items the check box is...
  8. gd

    Duplicate an existing records data into a new record

    Ok I see how this could work and I'll try it but before I do, one question.&nbsp;&nbsp;The recordset that I open it should be a query that selects only the record I want &quot;copied&quot; yes?<br>
  9. gd

    Duplicate an existing records data into a new record

    I need to know if there is any way to take the data from an existing record and create a new record with the exact same data.&nbsp;&nbsp;The only info that would change is the primary key which is an autonumber field.<br><br>

Part and Inventory Search

Back
Top