Search results for query: *

Hi, I'm having a very strange problem creating a report, should be simple just adding fields using the wizard step by step, but I get different results on different computers - can't see what is set to cause a difference! I created a task to teach the creating of a report, I added lots of...

Hi, thanks for your reply - I tried as you suggested and still no joy - File not found, I even tried with the IP address of the server! Any more ideas?! Thanks!!! ben-robinson.com

Hi, I've have an ASP app running in IIS6 on Windows 2003 One of the things it does is to look for a file on another server, simply using the line: fileSys.FileExists("\\server\folder\file.mdb") This was working fine, but recently it started to return False, it now constantly returns false even...

Hi, I have a database in Access 2007 with an OLEObject column containing a zip files. All I'm trying to do is open the zip file so the content can be viewed. I have created a form which shows the object, I can see the icon, when double clicked the file opens and the object becomes greyed out...

Many thanks - that forced me to look harder at that, I had come dangerously close to it - but hadn't quite understood (not really done very much vba stuff!!) As a result I found the drop downs at the top of the vb editor, which showed me all the available event - in actual fact, I found...

Thanks for your response, unfortunately - same - instant lockup!?! http://www.ben-robinson.com

You could start a function running on Mouse Down, and stop it on Mouse Up, something along the lines of: Dim buttonDown Sub cmdButton_MouseDown() buttonDown = True myFunction End Sub Sub cmdButton_MouseUp() buttonDown = False End Sub Function myFunction() ... If...

Hi, I'm trying to embed a web browser into a form in access, the basic priciples have worked, I've added a "Microsoft Web Browser" active x control, called it ie and used the following code to load a page: ie.Naviagate "http://www.msn.com" All good, but I want to know when the page has loaded...

If the page is refreshing it means the form is being submitted. Not sure why this would only happen in safari? To stop the form being submitted you would so something like this in your form tag: <FORM NAME="f" onSubmit="goFunction(); return false;"> goFunction() being the code that will run...

As ever missed the simplest solution and when for the over complicated!!! Server.HTMLEncode is perfect! Many thanks! Ben. http://www.ben-robinson.com

Hi, I'm having difficulty finding a solution to this problem, any help would be wonderful!! I have some text that has loads of non-ascii characters in it - and I want to take them out, and have found the following code which works lovely!!: Dim newDesc Set objRegExp = New RegExp...

I am work through a major document in Word. Having finished the majority of typing I am now inserting a large number of cross references across the document. I have a major irritation when doing this that is literally driving my up the wall! I would be very grateful if anyone could help!!! I...

I've put that extra line in, but get a error on the new line (with the squiggly line), the tool-tip tells me that it is "not accessible in this context because it's private" any ideas? I still don't understand that the identical code, but without parameters works fine, time after time -...

Thanks for your reply, just got round to trying it. I forgot to mention that I already have the line Dim Reader As System.Data.OleDb.OleDbDataReader I moved this to the header of the form, incase that was the problem, but nothing changed, so I left it there. I tried using your SqlClient...

I very new to this, so excuse any ignorance, but I have the following problem! I have the following code: OleDbConnection.Open() selectResults.Parameters(0).Value = startDate selectResults.Parameters(1).Value = endDate Reader = selectResults.ExecuteReader() While Reader.Read() ... End...

Thanks for that - it at least stopped my trying! The problem is I want an If field that displays some text when true and displays nothing when false - OK, but when false, I can't find it!! Which is where hidden text comes in - I thought. Anyway - I reply now, because I have solved the...

I have a If field in word, one of the results is text formatted as Hidden, but it does not display unless I am viewing the field code. Is it just not possible - or is there a solution to this? Thanks for your help Ben

Fair enough! That's kinda what I thought, just clutching at straws OWA is a good idea, and I had considered it, just does not work like the real thing! Important when I'm teaching - and then testing using simulation exam software! Thanks for you help Ben. http://www.ben-robinson.com

Thanks dennisbbb, that's pretty much what I wanted. Its still a little complicated though, having played with it it seems that you need to create the profile via the control panel so that you can set the security level correctly, I think this is a little complicated for my students to...

I tried that, maybe I'm getting something wrong, but there is nowhere to enter a password, so if I try to open the new profile I get: "Unable to display the selected folder or item. You do not have permission to log on" http://www.ben-robinson.com