Search results

perhaps i should have mentioned this is a continous subform I have only access 2007 using DoCmd.CancelEvent on the mousedown doesnt seem to effect the mouse being able to 'select' the values from the dropdown once the values are revealed by the 'onenter event' 'myctrl.dropdown' . But It does...

Thanks i just tried it It prevents the mouse from droping down the menu on the control but i have the control set to .dropdown on the OnEnter event (this is neccessary as the value in the drop down depend on previous entry) and the mouse can still select the values there must be another...

I have a data entry form, corectly tab indexed etc changes colur where the focus is and everthing. there are three dropdowns which drop down on the onenter event and whose values depend on previous entries. Despite advice to the contrary Users insist on using the mouse to select values from...

I am trying to populate a combo box on a client side access form from a server side stored procedure on sql server. using ado Im am getting the record set accross and the debug.print prints out from 1 to 4 addresses but I cant seem to bind this record set to the combo box in my form...

okay yes i see, i'm an idiot this event driven stuff is a bit confusing:o my code doesnt work the before update is fired as soon as i try to click out of the current row and if the flagUp is True then I cannot get out of the record because the record cannot update.

stone me ! its working fine now, i ve not tested the form fully to see if i get all the desired effects. me thinks that even though i ran compile, maybe i didnt save my last little edit before i tested the form as to why, i want to stop people editing randomly and force them through a tab...

i have a continuous sub form to which the user adds new records the validation rules & tab stops vary depending on the value in the first and sometimes the second field of the subform Problems arise when the user decides to edit a control in previous entry I am trying to prevent the user from...

Yay!! I think that the var lngBookmark being kinda similar to the word bookmark kind of threw me off course (not to mention a few beers that had been sunk last night :)) okay now i have it working Dim rs As Object Set rs = Forms!Caseworker.RecordsetClone rs.FindFirst "ID = " &...

I sort of get the idea (i think) do it all in the click event i think is what your saying (clean out the unload and open events) heres what ive coded to my click event but its still going to the first "caseworker" record:( Private Sub Case_Ref_No_Label_Click() intLastRecordUsed = Me.ID...

I have a parent form with a sub form so to refresh the form I am doing this Private Sub Case_But_Click() DoCmd.Close acForm, "Caseworker", acSaveNo ' do stuff here updating record set DoCmd.OpenForm "Caseworker", acNormal End Sub fine so far except that when caseworker reopens i get the...

thanks I think it had something to do with the where clause when i removed the Where clause i got results perhaps its something to do with the quotes " " i tried no quotes and single quotes but to no avail any way i just coded it differently without using a where clause and looped through...

Unfortunatley the table names have improper names with spaces in them but i have no controll over that:( when i try to run this function in the immediate window I do not get the results I anticipate The Table [Time Recording] has three entries which match the criteria passed but im...

im a bit green with VBA This what im trying to do If MyVar NOT IN ( String1, String2, String3, etc) Then Test = True but no matter what i try I just get Compile error..expected this or expected that Can someone clue me as to how this should be coded

I didn't really understand what Galaxiom was on about as I was so keen to get the random number code working. Which I did after a bit of fiddling:D So I can now use either option incremental or random In any event It has now occured to me what Galaxiom might be on about. When the button is...

Cheers very much Ill have a play with that and let you know how I get on

every time I create a new record it gets a sequential reference number Like this: Me![CaseNumber] = Nz(DMax("[TableCaseNumber]", "[Main]"), 0) + 1 (BTW this is not the primary Key) Whilst i imagine this is fine in most circumstances, the situation i'm in sequential numbers are causing...

Yay! that works nicely thanks very much.... BTW I still cannot find a 'mark thread solved' thingy any where????

thanks very much it looks like my syntax; in respect of the way I was saying "If the value = null" rather than saying If isNull(the value i'm referring to) then do this do that end the If block time for some more experiments:)

i'm a bit confused with If's and end if, I am quite new to access and VBA so perhaps im missing the bleeding obvious I have discovered (i think) that If a condition is met and I only want to do one thing , i only need If/then but if I want to do more than one thing when a condition is met I...

Thats the ticket I reckon!! yes I understand this is why it may seem weird but, if a prior control is changed it will invalidate some of the subsequent ones particulary some of the combos which will need to be set null and requeried. Im on that! part of the problem is that what is being...