Search results

Hi I have tried the following code for a cascading combo box: Private Sub cboStatustype_AfterUpdate() On Error GoTo MyErrorHandler cboSubstatus.RowSource = "Select tblparmedchoices.Substatus " _ & "FROM tblparmedchoices " _ & "WHERE tblparmedchoices.Statustype...

Hi, I have been trying to make a combo box dependent on the previous combo box selection. Originally i had tried using separate tables for different selections in the first combo box, but efforts to get this working came to nothing. So I decided to have a single table for all of the dependent...

This doesn't seem to work either, the code now looks like Private Sub Statustype_AfterUpdate() On Error Resume Next Select Case cboStatustype.Value Case "Parliamentary" cboSubstatus.RowSource = "tblpargroups" Case "Media" cboSubstatus.RowSource =...

hi, I have three tables tblstatustype, tblpargroups, tblmedgroups. I have set up the following code for a cascading combo box Private Sub Statustype_AfterUpdate() On Error Resume Next Select Case cboStatus_type.Value Case "Parliamentary" cboSubstatus.RowSource =...

HELP! the following message appears when in the code builder: "the form name Form1 is misspelled or refers to a form thats does not exist... if the invalid form name is a macro an action failed dialog box will display the macro name and the macros arguments after you click ok. Open the macros...

I have looked through a number of the previous posting and am finding them difficult to digest - in terms of how these examples can be applied to my database. Im not sure how this requery really helps??? Thanks in advance

thanks for this. Im still having trouble seeing how this can set a conditional pop-up for another sub form. my first subform1 is a drop down list (linked in as a one to many table). I would like subform2 to pop up and request an entry when a certain value is selected in subform1. For...

Hi, I have a main form 'contact details', with a subform from another table link as a one to many drop down datasheet. If i choose a particular subform from this (value 'y') I would like this to initiate another subform (from another one to many table) asking me to choose a particular...

thanks! i will give it a try.

Hi I have set up a form to run a query with the criteria linked to the options/drop down menus on the form. I am able to search for criteria set out in the combo boxes. However, what i would like to ensure is that if the drop down boxes are left blank the results will be to show 'all' results...

thanks for your reply do you mean give each publication its own record and link the tables one to many? How would this be searched/queried through a form? would i be able to se the criteria for a query by linking through the form? thanks in advance

Hi I am a little lost. Not quite sure if this is done by query, pivottable or even report. In my contacts database i have around 20 yes/no fields for publications contacts wish to receive. I need to create a form which allows a user to select a publication(s) and then show the contacts...

thanks Dennisk its got to be very user friendly, what i have at the moment is approximately 20 yes/no check fields (each relate to a publication). When a contact is entered the publications they wish to receive are ticked off. I need to create a highly user friendly form for mail outs that...

Hi I need to set up some sort of query form that allows a user to search for contacts from certain sectors and with certain interests to make a list of email address for a mailing which then transfer into groupwise... I'm struggling to work out how this is done... greatly appreciate any help...

Hi Ive inherited an old database at my company. My Access knowledge is limited and a mailing function does not work. Its a contact database which is used to send regular emails to stakeholders - each stakeholder requests particular documents but, even though they are ticked off in the...