Search results

Hi, I've tried to reverse engineer the "Pine" example of manipulating the filter arguement for a subform using multiple comboboxes, but have failed. "13 - Type Missmatch Error". i also tried the earlier method of manipulating the recordsource but if i chose more then one combo box to filter by...

Hi, i appricate there have been several posts on this subject, and i have managed to set up a filter by cascading boxes. however, i'm a bit stuck on making the filter 'live' i.e. to filter the records by each box in turn, narrowing down the records. e.g. all "sales", then by "department", then...

What advantages are there of using a switchboard compared to creating a form with buttons to open the other forms? Basically, why use a switchboard? Cheers, Rob

Hi, At what point is a back end table updated with a new record created on a form in your front end? I need to run a report of data i have just entered into a form and it returns black as the record doesn't yet exist in the table... is there a docmd to create the record? thanks for any help. Rob

hey, just a quick one, any ideas on a line of code to check if a report exists.. something like IF (report exists) Then... Cheers Rob

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

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

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...

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...

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...

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...