User Profile

Collapse

Profile Sidebar

Collapse
blees10
blees10
Last Activity: Feb 15 '08, 08:46 PM
Joined: Nov 12 '06
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • blees10
    replied to Access Report formatting
    in Access
    I am kind of an Access newbie. How would I go about doing this? (Language Conversion Table).

    -b
    See more | Go to post

      Leave a comment:

    • blees10
      started a topic Access Report formatting
      in Access

      Access Report formatting

      Hi Everyone,

      I am working on an Access report and the client is asking for nitpicky things so I am working on a way to make this work. I have a couple questions and they are not related.

      1. I have a date field which I formatted in the Format properties
      dd" de "mmmm" de "yyyy.
      I did this so that the date will display as follows:
      02 de Febuary de 2008.
      This works well,...
      See more | Go to post
      • blees10
        replied to Access Formatting Date Field Display based on condition
        in Access
        Thanks!

        I had to format the code because if it wasn't tax_id wasn't = "100", I wanted to display the full year.

        So I had to create an additional field in my table which only displays the 4 digit year and then modified the code as below:

        taxdate: IIf([tax_id="100",[taxdateyear],[tax_date])

        Its works great.

        Once again thanks for your help.

        ...
        See more | Go to post

          Leave a comment:

        • blees10
          started a topic Access Formatting Date Field Display based on condition
          in Access

          Access Formatting Date Field Display based on condition

          Hi Everyone,

          I have been trying for a while to get this working and it is driving me crazy.

          I have a subform on a report. On this form, there are 2 fields, tax_id and tax_date. The date is stored as text and is displayed as yyyy-dd-mm. I would like the tax_date to display only the year when tax_id = 100.

          I've tried using the left[tax_date],4), but I can't get it to display ONLY when tax_id = 100...
          See more | Go to post
          • blees10
            started a topic dtpicker field blank
            in Access

            dtpicker field blank

            Hey Guys,

            I have an issue with a dtpicker field in one of my forms. I developed this form using Access 2003 and everything works fine. Recently, I've been asked to deploy this database to secondary office. The version of Access loaded on each workstation in the seconday office is Acces 2003 as well.

            The Active X control for the dtpicker in my development copy is Microsoft Date and Time Picker Control 6.0 (SP4). The...
            See more | Go to post
            • blees10
              replied to Passing Multi-Select field parameters to a query
              in Access
              Thanks for the help. The code below should be placed in the On Click Event Procedure? Should I delete everything thats in there and paste the code below?

              Thanks!...
              See more | Go to post

                Leave a comment:

              • blees10
                started a topic Passing Multi-Select field parameters to a query
                in Access

                Passing Multi-Select field parameters to a query

                Hi Everyone,

                I've seen this question posted before and I believe the answer was to incorporate VB code somewhere into the form.

                I am not familiar with VB and just wanted to know where to paste the code to.

                I just have a simple query to pull all rows for any values selected in that multi-select field.

                Form name is Search
                List box name is List11
                Query name is Form Query
                ...
                See more | Go to post
                No activity results to display
                Show More
                Working...