I found the problem, some misnamed items. Another intern has a similar process working and I am getting help from them.
Thanks for all of your help, sorry for all of the confusion!
brittaff
Last Activity: Jul 22 '21, 08:33 PM
Joined: Jul 8 '21
Location:
-
I'll attempt to take this one step at a time.
First, yes..the BuildExhibits() code is very long. And as IslaDogs said, the moduke is called modBuildExhibit and the function in the module is BuildExhibits() . I cannot make changes to the function, it is also used by other people. If necessary, I'd have to ask if I can even post it because it is for my internship. I don't believe that the person who assigned this job to me knows much about the...Leave a comment:
-
The BuildExhibit module is defined as a public function in VBA. The end result is that it aggregates records into a sorted table. These records are coming from an Access table called InputData. The InputData table is created through a query.
The BuildExhibits module in VBA defines the public function BuildExhibits() and ends with creating a table called tblExhibits. This function doesn't have any defined parameters in the function....Leave a comment:
-
I'm sorry, I don't even truly know how to ask my question. This was assigned to me and is obviously beyond my capabilities.
I am using Microsoft Access. I was given an assignment to run a pre-written VBA module that is inside a large VBA project. The module is supposed to be ran on a table created in Access through a query.
I have the query working; it takes a very large data set and creates a table that only includes items...Leave a comment:
-
brittaff started a topic Help to create a table with query and then run table through a public functionin AccessHelp to create a table with query and then run table through a public function
I am writing code in VBA in Access.
I need to filtered a data set. I am brand new to this so I apologize in advance if this isn't clear.
qryFilter is the query that creates a table "Filter" that only has the filtered data.
BuildExhibits is the public function that I need to run with the new filtered table.
...Code:Public Function InuputData() DoCmd.OpenQuery (qryFilter) Dim objRecordset
Last edited by NeoPa; Jul 19 '21, 11:35 PM. Reason: Added [CODE] tags which are a requirement when posting code. -
Thanks Ade,
I have set up a query that runs through the table with the checkboxes and only prints a table with the items checked. My next step is to run another prewritten module for the table that was created from the query.Leave a comment:
-
Here is the first area where the RecordSet function is used:
'Add "Statement" Line Numbers to table. (line numbers are not correct for Reinsurance Ceded line).
strSQL = ""
strSQL = strSQL & " SELECT Min(tblExhibits Template.ID) AS FirstID, CoSort, AcSort, Ex5Sort"
strSQL = strSQL & " FROM tblExhibitsTemp late"
strSQL = strSQL & " GROUP...Leave a comment:
-
Thank you, I added more details. I have ever coded before and have been given a rather large project.Leave a comment:
-
Need to only run a module if the checkbox is checked
Sorry for lack of details, this is very new to me.
I have a large dataset. There is a table that has a column with the checkbox option. The table is created in the module's code. Some options in the table are selected with the checkbox and some are not. I want the records that are selected (checked) to be processed. My module runs on all the data in the set, but I want it to only run for the sets with the boxes checked. The key is...
No activity results to display
Leave a comment: