Search results

I have tested my 2002 setup on Vista and I get the same error message Has anyone found a solution yet? Bizzarly though in some ways not surprisingly My Access 97 runtime does work on Vista!!

It may be due to the Windows firewall. If you right click on the file and go to properties you may see an unblock button. If you do click unblock and you should then be able to oepn the file.

Do you have a solution for Vista?

You could try using the print #1 command and programmically create and then add the text to the file. When you create it give it a .xml file extension. Open "FileName.xml" For Output As #1 ' creates the file Print #1 "your text" ' for each line you want to add close #1 ' closes the file hth John

The proceedure is placed in a module. You need to call the code when the form is updated and you want the number to stick. My system creates a quote assuming the customer is going to buy some products. If they decide not to buy the record is deleted when the form is closed. If they decide to buy...

It sounds like this is the problem you're having. http://support.microsoft.com/kb/150384/ HTH John

Study my post. It gets round the multi user issue and avoids a seperate table for storing the invoice number. Peter's right if you do it correctly you need not store the year as long as you have a field with your invoice date in it.

In the post below I have placed some code which will increment invoice numbers by 1. If your invoice numbers are split into number field and year field You could modify this to look at the max for a particular year and increment by one. If it were null it would start at 1 again...

This will sort it out for you http://support.microsoft.com/kb/837150

My invoice form has a button to create the invoice. This checks to see if here is a value in the InvoiceNo field before it continues or not.

What I've done is create a field in my invoice table InvoiceNo - Set Indexed to Yes No duplicates and then use the following procedure to create the next number. Works in a multiuser enviroment too HTH John

That depends on your usage. Look on the prices and licensing page. My customers are on pay as you go £25 for 300 addresses is cheap enough

They have some code samples which may help youhttp://www.postcodeanywhere.co.uk/developers/samples/#access I use their active x contorl on my form and populate my address fields. I install their desktop software but don't open it at all. Check out their code in the samples also make sure you're...

Try http://www.postcodeanywhere.co.uk There charges are far less than the royal mail's. They also provide sample code etc. You can intergrate it into you're app completely. I use it very successfully in a number of locations. :)

I found the above code worked to an extent but won't read everything in a more complex document. I have played about with the code from the MSDN library and got the following to read the whole document. It still needs refining but it gives me the data output I need. The xml File <?xml...

Yes Bee I have used it in numerous offices and it has made a difference every time.

I have found this helps on all systems Win2k and above except WinXP Home http://support.microsoft.com/kb/150384/

Thanks KernelK I'll work my way through this. It looks very interesting. I'll see how I can apply it. Thanks again for your help John

Kernelk No I havn't succeeded yet, there again I havn't had the time to do as much with it as I would have liked but if you have anything to share I would be most grateful. John

Thanks KernelK I'll have a look through these, I am using the code in your top link to read the tags.. no Node_Elements but had completely overlooked their mention of Node_Attribute. I'll work through this and let you know how I get on.