Search results

I need to make changes to a table already containing data. Currently the autonumber field is simply there as a primary key, but I now wish to use it for another number field (Accession No) which was previously completed manually. As this doesn't seem possible or practical (as I need the...

The Else statement stops the list appearing in the cascade box. Seems to work without it!

Of course. That's got it. Thank you very much! Final code looks like this: Private Sub Subject1_AfterUpdate() On Error GoTo Err_Subject1_AfterUpdate If Len(Trim(Nz(DLookup("[Subcategory]", "tblsubjects", "[Subject] = '" & Me.Subject1 & "'")))) > 0 Then MsgBox "Please Choose a Subcategory in...

You'll be glad to know it's working. Only problem is, we've been going down the wrong road slightly, as I ideally need the message box to appear when it's not null, and I'm not sure how to turn this code around to do that. Any suggestions? You're help has been very much appreciated! Alison.

There's a compile error, it's asking for a list separator or ) and highlighting the section ")))= 0 Then I can't see what's missing. Sorry to be so useless! Your help is much appreciated, and will hopefully benefit others too, as I haven't been able to find anything elsewhere on how to do...

The only hover that appears is over '" & Me.Subject1 & "'" at the end of the dcount line, which correctly returns what has been entered in Subject1. I'm a bit of a novice at debugging, so hope I've done it right! Someone has suggested it has to do with looking for null values as a data-less...

Still no joy. I'm not getting any errors now, and the cascade works all right, but there's no msgbox appearing. Is there a last gasp I can try?!

It's still saying it can't find the field. Does it know the [Subject] is in tblsubjects?

It seems to be the If Is Null line. If I remove this line, the msgbox line, the Else and the End If, the cascading combo box works okay.

I've tried this and I can't get it to work - it comes up with error 2645 - doesn't recognize field. I've checked all the field names and tried various permutations with quotes, brackets, dots and I can't figure out what's going wrong. Any further help would be much appreciated. Thanks a lot.

I've tried having a fiddle with this, but as I'm a newbie, I can't see how I should actually incorporate it into my code. Further pointers would be much appreciated! Thanks, Alison

I am using the below sub to create a cascading combo box, which works fine. However, not every subject in tblsubjects has a subcategory, so I want a msgbox to appear only when there are subcategories to choose from. At the moment I am using If Me![Subject2] = "Dispute Resolution" Or...

Displaying Previous month in report I've used this formula in a query to look at the previous month's number of phone calls, and used sum on the number of phone calls. I want to run a report on this query each month. How do I get the Date box in the report to say it's for the month of x...

Many thanks to you for your codes. I'm still struggling with where I input it into Access to get it to work in my "LoanDueDate" field in a table (I'll also need to alter the date to add 3 working days, but can hopefully adapt the code myself). I'd be grateful if anyone could supply a...

Where do I put the coding into Access? Hi, this code is hopefully just what I've been looking for. However, I don't know how to put it into the date field in my table as I've never used coding before. Can anyone help please? Thanks.

I'm ignoring public holidays. :)

There is certainly a lot on the subject. However, I can't find anything that produces a date that is x working days after another date. Also, the answers do seem to be to use VB, which I have never used. I don't understand the code that's there, so I can't adapt it to my purpose, and I'm...

I've searched in Access and on the web and haven't found the answer to this. I found an IIF code on the web that I tried to manipulate to do what I want. However, it wasn't accepted in the Expression Builder box so I don't know if I'm putting it in the wrong place.

I'm an Access novice! I have a table with a library loan date field defaulting with today's date and a due back field. I want the due back field to show a date 3 weekdays after the loan date. I've tried using DateAdd("w",3,Date()) but this just adds 3 days, not weekdays. Does anyone know how...