Search results

I've created a form with Record Navigator which allows a user to create a new record. When the form is opened how do I immediately put the user into add mode by default? Thanks

I don't think this works. I created a small test report with one break on category, one field showing in that break, changed the CanShrink and CanGrow both to yes and in the code inserted this: Private Sub GroupFooter0_Format(Cancel As Integer, FormatCount As Integer) If txtBCC = "HA" Then...

Hi Pat: By your statement "The control needs to be set to not visible", I'm assuming this statement in the code (assuming the same If/Else logic) Me.GroupFooter0.Visible = False All Headers have been set to Can shrink/Can grow. "The detail section itself is set to yes". I've set the Visible...

Yes Maxmangion, that was it. Thanks! Having people help you who know it is so much more effective than reading a book!

Based on a footer code, I'm trying to shrink vertical heights, but the code below just doesn't want to listen. Any ideas? If BudgetCategoryReportOrder = 4 Or BudgetCategoryReportOrder = 5 Then Me.txtBCROSubtotal.Visible = False Me.BudgetCategoryDescription.Visible = False...

Is there some field or VB command that will suppress "You are about to append 1 record?

I am using extensive Hide fields in VB code based on group conditions and these are working However, the vertical space remains upon hide and I set "Can shrink" to yes. But the text field called "Subtotal" does not allow "Can shrink". Is there any other field I can set or suggestion I can...

How do I maximize a form at startup?

Resolved. Thank you Pat. Yes, I was able to use the group name. Paul

Yes Paul. That was it. I found the AS clause right after the FROM tblX. I tracked it backwards to another one also. Odd form for the original programmer to make right in the middle of the project. Thank you for helping a stranger. Blessings. Paul

Hi Pat: I checked that too, and no it's not (at least it doesn't show up in the query module). Is there any way of searching the system for it by name? Paul

Wow. I'm converting an old database which, through a query, references (what looks like) a table called "gross_charges", yet that "table" does not appear in the tables module, even with Hidden and system tables option turned on. I don't see any flat files by that name anywhere on my machine...

Yipes. I guess I got too excited too fast. I thought Groupname was a natural construct and it became obvious you gave me a generic example. What is Groupname? Does it have anything to do with the code? Private Sub GroupFooter5_Format(Cancel As Integer, FormatCount As Integer)

Rich: Thanks for the nice explanation. I get it now. I think I'll use the "disambiguate" method as I have other code elsewhere on the system that I believe still uses ADO. Again, thanks. Paul

I copied over tables, forms, reports, etc from another older database into a conversion database. A module that uses this construct in the old database... Dim db As Database Set db = CurrentDb ...generates "User type not defined" in the new database. Why? Thanks, Paul

Very cool and clean Pat. Thank you ever so much. And thank you for your generosity of your time. That too is appreciated!! Paul

In my report I have an unbound key field in the Page Header whose control source is tblFacultyBudgetHeader.FBH_PK, fed by a form value. I have added a subform onto the report in a footer group which requires two linked keys, FBH_PK and BudgetCategoryCode. Thus, upon completion of the subform...

OK, I suppose I could have another "recap" in last group, following the format of the first. However, I'm not sure how to do that without a subreport. I've created an artificial sort/group field to collect GroupA and B into Group 1, but I really don't know how to summarize those as displayed...

Pat: Sorry, I called you Robert (note to self: read...the...message...first)

Thanks Robert. On the surface I would agree with you. However, there is another occurrence of records in a group just after the reporting of this subform: Group 1 Group Break A row a: amt1 amt2 amt3 row b: amt1 amt2 amt3 Group Break B...