Search results

Thanks for the replies everybody. I'm working on some specifications at the moment, but I will give your suggestions a go tomorrow and post back then. Many thanks until tomorrow (!) -Neil

Thanks for that Glynch. Not quite what I am trying to do, but I will try to explain better: Yes, I am trying to pull a count query from another query on a form. Basically, I have 3 queries concerning this form: qryCWDetails feeds the Listbox for Calender Week Details. qryNPOID feeds the combobox...

I have a form, unbound, with a combo and a listbox. These are both bound to Select Queries. When a user updates the combo with their choice, and a record in the listbox is highlighted, an additional query will pull back all records that fall into this criteria. (The query refers to both the...

Hi all. OK, I have a search form that pops up as a Dialogue box, you enter the criteria (GMC Number), and click on the 'Search Button'. I have coding in place to account for if no record is found at this stage. IF a record is found matching the criteria, another form (Results) opens with...

OK, I'm half way there. I have used the following statement; SELECT DISTINCT [rptQAB - Temp].PatientID, [rptQAB - Temp].AttendanceID FROM [rptQAB - Temp] WHERE ((([rptQAB - Temp].PatientID) In (SELECT [PatientID] FROM [rptQAB - Temp] As Tmp GROUP BY [PatientID] HAVING Count(*) >1 ))) ORDER BY...

I have a table of patient details with some that will appear more than once. I need a query that will only bring back those that appear more than once, and show the results in the relating report. A normal SELECT statement I have used to filter the results brings back ALL of the patients from...

Nevermind, just had a brain wave.................. I'll use Unique Query property.

What I am wracking my brains over is this: I have a query that will pull off Patient ID's and Their Referral Type. Simple enough. Now, there may sometimes be more than one referral type against any one patient ID. AND there may be records that contain the Patient ID with the same Referral...

Excellent ! Many thanks. I used 'UNION ALL' statement and I achieved the results I was after. Regards, -NEIL

I will try to keep this as brief as possible. This involves two tables, say, table 1 and table 2. Both tables are identical in design and fields, but when a date is entered in a specific field in table 1, append and delete queries are run to copy the record over to table 2 and delete it from...

Thanks for that, although my efforts are being utilised elsewhere at the moment I will give that a go very soon. Thanks again, -NEIL L POPE

This topic is about a query I am running. The query has three tables in it, one of which is a SQL view (Linked) Within this view are the following fields: Patient ID Date Of Birth GP Name PCG Name Start Date Now, the problem that I am having is, to be brief, Duplicate Entries on the query...

Why don't you just use Command buttons running from Macro's ? Ie; if you have a command button to say 'Switchboard' and then create a macro to close the current form and reopen the switchboard ? I have used this method a number of times, and it seems to work perfectly. Email me if you need...

Hi there. You all have no doubt seen forum messages about rescaling, well here is another one ! I have developed forms at 1024*724 resolution, but some users have a resolution of 800*600. I need the code to resize the forms so that the 800*600 users can view the WHOLE form, just like I can at...

Thank you for your reply Pat. Could you give me an idea of what code I need for this ? I am really in need of help on this one ! Many thanks, -NEIL L POPE

Thanks all, I got it to work ! I owe you all a beer ! -NEIL

Thanks for the reply. By choosing 'YES' for the 'Locked' option, the whole tick box becomes locked, and cannot be ticked. I want to lock it ONLY after it has been checked (Tick appear). Any other ideas on this ? Many thanks.

Hi. I have a couple of checkboxes on my form, once they are clicked (The Tick appears in them), I want them to be locked so that they cannot be unticked. Can anybody Help Me ? Many thanks, -NEIL L POPE

I HAVE WORKED IT OUT ! NO NEED TO REPLY TO THIS TOPIC !!! MANY THANKS

When a command button is clicked, it open a smaller form in 'dialogue' mode. What I nned to do is have the value of a field on the main form appear in a text box on the smaller form as soon as it is opened, which is bound to a different table. (There is a relationship between the two tables via...