Queries, Pictures & Automated Procedures

[Bonifaceg]

--------------------------------------------------------------------------------

Hi again. (Zipped File Attached)

I have made changes to my table structure eliminating table-level pull-ups. I did try to use Candace's example (having a text field in the table with pic path), but was unable to resolve the OnCurrent and OnOpen events errors. These events were, in Candace's eg, on the form. I tried it on my PersonalInfo edit form and got a multitude of errors (Not code savvy ). Is there something right off the bat that I'm missing?

For the Nightly Check-in problem, I have created a table (TodaysStays) where I wanted to move data back & forth between (Q: With entering & deleting data so often, isnt there a chance of corruption / data loss?), but was unable to figure-out a query to do this. (My train of thought was as follows:
1) Pull records of current clients - Current Client Query, pulling from Table StayPeriods
2) Populate this information into Table TodaysStays
3) Flag Checked-In clients
4) Move data into Table StayPeriods
Is this a good way to do it or is there a more expedient way to do this? For clients with other data (Suspensions, Bars, etc), will this looping cut-out the information tied-in to them and show them as new check-ins with no adverse history?)

Is there a way I can have information from the table TodaysStays update to table StayPeriods automatically (say at the end of the day or at a particular time (8:00PM) )?

I expect to use table StayInfo to view all the information on a client. Is there a way to update records automatically from other tables before it? (Eg. When I enter a client (PersonalInfo) and check him in (Check-In, TodaysStays, & StayPeriod), can this information be automatically updated to table StayInfo?)

Thanks Again & Kind Regards,
Bonie.