Recent content by mjchristinaj

  1. M

    Macro in a field of a table?

    Hi, I would like one of the fields in my table to be a link that when I click runs a macro (a query). So, if the field is called 'Keywords', the entry has a keyword (for example "products"), and when i click on it, I get the result of a certain query (for example, the query that shows the...
  2. M

    Autofilter Access 2003??

    Hi, Thanks! It works when I type: WHERE (([Satellite Launches].Launcher=Nz([Forms]![QBF_Form_F]![Launcher] ,[Satellite Launches].Launcher) AND .... However, I found a new problem: if in the user form, I select a field to filter by mistake, and then I unselect it, it does not work, because...
  3. M

    Autofilter Access 2003??

    In essence, what I need to do is a 'autofilter' like in Excel with Satellite Launches table. What I am trying to do now is a QBFquery where the user selects what to filter, as AND statements. The field to filter comes from the 'Satellite Launches' table. Some fields are shown in the user form...
  4. M

    How to add Criteria 'rows' in a Query?

    Hi, I want to do a Select Query without VBA, just using the wizard. The problem that I find is that I need to do more "OR" statements than 'rows'of criteria. Is there a way to add new 'rows'of criteria? I have 9 rows to do "OR" statement, but I need to do 10 "OR" statements. Cristina
  5. M

    MultiSelect for Dummies!!

    I will try to explain my problem better. Let's forget about the list box for now. I want to store one record per satellite, but each satellite could have one or more applications (Broadband, Broadcast, Military...). So, when I display all the satellites, I would get a table like this...
  6. M

    MultiSelect for Dummies!!

    Hi lagbolt, thank you for your answer. I tried also the option of doing 2 tables. However, I do not see it as a one to many, but as many to many. In my case, the main table is 'satellites', so I store every satellite (name, date, year in orbit..., and its applications). So, a satellite can...
  7. M

    MultiSelect for Dummies!!

    Hi, I have been searching for info about Access 2003 MultiSelect option. I have found a lot of info, however, I do not know how to use it. I want in my forms a field where I can select more than 1 value. It seems like you can do this with a list box. It is fine for me till here. I have...
See more
Back
Top Bottom