In excel VBA, there is a file size limit on the module that holds macro code. I know there is - I've ran into it before.
Is there such a limit in access on the size (compiled or not) of a .bas module? Has anyone ran into one yet?
We have a database app from a vendor that we are allowed to customize - and we do. Upgrades are ridiculously difficult - the vendor releases an updated module, which we have to evaluate...
KaleeyJ
Last Activity: Dec 4 '08, 03:28 PM
Joined: Sep 20 '07
Location:
-
Quick question about .bas file size
-
Focus problem
I have a main form, called frmMain. I have a subform, and the control is named sub_options. The forms that can appear in sub_options all have a single textbox. frmMain has a button on it called cmdNext.
When I enter data in my textbox, I usually click cmdNext right afterward. The problem is that since the two are on separate forms, I have to cmdNext TWICE to make the click event occur (I suppose the first time is to change the focusback... -
Normally you just need to put the field you need "barcoded" in the source query of the report. Format this field for the barcode. (Like, with some codes, the data has to be surrounded by asterisks, so if I need to barcode the field ID, then I have an expression in the query that reads: Bar_ID: "*" & [ID] & "*").
Then just put that field (Bar_ID) on the report as a textbox, and in the format properties,... -
Ahhhh... I thought the error was generated anytime the file couldn't be accessed through the given path, whether it be due to permissions or bad typing. Perhaps I need to check our code again - I apparently was mistaken.
Yes, that helps considerably.
Thank you!
~KJLeave a comment:
-
I suppose that if we have to do either read access or continue running, security dictates that we continue running, suppressing error messages unless they try to open the file.
I was hoping someone had done a work around - like ghosting as a read-only user or something similar. The problem is that keeping the error messages is useful if the file doesn't actually exist - I was hoping to only suppress them if the file was not accessible....Leave a comment:
-
Dir function throws error when no access to file
I have an Access/Jet app with a ton of VBA, and a few particular funcitons are giving me trouble.
We have a part of this program where we can link a file name (with the full path) to an order. This works well most of the time. This gives us a record of what datafiles were used.
Recently, we had another department start using the Link function to link /their/ files on the network (original documents, design files, that... -
I think that I may be forced to do the multiple rpeorts solution - seems the only way to programmaticall y change a report's source is to do so in the OnOpen Event of the report - I would much rather be able to do it from my form (so I can set it back as soon as I am finished, among other reasons).
If anyone comes up with a better solution (that doesn't involve changing the code in the report's on open event), I would appreciate it,...Leave a comment:
-
Changing report source query at runtime
I have a report that uses a parameter query where the parameter is supplied by a form in my db - frmSINGLE. I need to run this report based on a different form - frmMULTI. frmSINGLE may or may not be open - in any case, I don't want to use it.
I would like to avoid having two reports (and two queries) that have the exact same contents save one criteria on one field - this db is big enough as is. So my plan is to change the record source...
No activity results to display
Leave a comment: