Search results

hi, the following error message appears when trying to access my database. I can't seem to get into it at all, not even by trying to import the data tables over into a new database. the following message appears: "The database has been converted from a prior version of Microsoft Access by...

Hi all, Another month, a new database, more questions... a quick thankyou to all those who helped with my last database, much appreciated! I am trying to set up a query run from 12 tables, each table is supposed to be the same but we have had a number of people changing things when they...

Hi I have a query that runs off three tables: These are tbl_contacts, tbl_status, tbl_publications. All contacts have a status but not all will have a publication. The problem is that when i run the query on a status type where none of the contacts for that status have a publication it will...

Hi all I am facing disaster after two months of solid work on this database, the deadline is the morning of the 25th and just when i thought i had got it all working i then put the main bulk of the data into the database and the main search query won't work, it freezes and ends with 'invalid...

hi I was wondering how you would base one query on the result of another through the same form. I need them to all be under the same command button... i.e. on click run 1st query and then run the second on the results of that query. How would i go about this, would it have to be a make...

Hi i have set up a search from that returns email addresses for contacts based on certain criteria. the only problem is that the query will return the same email address a number of times because the query is set up to respond to a number of queries each of which a contact might posses...

Hi i have set up a search from that returns email addresses for contacts based on certain criteria. the only problem is that the query will return the same email address a number of times because the query is set up to respond to a number of queries each of which a contact might posses...

Hi I wondered if there was an easy VBA code for putting a password in the after click event of a command button, i.e. the command button opens up a form, but to get to the form you need to enter a password. Im guessing this would be in the Afterclick code before the command to open the form...

Hi Ive created a search form on Access to search for peoples names and email addresses. I would like to use the results of the query to populate personal emails in Outlook (or groupwise) in a similar way to the way MS Word mail merge works... i.e. a seperate email for each email address that...

Hi I have been trying to set up this query via VBA code but, with no luck, have gone back to the query in design view. Basically the parameters of the query are determined by combo boxes in a form. This is fine if one combo box indicates one criteria but a problem arisis when multiple combo...

Hi I have set up a form to run a query, setting the following VBA to pick up values from the combo boxes in the form. The only problem is that I cant seem to get this working. When i press the command button it won't even get past the Dim db As Database line. Private Sub Command10_Click() On...

hi this is a long shot but is it possible to set up a macro which will send a column (email column) from the results of a query into the address bar of outlook? I know how to import and export data to/from outlook but this is a new one to me. all help much appreciated!

Hi All I have set up a form to run a query. There are 3 main variables; 'Status', 'Substatus' and 'Publications'. The publications variable has multiple choices on the form as it is likely i will be sending out more then one publication at a time. What I need to be able to do is that if a...

Hi all I have a problem locating where to put my requery for a subform and, also, how quite to type it. Here is the relevant information the drop down list row source in the second combo ( named "2ndstatus") is dependent on th1 1st combo ("1ststatus"), this is done through a query that I have...

hi I have set up a subform with two combo boxes, one dependent on the other linked through a query. the subform works when it is by itself but i get prompted to type in a parameter when i use the subform in the main form, i have no idea why. I am also having trouble setting the Requery on the...

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

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

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