Search results

On this thread, plog helped me out with a bunch of queries I was struggling with. My question concerns the query Review_sub_10: SELECT public_tblreview_items.review_id, Count(public_tblreview_items.review_item_id) AS observations_animal FROM public_tblreview_items WHERE...

For my project I want to make some complex calculations. One calculation requires six consecutive queries, each one building on the results of the previous. This calculation has to be applied to ten categories, so 60 queries in total. I have made the six queries using the Access interface. Easy...

Like my wife, Access doesn't understand me. In case of my wife, it usually means I'm doing something wrong, but with Access too? Here's what I'm trying to do: 1. Retrieve an ID from table1 (pending_review) 2. Use that ID to retrieve a corresponding value from table2 (pending_model) Part one...

I have a form2 that opens by clicking a button on form1. On loading form2, some VBA code is executed. I would like to create an option to open form2 from another form, say form3, and perform a different bit of code on loading. Is it possible to identify whether form2 is opened from form1 or...

My project has a postgresql backend hosted on Amazon Web Services, for which I am developing a frontend in Access. With your help, I'm making good progress, so I started to think about the best way to make the application available to multiple users (think of them as consumers, so no company...

Here's what I'm trying to do: I have an unbound login form that looks up credentials in tbl_users. So far, so good, thank you Google, this forum and copy-paste. The match is made on user name and password, but I also want to retrieve the userid and put it in a textbox on the login form. Here's...

Absolute VBA noob here. I've been searching the net for days but the answers confuse me more than they help. I need a good VBA book... Anyways, I have a search form based on a query that is based on tbl_models. When the model is found, you double-click on it in a listbox and a data entry form...

Looking for advice on where to start educating myself on the following matter. My project consists of a Postgresql back-end/Access 2016 front-end combination. For the time being, the two connect through a system DSN ODBC connection. I have come to a point where I need to identify users for two...

Hello all, My real name is Richard and I just registered on this forum. I have worked with Access in the late 1990s, when I created a customer order tracking database (with Access 97). I live in the Netherlands with a wife and two teenagers. I'm on the right side of 50 (I'll let you be the...