Видео

This was actually very helpful, thank you

Hi Crystal! Thank you for sharing this! I'm having trouble getting this working in my own Access DB. My query joins linked ODBC tables from an external SQL Server DB and has all of the needed fields (CalDate, CalTitle, and all Text fields 1-3). The query runs correctly and shows my data in the datasheet viewer, but when plugging this query's name into the macro, no data shows in the generated calendar. The only thing that is properly printed is the calendar's title. Any ideas as to what's wrong?

Welcome back🤩

Love your content Crystal!❤😎

So many cool lessons I didn't even know about in this video, thank you for the info!

Thank you, simple tips but no one explain it, at least in Brazil videos.

Thank you so much. This was so helpful

It can be a special feeling when you experience that AHA! moment. I have been battling with Access for weeks and weeks, stumbling again and again on the basics because I was tasked with creating and maintaining a database at work, having no Access experience it has not been a fun journey, but thanks to your videos I have had numerous AHA! moments where the penny has just dropped and things finally start to make sense. Thank you so much!!!! I am so excited to keep learning now and I am going back to my work database with renewed vigor.

I have a tabular form with lots of rows against a similar ID. But when I build a query either in update query or union query it shows multiple rows against same ID and one field is in the last row against that ID. Now I want how to solve this or how to build a union query based on a tabular form

Almost what I need. I need help please. Example: [ParentID] is the same in multiple rows with different [ChildID] in each row. The Query should list [ParnetID] with only one child, based on the lowest number of [ChildID]. So basically a parent with the oldest child (based on ChildID, the child id is unique so the oldest child should actually have the lowest id number). Help would be appreciated.

Great

Hi Crystal, so did Michael license his content for you to post/use? Love his stuff, and sort of amazing the stuff he was doing, many, many years ago. :)

I love Michael's stuff! Is he still active?

Thank you it was exactly what I was looking for and works just fine and although not instant does produce a perfect report from the query

Thank you Guru, thank you very muchj

Mere report ka design view aeise nahi a rhe keise set kro plz bta de

Wish you happy, you save the day!

thanks a ton mam

Isn't there an ability to do this natively now? I could have sworn there was... Love DataPig Mike Alexander's stuff! :)

Thank you so much for saving my life :)

Thank you ! That was very useful video. I was aware that it is possible to maintain custom document properties, but did not have a use case to work with it before. Well now I have and your video brought me up to speed quickly ! :-)

Very helpful!

11 years later and it is still relevant. Picture perfect explanation.

I never give For...Next enough credit. This is a very elegant solution and provides clarity beyond Mouse Move. Thank you.

Thanks a lot for this Crystal, it will save me a lot of time. And thanks to your calm voice, RUclips can translate it into flawless Dutch for me. English is my second language, but Dutch is for me just a bit better to understand it faster. Keep up the good work.

How would you find the location of the second instance of a character in a string? Alternatively, how would you find the first instance of a character from right to left?

My criteria doesnt work. Its showing the full records count per row

Thanks so much. I've been working on this for two days and you solved it for me in less than ten minutes!

God Bless You!

Thank you it is grate code

Thank you so much for this. I've been stuck forever

Crystal, you are the best!!! Thank you for all your videos and tutorials! I love how you explain things. Thank you very much. BTW I love your Documents Tables2Excel!!!! It is AMAZING! I have been looking for something like this, so far I was able, on my own, just to get the field names and some properties but nothing like your module! Thanks again and hope to see more videos from you.

Thank you for your great explanation and calm voice! This was very helpful.

Your tutorial on MS Access Hierarchical Relationships is truly exceptional. Thank you for sharing this amazing content. Your teaching style is superb - well-paced, clear, and engaging. It made the learning experience a real pleasure

Thanks for the clear and helpful explanation on creating/editing custom document properties. This is super helpful! It's hard to find reliable MS-Word related content that's actually correct.

Is that ok if you could show us how to highlight the entire row that has duplicates. If there there are 2, 3 or more duplicates, then highlight. I know how to do just highlight partial. I want the whole row to make easier to view to troubleshoot the duplicates. I don't remove duplicates right way. I have to seem them first, review, then I delete them. I have patient name, MRN #, and many other columns related to the patient. MRN cannot repeat has to be unique, however, sometimes we want to keep the duplicate happens to see if patient is an old client, had already treatment before in the clinic. It's a database that I did not create, it should be created in a more efficient way. It should have a field where shows the old history of the patient, instead of repeating the client's MRN record.

Great trick! Thanks for sharing!

Thanks

Thank you for this great info

Have you looked at the new version yet?

Thank you. I searched and searched to find advanced properties. Great vid and very informative. Well done.

Crystal, thank you for reviewing my separate comment/feedback and investigating the issue. By using your generated, reformatted SQL as the input to a new query, I was using your add-in differently than you had intended. Glad the issue was resolved. I certainly did not expect to see a video on the issue's resolution. But thanks again--another great video. jdraw

How are you uploading MS ACCESS *2003* videos all the way in 2022 ? 🤣🤣 Nonetheless, this video was helpful _enough_ for the problem I was trying to figure out. Cheers! ☀️☀️

Thank you Crystal.

Thank you!!

Good to see your tutorials again Crystal. Thank you.

My installation of Office 2013 doesn't have MS Access in it.

omg I always wanted to do this and stumbled upon your post. 30 minutes...Done! Beautiful. Thank you! PS. most Access how-to videos are boring...love the creative ideas you bring.

Thank you for such a straightforward and simple walkthrough.

This seems like an amazing opportunity, thank you. Just a question. When I run the analyser, I get the following error message: Error 13 (Write_Obj_Properties, Type mismatch) and then the analysis stops. How could I fix this?