Recent content by tazijake

Is a StepXCompletedDate field something else or do you mean that if that field is complete, obviously that step is done? When I say a 2nd check or visual cue, I'm speaking specifically on the user end. If I were creating this database for my own use, a complete date would be sufficient...

Thank you! I see what you are both saying as far as the redundancy, but it will serve as a visual cue (and, in essence, a 2nd check) to ensure that the user is filling in the correct field and then ensuring that they follow through on the step with the requirement that you helped me build. I...

Hello everyone! I have a form which is tracking a process and as each step is completed, the user clicks a checkbox to activate the textbox where they can enter the date the step was completed. If they click the checkbox to activate the textbox, I want to ensure that the textbox is completed...

I figured it out! It was a dumb mistake. It had to do with the name of the query. I did in fact create a circular reference because I was naming the new query that I had created with one of the queries that I used to create it. Sadly, it made sense to me when I first did it! I renamed it and it...

Hello - thanks for the advice shutzy: I did use the wizard, this report has been working well for me for a while, I'm just trying to add a little more value to it. Just gotta get these queries together! jdraw: To relate my issue to that video... I already have those sorts and groups set up, I...

Hi jdraw - Thanks for the response. I'm using Access 2010 and from what I've read you can't sort a count in the report. If you can, I haven't figured that part out yet. I did see that if you join the two queries that you could then just sort the count field in the report but I can't get my...

Hello! I hope this hasn't been covered elsewhere, I searched the forums - but ya never know... Background: I have a database which tracks requests from different departments. The requests are assigned sequential numbers (MOC#) regardless of the department it comes from. I created a report...

Hello everyone - I've been using Access for a little while and am starting to learn VBA to make my DBs more awesome! I visit this forum often so I figured it's time to officially introduce myself. Thanks for all of the help you didn't even know you gave me already! Alecia