Search results

Greetings All. I have a problem that just began occurring with the pictures on my forms. I have the forms linked to pictures in a folder called “Pics”. In the information table, the field for the pictures reads “\\B2r101t3\Pics\000-00-0000.jpg” where “B2r101t3” is the computer name, “Pics” is...

Hello all. I have a query that returns a tally of days stayed for clients at a residence. There can be multiple stays. I need to know if there is a way to calculate only the number of days stayed over the last 366 days. eg: Client A: IN:Jan 01 2004 OUT:Mar 28 2004 IN:Apr 01 2004...

Hello all. Is there a way to limit the number of times a query can be run within a particular period of time? (Eg Only run once a day for a particular date). Thanks, Bonie.

Hi all. I think this question belongs here, but I'm not sure, so bear with me. I have a database I created to track stays, occurrences, suspensions, bars, & personal Information at a men's residence. Within this, I have a form, unlinked, (frmcontrolpanel) that I want to use as a control panel...

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

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

Hi. I am quite new to Access, and have learnt quite a bit from your forums. I need some pointers on how to do the following. Any & all help is appreciated. I have a database to keep track of residents at a shelter. One of the requirements is that they all "check-in" every evening, or they lose...

Hello All. I am in need of some help for an Access database with the following tables: Bunklist (1-100) ClientInfo ClientStayInfo ClientChoreInfo Occurrences The above will be for a Shelter housing up to 100 men (Clients). Each client already has a file with his details (Table ClientInfo)...