Search results

  1. C

    Access db to Outlook calendar

    I have an Access DB that is used by multiple users. I have set it up to link the appointments to my default Outlook calendar, but would like to allow any user in the DB to be able to send it to a nondefault created Calendar that we all share. Here is my current code. I have tried several other...
  2. C

    Barcode Scanner

    :confused: I have a question. I have the scanner and everything setup, but it always populates the text box with the number and an = sign in front of the number. Ex. =12548779 How can I correct this?
  3. C

    Conditional Visible Subform

    I have subform that I only want to be visible in a parent form when the combo box has "Screening " selected. Here is my code. I'm not sure why this is wrong. Private Sub cboEvent_Change() If Me.cboEvent = "Screening" Then Forms!Initial_Action_Donor_Center.Form.sfrmScreeningDetail.Visible =...
  4. C

    Mail Merge

    I have a Word Document that is merged with Access Qry. In 03 i had to go in tools (in word) and click a box to allow it to connect to the database. Now I have 07 and it does not show the queries except in views and then does not allow me to connect to it. Not sure what to do??? :mad:
  5. C

    Iif

    I have a unbound text that I want to update to 20 when a field onte hform is >6 but = 0 when the field is <=6. Here is my IIF statement in the control source: IIF([Pitch]>6 OR [Pitch]<=6,"20","0"). No matter what Pitch equals the box keeps updating to 20. Why??:confused:
  6. C

    Summing Totals

    I have realized that I can't total a calculated control in a sbfrm, it must be a field and queries are the best option. I Have created a query and put in the following field Total Amount: Sum([AccessCost per]*[AccessAmount]) then had an unbound field txtbox on the form that totaled all of the...
  7. C

    Filtering a query from a Form

    I have built a Form that was originally a Split Form and added a combo filter that uses a Filter button to activate the Filter. I could not get it to filter the Datasheet part of the split form, so I changed to a single and added a subfrorm. The Subform will filter as desired. Now, I need the...
  8. C

    Code not working for filtering

    I am using 2007 and I can't get any of the code to work to filter the Form. I have tried several examples in the Forum and nothing happens. Even if I have the Combo as Visible = False it is still there. Anyone have an idea why?
  9. C

    Filtering Multiple Fileds

    I have a database that is set up to categorize media (ex music and movies) by theme. I have a field Theme which is a drop down. Because each song or movie can have more than one theme, I have 6 separate fields with Theme 1, Theme 2 etc... I have created a Form to filter the Query using an...
  10. C

    One to Many

    I am creating a database to track variances. Field 1 - Events and Field 2 -Event Tpyes. I want to be able to choose an Event in Field 1, then based on that choice, I want to have a list of options for Event Type. The list of Event Types will change depending on the Event choosen. Can someone...
  11. C

    Query Filter Expression

    I have a Form that is set to filter a query by dates. The code in the query linking the two is as follows - Between [forms]![frmConfirmation]![txtbd] And [forms]![frmConfirmation]![txted] - bd = before date & ad = after date ex. bd (4/1/2006) - ad (4/30/2006). It has been working great, until...
  12. C

    Outlook

    I have a database that keeps track of client information and future apointments. I would love to hav this data merge with outlook to go directly into my calendar. Is this possible and how do I do it? :cool:
  13. C

    Check box

    I want to connect a single check box to a record of check boxes, so that when it is on yes (checked) all the other boxes are yes (checked) automatically. How do I go about doing this? Is there an expression I can build for it? :confused:
Top Bottom