Search:

Hello,

I know a little bit about VBScripting, and a good deal about Visual Basic programming. I have been tasked to come up with something using Outlook Forms. We are still using Outlook 2000,...

Thanks sotoasty, I'm sure that will come in handy. However, I really can't use anything where I work now, because the machines are on different networks. That's really all I can say. I do use...

I like what you have done Gremmy...

I finally found some time to check it out. A few things I noticed... You can right click anywhere in the the box where the user's are, but if no one has...

So is this a text file, a database, etc... you need to be a little more specific there.

Also how are you reading this file??

You can always use


if left$(howeveryourdoingthis, 4) = "Jxyz"...

I am pulling my info. from a database. The info is comparing software. There are two sessions, one for software in general and one for people that use it everyday. Let's say that 100 people use...

Actually I don't think the "net send" type would have been good for you in your situation. Net send is kind of self reliant... a "Window's" based messenger service.

Since your installing apps...

Since I don't really know anything about threading, I can't say exactly how he did it.

What I do know, is this isn't related to processor threading. It's something different. and for bandwidth,...

The application that I wrote was kind of an update for one that we had previously. The guy who did the previous one is as close to a genious as I think I have ever been :)

He wrote his version in...

Hey Gremmy,

I'm not sure if this will help you at all, but a while ago I had to write an application that had the ability to use Windows Messenger to send a broadcast message to users on our...

There is a way to do this from form properties too.

I don't have it infront of me right now, but it's something like:

You can disable the control box of the form in the properties window, and...

I know that in MS Access, when you set up a table, it has a max # of characters in will accept if you make it a text column.

I had to make it a memo type, to actually allow more characters to go...

Anyone have any ideas? At least whether this is possible or not?

Some more information would be fantastic.

Like what else is in your form, is it say like two textboxes and a button.

One TextBox for Donation amount, and one for Receipt Number
and then maybe...

A good thing to do if your trying to split things in a text file, is separate them all in the same place.

Example:

It looks like your numbers have a max of 5 chars. So when inputting into the...

So the time has passed to modify any code... I had to push out my application as is.

Here I come lots'o SQL statements.

For future reference though, I would like to know if there is a way to do...

A little more information would be more helpful, but if your using ADODB, you can use something like this:


Dim conn as New ADODB.Connection
Dim rs as New ADODB.RecordSet
Dim mySQL as string
...

What if I restructured the table to have 3 Fields

Field1 = Software
Field2 = Yes
Field3 = No

Manually add a record for each piece of software, and set Fields 2 and 3 to 0

Then when a user...

Yes, I realized that. My fix was ... I created a Datagrid, and bound it to the new RecordSet. When I ran my application, I saw the one column with the actual data in my table, and a second column...

I was going to just edit this into my last post, but it's almost a different problem.

Alright I may have run into another small bump in the road. I wasn't looking far enought into the future I...

Yes and thank you. Access is pretty much a standard on all of our workstations. And we also need to keep everything on our network at the same version, so this won't be an issue for me at all.
...

I actually got everything to work how I wanted for the most part. I had to manually resize my Access window, but now everytime the report opens the window stays the same size. I'm satisfied with...

Alright just tested some things out.

I tried testing out the SQL statement in access, but it had to go from
Select [Level, count(*) from Survey Group By [Level]
to
Select [Level] FROM Survey...

I'm so glad I stumbled across this thread. It answered a huge question for me :) But it gave me another.


Dim oAccess As Access.Application
Set oAccess = New Access.Application
...

Thanks Gremmy, but I finally found exactly what I was looking for.



Dim oAccess As Access.Application
Set oAccess = New Access.Application
oAccess.OpenCurrentDatabase ("D:\db1.mdb")
...

Ok so I forgot to mention I was using MS Access and not a SQL Server. Maybe that could be the reason my app is bugging out at the


mySQL = "Select [Level], Count(*) From myTable Group by...