Search results for query: *

I have an application that I want to do 2 things with. a.) Select it and Send keystrokes. Note After you send keystrokes to the application the window name changes from "Ready" to "Not Ready". When the application is running my script works fine. If I enable the application to minimize...

I have a listbox displaying data. Initially the listbox is setup as 'Multiselect' - so that multiple items can be reported on. On one of my summary reports I want to disable the multiselect. When I use the code. mslist.multiselect = 0 I get a run-time error 2448 - you can't assign a...

The IP Address field is stored as text. Has anyone coded a routine to sort the records by increasing IP address. 10.30.5.1 10.30.5.10 10.30.5.2 10.30.5.3 10.30.5.4 Currently this is what happens if you sort.. the last octet jumps up with the other's. Any idea's? Kramerica

sql statment: SELECT [Enter Effective Date MM/DD/YYYY] AS [Date], [Enter Denial Explanation Code] AS EX INTO [tblParameters]; If you open a new query in Access 2002 - and paste this in the SQL window - and run it, it will create a new table called "tblParameters' - with 2 fields...

Once upon a time there was a table. This table has an OLE field where users have stored all kinds of things. Word Docs /Spread sheets / Txt files / bmps/ etc. etc. I would like a routine that can loop through the table and extract each of the OLE items to a file and place it in a directory...

I would like to identify the primary key or keys of a table with some ADO code. Kramerica

I am looking for a VBA routine that will compare two tables or recordsets and identify the differences. So I could pass it two table names and it could identify what is different between the 2 tables. Does anyone have any code to share? It would be greatly appreciated! Kramerica

When using Access 2002 on a form, I have a button that calls up the 'find and replace' dialog box. If I setfocus to one of the fields on my form, prior to running the code to pull up the dialog box, in Access XP the dialog box sets the 'look in:' to the last field I used. If I want to search...

I would like to display all the DSN's on a machine and list their corresponding Driver. Any ideas? So instead of just listing the DSN as: DS2TCDBR I want to list it as DS2TCDBR Microsoft Access *.Mdb

We have an ODBC Datasource setup. We have linked multiple tables to an Oracle back end. It would appear that all tables that have a memo field, when linked in Access xp display '#NAME?' for all fields in the table!!!!!! We have the latest patch from Microsoft on this...

I want to be able to count the number of records in a record set by passing a parameter to a stored procedure. For Example location id 7 is going to list all users who are in the 'TZY' Office. Then I can get the count and run it against location id 23 and get a count of all users at the...

I have a listbox. When I type in the first letter the listbox responds by taking me to that section of data. For example: If I have a list of states, and I type in 'M' it navigates down to the states that start with the letter 'M'. If I want to just type in "MA" when I hit 'A' it...

I have a table that I am opening as a recordset. I am looping through the recordset and on each record I am processing an 'Update Statement'. Code works great.. just slower than I expected.. Any ideas? I am using Dcount to give me a total of the number of PC's that meet my criteria. Then I...

Is there a way to display just the first page of a report? Let's say there is a report that you would like to print preview, and it is 170 pages. Can you do a preview of just the first page!? I know you can PRINT the first page only with VB code.. Is it possible to PREVIEW the first page...

Here's the dilemna. Reporting tool exists on several different machines. (Not Central the clients that use the tool are located in different locations with no connectivity amoungst themselves.) The reporting tool uses a couple of key tables that store 'static' data in them. Once the data is...

I have an Access Database that has a frontend and a backend. The application has been rolled out to different sites, and I need to add a couple of fields to one of the Backend tables. I can very easily distribute new frontends to everyone, but I have not run into the problem of 'modifying' a...

How do you add the 2 string values? I have 2 variables that I am reading from a Recordset. A= RSRECORDS("TotalB") B= rsRecords("TotalC") RESPONSE.WRITE (a) + (B) if Value for a = 763 and value for B = 381 my response.write statement keeps giving me 763381 What am I...

I have a simple problem.. and I am a little short on time. I have a Windows 2000 Database on the local C: drive, I would like to be able to click a button and establish a DSN Connection to another Access database that is on a Web server. NOTE THE OTHER DATABASE is across the WAN. Once...

Help question: How do you get Access to call HLP files from "F1" Key? I can successfully open the file with VB button. Dim stAppName As String stAppName = "C:\winnt\system32\Winhlp32 C:\MIGDB\DATABASEHELP.HLP" Call Shell(stAppName, 1) Kramerica

My database is Windows 2000. It has a front end and a back end. I have code to auto-relink the tables when they can't find each other and the code works. Unfortunately when the database first opens it gives the error with the yellow exclamation "Could not find file...