Search results for query: *

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

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

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

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

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

This is a rather complex and technical question and I would guess only a few may have had prior experience with such issues. If you have done application design between different MS Office programs and have ever handled errors between the different programs, I would appreciate your help. I am...

I am having a very weird problem with MS Word. I have a mail merge document and an RTF document output from MS Access that are both available and can be opened at any time. I open Word and select OPEN DATA SOURCE and then use the RTF document. This seems to load fine. When I go to actually...

I have reduced my code to a simple function call to exemplify the problem, so here is the example. I only receive the following message: Visual Basic Run-time error '13': Type mismatch Private Sub Form_Load() Dim AccountRst As ADODB.Recordset Set AccountRst = New ADODB.Recordset...

I am trying to learn more about the Microsoft Access object model and cannot understand if there is a difference between the CurrentProject and CodeProject types. I can see that there are different objects and properties in each, however they seem to share several objects and properties and I...

I am just starting into ADO.Net using Visual Basic .Net in a Windows application environment. I have been told that the DataGrid gives advantages over list boxes, etc however I can't seem to see why this is. For one thing, when I bind a DataTable to a DataGrid, I can't seem to hide any...

Confused on this one, I want to take the value given in a row (it is a bit value) and output a "Yes" or "No" instead of the representative 0 or -1 during a query. Example: SELECT AppName, Inactive FROM ApplicantStatus ORDER BY AppName Current Output Name: Billy Bob -1 Joe Bob 0 Silent...

I have most of a design done for an HTML Editor for Access, which allows a user to load HTML stored in a database, edit it and preview it, and return the changed code back to the server. I have read that using the Microsoft Web Browser control you can turn on the WYSIWYG editor which IE has...

I have been working at this all day, but here is the idea. I have a stored procedure which returns a recordset of employee information to the client. The recordset returned includes EmpID, EmpName, and EmpAsgn (assigned). CREATE PROCEDURE dbo.upProjTrack_RetRSEmps AS SET NOCOUNT ON SELECT...

I need some help figuring out the algorithm for designating a sort order on objects which are removable from the database. I would normally use integers to denote sort order, however with removable entries this does not seem efficient. Example: I have a list of projects and want to order them...

I have a database where I retrieve a record using ADO, then populate controls or bind the record to a form. The user can change data without affecting the actual table until they decide to save their changes. A timestamp is included in tables that will be accessed regularly so we can avoid...

I am in need of some help with calculations. I have the following set up in a database. tbl_Orders OrderID (AutoNumber) OrderInfo (Other stuff) Primary Key (OrderID) tbl_Inventory InvID (AutoNumber) InvDesc (VarChar 64) InvPriceFirst (Currency) InvPriceAddtl (Currency) Primary Key (InvID)...

Is there any way to pass open arguments to MS Access during startup?