Search results

Thanks for replying ... It does though ... It's an autonumber that's automatically assigned when the form opens.

Aarrrggh! I have a form where I keep getting this error message. First of all it was another message, which was "You can't add or change a record because a related record is required in table 'Episode'" Managed to sort that sticking a couple of DoCmd.RunCommand acCmdSaveRecord in. The 438...

You need to requery your form via code. If you check out this thread posted by Mile-O there's a really helpful sheet on what to put where. Click Here Post back if you have any more questions.

Not that I know of via a query, (although someone else may be able to clarify that). But if you do it via a report, there's an option for OnNoData on the Event tab of the report. In the code here, put Private Sub Report_NoData(Cancel As Integer) msgbox "No data to view", vbOKOnly, "No Records"...

It could possibly be your query is not grouping, therefore, repeating information for some reason. In your query, if you click the Greek E type sign on the toolbar, (can never remember the proper name). Alternatively, you can go to View > Totals - and then run your query, (providing you've got...

Are either of your forms Data Entry forms? Does the subform have Allow Additions? If you are adding to it via text boxes on another form, I always make it Allow Additions false - that way it prevents additions to the form other than the code you've got to add records. If neither of the above...

Thank you Rich.

Just checked one of mine and if the report is bigger than "fit to screen" it will have scroll bars. These won't print out.

Go to the properties of the report, and on the OnOpen Event enter a procedure DoCmd.Maximize It should look like this: Private Sub Report_Open(Cancel As Integer) DoCmd.Maximize End Sub If you're not sure about properties and code, post back. HTH

Not sure off-hand and have tried re-creating it to try it but can't. You probably need the Nz function, and I'm sure someone else can correct / confirm this and help. In the meantime, can you post a sample of the db so I can have a go? Am going shortly, so won't be able to look again till...

A bad one ... What's the difference between a fish and a piano ...? You can't tuna fish!!

Glad you got it sorted. Any more queries, just post back! :)

If you put it in the "Detail" section, it will do a count for each record. If you move it to the group footer (or if you've not got one of those, if you're only grouping it on females, in the report footer), that will give you the total count for the group / report.

Reports are very similar to forms in many ways. You can create a report via the wizard, using the same query as that which feeds your form. If you need what would be a subform in a form, you can create a subreport too. Again, you can have unbound textboxes the same as forms, with your =count*...

I use GPs in most of my dbs and the way I do it is have the GPs in a drop-down list, with the surgery already included. Because some GPs work in more than one surgery, I find that this is one of the easiest. You can begin to type in the name and then choose. Another way would be in your second...

Oh. Mmmmm. Give me a year or two and I might get it completely!

Thought it was just me, but got Col to read it too and neither of us understand it (phew)!?!?!??!?! :confused:

In the criteria row of "Next Contact Date" field put: Between [Enter Start Date] and [Enter End Date] This will give you parameters when the query is run. Ensure that the dates are entered in the same format as they've been entered.

Thanks Rich - will have a go.

I have been asked by two separate database users about this as they've both been having problems with some users going in and changing data later. Does anyone have any ideas on how to do this. The thing is, it won't be the whole form - because on both dbs, some information is entered to...