User Profile

Collapse

Profile Sidebar

Collapse
Mr Key
Mr Key
Last Activity: May 1 '21, 03:19 PM
Joined: Aug 23 '10
Location: Arusha, Tanzania
  •  
  • Time
  • Show
  • Source
Clear All
new posts

  • Mr Key
    started a topic How to stop king to jump in checker game with Java
    in Java

    How to stop king to jump in checker game with Java

    I have been creating English checker game by using Java, everything is working fine, my king is jumping and capture opponents pieces as it should have been. My problem is that when the king is crowned after capturing the opponent pieces it continue to jump back and capture other pieces available. Actually it is supposed to stop right after being crowned as king.

    Here is my code:
    Code:
    if (board[row][col] == playerKing)
    ...
    See more | Go to post

  • Mr Key
    started a topic How to merge c++ code into Visual C++ studio project?
    in C

    How to merge c++ code into Visual C++ studio project?

    I have created Win32 Application project in Visual C++ 2010 and I want to add C++ Program to display the word "Hello World" on the screen.
    I have read many Forums but I cant get what I want. They endup proposing another code-type instead of pure C++ code.
    Please help!!!!!!
    See more | Go to post

  • Thanks alot!

    Here is the step achieved to accomplish this task.

    A:On the MYSQL server machine
    1.Add Mysql port 3306 to the exceptions list of windows FIREWALL
    2.Give GRANTS to users that supposed to use MYSQL
    i. If you are using windows XP, On the command line just go the directory yo have installed MYSQL as follows.
    $ C:\Program Files\MySQL\MyS QL Server 5.6\bin
    then write ...
    See more | Go to post

    Leave a comment:


  • Ok thanks Orollay!!
    I know how to connect with ODBC in local machine but my question is on networked computers. Say Computer1 as a server installed with MYSQL and Computer2 as a client machine installed with MS_ACCESS with its applications. I can use MS applications on the same machine with MYSQL using ODBC connection as a link. I can also connect by PHPMYADMIN on network. but I need ODBC in network to simplify applications buildup like forms...
    See more | Go to post

    Leave a comment:


  • Mr Key
    started a topic How to Connect MYSQL to MS ACCESS in NETWORK?

    How to Connect MYSQL to MS ACCESS in NETWORK?

    Hi all!!
    I have MYSQL server running in one machine (say PC1 with IP 192.168.0.45) and I want to connect to MS-ACCESS in another machine (say PC2) on the same network.
    How can I go about it? Please help!!!!!!!!!!!
    See more | Go to post

  • Is better you leave the question unanswered rather than typing one line blablaaa.
    I know very well how to write WHERE CONDITION, the issue is to capture the input from one login form to SQL!
    Please the other time read first before u respond
    See more | Go to post

    Leave a comment:


  • How to set Dynamic WHERE showing customer rows depend on customer_ID using PHP?

    Hi all once again!!

    I have two tables in MYSQL, tblLogin and tblCustomers with the following Columns: tblLogin{LoginI D as Primary_Key, UserName, Password} and tblCustomer{Cus tomer_ID as Primary_Key, Customer_FullNa me, OrderID, OrderDetails, submission_date , Customer_LoginI D as Foreign_key}.
    What I want is to let customers to view their own records only due to their login information.
    To accomplish this I set two forms...
    See more | Go to post

  • Mr Key
    replied to How to create CROSSTAB query with TWO VALUES
    Thanks Zzz!
    I have tried the suggestions posted by Allen Brown athttp://allenbrowne.com/ser-67.html and it works fine. Thank you
    See more | Go to post

    Leave a comment:


  • Mr Key
    started a topic How to create CROSSTAB query with TWO VALUES

    How to create CROSSTAB query with TWO VALUES

    Hi all!
    I have my table with four columns as shown below
    Code:
    [B]ModCode	 CA	SE	IDs[/B]
    ETT04101	1	45	AbC8976
    ETT04101	2	45	ABCD0912
    ETT04102	8	41	AbC8976
    ETT04102	9	45	ABCD0912
    I want it to be like this one
    Code:
    [B]IDs	ETT04101(CA)	ETT04102(SE).....[/B]
    AbC8976	   1	             45
    ABCD0912      2                45  
    AbC8976	    8	           41
    ABCD0912
    ...
    See more | Go to post

  • Mr Key
    replied to How to Run Parameter Query in VBA???
    Thanks Mihal and Neopa for your time!
    I will work it out for two days and post the answer right here!
    See more | Go to post

    Leave a comment:


  • Mr Key
    replied to How to Run Parameter Query in VBA???
    Ok thanks NeoPa!
    You always have constructive ideas but very hard to grasp!!!
    I have read the article as suggested but coldnt solve my problem.
    I have a parameter query which is working properly so far, I just want to change the design towards VBA from ordinary queries. Should I run my first SQL through VBA then I can go ahead debugging my SQL string!!!!
    You know, I can make it on my own should there be no choice behind but...
    See more | Go to post

    Leave a comment:


  • Mr Key
    replied to How to Prevent Duplicate Records??
    Ok thanks for your time! I have set all records in Form1 and Form2 as primary keys to prevent any duplicate records, and set the appending action of tblForm2 to be first one so as to prevent any triggering incase of anything.
    Finally it solves my problem! I dont know the pitfalls on this that might come in the near future.
    Thanks
    See more | Go to post

    Leave a comment:


  • Mr Key
    replied to How to Prevent Duplicate Records??
    Well NeoPa! this may be a wrong question but they have been using the application for a year or so and already have cases with duplicate records and tried to solve it by deleting the duplicated data! the question is, by how many times Am I going to visit users for same cases??
    At least it should be query failures during executions that prevent any usage of this database but I dont have such case so far. This is my serious case !Duplicate!...
    See more | Go to post
    Last edited by Mr Key; Dec 24 '11, 09:21 AM. Reason: Spelling error

    Leave a comment:


  • Mr Key
    replied to How to Run Parameter Query in VBA???
    Thanks Neo and Rabbit, the queries runs with respect to the forms, the key word Me refers to the current Fields in a forms that referenced by the query. May be it is not the right place to be thus why I have asked for your hint!!!
    Rabbit, these queries varies in structures and differ one another; I have Append queries, Delete Queries, Update queries and simple queries, but all of them runs with parameters taken from either FormsComboBox or...
    See more | Go to post

    Leave a comment:


  • Mr Key
    started a topic How to Prevent Duplicate Records??

    How to Prevent Duplicate Records??

    Hi all once again!!!
    I have a Database that runs perfectly under carefully users. Due to the limitations on the database design capabilities I decided to use Transactions
    (You enter data once and then deleted by the appropriate queries following transactions to related tables) in which the forms you enter data is
    always empty after executions. Sometimes users tend to enter the same records once again just because they don't...
    See more | Go to post

  • Mr Key
    started a topic How to Run Parameter Query in VBA???

    How to Run Parameter Query in VBA???

    Hi all!!
    I have a simple database with 56-Queries that runs by passing parameters from specific forms. It works perfect!!!
    The problem is, I`m running out of space in the navigation pane, with 56 queries and more parameter queries to come.
    I would like to build parameter query in VBA so as to have user friendly database using the following code!
    Code:
    Private sub parameterquery()
    Dim stringSQL As DAO.Workspace   'Current
    ...
    See more | Go to post
    Last edited by Mr Key; Dec 23 '11, 01:41 PM. Reason: Layout editing

  • Mr Key
    replied to How to Run Sql query in VBA code & Macro?
    This guy were looking to delete specific records in a table not the whole table from database!
    The problem is in his code Delete * from Payment_detail_ Table where [Payment_id]=(Select Max([Payment_id]) from Payment_Table)
    If you want to delete specific records you don't have to use * (All), instead you have to list all fields in that table where your criteria are met! For example
    Code:
    Delete MytableName.Field1, MytableName.Field2,
    ...
    See more | Go to post

    Leave a comment:


  • How to Trigger "No Records Found" When There is No Records in .accde/.accdr?

    Hi all once again!!!!
    I have a database in .accde/.accdr format. The database has been designed using many relational tables.
    I set a form for deleting some records or all database.
    The problem is when you delete the records with action query it pop-up a message saying "you about to delete zero rows (0s)from-specified table" ten times for 5-relational tables. It is very annoying!
    I know how to get read of this...
    See more | Go to post

  • Mr Key
    replied to Create Dynamic Report using VBA
    What if I have products on the market that create Column headings of different Size, say from 15 to 40 depending on sales of that particular day.
    If you first design the Col1,Col2...Col 40; When it comes the number of column resulted from Crosstab is lessthan 40, it gives error.
    As Nico stipulated on Post no. 14 above, but I cant fix it. It still gives error.
    See more | Go to post

    Leave a comment:


  • Thanks Sir for your help, finally it works. I dint recognize the change from BeforeInsert to BeforeUpdate
    Thanks again!
    I can now move to another problem of AfterInsert Event Not Triggered as Expected on Pasted Records
    Thanks all for your contributed in this post!!!
    See more | Go to post

    Leave a comment:

No activity results to display
Show More
Working...