Search results for query: *

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

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

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

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.

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

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