Search results

Background: I have 26 tables relating to different areas of the country. Each table contains various name and address information, each record on the table also has a COLLID (eg 123A321). The COLLID is issued to anywhere between 5 and 200 records. The problem: I need to produce a separate...

Having a bit of a brain melt here. (Well it is Friday !!) I am trying to run the following calculation, but ot no avail. =Sum(5-([Payment])) And instead of getting the results of 5 minus the value in the payment field (which is £1, £2 or £4) I get £36.00 Any clues

I'm doing it as we speak

Because it isn't an error as such. I have intentionally bound to non existance control sources as they will exist as the xtab table grows

I understand what you mean now. I have amended your database to incorporate a datestamp in the amendment date field so that when the existing price text box is changed the current date appears in the amendment date field

Not sure what you mean :confused:

I'm going to be away from my PC for 5 days after today so I'll do you an example of what I mean and post it here

Can you zip and attach your database. It is probably easier to show you than explain

I have done something similar to this making individual text boxes visible/invisible dependant on the contents of other fields. Could you not try something along the lines of : If [field in the subform] = null then [subform name].visible = false else [subform name].visible = true end if HTH

(1) Create a form bound to your questions table. (2) Bind text boxes to only the questions you require for a category (3) Repeate steps 1 and 2 until you have all of your categories (4) Create either a form with subforms or a form with tab sheets That should do it

I did think about doing it this way but I am trying to get away from having to mess around with the guts of the form if I can as this will be rolled out to users

I agree that it is a bit unusual. The form is bound to a crosstab query which will eventually contain 60 fields. It currently contains 10 fields although I already know what the names of the additional 50 fields will be. I have bound the text boxes using these names so that as the crosstab...

I have a text box bound to a control source that doesn't exist (as yet) which when the form is opened displays #Name. I want to hide all text boxes with #Name in them

Doh! I meant visible property not function. I phrased the question wrong. I am trying to hide something if it doesn't exist and show it if it does.

Is it possible to use the visible function to show or hide a none existant control source on a form?

visible function a form Is it possible to use the existence of a '#Name' error on a form as criteria for a visible command?

Can I email you the database. It is probably easier to look at it rather than me try to explain it. The criteria for whether the record is to be printed or not will be if there is an "A" in the last comp field of the Payout_Crostab query.

Is it possible to create a crosstab table and then add an extra field which can be amended to specify whether the record can or cannot be printed?

Is it possible to show crosstab records in a form bearing in mind that the columns for the crosstab will increase each week

Ken, Thanks very much. This isn't what I was looking for but it has given me another alternative. Thanks.