• How can i express the percent margin in a query for Microsoft Access?

    How can i express the percent margin in a query? I have a field PurchasePrice and a field Salesprice. the field Purchaseprice is the price at which we buy the products and the field salesprice is the field at which we sell the products.I tried to substract the salesprice to the pruchase price and...

    Peljo20 pointsBadges:
  • Test cases for Ethernet switches

    I'm working on a project which is on the Ethernet switch. I'm totally new to it. Could you help me with access control lists (ACL), Quality of Service (QoS), and packet filtering concepts in detail? I find it difficult writing test cases for it.

    NetworkingATE1,545 pointsBadges:
  • SQL 2000 to Yukon Migration

    We have 4-5 applications on the front end of a portal. On the backend we have mapped these applications to SQL server 2000 Databases. Now, we are planning to migrate on the backend databases to Yukon and map it to the application on the front end. My question: Is it possible to use Yukon for one of...

    Kilaru0 pointsBadges:
  • Can I call upon the username of someone logged into the pc, and use it in a web link?

    Hi all, Basically, I've got a webpage I'm working on, and I'd like to be able to provide a link in that page, that will take a user into their home folder on the network. Since it'll be different for each user, but it uses their username as their home folder, I'm thinking there must be a way, to...

    Linger19740 pointsBadges:
  • Dynamic updates to a DNS Server

    What Windows Operating Systems support dynamic updates to a DNS Server? Which service needs to be running on the clients?

    1111100 pointsBadges:
  • What is NAT port forwarding?

    Describe in brief how you would set up port forwarding on a NAT router to allow a PC on the LAN to publish its web to the internet.

    1111100 pointsBadges:
  • SQL statement using RRN(file) on join pulling only Max(date) records from second file in iSeries

    I am using WebSmart with the I-series data base files. I am joining two data base files receiving the RRN so that I can use the fetch rrn and the fextnext to display one screen at a time in my WebSmart program. I have used this method many times except this time I have a one to many relationship...

    Isjld35 pointsBadges:
  • Membership login with mysql

    hi, i doing a login program which will be using mysql. I would like to how do i do that, I have done a little but i am stuck half way can anyone help? protected void Login1_Authenticate(object sender, AuthenticateEventArgs e) { MySqlConnection conDatabase = new...

    Blue50 pointsBadges:
  • I am a student trying to convert a excel spreadsheet to a Access database.

    My questions: How do I convert data from an excel spreadsheet to a Access Database. How do I convert a access form to excel - Using the form as a front for data capturing. How do I link multiple users to a access database - making allowance for data to flow simultanously into the database.

    Joshua55 pointsBadges:
  • How supply password in VBA during CompactOnClose for back-end password-protected db?

    Access 2000: Goal: to open and close a password-protected public access db (which compacts on close) and hide the "Password Required" prompt on open and on close. Purpose: Provide public access to Main.mde and protect Main.mde from remote connections, i.e, import & link. I have password protected...

    Dlc9ball20 pointsBadges:
  • Access to MySQL – How hard is this going to be?

    I've just taken on a client who has been building his databases in MS Access for 14 years. He wants to put a significant amount of this data into an online MySQL application. I know it can be done, and I've agreed to help him do it. Does anyone have a feel for what it will take to get his data...

    Ken Harthun1,195 pointsBadges:
  • security problem

    Hello, I have small workgroup having 10 computers in my office. I do some personal work in office like using yahoo messenger, checking personal e-mails and some online banking site. But how does one of my senior knows it? I do everything lonely and securely so that nobody in the office knows it....

    BinooDas123410 pointsBadges:
  • Implementing DBMS

    My company does not have information services staff and I am not planning to ave one at this moments because of the expanses. We have 12 WINTEL microcomputers that we used for variety of tasks withing the organization. We use Microsoft Office for words and financial application and power point, but...

    Mis15 pointsBadges:
  • Months query in Microsoft Access 2000

    On the basis of my query i have built a totals query as follows: SELECT Sum(qryMargin.MarginInvoice) AS SumOfMarginInvoice, qryMargin.invoicedate FROM qryMargin GROUP BY qryMargin.invoicedate; I want to break down the sum so obtained into months on the basis of the invoicedateand also to arrange...

    Peljo20 pointsBadges:
  • blanks (”) instead of NULL’s in SQL Server 2000

    I have a development team that wants to represent all fields with no values with a '' (blank) instead of using the database standard of NULL. The team is coding in C#. I am told it is easier for them to code around blanks than NULL's. Aside from taking up more space in the database than is...

    ColdDBA0 pointsBadges:
  • Can’t gert nested subforms to work in MS Access 2007

    Hi, and thanks for taking a minute to read my post. I am trying to get nested subforms to work, without success. I have a main form with a subform, then a subform inside the first sub. I'll call them 1 (for the main), 2 (for the first sub), and 3 (for the second sub). I can get 1-2 to perform...

    Mballard10 pointsBadges:
  • The most widely used form of database is a?

    The most widely used form of database is a?

    Jthomps25 pointsBadges:
  • MYSQL/PHP based CMS (Mambo,Joomla) on the 400.

    Has anyone setup one of the MYSQL/PHP based CMS (Mambo,Joomla) on the 400 yet? I use these CMS on regular Apache 2.0 servers with MYSQL 5.0 & PHP 4+ These CMS are very flexible and adaptable and I would like to use on the 400.

    DHanneman200 pointsBadges:
  • Download from the AS400 tab delimited file

    I need to be able to download in an automated fashion, a DB2 table as a tab delimited text file on a PC. I have successfully done this manually using the Actions munu in client access but need to be able to do it automatically in either a CL of a PC scheduled job so that it will run unattended. Any...

    Butcheanes5 pointsBadges:
  • trigger to update

    My Table Structure is: Table A Table B Table C colA -PK Col B-PK Col C-PK Col B-FK Col B-FK Col C-FK This relation establish a Concurrent relation where in Cascade Property fails.I can set Cascade property for any two tabnles...but not the third table. My requirement is : 1)To Update PK of Table B...

    Adithi5 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following