Search results

Wouldn't it be more feasible to use default values against your fields? Would be a bit more user friendly ;) RV

Not really. You do need to post your current query. RV

Replace function should read Replace(.Field("PostCode"), " ", " ") as you want to strip out a space, not add one ;) RV

Not sure what you're after then. Post your current query. RV

You're quite right ;) Including [TotalSDNI]and [InvoiceTotal] in the GROUP BY clause should also work though, although the retrieved row will be grouped slightly different. RV

Sure, no prob. Yes = -1, No = 0. So by summing all values you'll get -1 multiplied by the number of times you ticked "yes". Multiplying the sum hence results in the requested total. RV

Field1YesCount: -1*Sum([Field1]) Et cetera. RV

OK, I can see what your problem is. You get the square character rather then the number. Works fine for me. I can't tell you what's happening on your side. Perhaps somebody else can. RV

That's not what the error message is 'bout. Aggregate refers to the fact that an aggregation function is used. In a query using aggregate functions you need to group on each and every column you didn't include in an aggregation function. As far as I recall, you can't refer to aliases in GROUP...

You need to group on [TotalSDNI]-[InvoiceTotal] RV

Don't use lookup fields. Look here for the reason why: http://www.mvps.org/access/lookupfields.htm Base your report on a query. Combine the two tables in your query, using a join on countyID. In your query, include the column County from your counties table. RV

It is. Run Q_form1a. It comes up asking you to enter a parameter Forms!Form1!vormbeheer plus a parameter Forms!Form1!vormbeheer0. For both parameters, enter 2. Query result looks fine to me. So what's your problem? RV

I figured you were as your table definitions and structure tells me so ;) Anyway, I had a look at your sample. Could you explain your problem a bit more as I can't see any. RV

Otto, this is not I a strange fenomenon, it's how combo's work. I'm not sure what you're after but here's some advices. You need to define primary keys on all your tables. Use an autonumber colimn to reflect your primary keys. You should define relationships between your tables. Base your...

Search the forum on VPN. RV

Yes, your understanding is correct. Now of course the are exceptions to this rule none of which apply to your case. In case you want to run reports, which you normally want if you want to generate iinvoices, you base your report on a query. Normally you can use the same query as a base for the...

Again, you don't store calculated data in tables. Referring to me previous reply. RV

I'm not sure wat your frustration is all 'bout, but could it be that you're not too familiar yet with Access yet ;) An unbound control indeed does habe an After Update event. Calculated data is not stored in tables. If you want to review calculated data outside your form, then start using...

What you need is some VBA code on the Before Update event of the control where you enter your integer. Basic code is If Me.cmbCC.Column(0) = 1 Then If Me.nameofcontrol < 10 Or Me.nameofcontrol > 20 Then MsgBox "Enter a value between 10 and 20" Me.nameofcontrol.Undo End If End If If you're...

You need to use an append query as suggested by TanisAgain. One important remark regarding your variables. You need to explicitally declare all variables. If you don't, the default Variant will be used. For instance, this piece of code you posted Dim lngOuterCounter, lngInnerCounter As Long...