Search results

Thanks! This is just the kind of information I was looking for. I think I can add the functionality to give trial versions. I've seen some posts about that here. What about a Beta version? Do people put Beta versions on shareware sites and give them away for free or something? Or does...

This would be sold like any other software you buy. There are no maintenance agreements. What they buy is what they get, so there would be no additional reports. This brings up a point I wanted to ask though. Don't I need to make a Beta version and have people test it? Where do I get...

I have created a little Access application that I thought I'd try to sell online, but I have never done that before. Can anyone give me some pointers on how to do it? I have no idea as to how to even get started. Any assistance would be greatly appreciated.

I have searched for an answer to this seemingly simple question, but can't find one. I have a combo box bound to a table containing dates. The combo box's Format property is set to Short Date. I have the following code in the Not In List event of the combo box: Dim rst As New ADODB.Recordset...

Unfortunately, Access must be using different codes than Excel. For example, the KeyCode for the Insert key is 45, and the KeyCode for Home is 36. You can check this by putting MsgBox KeyCode in the KeyDown event on a form. Then press the Insert key on your keyboard. You'll get 45. That's...

So all the KeyCodes for keys like Tab, Insert, Home, etc. are below 32?

Thanks. The problem is that apparently the Keycode does not correspond to the ASCII character set. For example, try putting MsgBox Asc(KeyCode) in the KeyDown event on a form. Then press the letter a. You should get 65, but instead you get 54. The problem is that I don't just want to...

That works for the letters, but what about the numbers, the decimal point, the colon, the apostrophe, and so on and so on?

I am using the KeyDown event and am trying to determine if the key pressed is any kind of character or number (as opposed to keys like Tab, Ctrl, Print Screen, etc.). There must be an easy way to do this, but I've looked everywhere, and all I can come up with is something like the following...

I will try it. Thank you very much!

I have a query that has two tables that have a one to many relationship. I need to count the number of unique records on the one side. I saw a post where someone else had the same problem, and Pat Hartman said to remove the join to the many side. The problem is that I can't do that because I...

Thanks I figured there wasn't an easy way to do this, but thought I'd ask. Thanks to both of you.

Is there a way to get the difference between two strings? Not the size difference, but what the characters are that are different. For example: If you had str1 = "See spot run" str2 = "See the spot run" Is there some function or something that will return "the" when comparing the two...

There may be an easier way, but here's what I do. Create a module and paste the following code into it: Function CheckGroup(UserName As String, GroupName As String) On Error GoTo err_CheckGroup Dim wsp As Workspace, i As Integer Dim usr As User Dim blnFound As Boolean Set wsp =...

Another Way In case anyone is interested, I found another way to do it in which you can have the field type as hyperlink and be able to just click on the field in the form and it will open an e-mail. Insert the following code into the BeforeUpdate event of the form: Me![MyField] = "#mailto:" &...

Thank you so much! That's exactly what I needed.

How do you store an arithmetic operator to a variable and still get it to behave like an arithmetic operator? I need to be able to build a long equation using only variables. I know how to do it if the arithmetic operator is constant. For example, you could do this: varNum1 = 2 varNum2 = 3...

That did it. Thank you soooo much! You have no idea how long I've been trying to figure this out!

I have exactly the same problem that kbreiss had in this post: http://www.access-programmers.co.uk/forums/showthread.php?threadid=44723&highlight=max However, neither Pat Hartman nor jfgambit's suggestions work. Here's kbreiss' problem again. You have this table...

No errors I tried that, and there are no errors. Everything was working fine under Windows 95.