Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 133
Search took 0.05 seconds.
Search: Posts Made By: DiogoCuba
Forum: Queries 10-30-2019, 09:02 AM
Replies: 9
Views: 250
Posted By DiogoCuba
Re: Help on Querying with Cascading ComboBoxes

Regarding your question, thatīs right: the dependency is only when I have those cascading combos on the form, once the user chooses one and the other the bound table will save the information...
Forum: Queries 10-29-2019, 04:52 PM
Replies: 9
Views: 250
Posted By DiogoCuba
Re: Help on Querying with Cascading ComboBoxes

No rush and everybody is more than welcome to jump in!
Forum: Queries 10-29-2019, 04:39 PM
Replies: 9
Views: 250
Posted By DiogoCuba
Re: Help on Querying with Cascading ComboBoxes

OK, it is working now and returns the "WORKPLACE" as I need. Thanks!!!!:D

But how do I put the value from the PillarElement? This value depends on the SafetyPillar.
Forum: Queries 10-29-2019, 04:23 PM
Replies: 9
Views: 250
Posted By DiogoCuba
Re: Help on Querying with Cascading ComboBoxes

It is not working as expected, pbaldy. Despite of returning 5 records, the last column that was intended to return the "Methodology" instead of "3".

If you check the new attachment you will see...
Forum: Queries 10-29-2019, 03:28 PM
Replies: 9
Views: 250
Posted By DiogoCuba
Help on Querying with Cascading ComboBoxes

Hi,

I am trying to build a query that collects some information and export it to Excel. But since many values from the DB is coming from cascading Combobox.

During the tests I noticed when I...
Forum: Reports 10-29-2019, 01:19 PM
Replies: 5
Views: 226
Posted By DiogoCuba
Tutorial to Build a "Report Center"

Fellow Access Master,

I would like to know if you could reference me to a tutorial or something similar to a tutorial or example that I could learn how to make a "report center" where the user...
Forum: Forms 07-22-2019, 10:59 AM
Replies: 5
Views: 152
Posted By DiogoCuba
Re: How to "copy" data and "pasting" to the acNewRec

Thank you all for the invaluable and usual support!

I will study all options and see what i will apply.
Forum: Forms 07-22-2019, 06:28 AM
Replies: 5
Views: 152
Posted By DiogoCuba
Lightbulb How to "copy" data and "pasting" to the acNewRec

Guys,

I have a small DB and it has a form where users can input information. Since sometimes they have to input the basic information all the time, they asked me if it would be possible to have a...
Forum: Forms 07-17-2019, 06:03 AM
Replies: 3
Views: 115
Posted By DiogoCuba
Re: Why ComboBox does not trigger Formīs dirty event?

EDIT: It is a bound combobox, so how can I enforce it?
Forum: Forms 07-17-2019, 04:44 AM
Replies: 3
Views: 115
Posted By DiogoCuba
Question Why ComboBox does not trigger Formīs dirty event?

I have a form that would disable a button if user is editing data. However, when any combobox is changed it does not fire the Dirty even of the form.

Is it s normal behavior on comboboxes?
...
Forum: General 06-17-2019, 02:38 AM
Replies: 3
Views: 403
Posted By DiogoCuba
Re: Enjoy :) Working reports App

Thanks for the app!!! I might need something like this in my project!
Forum: General 04-19-2019, 05:25 AM
Replies: 25
Views: 43,628
Posted By DiogoCuba
Re: make the first letter uppercase

I believe Gemmaīs answer will suffice my needs since it will be too much trouble to get the special cases and other stuff.

Thanks anyway!
Forum: General 04-19-2019, 04:33 AM
Replies: 25
Views: 43,628
Posted By DiogoCuba
Re: make the first letter uppercase

That a great hack... But I made a terrible mistake when asking the question, I meant:

How to make just the first letter of the first word in upper case?

Example:

