Search results

Thanks The-Doc-Man, i will try as suggested..

Hello all, I don't know what i did, but i got this message when i open my db file.. I started my db on my old Access (2007) at home and continue to create.. Forms, Query and Report on latest Access (dont know the version but it was a bundled to a laptop).. Now when I open to my old Access, it...

Thank you very much GaP42, well explain.. Maybe your first code is the suitable one, because my Status control is bound.. Again thank you..

Hi, How would i use this, i dont want to remove the default value "Active" of the Status control if the balance is not = to "0" zero.

Hi the-doc-man, The calculated contorol is based on 2 controls, 1) TCP is from table which the form source, 2) SUM control from a subform within the form. Now the control i would like to based the auto change is "balance".. My appologies guys if i can't explained well..

M Thanks the-doc-man, i will take note of that..

Hello all, How will i auto change the status confrol from "Active" to "Fully Paid" if my balance control value is "0"..my balance control is a calculated control in my main table.. Thank you all.

Hi Pat, As i read your answers i see that i did make my tables all wrong, oh well i am learning step by step.. Thank you sir..

Dear all, I have this tables (attached).. can someone please take a look on it and comment. I know something is wrong here, but i can't figure out the correct fields of each tables.. I am thinking that i will just combine into one table, since it is a one-one relationship. This table will...

Yes as i said in the very begining, im a new to ms access.. Thank you guys for guiding me through..

Yes.. and sorry if my post mislead you all.. What i am asking is to get the wizard work again..

Sorry i am not following you..

Thank you.. help appreciated..

Many thanks cheekybuddha

hi, i am not familiar with crosstab yet.. can you connect me to a demo link pls..

yes.. and i dont know what was happened.

Hello all, For some reason i lost the wizard function of my Access.. How to immitate the function of creating a combobox/listbox.. The function that what i selected in the combo/listbox will store in a form control.. As a newbie i can only create a functionality with the help of the wizard...

Hi, that is what i said, but then i tought if there is something like switch to show the subform to add record if available to add.. Like i was told, they dont want to see that thing (subform) empty. If there is, maybe you can guide me through.

Thank you isladogs.. i will study your demo..

Hi Sir The-Doc-Man, Yes the computers to be connected are in same office.. small office so there is no problem in cabling... Thanks for the link, i will check it.