Dear All Please I want formula or VB macro, to sub-total the no. of hours when Emp.ID & date is matching eg. All Emp#.ID equal to 116 with date equal to...

I would like only the main switchboard to be visible on start-up but at the moment a "Contacts list" form (inherited from the Contacts template in Access...

Public Function my_dates(the_date As Date) As Integer Select Case the_date Case Between "07/31/2005" And "08/01/2006" my_dates = 2006 case Between...

Good day everyone. I appreciate any suggestion by all of you. 1st Is possible have Master & Child Link function without adding any subform? If yes, how? Eg:...

I have two related tables - Events and Contacts. I have created a form which populates both but the only records it will show are the most recent ones typed...

I have a form that utilizes two contact lists in separate combo boxes to illustrate projects that multiple people have worked on. I am trying to make it so...

I have created a query, all the fields from an existing table. One field has a date format. I want to select for records in which that field contains data....

I have tblMinisters with MinisterID (PK) and MinisterName, +++(with 50 records) I have tblChurches with ChurchID(PK) and ChurchName, +++(with 7 records) I...

I just downloaded a trial version of office 2007, I went into Access to create a database and when I hit create it says "application is disabled, and...

On new layout of Access I can not figure out how to hyperlink a scanned form onto our data base. Can anyone help me Please?

I originally cross-posted this question in microsoft.public.access.queries & microsoft.public.access.tablesdbdesign newsgroups, but did not get a response. I...

Ok- so I have created a table for my contacts called Person (with address, phone, etc) and table for Group (with speaker, author, attendee) and then a table...

I'm trying to build a database with minimal working knowledge of Access so even though I've been through the tutorial it seems way more complicated then what...

Let me explain... I need a database with contact names and then which type of group they are part of. 1. I created a table with ContactID (fields with name,...

When trying to open a linked table I get an error message that the file is opened exclusivelyby another user. I have used this link before many times and have...

Hi, I'm not sure if this is the correct forum to be asking this question, but I hope still to be able to get some help. I work for a photography place at a...

Help the desperate newbie! Did I design my database wrong? I created a form with basic name, address etc. then also include about 10 yes/no boxes to be...

I'm presently studying Access and having difficulty understanding building event codes. What I'm trying to do is suppress the printing of three controls in a...

OK- I need to go right back to start. I'm volunteering for a charity that has a yearly event and they need help!, --seriously they have 400 names on scraps...

Hi Using Access 2007. Despite lots of reading around the subject, relational tables seem to be a real block and this is causing issues with trying to set up...