Search results

ok i know everybody here squinches at the mentioning of mailmerge so lets forget that :) how do i extract values from a subform with the same master field value as the main form. master and sub tables are linked with an idNumber, so there can by many records in the subForms table with the...

you have a good point there, i just thought of longevity....but when i think of it there will be about 10000 records per year and this system will probably not run for more then 3 so 500kb per record thats not more then 1.5GB ill just make a Archived field with YES/NO that would just filter it...

i got it with this: Private Sub WordPrint_Click() Dim db As DAO.Database Dim rsParent As DAO.Recordset2 Dim rsChild As DAO.Recordset2 Set db = CurrentDb Set rsParent = Me.Recordset rsParent.OpenRecordset Set rsChild = rsParent.Fields("Photo").Value rsChild.OpenRecordset...

hi did you manage to export the attachment in the attachment field? if you did pls let me know

Ive got four tables tblProfile linked to tblSerif and tblCase and that one inturn with tblHearings. I have a working DB now and i want to archive certain records. And id love that to be an exact copy of my current table structure. What is the best way to do it? Should i make a "Archive"...

Yeah that's what i found out to, so ill probably have to do it that way. I did start a new thread on that but no answers at all, Thats why i asked you. Thx for all your help again!

Thx for the link. ill start reprogramming my brain the access way, btw i checked the page and "cmb" is not used only "cmd" command button, "cbo" is the comboBox :cool: thx again, you've really helped me, i'm starting to understand the syntax even if its only the beginning p.s Im building a...

Thx again it works perfect. I decided to start naming my object a little more descriptive :) Private Sub TypeCombo_AfterUpdate() If Len(Me.TypeCombo.Value & "") <> 0 And Me.TypeCombo.ListIndex > -1 And Me.TypeCombo.Value <> "All Prisoners" Then Me.Filter = "CustodyClassification =...

Yeah i did consider that but a combobox did seem like the least intrusive and most expandable solution, i might get more types(strings) and that would mess up the layout :P Thx for the suggestion though

I think i will try your method again, i know there are always many ways of solving a problem and through coding it at least feels like you have more control of whats going on. So lets say this works out, i can filter the recordset of the form with the 3 types. If i then want to filter again...

Hi again, I did solve it with this VBA code Private Sub Combo33_AfterUpdate() Select Case Me!Combo33.Value Case "Detainee" DoCmd.ApplyFilter , "CustodyClassification = 'Detainee'" Case "City Prisoner" DoCmd.ApplyFilter , "CustodyClassification =...

I tried and got as far as saving the query, but when i run the form i get a combobox with three blank options, the query did return the unique three values though....? but how do i sort the the table with these three options if i get the combo to show them...

Sorry for being confusing, I have a table with profiles of people, they are categorized by three types (the three strings) in my form i want to filter the profiles based on these thre strings so the form shows all profiles with that type. My form only displays one record at a time but i want...

ok, i dont follow fully but ill try, i still dont see how it will sort the the table and update the form so it only shows the records with the string in the correct field. Cuz when i select a value in the combobox it selects that specific record and shows it in the formm....but ill try your...

Hi yes i did, but as i have multiple record with one of the three options i get a combobox with tons of duplicates. I just want the three options available....and that example just shows that specific record in the form and does not perform a filter in the table.... So instead of having three...

Hi thx for the quick reply, I probably didnt explain well enough... I want to add three options to the combobox through a value list. Three short strings that are corresponding to three possible values in a field in the table that the form is linked to. When i choose one of these strings in...

Im having problems with the syntax, Can someone just point me to a simple VBA example of a combobox with list values that filter a form on the value selected in the combobox. The combobox is on the form its suppoused to filter. Sorry for such a simple request but im an old flashdeveloper and...

Hi, Im using Acc2007, ive succesfully managed to mailmerge a complete record set from access to word for printing using bookmarks. What's missing is that i have a attachment field in the record with a profile image. I would like to get that image to display in the word document created together...

I have one MainFormTable for the MainForm with about ten fields One of the fileds is linked to the SubForms SubFormTable and i have one field in the SubFormTable linked to the SubSubFormTable of the SubSubForm. Basically its a Law person Database. In the MainFormTable i keep information about...

Hi All, Im having a probably very basic problem......i have a form structure as below shows.. Form structure: I have a Mainform, I also created a subForm and a subsubForm on the MainForm..... SubForm table is linked to MainForm table and SubSubForm table is linked to SubForm . The SubForm and...