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 SkipVought 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. stburkeuk

    Sneaky way to view Body of an email without triggering return receipt

    Thanks, Given that I would not be able to design the view to show Unread mail can I get it to show the contents of the Inbox?
  2. stburkeuk

    Send MS Access report to Lotus Notes

    To send an access report via Lotus notes in the past I have exported the report as a word or Excel document and then using code picked up the file and sent it as an attachement to a memo. the code is on many threads an example being http://www.tek-tips.com/viewthread.cfm?qid=922205
  3. stburkeuk

    Sneaky way to view Body of an email without triggering return receipt

    I would like to take this thread one step further if I may, I have today with a little playing got to the same position as above - using an agent to set the returnreciept value to 0 from the Action menu, I would like to be able to do this on all incoming mail but we do not have the rights to...
  4. stburkeuk

    Using dao.recordset to Copy a record with Autonumber

    Hi, I have a multi-user database (access 2000 with most users using XP). Data is entered into a main table with an autonumber reference. There are then 3 nested sub tables that use this reference as part of the Key. I currently have an SQL duplicate function in place on the main table's...
  5. stburkeuk

    Automatic "_Backup" file?

    WaltW, Did you ever get to the bottom of this problem? I am experiancing the same issue - it is definately the system that is createing the backup - Access or the Server I don't know but the _Backup Database have the users ID in the Network details so I am suspecting it is Access. Any...
  6. stburkeuk

    Send a report via Notes

    FP - I have tried your suggestion but as with above all I am getting is the litteral - "<HTML><HEAD></HEAD><BODY><P> The Print Shop has <b>received</b> an order form </P></BODY></HTML>" in the Mail text. Is there any settings in Lotus that may need to be changed? or is it the way we are...
  7. stburkeuk

    Send a report via Notes

    Kev, To be honest - I would love to know!! I use the same method to send out a realy long mail with Deadlines in it that we would like to highlight in some/any way but have not found a solution to the problem. If anyone know please let us into the secret.
  8. stburkeuk

    Reading User info from Access LDB file with API Calls

    ArkM, Thanks, that was the information that I could find - after being told that it was possible. However the previous responce contains a link to the relevent MSDN site. There is a DLL "Msldbusr.dll contains functions that enable you to do the following: View all computers that have logged...
  9. stburkeuk

    Access XP - Error Message 3734 - Database blocked

    Lupins, thanks for your thoughts - that is certainly one options I could use but within our organisation we are discouraged/unable to distrubute applications to local PC's. I also didn't want to create lots of copies on the shared server (due to storage capacity problems) if there is another...
  10. stburkeuk

    Access XP - Error Message 3734 - Database blocked

    Could really do with some assistance/Advice on this one. I have a very simple database - Switchboard, two tables, one form linked to one table. When a user has the switchboard open multiple users can access the database, When the form is open - the database is locked by the passive Shutdown...
  11. stburkeuk

    Send a report via Notes

    Kev, Below is some code that I have inherited and modified for my purposes. I am not sure where it originally came from but have seen several versions on other sites. I use this code to pickup an attachement that I have created by exporting a report/query. I hope it helps. One point - on our...
  12. stburkeuk

    Reading User info from Access LDB file with API Calls

    I understand that is is possible to use api calls to read the lbd file for access databases to identify who and which computers have the database open, Can anyone provide me with the starting point on how to retrieve this info. Thanks
  13. stburkeuk

    Pros and cons of the &quot;OpenCurrentDatabase&quot; VS &quot;Shell&quot;

    Hi, I am building a menu system in an intermediary database to control the way users open a selection of other databases. I want to open one of the databases exclusivly if the data needs refreshing, once the refresh is complete close the database and open as Shared again. The method I am...
  14. stburkeuk

    How do I highlight duplicate field values on a form.

    here is an example of one I use Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) Dim intCount As Integer intCount = DCount("[txtMarket]", "tblITSMarketInfo", "[txtMarket]='" & Me![ctlMarket] & "'") If intCount > 2 Then Me.lblMarketCount.ForeColor = vbRed Else...
  15. stburkeuk

    How do I highlight duplicate field values on a form.

    The place to do the formating is in the Detail_Format event on the form (or if your controls are in a Header/footer then in the respective _format event.) I have used this previously to display a comment if certain criteria are met within the record. The principle would be the same - I have...
  16. stburkeuk

    Stock control

    If you create a query, link both tables together and select the Stock details from the first table and the Sale details from the second. Then using the 'Total' options on the query form (accessed by the Sigma icon on the toolbar) get the query to "sum" the items in the Sale details table and...
  17. stburkeuk

    Having a Field visible in Report Preview but hiding on Printout

    Thanks for the clue as soon as I read it I was coding in my head in preperation for work this morning. I setup a Boolean variable, When the user selects the PrintPreview commands on the form it activate the following code:- boPrintpreview = True ' To suppress the visible property of the...
  18. stburkeuk

    Having a Field visible in Report Preview but hiding on Printout

    We have a database that contains confidential information. I have been requested to supress the printing of three feilds on a Access 97 Report but to have them visible on the PrintPreview - much the same as the property on Forms that allow a control to be visible on Screen only/Print only or...
  19. stburkeuk

    Replacing Excel Pivot and MSQuery connection sources using VBA

    Got there - but this has created another question. I tested the method using a shorter path to the Database (c:\) and it worked. I added the Full database path back in but left the DefaultDIR as c:\ and it still worked. However if I add any directories to the defaultdir path the method fails...
  20. stburkeuk

    Replacing Excel Pivot and MSQuery connection sources using VBA

    I have got the SQL out of the .sourcedata array sdarray = .SourceData For i = LBound(sdarray) To UBound(sdarray) strSourcedata = strSourcedata & sdarray(i) Next i wkDestination.Cells(r...

Part and Inventory Search

Back
Top