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!

Recent content by gd

  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>
See more

Part and Inventory Search

Back
Top