Search results

If you have a look on the form Venue and press the seletion button this should give you an idea of how to complete your task. If you need any more help feel free to ask. Alastair

On your Menu form could you have the Venue ID?

The way your query has been setup the value of your parameter box is not saved and there for it you need to use the value again it has not saved it so it is lost. One way around this would be to create a form that will hold the value and then pass it on, would you like to make a simple form...

Do you mean when a new record is added to your database

If you can post your database i will have a look for you! Alastair

Have a look and see if i have fixed it. If you could let me know either way then i can offer more help on your forms. Alastair

What happens to your code does it error if so what is the error if no error then does it open the first record or last, i think we need a bit more information please. Alastair

Ray, Have you tried to click once on the database file and then holding the shift key double click, this should open the database and not run the on open event. Let me know if this work or not and i will try another way for you. Alastair

What exactly is your problem, what is the query going to do. Alastair

Have a look at this thread should help you out. I did a simple to use search on "Racing Database" and this one came up. Link http://www.access-programmers.co.uk/forums/showthread.php?t=81781&page=2&highlight=racing+database Alastair

Dash80, What is it that you are trying to do, from the information above and the supplied database it is not very clear. Alastair

Jason, I think your database will be fine as you can convert your database into Access 2000 automatically, in some case you will need to change some code but i would of said as a whole you should have no problems. Alastair

I am not sure how you mean can you enlight me any futher. Alastair

G28DMAN, Please find the attched copy of your database, i have changed the following if you need more help i would be pleased to help you. Frm Calclator I have included the twips calulation and used it on your form, it now pops up and you can see the background form (I think it will make your...

Sorry Missed That section Please find the enclosed and see if that works let me know if not and i will try again. Alastair

After looking on Microsoft Internet page i found that your code "Dim fso As filesystemobject" should be "Dim fso, fl" Alastair

Dean, I do not have win zip but, you could try and see if the attached works, I have copied the lines from the Non Win Zip function, see if this sorts you out. Alastair

Yoiu have a good idea of form layout, the only surjestion i have is that for the calulater you may need to look at twips this will allow you to use the calulater with out lossing the back ground form. Alastair

Smart, You have forgoten to attach the code/database. Alastair

It has worked on my computer!