Search results

I have an Access Query that returns a calculated field. This query feeds into an Excel pivot table. When this calculated field is used as a Value field in the pivot, the pivot table correctly displays the number of entries where the calculated value is not empty. However, when i dbl-click the...

I'm trying to hide the "Ribbon" using VBA, and I can't produce the results I need. I know a variation of this topic has been posted several times, but I haven't seen a post that duplicates my issue. The following code works when the database is in a DEBUG mode, but not when in production mode...

I want to create a dynamic IN() clause using a recursive VBA function. My UDF returns all the values I need for my IN() statement, but I cannot get the query to return the correct dataset. Pretty certain its in how I'm calling the function, but I haven't found a solution as of yet (maybe I'm...

I'm having trouble designing a query in MCASSESS to generate the results I need. Can anyone provide any insight into how I need to build this correctly? I have three tables relating to courses employees can take. Table1 is a list of courses, Table2 is a list of dates that courses were offered...

I've got three tables: Users, Classes, Registration. The Registrations table is my join table between Users and Classes. The fields are pretty simple. Users: UserID Registration: RegistrationID, UserID, ClassID Classes: ClassID I need to identify which users have not registered for which...

I am curious if there is a way to set a variable to an object type in Access by the name of the form or report object. For example, if I have a form named "frmSwitchboard", is there a way to set a variable to this by using the actual form name? A simplified example... Private Sub...