I have a report which displays fields from a form and a subform. the data displayed in the form/subform(master/child) are the source of the report.
My form is bound but my report is unbound. ...
I have 5 queries which i need to export into 1 excel spreadsheet. each query will have its own tab in excel.
class anyone?
don't know where to get started. queries are are already built....
Hi Experts...
I hope I can get help here, I am approaching after doing a futile search on Internet.
The problem is:
We are having a production server with the following config:
IBM...
I am currently in a group who is working on a new automated system for a business. This system will be used for employee shift changes and keep track of these shift changes. We have formul...
Hello all,
We are trying to extract some ODBC connections from client computers to transfer them to new PCs. We have noted Two distinct locations in the Registry that hold the configu...
Hey there,
I have a question about handling punctuation in SQL..
I want the SQL to be able to handle phrases such as "Dean's List" (including the apostrophe).
My current sql string is...
The directory and file is there nothing wrong with the network drive
Can anyone tell me how to resolve this error?
Could not bulk insert because file ' K:\Apps\orderlog\APAPORD1.txt ' coul...
The follow code in Access prompts me to confirm each statement. Can this be turned off?
Option Compare Database
'------------------------------------------------------------
' Build_80...
I WOULD WORSHIP ANYONE WHO CAN HELP WITH THE FOLLOWING: I need to translate this small piece of php into something that would work with an oracle DB. As it reads right now, it is setup to in...
How do i connect to a DBISAM database from Visual Basic
I created a function with column names passing as parameters . Both the columns store data of date type.
My function is as follows. I am getting an error. Please give me the clue where things...
got this working using access 2000 and ODBC but need to run it from a SQL server 2000 procedure how do I translate the syntax across from Access to SQL Server.
UPDATE (dbo_tbl_LVG_Media_Cat...
my MSI dept is planning to write a customised and in-house inventory and accounting software, using visual basic 6.0 and MS access database (mdb).
i need to plan very wisely as there is no ...
Hi All ,
I am getting this error on my database. I am running OLAP BI Bean queries against the database. But the Cache Hit percentage is 100% Below are sga parametes. Can you let me k...
I am trying to automate an Excel97 spreadsheet import into an Access97 table with a command button, but I get the error "Run-time error '3070' The Microsoft Jet database engine does not recogn...
I need a general cost comparison between DBMS's (such as MS SQL Server, Oracle, Mysql & DB2). I do not need exact figures.
Hi,
When I run query in SQLPLUS:
select CO_OUTGOING_EVENTS_PKG.GET_EVENTS('EM') from dual;
I get
OCI-21560: argument 3 is null, invalid, or out of range.
CO_OUTGOING_EVENTS_PKG.GET_EVE...
How can I insert a comment or remark in a Access 2000 sql query?
How do I find the number of columns in a table, using PL/SQL ?
Kindly suggest.
I had scheduled to backup the MSSQL 7 database backup to occur everyday at 9.00 PM. During the last one week it fails.
I looked a t event viewer of WINDOWS 2000 server where (MS SQL resides),...
I want to use the result of a sum in the same query.
Something like this:
select sum(columnA) sumof, sumof/10
from tablename
ALso I want to do something like:
select keycolumn, sum...
We are running MS Exchange on Windows NT 4.0. We only have a 4 gig hard drive and 13 users on the system. Our Priv.edb is 535,560 KB big. Needless to say, I am running out of hard drive space....
The page server is failing to serve reports where there is a parameter being passed to the report like a case number. It doesnt work. I can get reports without parameters to refresh and also t...
Can anybody please tell me why oracle complains about the semicolons at the end of each insert statement and the correct syntax to fix it.
INSERT INTO SYSUPD.F986101 ( OMENHV, OMAPPLID, OMO...
Hi
i am presently connecting asp pages to an access database. However becasue of my SQL statement i keep getting a datatype mismatch error. The SQL statement is as follows:
strSQL1="SEL...
