Search results

Sorry, I cant send you a copy of the database due to the agreement I have with the company. I tried to break it down and remove everything except the form but it is all interlinked and isnt really practical :(

Same thing hapens as before. It starts as showing '1 of ' then the dissapears when the record is changed :s Missinglinq, I pasted that code into the VBA and it gave a few errors when I tried to open the form

Hmmm, when I add that piece of code to the Control Source property for the text box it gives me an error telling me I cant assign a value to that box. Then when I delete the code from the VBA it gets a bit buggy on the form page. It comes up with '1 of 1' then when I change record it completely...

That code is much better, thanks. One small problem though. When the form is initially opened it appears as '1 of 1'. When the 'Next Record' button is pressed it then corrects itself to '2 of 17' and remains as 'x of 17' when the records are cycles through.

There is a subform, but it should not be included in the count

Thanks ZigZag, that worked perfectly, for some reason it thinks there are 25 records when there only 17 though :s I will have to play around a bit. And thank you vbaInet, you have been very helpful. I will give the books I have a good read. I am a little bit in over my head at the moment, it...

I have tons of books on Acces and VBA. The only problem is sifting through all the useless stuff trying to find anyting useful. It desnt help that when looking in the glossary for something like '1 of x' theres absolutely nothing

More coding than I would have liked. I am still trying to wrap my head around the Visual Basic side of it, but it's slow progress. The project is still in the early days though so I've got lots of time to do the learning How do I get into it on the VBA editor and what sort of coding would need...

I can't send you the complete database for security reasons. I am working on it for a company as a final year project and part of the agreement is that I do not share the information with anyone. I am working on cutting the database down a bit to only include this form and the table related to...

Ah, I see what you mean. I was able to do this on another form but for some reason when the form I want is opened it automatically clicks on another control box and wont let me unclick it. This means I cant get the form properties up, just the control box properties. Dont supose you know how to...

When I do that I dont get the option of 'On Current Event' I am using Access 2000, is it possible that the settings are different?

Sorry, I dont quite follow what you mean, I cant seem to find any value options called 'On Current Event'

Thanks for the quick response. I have done as you instructed and all that happens is that the box says '#Name?'

Hi there, I am having great difficulty adding a simple '1 of x' display on one of my forms. I am not talking about the automatic one that Access has in the very bottom of the form (for some reason this is hidden anyway). I am looking for one which will appear at the top of the form or anywhere...