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 TouchToneTommy 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. claytonjgordon

    Refresh form when opened for edit

    This is what I want to happen. The form opens and several fields are manual entry for the user. When its all filled out correctly, they hit a save type button that saves the form and sends it to the next level to continue. When it gets there, the status changes from "new" to "escalated" and...
  2. claytonjgordon

    Creating and editing a button through automation.

    I want a button to send an email with a button in it that adds the db to the user’s workspace and opens up a form in edit mode. I can create the email and I can create the button manually, but I can't seem to find out how to have that button created inside the email through automation i.e., not...
  3. claytonjgordon

    LotusNotes SQL Driver

    Does anyone have a link to download the latest LotusNotes SQL driver for quering Lotus Notes tables via SQL through an ODBC connection? We updated to Notes7 and our old driver isn't working anymore and I can't seem to find the driver on notes.net Dominus Nihil (Master of Nothing)
  4. claytonjgordon

    Can't goto next record

    I created a db with an access front end and three SQL back end tables. The users enter information into the access forms and its supposed to write to the SQL tables. On one form, this works perfectly: You hit a button on a menu form at it pulls up the data entry form as a new record. Private...
  5. claytonjgordon

    Get database path

    Is there a command that will provide you with the path of your database? I want to use the transfer spreedsheet command which requires that I provide the path of the file I'm transferring. The problem is that there are multiple front ends and the table is located on each front end. After the...
  6. claytonjgordon

    Importing Excel table into Access via button

    I built a database on access that uses a SQL server for the back end tables. That part works great but the business group wants to add a new feature that allows them to append records onto one of the tables from Excel spreadsheets. I'm thinking of doing this in two parts. 1) import the...
  7. claytonjgordon

    DLookup using text criteria?

    Can you use two text fields in the criteria section of the Dlookup function? I'm trying to create a feature where it takes the user's network ID using Me.TempID = Environ("username") and then compares it to a table where I have various users which I want to have exclusive access to a...
  8. claytonjgordon

    Passing unbound field data from Form to Continous Form, how do you

    I checked the FAQ and ran a few searches and couldn't find anything matching my issue. I have a simple form that has the user enter an account number and date into unbound fields and then push a button. I need assistance taking the values of these two fields and passing the data into two...
  9. claytonjgordon

    Bocking Duplicate Requests, How do you

    I would think this would be a common request and thus already covered in some thread or another but I've been looking for a few hours and didn't see any. If this has already been covered somewhere that you are aware of, please point me in the right direction. Here goes: I created a database...
  10. claytonjgordon

    Database version update feature.

    How do you create a database update feature that updates the various front ends to the latest version? To clarify: As a noob, my normal method for distributing my database is to send them the front end via Email attachment. Every time I change the database I need to send everyone a new...
  11. claytonjgordon

    Adding attachment from Ole Object to Body of Email (LN) via VBA

    I'm trying to take an attachment saved in an Ole Object field on my main Access form and attach it to the body of an Email (using Lotus Notes). I was write the code to send the Email but I must not be doing the Attachment part correctly because it just shows up as something like |$| instead of...

Part and Inventory Search

Back
Top