Search results

  1. P

    Question How to add Combo box field to Data Sheet view in form

    Hi, I have no where to turn to except the best place I know where to get the answer :) I created a new field as a text box, converted it to Combo box, then the Values are pulled from a query and all that works fine. I have a form that opens and displays these Fields in a Data Sheet view...
  2. P

    Macro for customised Email Subject Line Help

    Hi, I have a Form, user presses a button to launch Outlook and populate an email. The subject currently has =Replace(Replace("Issue |1: |2","|1",Nz([ID],"")),"|2",Nz([Title],"")) I need to add another field to this called Status. But simply adding the last bit of code bolded there, I get an...
  3. P

    what does this mean?

    1) can someone tell me what this says? If Me.Formfieldname <> Me.FormfieldName Then What does the <> do? Is this equals or greater/than??
  4. P

    Need Month Name based on Date in a Table

    I need to populate the Month Name based on a date field in my table. Thanks!!
  5. P

    Code to pull in a fied from SQL server?

    I migrated all my data to SQL and have a linked data connection (Table) to my access database. I have repointed all the form fields to the new linked table by using =[dbo_Survey_Main]![Reviewer] But now all I get is #Name? in every field. Do I not have the expression correct?
  6. P

    Custom Fiscal Calendar dates/fields

    I need some fields in my form to auto populate with the current Fiscal Month and Week based on a table. In Excel I created this very easy by doing a vlookup on a table I built based on WeekNum and matching those weeks up with the fiscal months and weeks. How can I do this in access and have it...
  7. P

    Link to data base form fields

    How would I link a form field from on DB to another?
  8. P

    Sending Email based on user name in form/Table

    I have searched and searched and have not found the answer, I am getting close so I got stuck and I am posting. Using Access 2007 I have a button that opens a Report based on a unique ID that I search for. The Report Opens and does contain a field for the email address. I have added an email...
Back
Top Bottom