Recent content by AbbottF

Worked like a charm. Hopefully I'll remember the trick next time I run into the problem. Thanks Abbott

I have a subform that when launched on its own displays the proper datasheet items against a query. The items listed (lapsed memberships) relate to many of the contacts that managed on the mainform. When I open the subform as a tabbed page on the main form, the datasheet items are automatically...

Paul, I changed sort sequence of the query and that fixed everything. Thanks

Pat, I agree. This is not an structure that an experienced designer would use (ROOM_ID ? ROOM_NO). The names and relationships should more obvious and structured to teach, not confuse.

More to the fact, VB.Net is truly object oriented. It supports inheritance and as bparker1084 mentioned, it has access to ALL the .net framework classes including generics. The transition from Access to VB.Net is not trivial, since Access handles many data and from functions "under the covers"...

FYI. When you have 2 table relate to eachother, they only need to share a single key. My guess is that GUEST.GUESTID will be linked to GUESTINFORMATION.GUESTID as a foreign key. GUEST.GUESTINFORMATIONID should be removed, since it is unnecessary.

I have multiple copies of a subA on a form. Each one has a unique name subAA, subAB, .... I am trying to populate text fields on each form based on the contents of a class. I can find the subforms in the controls collection but I can't figure out how to reference the text boxes on each form...

Paul, I tried that, but it still displays in primary key order. It did seem like an obvious fix. Thanks Abbott

I have a subform in a tab on my main form. The filter works properly...I see all the records I expect. But the OrderBy on the date field does not work, the rows are shown in ascending primary key sequence. The code follows .. Any suggestions? Private Sub Form_Load() If Me.Recordset.BOF...

It's in a class module. I meant there is no exit function construct in VBA. the end function was not copied into the message. Everything is working now, with the error code commented out. It's part of a data conversion fom a very old access membership module to one that supports the needs of the...

Thanks. But End Function is an invalid construct. VBA throw a compiler error. Anyway, I just removed the error testing totally, since this is a one shot conversion.

I don't understand, since it's a Function and NOT a Sub Exit Sub is invalid and rejected by the compiler. The line below is supposed to cause the exit while setting the proper return value. I use it throughout the project. ProcessCurrentContactEvents = returnCount

I'm getting aa strange issue with a clas module. A function (see below) creates some error that is not passed to the error handler. Instead, it falls thru from the exit to the error handler & goes into an endless loop of blank dialog followed by a "Resume without error" dialog. It even happens...

Your last post got me thinking. All I had to do is create 2 hidden bound textboxe to the 2 fields and set the values of the text boxes. That solved the problem. I was trying to think too much like a C# programmer, not like an Access programmer.

I was trying to keep things short. I call it a query or querystring, since I come out of the SQLServer world. The the OpenForm is ... DoCmd.OpenForm "frmFinanceFellow", acNormal, , , acFormEdit, acDialog, ffID ffID is the key field of the FinanceFellow table. The included code snippet is...