Search results

Your examples and google searches come up with all different VBA modules. I thought there should be an Action available to use in embedded Macro under On Click event. My understanding is Macro modules are there to make things easier if I don't wanna use VBA. Am I right? Is everything done with...

Hi there, I have a bounded form/sub-form setup with navigation buttons that I've created using the Macro methods available to navigate through the records. How do I disable my NEXT button when I am at last record or PREVIOUS button when I am at first record? Macro or VBA? Which one is easier...

Thank you so much for your help. I will use your solution to fix the issue and learn more about it.

The cmc_units must only show the units we use for voluumes (when water is selected in cmb_items) rather than the mass units. In that version (the one that mike60smart posted) it would show the mass units for any selection in cmb_items. My issue was fixed with the solution from June7 and now it...

Here is the version that shows units improperly when I select water. I need to see voluume units when water is selected. DB is attached with your solution.

Thi solution works fine and shows the messages but the problem is why I don't see correct units in my combobox cmb_units? When I select a liquid (water) I'm expecting the voluum units to be listed in my combobox. Please see the attachment.

I used your solution and it works now. Thank you

I used cmb_ for my comboboxes where as friends in here use cbo. I will try to use cbo from now on.

I did remove the "s" and error was gone. The message is still not showing. I am going to respond tomorrow if you send me the solution. Thanks for your time Its bed time :sleep: Good night

I used this version and as soon as I select Apple in items combobox it gives me error and shows the VBA code. Once I clear the error message and select other parameters, Units and Packagin, I still don't see the message I was expecting to be appeared in textbox. I've already changed the column...

Hi everyone. Sorry for beeing late. I was busy with some other stuff. I downloaded both db's you've attached but unfortunately none of them worked. I used "=[cmb_packages].[column](3)" in my textbox's control source and nothing was showing up in the textbox when I selected any item from...

Hi All, I hope you all are very well. I have a data entry form created by MS Access 2016. I want to have a combobox that lists different items based on selction of cmb_items (like a castcaded combobox in a countinues subform). I name it cmb_packages and it gets its values from T_packages...

Thank you very much. I added the third column in my query design and it started working. Good catch. Thank you a lot

SELECT t_indexed_items.item_ID, t_indexed_items.item FROM t_indexed_items ORDER BY t_indexed_items.[item];

No. It is a number between 1 and 5

I added the space. It didn't fix the issue.

Hi everybody. Please help me on following syntax error. I am using a string variable as RowSource of combo box: cmb_unit. As you can see in the attached image it has syntax error and I couldn't figure it out. Private Sub cmb_items_AfterUpdate() Dim sSource As String sSource = "SELECT...

Thank you all and thanks again to Arnelgp. Your code is the solution to my question. Have a nice day Masoud

I want to enter any number les than 32 manually in my input textbox and have the binary codes in output textboxes. For example if I enter 27 I am expecting to see: 11011, each bit in an individual textbox. This code I have here outputs nothing! :( :( I can upload my simple DB once I get home...

Hello, I searched a lot and came up with a function that is not working the way I wanted it. I have a simple form with an input textbox (txt_input) and a button (btn_convert) that is meant to run my function and assign the outputs (decodedArray(5)) to my output textboxes (TextBox0 through...