Search results for query: *

I can find info saying that it can be done, just now how. Any help is appreciated. I live to work and I work to live.

I have a process that runs on Access2k build 9.0.0.6620 that runs in about 27 minutes on average. When I run this on a different pc with build 9.0.0.4506, the process runs in about 1.5-2 hrs. The PC's are identical in terms of hardware, i.e. 1GB RAM, same CPU, HD's defraged. My biggest issue...

I have two address fields "BNA" (means Borrower New Address) and MADDR1 (mailing Addr). The BNA is returned by my vendor and I need to compare it to the MADDR1 field. If the address is different, they've given me good info and can bill me. If not, no charge. My problem is I can only get so...

Is it possible to export a query or table as a pipe delimited text file? I live to work and I work to live.

Is it possible to run an Oracle STored Procedure from Access? I live to work and I work to live.

Is there a forum, group, location, etc., where I can find help on SQL Navigator? I'd like some instruction on building Stored procedures to run queries, however, I'm not having any luck finding anything. Thanks Crusty. I live to work and I work to live.

I'm looking for the Oracle equivilant of the NZ() function so that I can use it in a Passthrough to Oracle, OR, so that I can create a view in Oracle and call it in Access... either way... what does Oracle call NZ()? I live to work and I work to live.

I'm developing on a new version of Access 2k. Our IT dept. has unfortunatley installed newer version as new people come to our department. What this means is that I have SP-3, however, several people in my department have 2, 1, or even original Access 2k Pro, no updates. Obviously, there are...

I am trying to dig up references/doc's to support why all our PC's need to have the same install of Access. My fellow Developer and I have the ActiveX Data Ojbects Recordset 2.7 library, while everyone else in my group has 2.5. This has presented several problems as everytime the db is opened...

I have a one record table that has a field I need to update with the contents of a variable. In DAO I would used EDIT, modify the field(s), use Update, save, etc. I can't make it work in ADO... Here's my code... Dim cnn As ADODB.Connection Dim rst As ADODB.Recordset Set rst = New...

A colleague of mine has the unfortunate task of merging an Access table with MS Word templates. The problem with this is the vendor, which receives the word files, has mandated that each file have no more than 500 pages. Thus, the poor girl, once a week, has 53000 plus letters to merge in 250...

I have been tasked with generated a list of all the fields in all of our Oracle tables. We want to build a db to show where all the possible locations are of a specific data. For example the "widgets" field is in the tbl_Product and tbl_Line tables. I want to write a query/code that will...

I have some VBA that runs a query via a Docmd statement. Problem is, everytime I close the db, the connection is lost. I'd like to add the connection string including the username and pw somehow so that every time the query runs, it relinks, everytime. I've already generated my connection...

I'm using the following line: DoCmd.TransferSpreadsheet acExport, 8, "qrySEL_FCL_REV_List_NoNoMod", "C:\Documents and Settings\sroark\My Documents\Demands\FC REV\Conv_AutoRefer.XLS", True, "" which runs the query and deposits it into a spreadsheet of my naming choice. Is there a way to...

Can anyone point me to some generic instructions on how to create folders? Much Appreciated.. Thanks Crusty I live to work and I work to live.

I firm I contract for has an old MDE. The developer that built it is long gone and there is apparently no source MDB for it. The database is starting to have issues and they need someone to tweak some things as well. Any ideas? Probably an Access97 db. Its pretty old. Thx. I live to work...

I have a report that merely calculates the values of the fields above it. The problem is in the case where there are no values. I get an error becuase it is trying to calculate a null. I've tried several functions (isnull()) etc, trying to eliminate the error and place a Zero in it's place...

My predisesor left a db which he has locked down very well. Its not an MDE, however, I can't seem to see any forms in Design view. When I try to change to design view, the db shuts down. There is obviously some code running somewhere, however, I can't see any modules. The db is set to...

I have a chunk of code that works for the most part. Its essentially a GUI that gives the user a status/update based on whats happening. Very simple, no problem solving. 1.populate text box with start time. 2.Post a message in another text box saying "TIME:Query x is starting" 3.kick off the...

I'm trying to tune someone elses work (doesn't work here anymore) and they have 2 queries which add fields. In the past, I've added a field, calculated fied, etc., by using "FIELD:X+Y" or something like that. What I'd like to do is add two extra fields, which will be populated by later...