Search results

Thanks for the "Choice" info ... I'll be looking into it !

I have the same feeling ... however these clients have bought into the Power Apps Dataverse scenerio !!

understood ... but in access you can ( and do) allow the secondary field to show up without any great effort. Is this not true of Dataverse too?

I have a table in Access that is as follows: I need the Whose field to become like the MS-Access. Can this be done using the Access to Dataverse tools?

Thanks for your immediate response ... i will comb thru your suggestions!! Marty

Hi Guys, Some Background: I've got a front-end and back-end db -- the communication is extremely poor between them but that can't be changed! Therefore I've gone from the db to several Arrays for most of UI. There is one giant outburst of db activity at the outset of the front-end and then...

MajP Thank-you --- this works amazingly well! Marty

Is there a way to add the previous row's cell "B" value to the current "B" cell and then add the current row "A" value? Kind of like in Excel? Thanks, Marty An Example: A B (Starting Point = 0) 35 35 = 0 + 35 15 50 = 35 + 15 4 54 = 50 + 4

How would I do that? M.

Thanks Pat! I'll do that!

Hi, This question fits with what you are talking about Form to Form: I've been looking for an event that gets fired when one closes the first form and then exits to the second form. Unfortunately, when I switch between the two open forms, the Deactivate event does NOT occurs for the first form...

Any updates?

oops!

As I explained earlier, when you open the screen and go to "Inuvik" every field correct including the << pos & " of " & reccount>> values. But when you then go to "Inuvik Town Site" the fields are correct EXCEPT the << pos & " of " & reccount>> values. Regards Marty

@MajP , I have followed your directions and they work! I now can build a "Record Navigation System" (RNS) for Main forms. I now have a situation where I need two separate RNS's for different parts of 2 subforms. The first is for "Campsites" and the second is for "Fuel Caches" both subforms of...

>> One pattern might be tables: Person, Res, Mission, Schedule. Tables are mostly obvious, except Schedule might look like.... >> tSchedule >> ScheduleID (PK) >> PersonID (FK) <--- one of these to be used per row >> MissionID (FK) <--- and not the other >> ResID (FK) >> DateTime I like your...

I have info in Excel about people staying in camp. I've show a sample of one person in the following: How do I convey info to a Table in Access that is normalized in the easiest manner using VBA? There must be some "standard" way -- I can't be the only person thats come across this pattern!!

Thanks to you both!!!

Whoops - you were right MajP -- I'm too embarassed to say --- looking in the wrong spot!!!

Already put a breakpoint in form open ... that's how I discovered it was in between the open and the load part ... right in between ! but where is it exactly ... i still don't know!