Search results for query: *

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

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

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

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

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

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

I have a form, with a sub-form which works well. When I add a new record, and add a new customer, (the first field to be entered) the sub-form does not update unless I move off that record and move back. I am trying to make this happen by code. (The sub-form contains data that would help...

I have a database with two front ends. 1st front end is with the back end and is used by me. I copy files to a directory (below the database) and then link them via a hyperlink. (Table is data type hyperlink, right click on form, select [hyperlink] [edit hyperlink] and [browse for file]...