Search results

I read somewhere that page breaks do not work if they are used in a subreport. Hope that helps.

Thanks for the reply. It was already set to Yes, so I'm not sure if that's it. Funny thing is that I moved the label so that it was physically touching the control. Seems to "stick" them together somehow. I don't know why that would affect it, but it seems to work.

As the title suggests, I need to know how to ensure the label always stays on the same page as the first record of a control.

I was having a similar problem using the Chr() function in a query. Turns out I had to use the Chr$() function instead. Can't find that in the help files. What is it?

Yes, but it does use a group by clause and an aggregate function on the NewDate field. Of note, I'm using Access 2000.

I forgot to mention that I tried that too. Didn't work. But thanks.

I'm using the Nz function to interrogate a date field in a query. Problem is that Access does not seem to recognize the returned value as a date when the original value was null. Here's what I've tried: NewDate: Nz([OldDate],0) and NewDate: Nz([OldDate],#01/01/1900#) I've also tried...

Thanks. I feared as much. I'll just tag the code onto something that happens before the form loads, as you've suggested (I had been hoping to avoid that due to the chance of it getting missed if I allow more than one access point to the form.)

I'm running some code from the main form's OnOpen event that alters the record source of a subform. I requery the subform at the end of the subroutine, but the changes are not shown until I close and reopen the form. It appears that the requery is not working. Is there a trick to this? :confused:

Oracle You can get a free copy of Oracle to play with from the Oracle website. As far as I know, it's fully functional. You just have to promise not to use it to make money.

I've heard IS gurus say that Access security is quite poor compared to other systems like SQL Server or Oracle. Just wondering how much truth there is to this and how much of a concern it should be. Are there any good online resources addressing this?

Yes, I did test the SQL. It worked. The problem was that it wouldn't open the recordset at all. It wasn't an update problem. Thanks

Solution After much debugging, I've discovered that it did not like the "Section" alias I had given one of my fields in the SQL statement. Go figure. :confused:

Error -2147467259: Method 'Open' of object '_Recordset' failed.

Actually in the line before that I update a control on the active form, which is why I force the save.

I'm having trouble opening an ADO recordset using a union SQL statement as the source. I'm wondering if it will even let you do that. I'm trying to avoid storing the union query in the database and calling it as the source if possible. Of note, I am attempting to open two recordsets with...

Solution For some reason, the form was not re-applying the sort order in the underlying query when re-querying. I coded it to set a form level OrderBy property, which seems to do the trick. The record locking problem also vanished. Me.OrderBy = "[SectionPosition]" Me.OrderByOn = True...

Here's my code in case it helps: Private Sub cmdUp_Click() On Error GoTo EH 'Renumbers the order for this section and patient, 'moving the active record up one in the sort order. Dim cnnLayout As ADODB.Connection, rstLayout As ADODB.Recordset, strSQL As String 'Does nothing if this is...

Thanks Pat. I actually do force a save beforehand, so that's not the problem. I'm also not using an update query. I'm using an ADO recordset in case that makes a difference.

I have a form (actually a subform, but that's not relevant), displayed as a continuous form, that the user can use to edit the display order of certain records. The form displays the records and allows the user to move them up or down in the order by clicking an up or down arrow. In the...