Search results

Hi, is it possible to assign a file name from fields in a form to a report you are emailing? i have the code below, but not sure on how to change the filename... DoCmd.SendObject acReport, stdocname, "Rich Text Format (*.rtf)", to_list, cc_list, , subject, msgText any help appriciated. Rob

oh, wait, done something daft... subform was set to visible = no as default... durr. you can really tie yourself in knots with this stuff! thanks anyway, i guess it just took a little thought. basically trying to make the whole thing idiot proof!

or not... .visible = worked, but not enabled... how odd!

yes, fields... think i've found a way around this... [Private Sub Part_Number_AfterUpdate() Me![sfrm_raise].Enabled = True End Sub Private Sub Form_Current() DoCmd.Maximize Me![sfrm_raise].Enabled = False End Sub] i forgot you could manipulate the properties of fields thru vb...

Hi, is it possible to lock (or otherwise prevent user from entering data into) a cell on a subform untill a particular cell in the parent form has data entered into it? thanks for any help. Rob

hi, all lines work individually. i think the problem is with the "else" i.e. if the arguement "If Forms![frm_problem]![sfrm_problem_report].Form![Report_ID] <> 0 Then" is any other case than not "0" then i get error message "you entered an expression that has no value". However, If...

Private Sub open_report_Click() On Error GoTo Err_open_report_Click Dim stDocName As String Dim stLinkCriteria As String If Forms![frm_problem]![sfrm_problem_report].Form![Report_ID] <> 0 Then stDocName = "frm_report_review" DoCmd.OpenForm stDocName...

Great, thanks for your help guys, thats worked a treat.

Hi guys, having problems using fields from subforms in event procedures for button clicks etc. I'm not great with VBA, but I am learning... example below, is supposed to take email address from a subform(sfrm_emails) to use in emailing report by sendobject. Private Sub send_report_Click() On...

Is it possible to, in VB, on form open have a message box appear where a user can enter (or select from a combo-box based on a qry - preferable if possible!) data to filter by. for example. filter by "engineers name" in a form containing records for multiple engineers but the user (the...

Cheers that work a treat! Got another one for you tho! (I don't know much VB)... I want to only run this command: Me.[Part Number] = Forms!frm_Menu_Create_CR!cbo_Parts If cbo_Parts is not a Null value. I tried, using my limited knowledge, a couple along these lines: Private Sub...

Hi, Many thanks to those who helped with my last couple of problems. I've allmost completed my project now and am debugging. I've found that in order to close one of my forms, which has combo boxes on it, I need to have no values selected in those combo boxes. Could someone give me the visual...

Hi Background I have a form with two combo boxes on it. 1. Supplier and 2. Supplier Part. These work fine and are used to either check a record of a supplier/part exists or to select a record of a part in the system and create a "complaint" for it. I want the Part number to copy over to the...

hi I have a cascading combo box on a form where by you can first select a supplier of a part and then a part from that supplier. (Attached is a pic of my structure). Next I want to be able to create a record of a "complaint report" for that part in the combo box... (see structure). Any ideas...

Awsome Pat! Think I've cracked it!! Combo box on a subfor for Parts - you select one or more suppliers and then bosh, its saved in tbl_Supplier_Parts. Magic! (I haddent appricated how your queries interacted with your forms - ie. if the query has the field "part number" it takes this from the...

OK thats helpful - i now understand the critical properties for a combo box. However, this does not store the supplier for a part anywhere but in the combo box on that form! Obviously this needs to be stored in tbl_Supplier_Part no? or am I missunderstanding the concept here? Do I store this...

Thanks pat... but i'm still stuck! I've attached a better picture this time - showing the whole structure. Have I now created transaction tables correctly? What I need is for the user, in tbl_Parts, to be able to select one or more Supplier for that part. This Supplier(s) need to be selected...

Hi, I'm developing a database to handle various aspects of quality control reporting. I've got a working structure however, i think, i have gone off the track slightly... First I'll show you part of the structure: (please see attached .jpg) (hope that makes sence)... so effictively I have a...