troubleshooting Question

Referencing checkbox on form from Module

Avatar of ckangas7
ckangas7 asked on
Microsoft AccessVisual Basic ClassicVB Script
2 Comments1 Solution272 ViewsLast Modified:
This is a simple one, but I still don't quite understand the naming / path references to object in Access VBA.  I have a checkbox called sparbox on a form named Spartan Report Dialog.  I am trying to reference the checkbox in the following module.  I tried
If Sparbox
If Me!Sparbox
and what you see below.  What is the correct way to reference the location of my checkbox object?

Sub rename()
Dim objWMI: Set objWMI = GetObject("winmgmts:{impersonationLevel=impersonate}!\\.\root\cimv2")
If Forms![Spartan Report Dialog]!Me!sparbox = True Then
Set colFiles = objWMI.ExecQuery("ASSOCIATORS OF {Win32_Directory.Name='C:\Central Billing\Import\Spartan'} Where ResultClass = CIM_DataFile")
Set colFiles = objWMI.ExecQuery("ASSOCIATORS OF {Win32_Directory.Name='C:\Central Billing\Import'} Where ResultClass = CIM_DataFile")
End If
For Each objFile In colFiles
  If LCase(objFile.Extension) = "psd" Then objFile.rename (Replace(LCase(objFile.Name), ".psd", ".csv"))
End Sub
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 2 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 2 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros