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 Mike Lewis 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. PaulCooper

    Access embedded auto updating Excel chart does not update

    Hi, I have a splash screen which has an embedded Excel chart. I thought I'd pasted it as auto updating and most of the properties suggest it is but in reality it does not update itself. Do I also need to add code (perhaps to on open?) to force a refresh, or have I missed something basic...
  2. PaulCooper

    No data in unbound text box

    Thanks guys ~ that was quick. Roy ~ yours is the key ~ I'm also using combo boxes and they use .value ~ I simply wrapped it all in one i.e. For intCounter = 1 To 3 If Me("Filter" & intCounter) <> "" Then strSQL = strSQL & "[" & Me("Filter" & intCounter).Tag & "] " & " like " &...
  3. PaulCooper

    No data in unbound text box

    I'm using (trying to!) an unbounded text box to drive a filter on a report. Reports![rptPOI].Filter = strSQL where strSQL is the value in the text box plus a * Entering data in the text box triggers the on_change event (which drives the filter change code) but there is no value to play with...
  4. PaulCooper

    Sending HTML messages from Access

    Thanks Remou, I tried this by sending myself the whole message (obviously this was a portion to highlight the fault) and your right. Pre-sending it does not work, post-sending its OK. Yet another lesson learned! (Test the whole cycle, not just the easy part).
  5. PaulCooper

    Sending HTML messages from Access

    Why does this line of code vBody = vBody & "<a href=""http://eric.greenlnk.net/it/service_storage_info.asp"">Please look here</a>" & " for a fuller explanation <br><br>" 'Now dump the string into the body of the e-mail .HTMLBody = vBody Result in this output Please look...
  6. PaulCooper

    Default, Populated Fields

    Why not use tabbed forms? From (at least) Access 2000 creating tabbed forms is as easy as dragging from the toolbar. Use the top portion of the page for your static data (address etc) and the tabs for your changing data. If you reduce the size of the form design so you can see your forms list...
  7. PaulCooper

    Queries on large database run very slowly

    Thanks PHV. jsteph; .mdb is on the D drive ~ a local drive with about 15Gb spare space. SELECT DISTINCT tblFilesMaster.FileName, tblFilesMaster.Filesize, tblFilesMaster.LastAccessed, tblFilesMaster.path, tblFilesMaster.LastWritten, tblFilesMaster.Extension FROM tblFilesMaster WHERE...
  8. PaulCooper

    Picture Cells

    I agree with Pseale ~ embedded images are a pain, not least because they bloat your database. I store the path name of the image in a field called fPicture and I use a picture container ShowImage. Each record can then point to a) a default picture or b) the relevant picture and this code, in...
  9. PaulCooper

    Queries on large database run very slowly

    I have a largish (3.2M record) database with a couple of 255 characture fields (some full) and some other data. I do have some indexing switched on. Running queries is VERY slow and sometimes I get "running out of virtual memory" error messages. Looking at the system monitor only 11% of the...
  10. PaulCooper

    How to create a timeout to throw users out of the database?

    DaOtH is there a way you can share the .exe and associated .ini file? I guess this is doing what easyit's .bat file does, but including checking within the database (as you previous comments) rather than checking an associated txt file. Although this started with lazy users, I also have to...
  11. PaulCooper

    How to create a timeout to throw users out of the database?

    DaOtH, EasyIt, You both seem to have workable solutions. I cant write .exe's so the BAT solution seems right, although I agree with not downloading a new front end every time. Perhaps the .bat can call the front end and if it fails (mismatched version numbers) the front end "ends" and the bat...
  12. PaulCooper

    How to create a timeout to throw users out of the database?

    FancyPrairie: Both your answers are very helpful, thankyou. The first leads to threads within threads, with information to be mined along the way, again very helpful. I will try your code ~ thanks for posting it. Markgrizzle: I will try an Internet search for your suggestion, just to see what...
  13. PaulCooper

    Setting default value = to last record entered

    Add a field to your table DateChanged type date. Add a textbox to your page with the control source DateChanged. Make this invisible. Name it txtDateChanged. On the form afterupdate add something like txtDateChanged.Value = Now() Everytime the form is changed the [DateChanged] is updated (bit...
  14. PaulCooper

    How to create a timeout to throw users out of the database?

    Hi, I have a database that has a front end and back end. I have some lazy users who do not log out so an access.LockFile.9 is generated which prevents me from updating the code. (I cannot delete this file ~ says someone is using it, does not say who!) It is a major pain to work around folk...
  15. PaulCooper

    How to extract NT File OWNERS name

    Just a simple code snippet then [dazed] I've printed it and will take it to the pub and see if a couple of pints makes it clearer. Thanks for the pointer.
  16. PaulCooper

    How to extract NT File OWNERS name

    I run an Access 2000 database on a large NT file structure overnight. This collects filenames and path data so I can track .avi's, MPG's and large duplicate files. No problem so far ~ works a treat. Does anybody know how I could extract the file owners name which would help in tracking down...
  17. PaulCooper

    Data Entry Initials

    control source =Environ("UserName") works in 2000 ('cos I just tried it) ~ no idea it was so easy. Thanks Paul

Part and Inventory Search

Back
Top