Search results

0 and -1 are the real numeric values of the constants "false" and "true" respectively. Thus when you say that your table has 0's and -1's, data has not been lost --- rather, for some reason, Access has simply forgotten that the field type for the field is yes no. Have you tried simply popping...

Thanks for your replies: 1) llkhoutx, I have done the requeries okay. As I say, the problem manifests even when scrolling through the window showing the subform. Access is not redrawing properly. 2) Pat, I tried your focus suggestion, and still nothing. What I can report is that I have...

Hi, I hope somebody can help with this one .. I have a large form containing two subforms. Both subforms display datasheets (both consist of one field pulled from a table, the other is a calculated field with conditional formatting applied depending on the content of the field). The first...

Thanks Quick and dirty it may be, but it worked. Many thanks.

I have come across an annoying but niggling problem. I have a large text box on a form, linked to a memo field. I want the textbox to show its scrollbars when the form is first opened, however the only way I can see to do this is to give the textbox the focus. So far, no problem ... .. but if...

The problem is that when you click on the Close Button, that control gets the focus ... and as you cannot hide a control with the focus, when you run your code to hide that button, lo and behold an error occurs What you need to do is insert a line that reads: docmd.gotocontrol "<control name>"...

My fault --- typed the reply in a hurry. Should be: note.visible=true Doh!

Ruby, The very simplest way to do this is as follows: 1) In design view, set the "visible" property of the text box to "no". Thus when the form opens, it will be hidden. 2) In the ONCLICK event of the command button, write the following code: note.visible=False ... and voila. The text box...

Rich, Thanks --- that's exactly what I want to do. Perhaps I'm just being deliberately slow on the update --- but all the options the crosstab query seems to present me with are numeric ones (e.g. VALUE) --- how does one get a single text value to appear? Thanks for the reply,

Thanks for your advice Pat, but the problem is that crosstab queries seem to only be happy to summarise numeric data . Whereas I want text to appear e.g. in the example I gave, where say 18/08/01 (date) and "HB1" (room) intersect, I don't want a subtotal, but rather the contents of the "event"...

In A2K I have a database which holds timetable of courses. Fields consist of 'date', 'tutor', 'room' and course title. What I want to try and do is subgroup by 'date', but then have rooms stretching out horizontally across my page, with the other details below. e.g. DATE Room 1 Room 2...