"MY NAME IS DIOGO....
Forum: General 04-19-2019, 03:43 AM
Replies: 25
Views: 43,628
Posted By DiogoCuba
Re: make the first letter uppercase

Gemma the Husky, how can I change your code to have just the first word in Upper Case?
Forum: Forms 02-28-2019, 03:45 PM
Replies: 22
Views: 426
Posted By DiogoCuba
Re: Combo Box Locked and Disabled but still clickable

I would like to thank you all for the help on my formīs issues.

Specially for JHB for calling my code "messy", that pushed my buttons and I have revised it to have a more straight-forward...
Forum: Forms 02-28-2019, 05:21 AM
Replies: 22
Views: 426
Posted By DiogoCuba
Re: Combo Box Locked and Disabled but still clickable

I tested it using it at LOAD but it didinīt work because when I navigated to next record it didnīt change the formatting as expected. Neihter using it at the buttons LOCK/EDIT.

I have even...
Forum: Forms 02-28-2019, 04:35 AM
Replies: 22
Views: 426
Posted By DiogoCuba
Re: Combo Box Locked and Disabled but still clickable

I indeed suspected that the form current event was causing me trouble.

Let me work on your solution and let you guys know.

Thanks.




Enviado do meu iPhone usando Tapatalk
Forum: Forms 02-28-2019, 04:20 AM
Replies: 22
Views: 426
Posted By DiogoCuba
Re: Combo Box Locked and Disabled but still clickable

Colin,

I have changed the Form_Current event to this to mimic the removed the CF:


Private Sub Form_Current()
Me.lblHeader.Caption = "SAFETY OBSERVATION CARD: " & Me.txtCardNumber...
Forum: Forms 02-28-2019, 04:11 AM
Replies: 22
Views: 426
Posted By DiogoCuba
Re: Combo Box Locked and Disabled but still clickable

My dear Colin, as usual, you were right! :)

The moment I removed the CF both controls became locked. I will test the theory proposed.

Thanks for the help!
Forum: Forms 02-28-2019, 03:18 AM
Replies: 22
Views: 426
Posted By DiogoCuba
Re: Combo Box Locked and Disabled but still clickable

I changed the code from the button on the main form that opens the frmCardObservation to this:


DoCmd.OpenForm "frmCardObservation", acNormal, , , acFormEdit


The cboGoTo odd behavior is...
Forum: Forms 02-28-2019, 03:05 AM
Replies: 22
Views: 426
Posted By DiogoCuba
Re: Combo Box Locked and Disabled but still clickable

In that form I have got 3 issues actually:


cboGoTo that has the "locked" effect after being disabled and enabled again.


cboBehaviorFK and cboBehaviorIssuesFK that remains clickable even...
Forum: Forms 02-28-2019, 03:02 AM
Replies: 22
Views: 426
Posted By DiogoCuba
Re: Combo Box Locked and Disabled but still clickable

That was intentional, once the code on the cboGoto after update event loads the record to the form then I donīt want cboGoto to display the card number since it is already being displayed on the...
Forum: Forms 02-27-2019, 02:39 AM
Replies: 22
Views: 426
Posted By DiogoCuba
Re: Combo Box Locked and Disabled but still clickable

The form is attached, I have removed a lot of code from the original form as per Isladogs' and JHB's advice.


The comboboxes with problems are on frmCardObservations, which is an editable form....
Forum: Forms 02-26-2019, 02:54 PM
Replies: 22
Views: 426
Posted By DiogoCuba
Re: Combo Box Locked and Disabled but still clickable

Thanks CJ! I will work on that. Seems this file is building up a lot of issues against me lately.

Now I have just noticed another combobox is behaving oddly: if disable it and enables it becomes...
Forum: Forms 02-26-2019, 01:49 PM
Replies: 22
Views: 426
Posted By DiogoCuba
Showing results 1 to 25 of 133

 
Forum Jump



All times are GMT -8. The time now is 10:20 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World