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...

that, I don't know. If you can post a working example as you have it, I'll be glad to look.

Not positive, but from what I've replicated, it seems to be related to the data type of the bookmark and how it is being saved into the STRING variable. When watching that variable, it seems to always have a value of "?
", even when records change. And since it's always being stored the same...

Instead of using the bookmark as a reference to your current record, you might try using a UniqueRecordID. Private Sub chbChoiceSelected_AfterUpdate() On Error Goto ErrorTrap Dim rst As DAO.Recordset Set rst = Me.RecordsetClone With rst .MoveFirst Do While Not .EOF...

I've done something similar, but have preferred to use an SQL statement. Maybe it can help you. With the code below, you would need to change "tableName" and "UniqueRecordID" to the appropriate names for your situation. Private Sub chbChoiceSelected_AfterUpdate() On Error Goto ErrorTrap Dim...

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...

Learn something new every day. Now that i know what IN() is actually doing, it makes sense. Not sure yet if I'll be able to use the ad hoc approach in this particular situation, but it does give me an avenue to think through. Appreciate the quick reply.

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...

Greatly appreciate the time you took to provide a working model! I'll be going through it here shortly. BTW, good to see H.P. passed his classes.

The closest I could come is the following: PARAMETERS [Course ID] Long; SELECT QRY1.EmpID, Cou2.CourseName, QRY1.[Class Date], Reg2.Score FROM (SELECT Reg1.EmpID, Max(Cla1.ClassDate) AS [Class Date] FROM Table3 AS Reg1 INNER JOIN Table2 AS Cla1 ON Reg1.ClassID=Cla1.ClassID WHERE...

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 came up with a solution, although maybe not the best. If anyone has the "proper" method for accomplishing this, please let me know. SELECT Classes.ClassID, Users.UserID FROM Classes, Users WHERE (Classes.ClassID & "-" & Users.UserID Not In (SELECT Registration.ClassID & "-" &...

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 came across a little personal side project, and thought it was a good time to try and come up with an alternative to my inquiries posted here earlier. Here's what I have working, for those who might be interested. Instead of passing a form name, I am passing an object variable that is a copy...

Thanks to all for suggestions! Really appreciate all the feedback. The subform technique looks promising. I'll continue moving forward with this in mind. If I happen to run across a method for my initial inquiry I'll post back, but for now I'll go with what we have here. Thanks again!

Appreciate the reply. I have read that site, and have based my form management from it. However, it still does not address my initial question... In the example in the link, a new instance of a form is created by hard-coding the form code name into the procedure. This is what I am currently...

Thanks for the speedy reply. While the DoCmd method would work, it still does not resolve my initial question. I want to set a variable as an instance of a form/report by using the form/report name. There are situations where multiple copies of the same form may be required to be open...

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...