Search results

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 that the 2 last columns will only return the IDs from their original tables. Also you will notice...

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 run the query it is duplicating the entries, i.e. I have just 4 records, but when I simply include...

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 can build up his own report. Appreciate any help on this!:)

Thank you all for the invaluable and usual support! I will study all options and see what i will apply.

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 "copy" of a certain record to paste it on the acNewRec, so they can change only the few things...

EDIT: It is a bound combobox, so how can I enforce it?

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? Thanks, Diogo Cuba

Thanks for the app!!! I might need something like this in my project!

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!

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. THANKS FOR ASKING!" should be turned to: "My name is Diogo. Thanks for asking!"

Gemma the Husky, how can I change your code to have just the first word in Upper Case?

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 approach. The form has been working OK all day after many testings and the "LOCKED" effect was indeed...

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 considered applying that to the navigation buttons but they are already being used at the main form...

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

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 Me.cboBehaviorIssuesFK.RowSource = " SELECT tblBehaviorsIssues.BehaviorIssueID, tblBehaviors.BehaviorID...

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!

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 not locking itself after closing and reopening the form or clicking on editing and locking again. I...

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 after they are locked and disabled.

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 lblHeader on the top. I have done some testing and commented this part of the code and also tested...

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. cboGoTo is the one being "locked" if I change it´s LOCKED and ENABLED property when I click on...