Search results

By my "just add this" in the previous comment... I meant "just add this to the test code I already provided in the sample db." :)

Ok, reddevil1, IF I understand what you're after then just add onChange event code like this to your ContractID control. Private Sub ContractID_Change() ContractDetails.BackColor = 9170175 ' Yellow focused color End Sub The ContractID_GotFocus code with its "Is Recolor = True" keep the...

I read your "every other time" in the first post: in terms of every "OTHER" time... one time normal, next time colored, next time normal. So, if I now understand you right the form in the attached database should do what you're after.

May be a better solution, but this should work... Private Sub ContractID_GotFocus() Static Accumulate As Integer Accumulate = Accumulate + 1 If (Accumulate Mod 2) = 0 Then ContractDetails.BackColor = 9170175 Else ContractDetails.BackColor = 9800909 End If End Sub On second...

Thanks, Pat. Your comments about open vs load clarified that issue! And your "= forms!someform!somehiddencontrol" just turned on the light. Thanks.

Pat, The Join option makes sense. That certainly would work. It just seems inefficient... having to tack header data on to each detail row, when it's only needed at the top of each report. Talk some more about the difference between Open & Load. I thought that you added code related to setting...

In a Report I'm using DAO to pull some header data from a Company table. Assigning the value of a field (like Company Name) to the Caption of a label works just fine. But one field is variable text and may need to grow, so I'm using a textbox (txtDescription). The code below throws an error...

Solved!! I knew it was something simple. Pat had the right idea. I was focusing so much on the WHERE clause and spelling the table/field code properly that I failed to see that I had accidentally uncheck the "Display this field in the query". So the field that was needed for a column in the...

TempVars!donor has been corrected since my original post. It is actually: TempVars!donor.Value This globally available variable is set in the calling program from the value of a Combo Box holding all the DonorID's and names.

Yes. Double checked that already. Table: Contributions Field: ContribDt As I noted, the 2 queries are identical except for the final Where clause on the second one that limits it to only one donor. First query doesn't throw the error, second one does. Also tried the Access square brackets...

Two queries acting as RecordSource for a report: 1) gives donations for all donors within a pair of dates 2) is further restricted with second WHERE clause to only show 1 donor The report (when using the second query) pops up a modal box asking for the value of ContribDt. Why?? Here's the...

Thanks. Nz(Me!ID, 0) Mental block :)

I know I've seen this, but can't find a reference... I've just added a new Name to a clients table in a modal popup form and want to grab its Autoincremented ID value to return it to the calling form.

THANKS! From moment to moment with this software I feel on top of it and the next, like a complete dummy. Searching high & low and forgot to check the obvious "Help, Caption" :o

Yep! Thanks. Where is that documented?

I'm adding a field value (Addressee) to some text in a Label... Label.Caption = "Initial text " & [Addressee] Problem: If the name contains an ampersand, like "Joe & Sally" the "&" shows up as an underscore. Tried to escape it... no joy Tried "Joe " & Chr(38) & " Sally"... no joy I can...

Identifier Type Characters... Thanks. Interesting feature. I think I prefer the full declaration, it's clearer on those late night code review sessions.

Just ran across a function that has these lines of code... What is the "@" doing? Const Thousand = 1000@ If (N = 0@) Then

Thanks, Jdraw & Pat Pat, I follow your comment re: intellisense and the use of "." And the processing time saving feature of adding Me. to the right side of the equation. I'm finding Access's syntax a bit confusing coming out of a dBase (hate to admit it) background where you'd reference the...

Assume a form (myForm) containing a combobox (cboName). Also on the form is a tabControl (TabCtrl18) containing a subForm (sfrmItems) on one of its pages is a textbox (txtName) I have successfully set txtName = cboName.Column(1) when the user clicks on the containing page of the tabControl...