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 Chriss Miller 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 nashman

  1. nashman

    Close Lotus Notes Email From VBA

    Hi All, I've been using code that was posted here to send emails automatically through VBA. Works beautifully by the way, thanks. The only missing item is to close the actual email client. The CreateObject("Notes.NotesSession") does the opening work but I haven't seen anything that can in turn...
  2. nashman

    Updating ASP Page With Frames and ListBox

    Thanks ecwcee. I did just that ( Request.Form ) and it worked. I had tried this earlier but to no avail. I must have misspelled something. Thanks again for your help.
  3. nashman

    Updating ASP Page With Frames and ListBox

    I am really hoping someone can help me out with this. I am new to ASP. I have searched everywhere and I am sure this is probably a simple issue to resolve but I can't seem to find the answer. I have 2 frames. The left frame has a listbox which I want the users to make a selection from. Based...
  4. nashman

    How do I import data from a remote ODBC table into a local MS Access table?

    I have seen a number of questions and requests for how to do this. I was doing a little investigation and found this interesting info on the Microsoft site. Basically stated, through the SQL window of a regular query, you can run the INSERT INTO command using the ODBC connection string that...
  5. nashman

    Simple MessageBox Agent

    Thanks for your reply Pascal...I was afraid that this was going to be the case. I have an Access module that I am using to do this and our IT dept was giving me grief. Looks like I will have to fight my case for Messenger service access.
  6. nashman

    Simple MessageBox Agent

    Hi, I am trying to create a simple MessageBox pop-up from an agent. I want the agent to check all incoming emails as they arrive and if the Subject field matches a condition, create the pop-up message box. I am having a helluva time getting this to work with LotusScript. I have the correct...
  7. nashman

    Append data to Oracle - SLOW

    Thank you both for your responses. TheFitz: Did you shell the command for SQLLDR.exe and call it from VBA ? If so, what did your VBA look like ? jmeadows7: I am unfamiliar with PassThrough queries. Do these work for all ODBC databases or is it restricted to SQLServer databases ? Thanks
  8. nashman

    Append data to Oracle - SLOW

    Hi All, I need some help in figuring out if there is a faster way of appending data to an Oracle BE table. I have an Access database that opens a recordset and reads a field. The VBA code then needs to convert the field data ( which is a series of ASCII characters ), convert this ASCII...
  9. nashman

    MD5 encryption

    Way to go vbsun !!! 2 stars for you. I have been looking for this encryption method for a long time. Thanks
  10. nashman

    Logon Prompt

    Sorry folks, Don't know much about arrays... What would this code look like using Craig0201's comment about "Change every returned array to a variant and replace every call to an enum value with the integer equivalent. I've done this and it works fine."
  11. nashman

    Import objects and Access System Tables security issue

    Hi All, I have run into the same issues where importing the MSysObject table into a blank database provided all of the information required to access my data. There are a number of things you can do to help prevent unauthorized access. Because of the many add-ins available that will provide...
  12. nashman

    need help automating a CICS mainframe job

    I use a similar code but one that does not necessitate the use of the AppActivate command. I have created an initialize module that sets the communication between My Access database and the CICS session. This was, regardless of what I am doing, the send.keys command will work, even if I am not...
  13. nashman

    Write SQL in VBA for rowsource of chart

    One method is to create a combo box on your form for your WHERE clause. Call it txt_WHERECLAUSE. Then create a command button which will change the rowsource for your chart. You can reference your txt_WHERECLAUSE in your SQL statement like this... [Forms]![Your form name]![Your chart object...
  14. nashman

    Unable to output contents of a report to Word

    Take a peak at this thread...there is a link to a site with code that may help you out. http://www.tipmaster.com/includes/refinfo.cfm?w=450&h=350
  15. nashman

    Import from multiple ODBC's

    You can automate the linking of tables from Oracle or any other ODBC database to Access. The simplest approach that I have used is to use the DoCmd.TransferDatabase method from Access. A word of caution here...some databases will require you to still make some kind of manual selection ( for key...
See more

Part and Inventory Search

Back
Top