Hi folks;
Whew, it's been a while since I've been around here! Thanks for all the help with various Access projects, although that sort of thing is mostly behind me now.
The new challenge is administering a small network, currently an SBS2003 domain with about 8 computers and 5 users. I'm getting ready to upgrade to SBS2008 and it's struck me that I don't really know much about how it all works! I can work the controls...
Whizzo
Last Activity: Oct 7 '11, 12:00 PM
Joined: Feb 8 '09
Location:
-
Training material to catch up on SBS 2008
-
Outlook Web Access no longer working under SSL. Or at all in fact.
Hi all;
This is driving me up the wall! A few months ago the Remote Web Workplace failed to work on a pretty much fresh install of SBS 2003. I tried everything in the Microsoft rulebook to get it working but instead OWA started playing up. Forms-based authentication stopped working, then it started coming up with Page Not Found errors, but -only- if SSL was turned on at the server end. If I turn SSL off then forms-based authentication... -
Thanks fish, that's almost the tree I'm barking up but I don't need to let users enter their own operators. The user will supply the number (say 500) and then the iif() statement will supply a Less Than operator. I did try
instead of starting with Alike but the expression was too complicated for Access to process,...Code:< IIf(IsNull([forms]![frmReportGenerator]![cboMinTotExp]),"%",<[forms]![frmReportGenerator]![cboMinTotExp])
-
Sure it makes sense! Here's how I understand it. An iif statement is made of:
1. Criteria. String to check for validity.
2. Truepart. Return this string/value if (1) is True.
3. Falsepart. Return this string/value if (1) is False.
In this case:
1. Criteria is "Is this [txtTest] empty?"
2. Truepart. "If [txtTest] is empty, return a "%" here." (in this case it's a Criteria...Leave a comment:
-
Close but no cigar. The "blank search parameters" problem was one I solved last week, that at least is working fine now. My problem is how to fit < and > into the TruePart of an iif statement, where the TruePart is a control on a form. Any ideas?Leave a comment:
-
Passing operators into parameter queries?
Hi all;
Well, I've had my obligatory hour of Googling, scratching my head and trial and error and now I'm stumped. I'm using the following code as a query parameter:
The idea is that if there's value in the field then the parameter is carried into the query. If the box is empty then it's...Code:ALike IIf(IsNull([forms]![frmReportGenerator]![cboMinTotExp]),"%",<[forms]![frmReportGenerator]![cboMinTotExp])
-
And there it is. I tried the criteria with a text box instead of a combo and it worked. Then I changed the bound column for the combo box and it started behaving itself. Happy days! I always thought that if you addressed a control in a form it always picked the data from the control and ignored bound columns etc. Ah well, one lives and learns. Thanks folks!Leave a comment:
-
Here's your info FishVal, thanks for taking in interest!
tblAccounts.Acc tHoldingBranch field is a:
Text field, all characters forced to uppercase.
cboBranchName row source is:
Bound col. 1Code:SELECT tblBranchList.[Sort Code], tblBranchList.[Branch Name] FROM tblBranchList ORDER BY [Branch Name];
Table col 1. Sort code
Table col 2. Branch name
Interesting. Hadn't thought...Leave a comment:
-
Haha, you asked for it!
...Code:SELECT DISTINCT [perscustforename] & " " & [PersCustSurname] & [BUSCompanyname1] & " " & [Buscompanyname2] AS Name, tblCustomers.CustID, tblCustomers.TotalExposure, tblCustomers.SumAssured, tblPolicies.PolicyNumber, tblPolicies.PolicyIssuerName, tblPolicies.PolicyHolder, tblPolicies.SumAssuredValue, tblPolicies.CollStatus, tblPolicies.MaturityDate, DateDiff("yyyy",#5/5/2009#,[MaturityDate])Leave a comment:
-
Sorry folks, that was a fib. When I put the criteria in as
a dialog pops up at runtime and asks me for the very same parameter that I'm trying to pass, i.e. the string in txtMyTest. Maybe that helps?Code:[forms]![frmMyForm]![txtMyText]
Leave a comment:
-
Is ANSI 92 affecting my query parameters?
Hi all;
Here's one for you. I have a form open (let's call it frmMyForm) which contains a text box (txtMyText). The contents of this text box is passed to a parameter query as:
Exactly as it says so in the book, so to speak. But it's not working. It seems to be looking at the form, at least it doesn't ask me to enter the value manually, but the query doesn't return any results....Code:[forms]![frmMyForm]![txtMyText]
-
Excellent! Just what I was looking for! Thanks folks!Leave a comment:
-
Scratch that,
seems to hold water. All solved!Code:IIf([PolicySumAssuredLife1]>[PolicySumAssuredLife2],[PolicySumAssuredLife1],[PolicySumAssuredLife2])
Leave a comment:
-
What a coincidence, I've just hopped on here to find an answer for the exact same question! How is this done with IIF()? All I want is for the query to look at column1 and column2 and place the highest figure it finds in column3. As far as I can see IIF() can only compare A to B or B to A, not both. Any ideas?
Thanks!Leave a comment:
-
That worked great, thanks! I'll try and get a bit more used to it. How come format() worked? Looking at the function help it seems more concerned with formatting dates and times. I was going to use CStr() instead but now it looks like I won't need to.Code:Len(Format([NumericField]))
Leave a comment:
-
Conditional formatting and expressions?
Hi all;
Any reason why putting:
into the Conditional Formatting of a control isn't applying it in a report? Even when the length of [COMP Policy Number] is indeed shorter that the length of [Policy Number]? I've tried a few other simple expressions in Conditional Formatting too, such as:Code:Len([COMP Policy Number])<Len([PolicyNumber])
Code:[[I]an empty field][/I] = ""
...Code:[[I]an empty [/]
-
Got it:
Seems to be working...Code:Last(concat([tblCustomers]![CustID],CStr(nz([policynumber]))))
Leave a comment:
-
Data type problems when concatenating fields.
Hi all;
I'm using this great bit of code to concatenate a fields from multiple rows into a single one.
...Code:'Concat Returns lists of items which are within a grouped field Public Function Concat(strGroup As String, _ strItem As String) As String Static strLastGroup As String Static strItems As String If strGroup = strLastGroup Then -
I'm not calculating this on the fly because the data in the DB is only a snapshot, read-only. The findings will be used to make updates straight to the mainframe somewhere in Denmark. I'm trying to populate a flat table which will generate a report, rather than relying on queries to come up with report data. I found a kind of alternative to scrolling through the records in the end, I put GoToRecord,next on the On Timer event of the form and set...Leave a comment:
-
I was hoping that the fields would be updated to the figure returned by the Dsum function but no luck. The exact same string on the On Current event in a form sets the value of a control perfectly, simply using me!control = ... in VB. I was under the inpression that:
in the Update To bit of the design...Code:DSum("[AcctBalance]","[tblAccounts]","[tblCustomers]![CustID]=[tblAccounts]![CustID]")Leave a comment:
No activity results to display
Leave a comment: