Search results

This is the approach I used and now it works perfectly. Thanks for giving me the idea of handling a subform as a control in a form, and not a form within a form. I got stuck because I treated it as a form. Everything was untangled nicely once I got in the right direction. One thing worth...

So I suppose it's something like CStr(i), converting another data type into string type? So in that sense, null & "" would also force Null to become a zero string? If so, this technique can be very useful when handling the nulls. Got it. I have a solution forming in my head now. All I need to...

I'm not at work right now so I'll just post a quick reply. CJ_London: I did that already. It only requeries the main form, not the underlying subform. Sonic8: A subform as one of the controls in the main form! I hadn't thought of that at all. If it were combobox that needed to requery, I...

How do you write a sub procedure that, when you pass a form's name or a form object as the parameter, it checks to see if the form is loaded, then requery its underlying subform? This is what I was trying to do, hard-coded: Forms!frmMain1.subForm1.Form.Requery Ultimately, I'd like to come up...

This is awesome! I have bookmarked your website for future reference. Thanks a lot. I will try my best to decipher the codes.

Actually I was thinking of something like a custom message box or input box that has both a template and a class module, the contents of which will vary depending on what the code tells it to do. I'll just stick to controls for now. Time to continue reading that Access Events thread...

I will definitely go through this entire thread. Thank you so much for your examples. Now I think I have my two-fold approach to this problem: a template form that defines their looks (for copy & paste) and class modules/common procedures for their behaviors. I wonder if I could also do the...

This is great stuff! Thanks to MajP for opening my eyes to a new dimension. Now I have a few questions: This class module defines the functions of the controls. So before I use this class module I need to manually places all of the controls into the form, format them to my liking, and name them...

This is fabulous stuff. I have bookmarked this page. Thank you so much!(y)

Yes, common procedures and functions with parameters is also the approach I use most of the time. I have quite a few universal procedures stored in modules for various tasks in many of my forms, something like yours. This works fine for me for now, but I keep getting recommendations to use class...

Yes, I was just coming to that. The funny thing, though, is that sometimes just copying code over from template to new form doesn't automatically register the event, and the code won't be invoked at all. For example, if you copy the code from the line Private Sub btn_Click() all the way to End...

Wow, thanks for all your responses. It will take me a while to digest. For now, I guess I'm more inclined with Doc's idea of a template form, because it's something I can work on right away. I imagine I will be creating a blank form, populate it with my reusable controls, properly formatted and...

Let's say I have a textbox that allows only numeric input, or OK/Cancel buttons with preset formats and Default/Cancel properties, any kind of reusable controls that I will have on several of my forms. Is it possible to save those controls somewhere, along with its formatting and code, so that I...

Figured it out myself. Turns out the solution is so simple that I was ashamed of myself for even asking. Just put this line in the startup script or Form_Load event of the startup form, and this resource will stay accessible until the next reboot. Shell "net use \\server\share /user:usr pwd"...

Actually, it doesn't really matter which OS hosts the share folder, what I'm really looking for is a way to authenticate and interact with network shares through code, the way you use connection objects, connection strings or drivers to authenticate and manipulate remote databases. If all...

It's a folder in the Ubuntu Samba server, to be exact, so I just specify browsable = no and that share will be hidden. If you can access that folder with any random string as username and no password, that means there is already no restriction to access. I just don't know why Windows insists on...

Hi, I have a table with a field named [ImgagePath] that stores pictures of items. Images are stored on a folder in the server. I have set up the folder to be completely public but not browsable, that means anyone can access the folder if he/she types in the path \\server\folder directly in the...

Yeah, probably, same goes for the SQL. Guess I'll never find out. Thanks, people, for all your help. If something unexpected comes up again, I'll put it in another thread.

DAO was indeed included in the list of references, but with my current project, it wasn't checked by default, when it should be. The statement Dim rs As DAO.Recordset threw out a "User-defined type not defined" error, and it took me some googling to correct it. I didn't run into this problem...

Yes, I just did. A fresh blank database with nothing in it. I went to check the references immediately. And yes, DAO was checked by default. But it wasn't the case with my Project2. I had to Google out the full name of DAO and find it in the references list.