Search results for query: *

Hi Duane Thanks for the reply No im not storing the addresses in multiple places :)Just in the appropriate tables I have the following tables: TblClient PK ClientID CompanyName Address Phone etc TblClientContact PK ContactID FK ClientID Title FirstName LastName Position Phone Email...

Hi everyone I am missing something simple here i am sure I have a table ServiceCompany PK ServiceCoId Autonumber FK EventID Number CompanyName CompanyAddress ServiceProvided ServiceCost I have a form (mainfrm) which is based on tblevent where i have details on the type of event we are...

Thanks Guys This is exactly what worked for me =[eventattendsubform].[Form].[countpeople]

I have a main form with a subform and i am counting the number of records in the subform (it will be the number of invites sent) The control in my [eventattendsubform] is called [countpeople] and its control source is count(*) This is placed in the footer of my subform My control in my main...

If batching means selecting multiple values - then yes, that is what i require thanks

Im not entirely sure - batching invites sounds better though. It has to be easy to use for the end user as they are not computer literate.

Hi Duane FK EventID is actually what used to be EventdetailID - I removed the "detail" part as it wasn't necessary - I forgot to change it in my post I have also changed the RSVP cell to a choice of accept or decline instead of yes or no. The code for the query is below (i couldn't put the...

Hi everyone I am creating and event management database (which is nothing like the template Microsoft has) I have the following tables: TblClient PK ClientID CompanyName Address etc TblContact PK ContactID FK ClientID FK EventID Invite-Yes/NO FirstName LastName etc TblEventDetail PK...

Hi everyone Previously I posted a similar questions and I only had Access 97 to use. Now i have Access 2007 and I am still having trouble. I know I am missing something simple but I just can't see it. The templates Microsoft has are not what I need at all and I can’t download any other samples...

Hi everyone I have Access 2007 and I read somewhere that it is better to use code (which is Modules?) I don't know much about code (as I have always used Macros) and I have a form which has a-z buttons to search for employees (from an old version of Access) What i would like to know is - what...

Hi PH I need to test against both dates as I need to know how many raised and how many closed for the month for each type - corrective actions, non conformance and process improvement.

The main table i am using has a number of fields and only the following are where i get my data from DR No Autonumber Type Lookup 3 types previously mentioned Date Raised Date Close-out date Date Rework yes/no So, I need to get a report...

Hi I have a Deficiency Report Register database. I need to run a query which will end up looking like this This Month No. No. No. Type Raised Rework Closed Corrective Actions...