Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: IKinal
  • Content: Threads
  • Order by date
  1. IKinal

    e-mail addresses

    Hi, I have a field in my table that contains e-mail addresses, and I want to convert the field into a hyperlink field so that clicking on the address will start a new mail message. Unfortunately, when I make the field into a hyperlink, it defaults to creating website links, i.e...
  2. IKinal

    Run a module

    Hi, I wrote several modules in my Access 2002 database, and I now want to run them, but I can't, because the run button in the modules view is greyed out. How can I get the button to work? Thanks, I. Kinal
  3. IKinal

    Tab

    Hi, I'm trying to get my VBA code to print a tab to a text box. I figured out that vbcrlf inserts a new line, but can't find a similar command for a tab. I tried vbTab, but that just produces a box. Thanks! I. Kinal
  4. IKinal

    Counting

    Hi, Let me start with some background of what I am trying to accomplish. Basically, I have a table that keeps track of votes for people in three columns, and the votes are given a category from 1 to 13. Now, there are two types of votes, with some of the numbers falling into one, others into...
  5. IKinal

    Count based on multiple criteria

    Hi, I need a count based on two criteria in my table, such as a count of everyone where sex=2 and category=1. Is this possible in an Access query? Thanks, I. Kinal
  6. IKinal

    Code behind report

    Hi, I need to generate a report with some complex logic, and I am trying to figure out whether it is possible to generate a section of a report programatically - I guess something like setting the control source of a text box to a VBA procedure. Is this possible in Access 2002? Thanks, I...
  7. IKinal

    Data translation using variables

    Hi, I have ranks for people stored in a field by the date that they got the rank, i.e. 98/99/01/02 . In my report I need to translate the ranks into their text equivalents, i.e. 98 is rank A, 98/99 is rank B, 98/99/01 is rank C, etc. I know how to do this with static values, but I don't know...
  8. IKinal

    IIF statement syntax

    Hi, I am just starting out to add programming to my reports. I'm trying to make an IIF statement work, but it is giving me errors. Here is the statement that I have: =IIf([State] is null, 1, 0 ) Access is giving me the standard invalid syntax error message, but I don't know where the problem...

Part and Inventory Search

Back
Top