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 bkrike 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: marksnow
  • Content: Threads
  • Order by date
  1. marksnow

    Using Shell cmd /c

    Hi I have some code in my DB that opens up a file using the following code: 'Opens the file. stAppName = "cmd /c " & Chr(34) & fileName & Chr(34) Call Shell(stAppName, vbHide) Now the above works perfectly well when opening a file on my C:\ drive even if there are spaces in the directory...
  2. marksnow

    Copy all records from a from to the clipboard

    Hi I have a sub form currently that is in datasheet view and I want to setup a command button that when clicked will copy all the records from the sub form into the clipboard. I am essentially wanting to replicate going into the subform and pressing Ctrl + A (to select all records) and then...
  3. marksnow

    Hosting the backend remotely

    Hi Does anyone know of way/if possible that you can host the backend on the internet/remote machine and have the front end connect to it. What I am trying to achieve is that we have 3 offices and we want them all to share the same backend. Currently all 3 offices have their own backend. The...
  4. marksnow

    To Do Items 1 day early

    Hi, For some reason when I enter To Do items they show up on the calander a day early. Everyone in our office is experiencing this. Any ideas? Regards Mark
  5. marksnow

    displaying all records in this query

    Hi I have a form which displays some of the information contained in a quote. The problem is that if there is no description entered for the quote it won't display the quote record at all... The SQL I have is: SELECT tblQuote.Date, tblQuote.QuoteID, tblQuote.Status, tblCompany.CompanyName...
  6. marksnow

    The recordset is not updateable but works in places???

    Hi all I have had a look at past posts on the above issues but have not been able to resolve my issue. I have a form which displays information on sales orders (frmSOBook) and works fine. I have another form (frmListSo) which brings up a list of sales orders which you can then click on to and...
  7. marksnow

    Sendmail in VBA to Lotus Notes

    Hi everyone I have been successfully in getting some code to work that basically sends an email through lotus notes and saves a copy of the email in the sent items folder. My problem is that I want some code that will basically open up a new email and insert the email address, subject and...

Part and Inventory Search

Back
Top