Search results

You mean the References in the VBE? All the usual things I use appear to be ticked. Is there something in particular I should look for?

Help, SJ, or another genius, please. A new machine is flung onto this desk, and beautiful as it is, it refuses to recognise query Functions in Access 2k. In truth, it mocks me, saying 'Functon is not available in expressions in query expression ... ' and then quotes the simplest function to do...

Thanks, Ken. Yes, I tried to avoid another field, and was being forced into it, and then I was getting this calculation to add a string to the new fld, txtCertified. I see what you mean about having the new field do the job itself. Either the certificate has been awarded or not. There's...

What a curse, Ken. It applies the question to every record. Back to the drawing board. Cheers

No ... tried it out but that isn't the answer. I need the function to work on change, and that's what causes the msgbox to show when the db opens. But I am using a test db, set up to require this function to be busy. Perhaps it will be ok in its real position ... more thinking required from...

Perfect, Ken, naturally. I am very obliged to you for taking the trouble. H O W E V E R, it inspires a problem. When the database is called up with only the form appearing, message boxes appear seeking a yes or a no. Is there some code that stops the function going to work before the form...

Hi Ken - This is almost a copy of my attempts, but only almost so I will happily give it a run. Back soon. Many thanks

The Abs() has been getting round the previous complication. That the date must be more than 14 days after cboDOA and that the entry must be Induction in cboWork. Now I need to say if he has these qualifications, he must have his work certificate. Abs() was working well. But now there's this...

Thanks, Ken. I'm trying something similar, but I wondered whether perhaps an Abs couldn't be tampered with. I'll report back.

I want to add a proviso into a function. If a record is about to become "Available", I want to have a message box ask first something like "Has he passed the test?" If the answer is "Yes", show "Available". But if it's "No", then keep with the status quo. At present, this decides the...

Thanks, Pat. It isn't working for me that way. But as I've learned with Access and VBA, there's almost always a variety of ways. Cheers

Sorry to bother you again with this, Pat. The combo in the table has 7 entries for, say, religions. And I need to apply each of these religions to, say, PlaceOfWorship. There are quite a few of them. I know how to use Union Queries to collect information from fields in different tables, of...

That's very good of you, Pat, to explain it so thoroughly. It is appreciated very much. And thanks too for the examples. Gratefully paul

A field has different occupations. I DON'T want these jobs to turn up: SELECT * FROM qryMain WHERE (((qryMain.Work)<>'Available' Or (qryMain.Work)='Dismissed' Or (qryMain.Work)='Induction' Or (qryMain.Work)='Open University' Or (qryMain.Work)='Restricted' Or (qryMain.Work)='Seg*' Or...

Thanks very much, Pat. My way was the basic road and complicated. This certainly sounds far better. Thanks very much for explaining. Cheers

cboFaith offers 8 possibilities for religion. Three other fields are, say, Church, Chapel, Mosque. How would a master craftsman, like S J MacAbney (for instance), offer a report showing how many of each of those 8 entries for Faith goes to each of the three fields. Like presbyterian Church...

SJ, Thanks very much for going to all that trouble. All noted about early and late bindings. I didn't appreciate the difference between bang over period (early/late bindings) - or have forgotten it - so it's a lesson learned. Yes, it was my mistake. I added the 'End If' to other EndIfs at the...

If the date in txtEndDate is more than 28 days old, I need cboWork to read "Available". The following doesn't work ... for some reason. If Abs(DateDiff("d", Me!txtEndDate, Date)) >= 28 Then Me!cboWork = "Available" Be grateful for advice, Craftsmen.

Thanks, Pat. Yes, it works well. Cheers

Sorry to be so long getting back, Vince. Never a moment to breathe here. This is the situation +/- Five queries, and five totals query, and one query to collect the totals and to feed them onto a form for display. The queries are fed by qryMain from tblMain, but they could as easily come...