Search results

sorry for my bad explanation. Basically I've got a list box in the main form. When I click the item in the list box, I want to select that record in the main form. Main form is called frmComponentLibrary The list box is called List8

Thanks for your help and advice, I've now created a list box instead of a subform. so what now? I have tried this, is this right? (i know its not cause it doesnt work) Private Sub List8_GotFocus() Me.RecordsetClone.FindFirst "[ComponentID] = & Me![List8] Me.Bookmark =...

I have a form with 2 subforms in it. The first subform is from a linked table that has details about the record selected in the main form. The second subform is a list of all records in the mainform. (it is the same table as the main form). I am using this like a phone directory selector. I...

Thanks Kiwiman, I will try this out after the weekend.

Ok, so I can use the macro builder to make a button open another form, or report, but.... How do I open an attachment that is in a table. The attachment is a pdf, .docx or .xlsx file.

Hi All, How do I make a command button on a form open an attachment from a table? Thanks, Mr Shape

I've only been using access for a few weeks now. I'm stuck on something that is probably quite simple. I have a table that has the following fields: OperativeIDCode FirstName LastName Then I have tables for, Address, Tax Info, Traning. etc. I know that all the details could be put in one...

Thanks Rookie, I have make that tables and linked them as you suggested. Ill now attempt to make a form for entry and a report to go with it.... hmm. By the way: great formatting, makes life easy!

I sorry if this is to simple for this forum. Please don't think im lazy either for asking, I've been trying all week to do this but can't make it work... Im trying to make an attendence register as follows: Date Location Attendee Topic Supervisor The idea is 12 times a year over 9 or so...