Search results for query: *

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

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...

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...

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

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...

OK, now I see. Thanks! I. Kinal

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

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

Unfortunately, both of them produce a square character, and not a tab. I. Kinal

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

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...

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...

Thanks, that solved the problem! I. Kinal

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)...

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...

Thank you both for the help - problem solved! I. Kinal

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

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...

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...

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