Recent content by Mark-BES

Many thanks for your input, however I am experiencing difficulties. Please see the attached. This is one example of what I have tried...

I have a small stock control database built around a Northwind example. I am trying to build a query that displays items low on stock. On my products form I have: Min Order Level field (stored value) Units on Hand (calculated value from products subform (units received-units sold)). Q1: Do I...

Don't hold me to this but I think you need to look at making an "Update Query"

I don't know whats happened but it now seems to be working! Weird!! Thanks for all your help Oldsoftboss and RuralGuy!!

Thanks RuralGuy but thats not it either. I think I have found it though! On my form FrmProducts, I have a subform called "FrmProducts Subform" This appeared to flicker when the error occured. I created a copy or the original as a test and deleted the subform in question. It then works Ok! I...

Thanks fr the reply Dave. Unfortunately the suggestion did not work. I tried troubleshooting with my very limited knowledge. By commenting out the following: Set rst = Forms!FrmProducts.Recordset.Clone rst.FindFirst "[ProductID] = " & Me.SearchList The error did not occur - Ok, the the code...

Hi, I am trying to integrate the excellent search facility (search multiple fields example) posted on this site by OldSoftBoss http://www.access-programmers.co.uk/forums/showthread.php?t=123219&highlight=advanced+search When I re-create it in my db, it all works ok until I double click on the...

Take my advise - (I had to learn the hard way). Spend some time looking at the sample database's shipped with Access 03. Look at how they work both to the user and behind the scenes - this WILL take more than 5 minutes. Do not start designing in access yet. Sit down with a pen and paper and...

Try this... Hi, If you want an installer program try this http://www.clickteam.com/eng/installcreator.php Unlike most, its not hundreds of pounds and it is simple to use (wizard based) I have used it a number of time and its pretty good. You can download a free fully functional version or...

I Know, I know :D I remember saying it at least 3 year ago ! I do not like VR for that very reason :)

I know It does not sound quite right :) but it is easier to use (and requires less training) than the well known/popular IBM/scansoft ViaVoice. I personally do not like voice recognition systems. Despite being around for years and years, they are still in their infancy. Only now can PC hardware...

Hi, I work in the voice processing industry (8 years) for some of the largest dictation manufactures. If you are going to use voice recognition, use Dragon Naturally speaking 9 http://www.nuance.com/naturallyspeaking/ Its about the best you will get with existing technology Hope that helps.

Gemma, you were spot on! It now works. Thank you! after typing "msoFileDialogFilePicker" into google I found this on another forum: Press Alt+F11 to open the VB Editor. In that window, choose menu items Tools -> References..., then look down the list for Microsoft Office 11.0 Object Library...

Hi, I am a vba novice and in need of expert advise/suggestions: I have a products database. I wanted to show an image of the product (that users can update) on the form. The example used in the Employee form of the Northwind database fits my needs perfectly. I have copied/pasted all the code...

I have had a similar problem in the past. It was due to the PC not finding the printer. If your on a network, try setting another printer as your default and see if that makes any difference.