Search results

When I was little, pumpkins were hard to come by and pretty expensive (certainly compared to here, where we've got a 'pick your own' place just down the road). As a result, we used turnips and I can categorically state that it's a damn sight harder work carving a recognizable face out of the...

Not that it's got anything to do with motorbikes or jazz, but someone briefly mentioned Halloween at one point so just thought I'd pass on what I've seen here :D . Halloween in Canada - well, Ontario at least - is HUGE as a celebration. I remember some news story saying that the amount of...

Thanks both. 2 hours later, the import finished and it appears(?) to have done the trick. I've made a note of the links, in case it reoccurs. Still, if it worked properly all the time, where would the fun be?

Yes. It takes a while, but no errors.

I've started getting this vague and in no way helpful message every time I attempt to look at any of the VBA behind my forms, modules, etc. Luckily, the front end is stored separately from the data, but it's still preventing me from making changes to the forms. I assume it means corruption of...

1) You're grouping by 'program id' and not mentioning any other fields as group or sum. You need to remove all grouping or ensure all fields are included in some way. 2) The 'Sent' field has a different name in query B1. 3) 'Clicks' field has a different name in query B1. 4) 'Sent' field has a...

Okay, I got to the clutching at straws stage and tried compiling the database. Once I'd done that, it allowed me to use the SetFocus expression to move to the next combo box. All is now well with the world :D and thanks to those to helped.

Thanks for the response. My problem is that I don't want to enter any new data (as the person's name is already present, albeit in a format that the drop-down list doesn't recognize). I've tried using SetFocus to move to the newly populated combo box, but something is causing the focus to...

Not the entire form, no. I've been able to work around the problem by replacing 'enabled' with 'visible', for the second combo, and blanking the first combo box if the second becomes visible. This inidicates to the user to use the second one, and they seem happy enough with it. It's not ideal...

oops, should have been [LastName] & IIf(isnull([LastName]),"",", ") & [NamePrefix] The bracket after [LastName] was missing. Sorry about that (put it down to lack of sleep) :o You can use it in a few ways - and I'm sure other forum members will suggest them - but I usually construct it as a...

If you replace [LastName] & ", " & [NamePrefix] with [LastName] & IIf(isnull([LastName],"",", ") & [NamePrefix] you should get a zero length string, instead of the comma, whenever there is no value in the LastName field. Playing around with the other commas in the same way should allow you...

str_Criteria is "The NewData value should be somewhere in the field IALastName". This part is working, the source for the second combo box is correct every time. It's shifting the focus that I'm having the real problems with.

I think something like the following should work for you. You may need to tweak it, if I've missed a space or something like that. 1) Set up the criteria 2) Check if any records match it (in this case, I'm counting the Community field, but if not every record has a value for this field, you'll...

I have a form that gets populated after the user selects a value (a person's surname) from a combo box. This works fine if the name is present or if the name is missing entirely. Where I'm having problems is if there are two people in a team e.g. the last name could be 'Davies/Smith'. I want the...

But the previous picture was of inflation. So that picture suggests that inflation destroys inflation? Never mind, how about this one.

Okay..... but how does that 'destroy' the previous one?