Search results

  1. T

    finding max date

    ok ihopefully i wont make this too complicated to under stand. i ahev a form which will populate a form from a query. the query is pulling info out a table included int hti sinfo is the date when it was entered. in the criterai of the query i hve added this code Between [Forms]![Boxes...
  2. T

    FIND and replace via a form

    iam confused with this last statement sj mcabney Ghudson was saying that if i attach a numberical vaule to the officers name then all i will need to do is do a change once and all records attached to that officer will change automatically becyuase of the atuonumber. but i do not want to...
  3. T

    FIND and replace via a form

    Hi thankyou for this. but there will be times when only one instance will need changing and not the whole lot. there could be a reasn that they no longer look after one record. so this unfortunatly wouldn't work. any other ideas please
  4. T

    FIND and replace via a form

    Hi there i am looking for a bit of help. I have a database that has a form/VBA front end that has linked tables from a back end DB. it is a restricted Database given out as an MDE file to users. On the main form, there is a combo box called responsible officer this is connected to a column in...
  5. T

    Using a VByesno message box

    Thankyou Thanks guys i will go and try your solutions many thanks for your time
  6. T

    Using a VByesno message box

    Hi guys i am looking at using some message boxes in a access database i have two fields that can be changed but what i would like is that if you click in the fields and update the data when you click out a message box appears sayinf something like are you sure you want to update this info...
  7. T

    Tab Indexes

    Hi there i am a bit stuck I have a database, the main form consistes of 4 pages with a multitude of list boxes combo boxs subforms and such like. i am trying to edit the tabindexes over the pages so that the tab index of zero on the first list box on the first page then going left to right...
  8. T

    finding vlaue in table using serach button

    has anyone any ideas i am begiinig to pull my hair out about this problem but i am one of these people that can't give up please help
  9. T

    finding vlaue in table using serach button

    the find facility i found the Micorsoft find facility and but a find button on my form. i thought that it would look through all the tables and return the value that you searched for, but it doesnt matter what you put in there is always comes back with the same answer that it can't find the...
  10. T

    search tables

    i am a bit stuck as to how to sart coding a search button. i have a form that has a search button on it when it is click a new form opens up with a text box and a command button called continue what i would like it to do is enter a vaule in the text field and when i click continue i would like...
  11. T

    finding vlaue in table using serach button

    normalisation complete hopefully so i have added a subform onthe page and set up a new table in the DB for it i have normalise oall the naming conventions so hopefully on that side of things everything should be working properly. but i still now have the problem regarding the code behind...
  12. T

    finding vlaue in table using serach button

    in some more detail i have page and on it it holds a number of text boxes. each secxtion has three texboxes, named date removed, requested by and reference number. this certain book can be requested four times so there is four sets of text boxes for requested. then there is the returned...
  13. T

    finding vlaue in table using serach button

    sorry i am sorry, i didn't mean for it to be taken as stone, i was just trying to make life a little simplier to explain. i dont actually have eight lines name telephone phone but i was struggling to explain what i meant with all the typing of different names for text boxes each line is...
  14. T

    finding vlaue in table using serach button

    more explanantion sorry I have a main form, on this form there is five pages but all information on these pages is saved in the main form table. The page i am talking about: to simplise things it has a lot of text boxes on which are all connected to the same one main table. There is 8 lines...
  15. T

    finding vlaue in table using serach button

    i have a page on a main form on this form there is many textfields all stored in the same table. a set of textfirldswere named telenumber 1 through to 8, thesetexfields are linked to hundreds of friends, and i wanted to beable to put a searchfacility in so that i could serach for the telephhone...
  16. T

    combo box problems

    Hi there I am a bit stuck I have a combo box that is bound to my main box table, which in turn is connect to the main form query. in there I will have a number of barcodes, I would like to be able to get a list of the barcodes on the drop down menu . What I have done so far is that I have the...
  17. T

    VBA code to set data in combo boxes using raion buttons

    can anyone else help i see that mile-o-phile is offline can anyone else help with my little problem
  18. T

    VBA code to set data in combo boxes using raion buttons

    mile o phile did you get chance to look at the document i attached on friday i ben working on it all weekend and have had no prevail????
  19. T

    VBA code to set data in combo boxes using raion buttons

    mile please see atached doc i have given a screen shot hopefully expalin my problem thankyou for spending so much time on this
  20. T

    VBA code to set data in combo boxes using raion buttons

    it doesnt work unforunaltely this doesnt work it still just keep looking at the the one that you clicked on it should look at the main talbe to retrieve the information off it that was stored when it was orginally created by it seems that it doesnt do that it just sticks on the one you have...
Back
Top Bottom