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 derfloh 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: *

  1. IKinal

    Write Conflict (the whole enchilada)

    Sorry, I meant to start a new thread instead of replying to this one, although my problem seems similar to this problem. I. Kinal
  2. IKinal

    Write Conflict (the whole enchilada)

    Hi, I am working with a database that has two tables with a one-to-one relationship between id columns in each table. One of the id columns is an identity column, the other is not. I tried to enter data into both tables from a view, but when I create a new record and enter data into a field...
  3. IKinal

    e-mail addresses

    It actually appears that as long as I have a # before the e-mail address (which gets hidden from view), clicking on the hyperlink will bring up a new mail message. Basically once I got rid of the http:// that Access inserted, I was fine. It could also be something about my setup; I'm running...
  4. IKinal

    e-mail addresses

    Thanks, that worked. After that I did some more experimentation because I didn't like seeing the mailto: text. I ran another update query to remove it, and things still work fine, and the problem is solved! I. Kinal
  5. 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...
  6. IKinal

    Run a module

    OK, now I see. Thanks! I. Kinal
  7. IKinal

    Run a module

    Thanks for the info. I have solved the problem by using a runcode macro. Of course, now I'm wondering what the purpose of that run button on the modules page is? I. Kinal
  8. 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
  9. IKinal

    Tab

    Unfortunately, both of them produce a square character, and not a tab. I. Kinal
  10. 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
  11. IKinal

    Counting

    OK, I did some more experimentation last night, and I came up with something that works - I created three counts, one for vote1, one for vote2, and one for vote3, and then added them up. That seems to work, and it seems to work even faster than the original count did. Not sure if this is the...
  12. IKinal

    Counting

    OK, now another problem has come up with this query. It is only giving me a count of 1 when it finds a match in the first column, but it is not giving me a 2 or 3 if it finds additional matches in the second or third column (vote2 or vote3). My guess is that this has something to do with the...
  13. IKinal

    Counting

    Thanks, that solved the problem! I. Kinal
  14. IKinal

    Counting

    Here it is: Dim SQL As String Dim ID As String ID = Text0 SQL = "SELECT Count(*) AS CountOfRecords FROM KPZ INNER JOIN KPS ON KPZ.ID=KPS.ID WHERE (((KPZ.VOTE1) Like '01*' Or (KPZ.VOTE1) Like '02*' Or (KPZ.VOTE1) Like '03*' Or (KPZ.VOTE1) Like '04*' Or (KPZ.VOTE1) Like '05*' Or (KPZ.VOTE1)...
  15. 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...
  16. IKinal

    Count based on multiple criteria

    Thank you both for the help - problem solved! I. Kinal
  17. 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
  18. IKinal

    Code behind report

    Thanks for the reference. Between that article and another one that I found, I figured it out. For anyone curious, The Vba code is simply textbox = "What you want to say", where textbox is the name of the textbox. Then I made that textbox unbound, and called the Event Procedure from...
  19. IKinal

    Code behind report

    Yep, that's the idea - I'm trying to get the code to generate text into a textbox. More completely, I'm trying to create a list of membership dues for people, which involves creating a line for each year of outstanding dues (based on the last paid date), and on that line there also needs to be...
  20. IKinal

    Code behind report

    Thanks, that seems to work. Now, what command do I use in the procedure to generate text in the original textbox? I. Kinal

Part and Inventory Search

Back
Top