User Profile
Yvonnebatfink406
Copper Contributor
Joined Oct 05, 2021
User Widgets
Recent Discussions
- 1.8KViews0likes0Comments
Re: Access 2010 to professional plus 2019
Thanks for the reply, I have created a database for us girls in an office, I have limited knowledge of database, ecdl advance level, at the moment we are using a spreadsheet to list the customers and their details when visited, each time they come in another line is added to the spreadsheet which isn't the best idea, I have created a database with basically 2 tables, one for the customers details ie name etc and another table for each visit. These r joined by customer ID in relationship. I have a form which is the main navigation for moving around different queries and to find each customer record,. when I have entered a customers details on a form I created, a form I created for the second table for their visit info loads, this is quite a long form, at the end of this form I have a button that opens up a new record for their next visit. It's always opening up at the bottom of the new blank form instead of at the top, I have tried tab order but not helped. I have worked how to stop the main form from being closed by saying no in the properties so that's sorted as if the girls accidently closed the main form, opening it again in the navigation pane would confuse them. If I could just get it to scroll to the top when a new customer visit is added would finish it off. I am amazed I've got my database and queries to actually work consistently in the first place and now just looking at the finishing touches1.9KViews0likes2CommentsRe: Access 2010 to professional plus 2019
Thank u so much for replying twice, after sending you a message I then found how to start new discussion. I'm no expert at this, I have used the control button to move to different records and queries and added things like auto fill for my forms, are these things the API and active x which you describe. As you sound so much more knowledged than I am, can I ask 2 more questions please, I have a form that has a control button at the bottom which takes you to the next record for the individual customer, when the next form loads it starts at the bottom of the form (as my form is quite long) I have checked tab order but don't know what else to try, VBA is not something I understand much but have managed to add some from watching utube videos. Question 2 can I password protect a form so prevent it being closed as I've made it a main menu. If you can help I would need an access for dummies step by step guide through it lol1.9KViews0likes4CommentsRe: Access query last record by date
I believe I have done it thanks to scrolling through utube, just checking now that it's giving back correct information, really appreciate that you replied and hopefully the link might help anyone else. 😀 https://m.youtube.com/watch?v=5cnwHyn4dnI1.7KViews0likes3CommentsRe: Access Query Problem
Its been a while since this was posted but I hav a similar issue, I have customers on one table and customers appointments with us on another. These are linked with customer ID and each appointment visit has its own unique ID too. I want a query to pull up the last appointment information for each customer by the last date they been seen. Then I want it to group information together, eg some customers are in different categories for each different appointment and I want it to pull up the last category by the last date for each customer. The code above confuses me when it's typed like that. I only know how to add it into query design rather than the code. Hope I hav explained enough, if not I am willing to tell u all the different fields if this helps. When I've tried to use max or last, it's pulling up maybe their second visit rather than the third visit (most recent)1.8KViews0likes0CommentsAccess query last record by date
Hi, I have created a database with a customer table and an appointments table linking them with a relationship using customer ID. My appointments table has an appointment ID also, so that each appointment is recorded separately for each customer. I want my query to show me each patients appointment information from their last visit. When I have tried using max and last, its pulling up eg, their second appointment out of 3. And to explain, really need step by step instructions as I'm a novice and amazed my database works in the first place. When I finish work, I can add all the fields I have onto here to help maybe get an answer as to what I put in my query design. Grateful for any help btw.1.8KViews0likes5Comments
Recent Blog Articles
No content to show