Search results

Thanks for the reply, Scott....I will try that & see what it returns. Regards, Bonie.

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

In-Between Dates for Query Thanks for the reply, Sergeant. To Clarify: Unless I'm mistaken, the IN dates are the ones on which the criteria would be applied. Going back to the initial post, for the period IN:Apr 01 2004 OUT:Jun 30 2004, would the days stayed be counted from the 13th of...

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

Thanks Doc, FoFa, I thank you both kindly. :) Let me get to this. Best regards, Bonie.

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.

Thanks for the time Peter, & Congrats on becoming a Grandfather! I also had some probs with the form frmcontrolPanel, but not as drastic as those you did (It was not showing the client's name on MouseMove). I am looking foward to having a look at the db structure & forms. Congrats again, Bonie.

Hi Peter. Hope this clarifies things some. :) ... I assume you have StayID and ClientID as a Client may return for multiple stays - Correct? Yes. The clients may & do return many times a year. They are, however limited to 90 days in a calendar year. ... Are Client details known and...

Clarification Hi Peter. You have it right on the money! That, and the fact that I want to get the Clients names from the clients table. (I have a modified form frmBunkNumber, which has a dropdown of the clients, but I am still stuck as to how to get the FirstName, MiddleName, SSN & LastName to...

Intentions Hi Peter & thanks for taking the time. The DB is meant to enter & track client stays & activity at a shelter/residence. I combine a client name with a Bunk number into the table CheckIn (ref relationships). The form frmcontrolpanel is, as you said, currently bound to...

Thanks for the suggestion. I'm actually not trying to move data between tables. The form in question displays the current record on mousemove, and the user then has an option to perform one or more of several actions. The help I wanted was in with linking table Checkin to form frmcontrolpanel...

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

General Help for a Newbie 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...

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

Thanks. I have table with: CheckInID, (AutoNumber) CheckInDate (Date), ClientID (Lookup to Table on Clients), DailyCheckIn (CheckBox to check Client In for the day). The Unique Identifier I use is the client's SSN. The form is something I will need to look into, as most of the terms you...

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