Search results

I am converting my MDB app to an ADP and MSSQL back end and am rethinking my position on subforms. Most of my forms have tabs, generally 3-5, on them containing subforms. And the user generally selects the record they want to work with on the header form or on the first tab. My question is/are...

I have the following sp that doesne't seem to output anything. ALTER PROCEDURE dbo.spKitsWithSubOrders (@lngWOID int, @lngWOIDSub smallint, @bResult bit OUTPUT) AS SET @bResult = 0 IF EXISTS ( SELECT dbo.T_SetupSheetHistoryCombinationsDetail.WOID...

I am having problems converting the floowing code to ADO. Specifically with the FindFirst and Move. I have serached but don't fully understand when to use "Seek" and when to use "Find" and also what options I have to include with them. Dim blnFound As Boolean Dim lngWOIDSub As Long, lngWOID...

I don't think so, but what I do generally is just make a little unbound (to data) form and put my combobox on that then on a button run whatever code, form, report that I need.

Is there a way to prompt the user to set the Project's connection information, like the Server Name, Database? I want my users to be able to provide this info the very first time they run my Access .ADE because I won't know the name of their server or login name. (Although I probably would...

You need to put something in the CNames() like a 1 or a 2. 'UserorComputer; 1=User, anything else = computer so try this: Forms!FormName!TextBox=CNames(1) Mitch

Two easy API calls can provide you with network log in name of the current user of the workstation and the network name of the computer itself for use in your Access application. Declare the following functions in your module and add the following function: Private Declare Function...

One of the main reason is for data access and manipulation speed. From what I have read, it is the faster way to work with the data on SQL Server. Yes, I don't like giving up local tables! :mad: One thing I don't understand yet, is why, when I create someting or even look at something in...

Yes, that did it! Thanks. :D

I am trying to add a new record to a subform from a button on the main form but when I do, the subform's blank new record does not "jump" to the focus like when I click on any of the subform records and hit Insert-->New Record. Here is what I have on the button...

Are workgroup files (.MDW) still used in an Access 2002 project (.ADP ) ? I am converting an Access 97 .MDB version to to an Access 2002 project (.ADP) and the workgroup administrator is grayed out in the Tools-->Security section when I open my .ADP file. If it is not, then how do I protect my...

Sorry about the deley, I have been fighting my new firewall dropping my connection. Now i see what you want to do better. Waht you need to do is do is somethig like this: 1. On the combobox LOAN (you may want to change the Name of that to something linke cbxLOAN, sometimes referencing a...

Many Thanks! :D

Works !! I got it to work! :D I had to make 4 queies: 1. Ranks 2. Max of Ranks 3. Top Ranking Employee at each Company 4. Top Ranking Employee at each Company for ALL companies I could not find a way to do it in less, but there probably is. I have attached the database that worked for...

I'm not sure I fully understand what you want, but here goes: 1. You select an item from the Equip table. 2. If that item is allready out, you want something on the form to indicate that. 3. When you select an item that is not out and you "tag" it for use, the loaned out field must be...

Here is my table of companies and employees with thier title ranks, I need to select just the highest ranking empl for each company. Comp anyID Rank EmpID ===================== 100 1 104 100 2 103 100 3 101 100 4 102 200 1 202 300 2 301 300 4 302 400 2 402 400 3 401 My problem is how do I...

I am converting some code from an Access MDB to an ADP. I have the following code that runs from a combo box on a form that is NOW based on a stored procedure: Dim lngECN As Long lngECN = Me![cbx-FindECNReq].Column(0) ' Find the record that matches the control. Me.RecordsetClone.FindFirst...

I need to get the UNC for a file that is local the the PC the code is running on. For example: c:\This is the dir\this is the sub\12345.txt I need this in UNC format. I am using the Common Dialog, but if there is a better way then I am open. I can use this for the actual network PC but not...

But I still have the issue of how best to "put together" the characters as they come in one at a time. Or am I making that harder then it should be?

I am doing this the "brute force way", so I am looking for a better way. I am intteracting with another program that is getting an ASCII text file via the serial port. I can't change how I get the data, it will be given to me one character at a time, I make a call to its function and it returns...