Search results

Hi Paul, Works a treat, just couldn't think there. thanks

Hi I have a form that is set to allowEdits = False, allowAdditons=False, AllowDeletions = False, thus setting the form to read only. However I have a textbox on the form that I use to search a particular field. However when the form is set to readonly I cannot enter anything in this textbox...

okay, I am trying out the DMAX Function in a query but it returns an #error in the field and returns all values SELECT tbl_Master.MasterID, tbl_Master.PName, tbl_Master.Ver, tbl_Master.Date_Entered, tbl_Master.Loc, tbl_Child.ChildID, DMax("[DateTimeStamp]","tbl_Child","[tbl_Child.MasterID]='"&...

hi missinglinq, That what i thought i would have to do, was just hoping there was some other way. Jamie

Thanks for the reply, However, the form will still show me all the records associated, i am only interested in the last child record of the master. Each master may have 100 child records but i only want the last child for each master. Thanks Jamie

Hi All, I have 2 tables, master & child. with a one to many relationship. On one of my forms I want to display some of the fields from the master table and only the last entry from my child table. How would i accomplish this? Many thanks Jamie

Hi there, Sorry for the delay in getting back to you. It will be ok for some of the users to add/edit & delete queries and reports, they just like the wizards to help the do so. I have at the moment to created forms with options for them to query the tables and display in a datalist below and...

Hi all, I have an access form which i have turned of menus, navigation and shift key. What I am looking for is to have buttons on my form to allow users to create and delete queries from my form. I already have a listbox that shows all the queries and runs them when a user double click on them...