Search results

I get it but like I mentioned, if there is adjustment to do, if can done via the table instead of the need to release a new front end.

Right but I want to display an hint by using a dlookup from a table (see my attachment). In the futur, if there is changes in the hint, they can simply change in the table without the need to throw out a new version of the front end.

Hi, I have attached an example of what I am trying to achieve. If you open the "client_subfrm", and click on any field, the "Hint" will lookup in the table for hint, but if you open the main form which is supplier_frm, it won't work. Can you take a look. Thanks

Thanks this works, but I forgot to mention that the field is in a subform. The code works when I open the subform by itself but when its in a form as subform, the active capture the form as active form, so it doesnt work.

Hi, Nope it does not. I get error message: The expression you entered has a function containing the wrong number of arguments. Thanks

In a continuous form, I can write: [control].[Form]![field name] then it will populate that field. On a single form, I have multiple field on the firm. I want the form to prompt the name of the field I am currently in. Once I go to another field, it will prompt the name of the field. Example...

Yes, but I have to set the function to populate the field name on each of the field. Isn’t there an event on the form itself that detects each time we move between field? Thanks

Hi, I have a form with many field and I would like to know if it's possible to populate the name of that field once we click on that field? Is there any fire event that capture each time we navigate through different field? Thanks

The number of male and female per province. Province is already predetermined. Thanks

Hi, I need to reproduce a table as per below and I would like some feedback on how to design such table? Province of Employment | Participating employees | Male | Female BC AB SK MB ON QC NB NS NL PE Federal I'm thinking 2 tables: The first one with 12 columns, one for each province + PK id...

Thank you very much!!! This saves me tons of time!!

So now, I changed the code to the following to target the form directly: Public Function fncChangeTag() Dim aO As AccessObject Dim fm As Access.Form Dim sf As Access.Form Dim ct As Access.Control 'For Each aO In CurrentProject.AllForms ' If aO.Name = sForm Then...

I was able to run the function, but now, after close it and reopen, I can't run it anymore. It says variable not define. Is there a way to decompile Access to reset all memory in the database? Looks like something its messing with my database now.

Not really, I have about 15 subform with at least 15 fields on each, thats about 225 to manually do them. I won't do it manually ;)

All the form are closed and I just execute within the Immediate Windows. Call fncChangeTag("pdo_prod_reg_info_rrsp_subfrm") I also added the msgbox at the end of the function to ensure it's completed properly, the prompt does appear. I went back to pdo_prod_reg_info_rrsp_subfrm, right click...

The debug.print does give the right Label name and it's caption, but it does not change the Tag property of that Label. After executing, I went into design mode of that subform, and the Tag for the label is still blank. Thanks

I execute within Immediate Windows, went back to the design form of the subform, the label associated to the field still has empty tag? Thanks

Tried that as well, not working. Thanks

Yes, I add a command button on that subform to only create the tag within that subform. Thanks

Hi, I added in my subform about 20 fields, and I want to change the tag property of that label to match the name of it's field. Is there a way to do it via a code instead of manually doing it one by one? Here is what I use but doesnt seems to work: Dim c As Access.Control For Each c In...