Search results

I have used VBA for some things but I'm still very much a novice. I will try this and see if this works. I might need some more assistance with it though :o.

The popup opens from a command button on another client related continuous form. The macro contains a 'where' clause "ClientID=" & ClientID. That way only that client's records will display. For the time being I have disabled edit mode on the popup and made it read only other than the...

Hello. I have a continuous form which is used to record client messages. I have the form placed in another form as a subform, whereby the form displays the message history of the client shown in the form. This works fine, with the last record in the list being a blank record ready to be edited...

Thanks, that was the answer!

Hello all, I would appreciate some help with a query expression. I have a query which has a calculated field based on an IIF expression, that checks a range of date related conditions to resolve to a Yes or No. It is used to determine whether a client contact is required each day. I am having...

Thanks arnelgp. That kind of works, I get some fields filling ok, but others display an #Name? error. This is the code I put in the On Load event: Private Sub Form_Load() Me.RecordSource = "Select ClientID From cboClientID.column(0) Where ClientID = " & Forms!frmBaseCallSheet!ClientID...

Hello. I have a form frmBaseCallSheets which displays client information in a continuous form. I would like to open another form frmEmergencyActivation from a command button, which will open this second form and select the ClientID from a combobox in frmEmergencyActivation based on the ClientID...

I worked out the solution. I needed to set the criteria as pbaldy said. It was fairly simple in the end. the Month() and Day() criteria were used to generate the query in the first place. All I needed to do was to set the criteria properly in the DLookup. The criteria set in the conditional...

Hello all. I have a report which displays a date of birth field. I want to be able to highlight records where the dd\mmm is equal to Date(). I have a query which generates a list which I think I should be able to reference with DLookup but I must have the expression wrong. I have tried in...

Mmm, yes. What I meant to say is that I got a workable result from the syntax: =IIf(DLookUp("[ClientID]","qryNewClientMessages","[ClientID]=" & [ClientID]),"New Message"," ") but the result I ideally am looking for is to display the contents of the field [Details] from the query...

I find I am continually asking for help with the correct syntax in expressions. In this case it might be the construction of the arguments as well. I have a text box in a form which I want to show the details of a new message for a client based on a criteria of >Date()-2. In this case I am...

Thanks MarkK. I sorted it out myself by copying the SQL to a text editor and after looking at it carefully noticed that FullName was there but as a calculated field, not a selected one. I just changed the ORDER BY statement to that field name and all worked ok. I don't remember setting this...

Hello all. This is one of those frustrating things which should be simple but just isn't. I have a report based on (I think!) a query. One of the fields is [FullName], which I always compile after sorting LastName as Ascending. Therefore any time FullName is used it ought to be sorted...

[SOLVED] Re: Syntax help needed! Thank you arnelgp, that worked perfectly. I knew it was going to look something like that. (That one will go in my text file for difficult expression syntaxes!)

Hi all. I have read several posts covering this issue but I'm still stumped as to how to structure the syntax for a DCount function as the source for a text box on a form. I have the following expression on an existing text box which works jus fine...

Oops. I forgot that my form was based on the table with a calculated field rather than on the query. It works with the above syntax. Thanks anyway :).

Hello. I have a query with a field that checks against a range of criteria in order to resolve to a "Yes" or "No" for any given date. I wish to add a dlookup function to the expression which looks up today's date against a table of public holiday dates. The expression I am using is...

Thank you Isskint. Actually I have thought through this a little more and am a bit clearer on what I want now. (Sometimes it takes me time to get clear in my mind exactly what I really DO want!) . We operate a service calling clients with serious health problems every day to check on them...

Hoping you can help. I want to be able to pre-fill records with information based on a form every day for each client. This needs to display in a datasheet view showing all clients for each location. Each day the subform needs to show the expected results of that day's activity with clients if...

Namliam, I didn't say it was the only way to achieve my result, and certainly not the best I'm sure. I am still studying Access and I am sure to come across a better way to structure this expression. This was just a first solution to my problem. The key accomplishment here was to prove to myself...