Activity Stream

Use the SQL as the recordsource?

Table one - is a list of thousands of items. eg. Item 1 Item 2 Item 3 ... ... Item 100 Query One - a list of variable unique items - for...

I don't understand what you want. If multiple records match that criteria they will display on form.

Thanks for the quick response I apologise. I don't think I was clear. = "Field1 LIKE '*" & strSearch & "*'" This would presume that I could...

I got a compile error: User-defined type not defined. This is the statement that created the error. Dim db As DAO.Database This is the same...

Ya mean "Liver alone, cheese mine"? :rolleyes: I laughed anyway!

Okay, pointed me in the right direction... Here's the joke. Three dogs are in the doggie bar having a drink. There's a Husky, a Doberman and a...

= "Field1 LIKE '*" & strSearch & "*'" Otherwise, set form RecordSource property with the complete SQL statement.

In addition to the other comments, suggest show some content- you first debug implies that rs!shortprogram is the 3 letter word ‘and’ so way less...

Hi AJ See the attached example

Most probably because I don't know how to, and I also got "Can't execute a Select Query" error. It was a Union query being changed to include only...

I read that as you're trying to add a child record when there is no parent record for it. That is not possible. If you're trying to add another...

If your rs is empty, Move anything will raise an error. There are better ways - I use what Allen Browne wrote: If Not (rs.EOF And rs.BOF) Then ...

Hi mike, Thanks! That's what I ended up with, so I'm glad to know I'm on the right track! I am still having trouble determining the best way...

You are not moving to next record? Plus no need for exit, as you have that as your loop?

Format property can simply be set to 0000. Still doesn't explain why data is duplicated. Why not just save record ID?

I assume that is most likely the issue. The one field is formatted as a number and the other short text. I assume there is no real workaround to...

Are fields text or number type? Text type can retain leading zeros, number cannot. However, can format number field to display with leading zeros. ...

It's good that OP found a solution, but you guys are making this look like it's a guessing game and it's NOT. Everything is in the form variable. The...

I prefixed my controls with values like those, rather than suffixed. Easier to see at at glance, was my thoughts?

I will give these a read. I like to think I have been doing a fairly good job. Textboxes end with Txt Labels end with Lbl the main form is called...

I used to do the same by prefixing with ctl. :)

Perhaps learn the structure of how to refer to controls from elsewhere than the form itself? http://access.mvps.org/access/forms/frm0031.htm

No, but there is plenty of info on custom classes out there but not always easy to find. Many of the classes I use are entirely self contained...

Brackets are required if names contain spaces or Heaven forbid, start with a number, so that's what they're meant to signify. Putting them in causes...

Ahhhh! I misunderstood because it was in brackets like the other references. My bad! Fixing this worked!...

None of those use Form. after the subform control name. Form. isn't a reference - it's a requirement.