Recent content by John_W

What is your criteria entry? Are you sure it's the same data type as is returned by your function? If your function is returning a Date/Time then you can't just use "2007" as a criteria because that's a number not a date.

There's some useful stuff here worth trying: http://www.granite.ab.ca/access/performancefaq.htm

I did a questionnaire database some years ago. The normalised table structure was something like this: tblQuestionnaires QRid QRName tblQuestions Qid QRid Qtext tblRespondents Rid RName tblAnswers Aid Qid Rid AYes/No I don't seem to be able to upload a picture unfortunately. But if you can...

Split it into two queries - the first to do your sum function, then the second - based on the first - as an append query. I guess you'd want to run a delete query first to delete the existing records? Or if you prefer the maketable, if you used the CDate function to coerce the contents of the...

I've used DSUM in a query to do something similar. It will work, but might run a bit slow.

I wouldn't use autonumbers for invoice numbers, or for anything meaningful. You can code something to assign sequential numbers to invoices if that's what you need.

I suspect it's something to do with you not having actually created a new record for the default value to be applied to. But really I just wanted to say you shouldn't be so bothered about 'wasting' autonumbers. If you're relying on them to be sequential or something, that's not good and you'll...

Not quite. Month(date()) will currently return 10. If you subtract 11 from that you're not really where you want to be. You need a method which takes account of the year also. I'd suggest using the DateAdd function to subtract 11 months from today's date.

I know. I was explaining for ChronicFear, who asked...

Not that it matters much here, but VBA expects an explicit declaration for each variable. So in the code: Dim Beige, Brown, Chartreuse, DarkBlue, DarkGreen As Long Only DarkGreen is declared as long - the others are undeclared and will be assigned Variant by default. Catches everyone out as...

Is that variable declaration really in the book? Dummies!

Is each piece of text specific to a particular code, or are some shared between codes? If not shared, I'd consider the text to be an attribute of the code and have a column in each table. Having said that, are you sure you need two separate tables for codes? Why not hold all codes in a single...

Use a Totals query, grouping on CaseFullRef and the other relevant fields.

Custom rounding function here to help in this circumstance: http://www.mvps.org/access/modules/mdl0054.htm

The easiest way of parsing is to use the VBA function Split, which will return an array containing the parsed elements. You just need to tell Split what delimiter character you've used. It might seem obvious, but don't use a delimiter character that could actually appear in the data. I once had...