Recent content by PaulCooper

bump :-) Have I beaten you?

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

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 " &...

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

Bump: DaOtH ~ any progress? Paul

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).

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

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

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

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

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

Bump: DaOtH ~ any progress? Paul

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

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

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