Search results for query: *

Uses exists and a subselect with a group by.

Ah well, thanks!

I was wondering if there is any way to typedef like in C++ in VB.NET. I have a lot of qualified references and would like to shorten their names. Thanks!

I am trying to find a way to determine if a user is allowed access to tables in SQL server so I can handle permission management on the client side (a nice GUI to tell them not to do stuff they shouldn't be doing). I figure there should be some way to determine if the currently logged in user...

We have 3 computers in our house, one directly connected to the Netgear router, a laptop on wireless, and a desktop on wireless. I have secured our network and set up all of the devices for use on the network. The laptop is fine, but my desktop has problems. I always have "Very good" in the...

You must be sure to do calls correctly as well. There are a ton of ways to use function calling, which I think is one of the downsides to VB. I think these are all correct... 'Invalid SomeFunctionCall() 'Valid SomeFunctionCall 'Valid Call SomeFunctionCall 'Invalid...

You will be better off using early binding to help alleviate memory issues if your program errs for some reason. What you are looking for is probably an optional value, as exemplfied below. You can call the function with either one or two values. Example calls If Not...

We have a laptop at our office that connects to the network domain at work, and a desktop at home that connects to a workgroup (since we don't have a domain controller, or any user for one at home) and we want to find some way of connecting the two computers so we can share certain files back...

I am trying to automate a system of allowing users to copy their calendar appointments into a team calendar since we have several teams and it can get confusing and messy finding the team calendars and making sure everyone gets the item to the right place. I have been able to get the function...

It sounds like perhaps you are using all of your memory when going to the larger number of records. When performing joins and complex queries, the computer loads as much data as possible into memory and performs the required action. If you are out of memory, the system is constantly reading...

Sounds like you may be using the included calendar or another Active-X control, which tend to be changed in every version of office, causing issues. If you are using an Active-X calendar like the MS Calendar, or another external Active-X control, try removing it and seeing if you still get the...

Yes, I have tried it with no parameters, with 1 parameter of each, and with 2 parameters of the correct types. I even have tried type casting to ensure correct types whenever passing to the parameter instantiations. It's still a no-go, though I cannot find any reason why. When I take the SP...

Unfortunately, the ActiveConnection requires an object reference, which uses the set command.

I have been using a piece of code for a very long time now and have not had a problem with it, but now for some reason I am getting an error that says I cannot set the activeconnection of a recordset with a command as its source. I have been doing this for months with no problem, and still can...

That is all I wanted, thank you PJ!

I am trying to write a set of functions to allow a user to open a template and perform a mail merge on that template. I have asked this before, however the answer I received does not seem applicable to my needs. We have the following specifications: We have an MS Word template that we want to...

To get the object you are wanting, just create an instance of a Word.Document object and set it equal to your initialization of your new Word.Document in the code above. Example: '--------------------------------------------------------------------------------------- ' Procedure ...

Alright, I'll take a look. Thanks PHV.

I am revamping some older code to work with some mail merge automation I set up between MS Access and MS Word, and all works great except one single query. One of the automation functions I designed allows the programmer to pass the name of an access query to the function, which in turn opens...

I don't really understand your data and issue. If you could, please put some data and examples of calculations and results to help.