Search results

Thanks Rich, but that was the first thing I tried. Thats when I got the error message. However, further investigation has revealed that I only get that message on one sub-form. The other one works fine. Both sub-forms are on different tabs and it is the front one that gave me the message (I...

I have a form which contains a sub-form. If I use the spell checker, it does not work for the contents in the sub-form. I get the message that the spell checker only works for fields that are text or memo even though they are of that type in the sub form. Is there a way around this?

Rob, Thank You - Proper Job!

I am trying to print a report of the current record in a form. From the Help files I have found this: Tip You can print a form's current record in a report by carrying out the OpenReport action in the Click event procedure for a command button. For example, adding the following Visual Basic...

Sorry, I haven't looked at web pages before so I can't help you. I suggest that you re-post your question with reference to that specific problem otherwise people may think your problem has been resolved. Good luck.

I think you are doing something wrong. There is nothing wrong with using a blank form with a number of command buttons, each one an option in your menu. Forgive me if you have already done this: On you blank form, attach a new command button. The wizard should open and give you a choice...

Well if you don't have an on click property it has stumped me. I know it may be obvious but have you highlighted the command button before you look at the properties?

Have you got the 'Event' or 'All' tab displayed on the properties?

In the properties for the command button, enter what form you want to open where it says 'On Click'.

Start again and use the wizard.

You hit the nail on the head. Thanks for the speedy response. saintsman

Is there a way of ensuring that fields in a report print the same size? My field's border colours are set to black so that the report prints it shows a grid, but one field has the can grow property set to yes. When it does grow it makes the report look odd. Some of the fields contain text and...

Fushiren, I found the solution so long ago I can't remember how I found it. The problem occured after we bought new PCs with higher spec processors. It worked on the old machines but not the new and I could never get an answer from our IT gurus (not that they ever knew anything about Access...

I would examine the query that your report is based on. If the information is being saved on your form then it is in a table somewhere. Therefore you can get it out. You are either looking at the wrong table or the query has restricted the data you want to see. Run the query and see if the...

I've had this problem with certain PC's before. Try using =DateValue(Now())

You need a sub-form. The main form for the athlete and the sub-form for the medicals. This means two tables (one for athlete and one for medical) with a relationship between them so that you know what medical belongs to which athlete.

Have you tried to produce your report direct from the table? If you have , produce a query first and design your report from the query. If your query shows the right result so will your report. If the query does not work, what is the link between the two tables that puts parents with children...

I wish to design a report (or form) for manufacturing an item. The report has three parts: One showing how to make the item, the second a list of the equipment required to make it and lastly a certification of the work carried out. Now I hope to do it all together in one report and I can by...

I would look again at your query. They only show what you ask for and you may have put something in the criteria that limits what you see. The three Adelphis are different and you are probably seeing the first one three times and not seeing the last two. Check your table to see how many times...

Option 2 did it. Thank you very much. To be honest I didn't know that existed. You learn something new every day! Saintsman