Recent content by tjnichols

I looked up the "FileDialog" but couldn't find an example that spelled it out enough for me to apply it to what I need here. Again, this is SOOOO NOT MY STRONG SUIT!! I really appreciate your help! Here is what I came up with though: - Does it make sense? Declare PtrSafe Function...

Ok - can you post the code to replace what I need here?

I have a database that was created in Access 2007. I have moved it to Access 2019 with the Windows 10 update. The issue I'm having is when I try to run the macro it should open a form to look for a file. It does nothing. I must admit VBA code is by far not my strong suit but here is what I...

Well Jon - I love this site. It has been extremely helpful to me with my Access endeavors. Well mostly - I wish you could block someone from even being able to reply to my posts. Galaxiom isn't helpful and just slams you for not 'doing it the right way'. I understand there are proper ways to do...

I need to store these values as they will be used in reports and other forms. Can you please help me with my problem versus pointing out issues you think I should fix?

Good evening. Alright now I feel like something off the Adams Family but down to business... I need to create an update query that updates two fields. One is a fiscal year (FiscalYear) field. The fiscal year runs from July 1st through June 30th. The calendar year (CalendarYear) is your typical...

Yes that worked! I should have thought of that. I am not new to Access but there are a lot of things I don't know how to do which is why I post here but I should have known that! Sometimes, you can't see the forest for the trees. ;-)

Can you limit the pages to print based on if there are records in the subreport portion of the report? For example... I may have 20 records in my contacts folder. I may have 100 assets but I only want to print the report based on the assets that are checked out. Thanks! Tonya Nichols

Good afternoon. Can you make different subforms appear based on whether or not a check box is checked? Thanks. Tonya Nichols

Bob - I'm sorry! It says I can't because there are things that rely on the 2007 version. Let me know if you have additional ideas! Thanks!!! Tonya

I have a form that is attached to a query. I want this form to add an Attendance ID, the consumer ID and child ID will be automatically entered because the Attendance ID is an autonumber and the other two are linked to parent forms and will be filled in based on the ID's of the parents. The...

Yes - but I went back and looked closely at the formatting - IT'S FIXED!!!

As requested vbaInet - here is the SQL. I will look at the formatting. I have looked at this but I am unsure of whether or not this is a problem... My Attendance table has an autonumber for the Attendance ID, my classes table also has an auto number for the classes ID but the field that...

I have a query that I want to actually populate a table with information. This database is a contact database that has classes that the contacts / students will attend. I think the AttendanceID should be a new record because each contact can attend a class. Each contact can attend many classes...

OK but I get a Type mismatch expression error when I do this... I don't know enough about code to know how to correct it.