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

    Hoe To allow multiple users to view queries and reports

    Good Afternoon: I need help allowing more than 2 people to be the in the db at the same time, and view the same reports and queries. Please offer any suggestions. Thanks
  2. GessTechie

    Import 1 cell from Excel into Access

    Good Afternoon: I am trying to import a single cell from an Excel spreadsheet using an Access query. I can import the entire spreadsheet, but cannot separate the cell I need. Any help is appreciated.
  3. GessTechie

    Reading Variable Length Text strings

    Good Morning! I have a text file that I want to separate into individual fields in Access. However, the text sizes vary in length and they do not hold their position within the text string (I imported the text into 1 field). The import text wizard actually screwed me more than helped. I have...
  4. GessTechie

    Using Form As User/Password Validation?

    I asked this question a few days ago.... Here is how I solved it... Private Sub Command18_Click() On Error GoTo Err_Command18_Click Dim stDocName As String Dim stLinkCriteria As String Static UserId Dim Text11, Text13, Text19 If IsNull(Text11 =...
  5. GessTechie

    Update and Append Query will NOT update

    I changed the EndDateTime variable and I now read the Now() from a text box in the form. Still no update...... AAARRRRGGGGHHHH!!!!
  6. GessTechie

    Update and Append Query will NOT update

    I inserted the two lines of code to turn off/on the warnings, but the table isn't updated. Still baffled.....
  7. GessTechie

    Problem Updating Table from docmd.runsql

    Good Afternoon... I want to update a table based upon a docmd.runsql command from a formm The table has two text field, and two date fields, as well as a primary key. The form runs great but when it attempts the docmd.runsql statement, it says 0 records to add. Here is the code...
  8. GessTechie

    Update and Append Query will NOT update

    Good Afternoon... I want to update a table based upon a docmd.runsql command from a formm The table has two text field, and two date fields, as well as a primary key. The form runs great but when it attempts the docmd.runsql statement, it says 0 records to add. Here is the code...
  9. GessTechie

    User Log Table

    Afternoon All.... I have a User ID table with user ids and passwords. I pass the user id from a gateway screen to another form as a static variable. Now, I want to update a user log table with the user id from the gateway screen and Date and time the user started the form and the date and...
  10. GessTechie

    User ID & Password lookup

    Hello.... I have a form that I use as a gateway to a database. The form asks for a User ID and Password that I have stored in a separate table. On click of a button, I want to determine if the user entered the correct User ID and Password based upon the User ID table. If they have, it...

Part and Inventory Search

Back
Top