Recent content by gdesruis

I had the [Activated?] column set as text. Upon switching to Yes/No the code worked flawlessly. Thanks!

By changing the year column it does provide an accurate check based on the year, but it is not considering the [Activated?] column if the value is "no". Should I try your query method and see? or is there a simple piece i'm missing thanks for following up.

thanks, that seemed to provide a count for me instead of a type mismtach, although the criteria filters do not seem to be working, it is just providing a total.

I am looking to generate a total number of a given column based on two criteria. I would like a label (or textbox if necessary) to display a given total of "Active" devices based on a given month. The table name is "Blackberry" and the specific columns I would like to check would be...

Wow thanks, I will look into all of this. I might be way out of my league here. and yes an unbound textbox.

I would like to run a check on a textbox to ensure it contains a proper format. format: starts with: 0- contains: 7 digits after.

Hey Bill, thanks for the quick response. I have tried to use the code you provided, and i keep getting the error "else without if". Also, can I add my blank data entry checks for the two textboxes to your block of code? (ideal at the end or beginning?) Your code: Dim dbsemployees As...

New to MS Access, and it is bringing back memories from using VB in highschool. Quite beginner here in terms of VBA knowledge and the Access itself. Through researching on google. I managed to find code to create a user login screen. I added a new button to allow for new user creation. I have...