Search results

I have a parameter query which is based upon a combo box on a form. When I select something from the combo box the query runs, but I get no records returned. If I run the query without the combo box input (just by typing in the criteria), records are displayed no problem. What am I missing...

I do not have a sub form with data in it!

Good morning, I have an access data base which I have attached, There are Sub systems and pre requisite sub systems. The pre requisite Sub Systems have a tick next to them. There is another tick box to say whether that sub system is complete or not. I want a formulae that lets me know if the...

Thank you for your response but I am afraid I don't quite follow?

Good morning, I have an access data base which I have attached, There are Sub systems and pre requisite sub systems. The pre requisite Sub Systems have a tick next to them. There is another tick box to say whether that sub system is complete or not. I want a formulae that lets me know if the...

You are quite right, I have worked out what I was trying to do, I wanted to update several fields at once to true with the date. I did this by running a query, Thanks for helping me and teaching me Forum etiquette!!

I am probably not making myself very clear, Not all my fields are the same in the record but some of my fields are duplicated, There are no duplicated records.

Yes I do, or else I could run a duplicate query.

Sorry to be so confusing I am so new to this and haven't quite got the jargon right. I meant duplicate rows. Duplicate values in the columns!

Hi Uncle Gizmo Thank you so much for your help, I have put it all on one table. There are a few duplicate Columns in my records, I want to be able to update the same column of duplicates at once to say Yes. Does that make sense?

Hi All I have several tables with the same Fields, I want to just tick one table and update the other tables that have the matching information as ticked. I hope this makes sense, Is this possible? Hopefully someone can help this poor girl who has been thrown properly in the deep end but...

Hi All My name is Stephanie, I work in Namibia and I am very new to Access, databases, Sql and VBA. I am really looking forward to getting some help from this forum.