Search results for query: *

Hello? No one can help? I didnt think it would be a difficult question, to find out how to load a single data element to an unbound box on a report. *mutters a bit*

I've also tried all these too... =SELECT [CountOfClient ID] FROM (DC Count) WHERE [DC]=1 SELECT [CountOfClient ID] FROM [DC Count] WHERE [DC]=1 SELECT [CountOfClient ID] FROM (DC Count) WHERE [DC]=1 =SELECT "[CountOfClient ID]" FROM "[DC Count]" WHERE "[DC]=1" SELECT [DC...

Alright, in trying out various options, I've been trying something like this: =SELECT ([CountOfClient ID]) FROM ([DC Count]) WHERE ([DC]) = 1 This is designed to extract a single value from a query DC Count, looking in column CountOfClient ID for the value related to the value DC=1. It's...

I'm at a loss as to what to do next, and would dearly appreciate some assistance. My database captures client details, and I have to provide a demographic breakdown. Now the nature of the demographics changes depending upon whom I need to report to, so it's done via a query using SQL and a UDF...

No luck. Dropping the Me caused no changes. Also, I checked the spelling etc. as suggested and it was all ok. Nevertheless, I tried the auto-complete option, built the lines as suggested and still had no luck. The control in question is about 14th on the form, it's definitely not the first...

Results: tried both your code segments, both yielding the same 2465 error... *shoots self* Copied your code verbatim as it seemed correct, and it reported the error as soon as the form was loaded. When entering debug mode, it took me to this line: Me.[Name_of_Referee].Enabled = True Removing...

Wonderful, this looks good. As soon as I clear a few other jobs off my desk, I'll give this a try. My thanks for the amount of effort you put into assisting.

Thanks for your assistance, however I still have had no joy. I'll copy a code snippet, hopefully you can show me where I'm going wrong. --------- Private Sub Referral_From_AfterUpdate() If Me.Referral_From = "Self" Then Me.[Name_of_Referee].Enabled = False End If End Sub ------------ This...

Greetings. A quick and hopefully simple question for your eminent brains. I have a drop-down list with several elements. The drop-down gets it's values via Lookup from another table. Depending upon the element chosen, I want to have several other fields to be either enabled or disabled. As...

Thanks for offering your help. At the moment I have 13 responses available under Organisation. Of those, six require a mandatory related address (et.al.) be entered, and two require the following fields be left blank. After I've completed this it's being handed out to several offices who will...

I'm trying to find out how to restrict what can be placed in a text field based upon the element selected from a drop-down field. I have a database with a drop-down box (a list of organisations), which gathers it's values via lookup from another table (this is working fine). I then have...