Search results

thanks pat, I'll give it a go

thanks for the reply I can do what you suggested but the secratary cannot [she's not very technical minded]. I was just looking to see if anyone had actually coded a button that would just send the co-ordinate from an access query to mapinfo, open it, display the map/layer in question and then...

Hi Guys can't quite seem to find what I want so I thought it would be quicker to post. how would i go about sending a Map Reference from access to mapinfo? we have a new secratary and I would like for her to find a location in the database table, press a button on a form which then opens...

yes - thats what i'm thinking thanks anyway

I seem to be answering my own question. further investigation has takem me to the reference library in VB. my Access 2003 is running Microsoft Access 11.0 object library while those using Access 2000 are running Microsoft Access 9.0 object library. this is the only difference i can see and...

further update i have successfully just printed off my report from another computer on the network on a machine running Access 2003. it would therefor appear to be a problem between different versions of Access - even though i have saved the database in Access 2000 format.

i am now geting an error message 3001 - invalid argument. this error message does not appear on my computer but on other computers trying to print out the report. the network database works on my computer but when used on anybody elses computer will not print a report based on a query with an...

no everything has been transfered from the C drive to the network. The secratary can do a search on the database which is on the network and it shows her the results, images as well. the problem occurs when she tries to print the results out - reports with no images yet they appear on the screen?

I'll try to be to the concise and to the point because this problem is doing my head in. I'm using - access 2003, network printer, screen resolution of 1280 x 1024 secratery is using - access 2000, different network printer, screen resolution of 1024 x 768 I have created a database on my C...

thanks the data is stored in a table but i did try what you suggested above and everthing was fine on the reboot

thanks for the reply the answer was to look up the '.value' and '.oldvalue' actions and code my text box so that the afterupdate event of the 'category' field was to place the old value in the text box of the 'old category' field. Me.[old category].Value = Me.Category.OldValue

hi guys i have a main form and a subform. on the main form i have a field called 'category' [numerical] and on the sub form i have a field called 'old_category' [numerical] what i want to do is if i change the 'category' field from 1 to 2 i automatically want the old value of 1 stored in the sub...

hi i had the same problem. what I did was create a Query By Form. the output was a form based on this query which the report was based on. alternatively just base the report on the query by form [QBF]. one thing you should remember. if your image is 250kb or above you will have problems printing...

hi the code above works with access 2003 if i change the line: Set objXL as New Excel.Application to Set objXL = Excel.Application however it overwrites the same cell in the excell worksheet: .Cells(2, 1).Value = Me.txtXl how would you make sure that the text you export from access goes into...

i have a grave memorial database with over 12,000 images [externally stored] and a report which has 2 subforms based on a QBF. one of the sub forms is an image. so for each query the report will only import 1 image and then print. the image to import was 300kb but if i wanted to print over 30...

isloaded exactley what i was looking for cheers

thanks for the reply but the true statement does not work any other ideas guys?? thanks

hi guys sorry for the silly question but i'm banging my head at the moment when i close a form i run a requery on another form. But if that other form is not open then i get an error massage. Private Sub Form_Close() Forms!memorial_search_results.Requery End Sub i have tried changing the...

thanks for the reply KeithG where would i use this code? below is the code i'm already using with 2 unbound text boxes called "addressline1" and "postcode" Private Sub Command32_Click() If Not IsNull(Me!addressline1) And Not IsNull(Me!postcode) Then Application.FollowHyperlink...

found the answer if anyones interested if you follow the link above and the associated coding and substitute this line for the google code "http://maps.live.com/default.aspx?where1=" then it will open live search whic his a much better aerial map then google