Search results

Many thanks to the both of you!!

That sounds like it would work fantastically. Unfortunately I'm really new to Access (I just learned how to use it before starting this database), so I wouldn't even know where to begin to do that. If you could help me with that I would be incredibly grateful.

Hi all, I'm currently working on a database which will be used by a decent number of people (around 50), and I'm working on ways to make sure it stays secure. One of the things I want to do is require a name to be associated with records which are appended/updated through queries which each...

Thanks a lot Sam!

I do have a time stamp on the records, it's currently set to =Date() With regards to which records get updated in the original table, they all do. This update query is meant as an undo to any editing which is done (the data is automatically archived before it is edited). However if Client A is...

I'm currently having some difficulty with an "undo" button I was asked to include in a database. The 'undo' function of the button would simply be updating a table with records from an archive table, thus whatever information had been archived/edited would be restored to the original table. The...

Of course I would forget to include the mock database up there. Here it is.

Hello all, I'm currently putting together a database which links together Clients and Brokers, and have put together this small mock database to illustrate my issue. I currently have a form which allows End users to add New Clients to the system without meddling in my tables or queries, and to...

Oh wow! I just figured it out! Your Left Join worked like a charm, just have to make the "no" for terminated clients an OR statement instead of an AND statement. Thank you so much for all of your time and help!

I totally understand what you mean (and thanks for pointing that out, as I'm pretty new to Access), but I just tried a Left Join, on both my database and the mock database, and still a Broker with no client attached will not show up.

Thanks for offering to take a look at this. I replicated the database with obviously fake information and slimmed down to my specific problem (There are more fields in my actual Clients table). I created the queries and form exactly as they appear in my database, so I really hope you are able to...

Sorry for the late response, I had a lot of work to do yesterday. My relationship is definitely centered around BrokerID, and the drop box is set to show all the brokers, but the query itself will not return any Brokers not associated with a Client, and I don't quite understand why/how to get...

I am currently working with a query which relates Brokers to their Clients. Each client has a BrokerID associated with it. This query is also linked to a form which can search for specific Brokers with a combobox. There are also fields of client termination and Broker activity. The query is set...