Search results

Im sure that this is an over asked question, but, how may i remove duplicates from my query? I have a visits table, with managers doing these visits; and i have a field called "Manager". The problem now is that when i put this in a form, and create a search combo box, the combo shows me the same...

yep.. i just locked everything and made an edit btn...

in property sheet.. cuz access chose not to accept it as code.. and the dam thing still not working.. i gues i'll just make the whole thing read only and disable all of the fields that i need, and create an edit button with a form to it.. thanks for all your help guys!

every time i want to close the form or the application for rhat matter, access bugs me by asking whether i wish to save the current form i am on.. and it does this non-stop!! any ideas how i can fix this? cuz the database is fearly complex now and i don't want to re-create it all again =/...

and when i put it to No in form properties under Data, the blank record still appears, ready to be filled in =/ i have this problem on my continuous form, where the whole list is presented to the user. I need to visually get rid of this stupid row.. any ideas how?

so where do i put: .AllowAdditions = False cuz im a little confused.. how do i make it work? =/

hi guys, how do i make my forms Detail - read only, and leave the header as normal? you see, i have a combo box which filters the form in the header section, but if i open the whole form in read only view, the combo doesn't work what results no filter for me :mad: or alternatively, how do i...

hi guys, basicly, i got an Add Contact button, which runs the macro attached to this post, what opens a blank form; at which stage i wish for the form to enter a value in one of the fields from another form: On Load event: Private Sub Form_Load() Me.ShopInfoID =...

so.. i have a continuous form within the subform of a form (hope it makes sense cuz its gona get worse). I have a button for every record in the continuous form, so that i can edit that specific record in a new form. the button has the following macro, attached to this post... the form...

For god sake.. if only we had thought of that earlier =/ spent the whole day looking for solutions.. Thought I should thank the best post :o thanks, a lot bud.. it seems to work like clockwork now :)

still not working mate.. any other ideas or thoughts on how to approach this? :(

-.- yes.. yes i did.. still not working my friend..

nop.. not closing =/ seems like a standard task, yet flipping impossible cuz access chooses to be an idiot

Sub Form_Load() On Error GoTo Form_Load_Err If ParentFormIsOpen() Then Forms![01_AddShop]!ToggleLink = True Form_Load_Exit: Exit Sub Form_Load_Err: MsgBox Error$ Resume Form_Load_Exit End Sub

so, i went through my wizzard on creating a form, where i use two tables, and i had chosen the option to have "linked forms" rather than "form with subform(s)". When i click on the button to open the child form, i want the parent form to close... any ideas at all? cuz i tried almost...

Has anyone got any ideas on how you can carry previous information onto an other form? I was told that OpenArgs may help, but i have no idea on how to use it.. for instance, i have information which i fill in one for, then when i click on the Next button, another form opens with the previous...

http://www.youtube.com/watch?v=pMiJHhjzC8Y

On form filtering and handy overall: http://www.youtube.com/watch?v=khndDXtFC7I

Dynamic combo boxes: http://www.youtube.com/watch?v=pMiJHhjzC8Y

so what do i need to do? :)