Database

Microsoft Access

I have created an Iff statement where it will compare two fields and return the bigger number. The problem is that instead of compare the numbers as a whole, it compares them digit for digit. Result is that it will return a value of 150 instead of the bigger value of 1040, because the second digit...

Answer Question   |  May 13 2008   8:06 AM GMT   |  asked by Jaco
Microsoft Access

MS Access ActiveX Control

I am using a MS Form where I am trying to fill in a couple of date fields from a Calendar I inserted using ActiveX controls. How do I go about doing that?Thanks,Asuasol

Answer Question   |  May 12 2008   6:50 PM GMT   |  asked by Asuasol
Microsoft Access, ActiveX, MS Access

Combined Address

I have one tblContacts that has "Home" and "Work" address included within it, I also have an option button 1="Work" and 2="Home". I need to prepare a mailling report, but only for the defaut address.Someone suggested that I create a calculated field. I tried this but all that it is doing is pulling...

Answer Question   |  May 12 2008   5:29 PM GMT   |  asked by Thuzinec
SQL, Query, Microsoft Access

Net Present Value

In an Access Form, I want to be able to have five values in text boxes and use those five values along with another value in the form, the return rate, to produce the Net Present Value

Answer Question   |  May 12 2008   4:41 PM GMT   |  asked by Mattylar12
Financial Functions, Microsoft Access

Best RAID for Database Server

We have 70+ users connecting almost 125 machines to connect to an Intel 5000VSA 4dimm Board Server with 2 Xeon processors, 6 SATA (on-board RAID 0, 5 or 10), 1 IDE port. I want to put the best possible RAID with 200/250GB SATA drives, with Best Redundancy and Performance, irrespective of the cost....

Answer Question   |  May 12 2008   2:00 PM GMT   |  asked by Mkanjani
RAID configuration, Intel Xeon, Database Servers

MySQL Stored Procedures with Parameters in Crystal Reports 9???

Hi,am using Crystal Reports 9 and the MySQL 5 DBMS.I have a stored procedure which accepts a parameter, Crystal Reports won't accept this stored procedure and cites 'Incorrect Number of Arguments; expected 1, got 0'. Im pretty new to MySQL and perhaps I shouldn't be creating stored procs the way I...

Answer Question   |  May 12 2008   11:10 AM GMT   |  asked by Les za
Crystal Reports 9, MySQL, Stored procedures

how to get list of encrypted objets in sqlserver 2005?

i need a list of encrypted store procedure name,encrypted trigger ,encrypted functions from sql server 2005.

Answer Question   |  May 12 2008   7:50 AM GMT   |  asked by Subrata73
SQL Server 2005, Encrypted stored procedures, Encrypted triggers

Aggregate data

Can I manipulate aggregate tables at the census tract level? In essence, could I create dummy variables, such as: white, black, hipanic, other for 100 census tracts? Or is this only possible with individual level data?

Answer Question   |  May 11 2008   5:42 AM GMT   |  asked by Romanov38
Census Tract data, Database programming, Database

Grouping and Sorting

I have a Crystal report in which I want to group employee number but sort the group by hire date. Is this possible?

Answer Question   |  May 9 2008   9:48 PM GMT   |  asked by KatSil
Crystal Reports, groups, Sorting

Populating a db with information stored on another db

I have a general how-to question. I need to populate a database with information stored on a separate database. I have never done this before and I would like to know the process that is usually used. A little information concerning the databases. My database is set up through phpMyAdmin. The...

Answer Question   |  May 9 2008   7:54 PM GMT   |  asked by LoganGoesPlaces
phpMyAdmin, Database, SchoolTool

Open Import window via code in MS Access

Within a MS Access application, I would like to have the window that is opened when you select: File | Get External Data | Import via code.

View Answer   |  May 9 2008   3:14 PM GMT   |  asked by Rjwilcox
Database, MS Access, VBA

Error - You are not authorised to access this database

Hi, i have installed domino and notes on my home pc. i have created 3 users. now the problem is that when i try to access mail or click on new memo to write mail as a user following error encounters "You are not authorised to access this database"as a administrator i can do this. I hv created all...

View Answer   |  May 8 2008   12:33 AM GMT   |  asked by Meenateena123
Lotus error messages, Lotus Domino, Lotus Notes

MySQL Stored Procedures in Crystal Reports

Hi,am using Crystal Reports 9 and MySQL 5 DBMS.I have a stored procedure which accepts a parameter, Crystal Reports won't accept this stored procedure and cites 'Incorrect Number of Arguments; expected 1, got 0'.Im pretty new to MySQL and perhaps I shouldn't be creating stored procs the way I...

Answer Question   |  May 8 2008   11:18 AM GMT   |  asked by Les za
MySQL, Crystal Reports, MySQL Stored Procedures

Is there a way to set up database mirroring in SQL Server 2005 to receive failover notification?

I'm setting up database mirroring in SQL Server 2005 Standard Edition and was wondering if there is a way for SQL Server to send me a notification of a failover and for it to automatically run a script when the mirror is brought online.

View Answer   |  May 7 2008   4:12 PM GMT   |  asked by SQL Server Ask the Experts
Database mirroring, SQL Server 2005, SQL Server alerts

Is there a query to search text of all SQL Server database objects that reference a specific table/instance?

We want to migrate to SQL Server 2005. We need to find all database objects such as Stored Procedures, Views, Triggers, User Defined Functions accessed specific tables, DTS packages that reference a specific table/instance. Is there a query that will allow me search the text of all?

View Answer   |  May 7 2008   3:49 PM GMT   |  asked by SQL Server Ask the Experts
Query, SQL Server migration, Database objects

How to perform exploratory database testing using ERDs

Can you please advise me on how to perform exploratory testing on a database using ERDs?

Answer Question   |  May 7 2008   3:05 PM GMT   |  asked by SQL Server Ask the Experts
Database testing, SQL Server database design and modeling, ERD (Entity Relationship Diagram)

While loop Vs Cursor

What is difference between navigating records in while loop and cursor ?

View Answer   |  May 7 2008   4:16 AM GMT   |  asked by Just dream
Development, WHILE Loop, Database

Split Databases - BE Structural Changes Version: 2007 (12.0)

Can I make structural changes to the BE database without affecting the users? i.e. the relationships, proprieties Also, why do you have to put the FE on the users computer, can't you put their copy of the FE on the network, under a folder just for that user?

View Answer   |  May 6 2008   8:23 PM GMT   |  asked by Thuzinec
Microsoft Access, Access 2007, Database

Update table to remove invalid char type (tab) Oracle

I need to update a table I have in oracle that has an invalid character type in it. It looks like it is a tab character. Can someone give me a script to update this field in the table to remove a tab character from a field and replace it with a space - I assume? Very few rows have this 'bad' data...

View Answer   |  May 6 2008   4:46 PM GMT   |  asked by Meb
Invalid char, Oracle

SQL DB2 COBOL date reformatting

Hi and thanks in advance,I want to use DB2 SQL in COBOL to reformat a date from CCYY-MM-DD to MM-DD-YY. What is the simplest and most efficient way to do this?Christy

View Answer   |  May 6 2008   3:26 PM GMT   |  asked by Ctrevino
COBOL, SQL, DB2