Search results

  1. M

    Controls and visible not visible

    Hi all, I've designed a form in access and want to use it multiple times in Access otherwise I would have to create the same form at least 4/5 times so I would like to do is when the control/button to open the form is used, it applies different controls about what can be done. For example...
  2. M

    Filters and VBA

    I've created a form that allows me to select the email addresses that I want from the database based on the dataset that the customers has signed up for. I now need to put another filter on this so that as well selecting which dataset the customer has signed up, but it also selects the type of...
  3. M

    Querying on a form based on checkboxes

    Struggling with creating a search function on a form using checkboxes. I'm trying to create a form where I can tick the boxes for datasets, for example, 1 and 3 out of 5 and the query will return anyone in the database who has those two ticked, whether it is just one of them or both or them...
  4. M

    SQL to Access ODBC link issue

    Hi all. Having a bit of a problem with a form in Access. I have the table setup in SQL and have linked in Access via an ODBC. I create a form using the fields to enter the data into however I'm getting errors when I use it that says: ODBC call failed [Microsoft][ODBC SQL Server Driver][SQL...
  5. M

    Access to Outlook mailing list

    Currently have an Access database that we use to keep track of all our contacts which we pull the email address from when send out emails. We used to use Lotus Notes but have since migrated to Outlook 2007. Currently have Access 2003 but we are either going to Access 2007 or 2010 (not been...
  6. M

    Enabling options

    I'm by no means an expert when it comes to using access and its many controls that are avaliable to use on forms. Thats why I've come here to seek your help. I have a database that has been created by someone who has now left the company and it needs a little work done to it. The ideal thing...
  7. M

    Exporting table to csv

    Hi all. I ave a table in access that has a column in the format single with auto setting for decimal places (I'm guessing this is 15 sig figs but I'm not too sure). What I'm trying to do is export this file as a csv so I can use it SAS. When I use the export function and select csv it truncates...
Back
Top Bottom