Search results

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...

Reply to what does this mean ... 1. Values that change in all the date and text controls that are bound to Recordset fields properly update the db when Recordset.Update is called. 2. This is a Modal form with FinanceFellowID being passed in OpenArgs. Dim rst As DAO.Recordset Dim...

I have a single record recordset that is loaded form a table and set as the forms recordset. All fields that are bound to controls update properly. I have 2 fields whose value change when 2 unbound combobox values change. 1. The value shows as updated in the recordset 2. The call to...

1. True. You're in control of the binding. 2. No access runtime. You'll probably want to use the entity framework, which makes db access more structured. 3. So many MS controls plus those from Infragitics and the like. 4. I use the Infragistics charts and grids. They are the fastest on the...

Thanks. I decided to take the easy way out and just passed the id of the record to update to the modal form and opened a new recordset with the single row. Everything is almost working. Jut having a problem when I go to save the record, says it's opened by someone else. That seems to be a...

Addendum: I set a unique index with all the relationship keys. I was most often getting - error 2501 OpenForm action was cancelled with the Recordset not updateable appearing periodically.