Search results

Is this the preferred way to do it ?? Al

I dont understand why its a normalisation issue. I'd be interested to see the proper way to do it...

Here ya go I hope it does the trick Al

Hi I could help you out with this. Im trying to set up a small sideline business to create Access databases. Ive got a couple of databases out there with customers that are working quite nicely. I would be looking to charge a SMALL fee but for something like this shouldnt take more than a...

Hi david Initially I would install this on a single server for them so i wouldnt be expecting them to do anything themselves. Eventually Id like to create a Web Based version of the application so it can be used by many users across the country. Does this help ? Thanks Al

Hi I need to deploy my Access Application but I want to protect it from being copied and being used by unauthorised users. I know how many users are intended to use it and I suppose I could capture their login username, but are there any other ways of protecting it ? Thanks in advance Al

Thats great - I will use that :o)

Well, that will be down to te users t make sure they only select one I would hope they wouldnt. I tried to think of a way of doing this, maybe by using a FindDuplicates query which would perform an UNDO if a second checkbox was selected. I'll work on that... If only one Blood Pressure or Pulse...

The date is stored in the Appointment Table Where I have MANY Blood Pressure and Pulse Rate results, the user would select which Blood Pressure result is the optimum result and which Pulse Rate result is the optimum result. Where I have ONLY ONE Blood Pressure result or Pulse Rate result...

NHS_No is unique to each patient an yes, the NHS Number is with them for life...

there ya go...

Im using 2007 I need to get the data into one query so I can refer to it in a mail merge document. Are you suggesting I insert a query into another query ?

I think the problem is, when I go into my design view, it has a LONG SQL Statement and Im having problems understanding where to put the functions Here is my SQL Statement... SELECT tbl_Appointment.Appointment_ID, FIRST(tbl_Appointment.Appt_Date) as latestdate, tbl_Appointment.NHS_No...

Thanks for that but Im a bit of a beginner to queries. Where would I enter this ?

I have a query which lists many date related events for 3 or 4 people. Like this... Date Person 22/5/09 Mr Smith 17/5/09 Mr Smith 12/5/09 Mr Smith 21/5/09 Mrs Jones 16/5/09 Mrs Jones 11/5/09 Mrs Jones I only want the query to return...

OK, this might be tricky to explain but I'll try. I have a Form which has a Sub Form and that Sub Form has 2 Sub Forms. frm_Patient ---frm_Appointment ------frm_Blood_Pressure ------frm_Pulse_Rate A patient can have many appointments. An appointment does not have to have a Blood Pressure...

Hi I need to construct this type of IF Statement in a query, but Im not sure how to... If [THIS_FIELD] = "This_Value" Then "Return_This" Ive tried a few syntax combinations but nothing seems to work. Can anyone help ? Thanks Allan

How do I pass an Expression in a query to a text box on a form ? Ive tried DLookup but it returns an error.

I tried Pbaldy's suggestion and it worked fine. Thanks you I love this site

In a previous post, someone told me that I could refer to a query field from a text box on a form. The query I have ALWAYS returns just one record, so I am referring to a field in that query record via the Control Source with... =[Appt Query]![Score1] but it wont work. Why ?? Thanks in...