Activity Stream

Thanks heaps. Would you mind answering a few questions, please? 1. Is "txt" something I'm supposed to include? If so, is it supposed to be on a...

I would recommend you develop a better naming convention. Imagine having a dB with 20 tables - "ID" as the PK field name for every table would be/get...

Happy to help! I think you'll be happier in the long run, and the app will be more professional.

If qryResult was a pass through query, it would work for any valid table.

sorry, dumb question

Thank you too for your answer, Vlad. I did thought about building my own confirm deletion dialog. I'll see, if it's necessary.

Thanks for your answer. I think I'll drop the idea of prevention and presume the user knows what he does.

Good call, thanks pbaldy!

Most of us would use a form to gather user input. When you do that, you can just refer to the form for the value. You also have more control over...

Hi I've just seen this thread. Many thanks to @Micron and @missinglinq for alerting me. Rather than use the AWF link, I suggest you go directly to...

Thank you June. I think you may be right. You usually are ;)

Looks more like need a regular aggregate, not a crosstab. SELECT , Max(Feature1) AS F1, Max(Feature2) AS F2, Max(Feature3) AS F3 GROUP BY ; If...

You're very welcome, good luck with your project! Cheers,

As Vlad shows, must concatenate variable inputs. You declared variables as string type. Are the fields text data type? The variables are not...

Using DAO recordset.delete method does not trigger a prompt...

Normal approach would be a form bound to Table2 and combobox to select JobID and save as foreign key into Table2. Since you have form bound to...

Try this: strSQL = "Delete * From WHERE = '" & pos & "' And = '" & trng & "'" Note the single quotes needed for string variables (none for...

Hi so I have gone back to this and have done the following. Table1. = Jobs with fields JobsId, and associated fields Table2 = Seals which June...

Totally makes sense that split function didn't belong. I took it out and the function works perfectly! Thanks for the help. I'm always learning!...

Take a look at creating a "Crosstab" query

AFAIK, delete method is not applicable to a recordset in 2010 or 2013 Access. If you want a delete prompt, just use OpenQuery (a stored query) or...

Thank you very much June7 both ways are working perfectly. I understand the first but not the second. Actually I was looking for a way to generate...

Hi If you have setup your table relationships correctly then the Foreign Key will auto-populate when adding a new record in the subform. If you...

would help to see some example data and the result required from that data. suggest this might work, but no guarantees, it is extremely...

Your design does not follow good relational database design,what will you do if your business grows and you'll have 6 operators? How do you know who...