User Profile

Collapse

Profile Sidebar

Collapse
ashes
ashes
Last Activity: Aug 10 '08, 11:17 PM
Joined: Jul 27 '08
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts

  • Hi,

    the code that posted does nothing. do you have any other ideas that may help?
    See more | Go to post

    Leave a comment:


  • ashes
    started a topic Parameterised queries

    Parameterised queries

    Hi,

    I am getting an error message saying:

    “No value given for one or more required parameters.” And it points to this line
    command.Execute NonQuery()

    I am not sure what this means. The code I used is below:


    Code:
    With command.Parameters
    
                        .Add(New OleDbParameter("@Firstname", FirstName.Text))
    
                        .Add(New
    ...
    See more | Go to post

  • inputting information when there is a foreign key

    Hi all,


    In Ms Access, I have a Customer table and a Credit Card table. The CustomerID field is a primary key in the Credit Card table. Both tables already have sample data in it.

    So, when a customer wants to purchase a product, they proceed to checkout and payment. They fill out the payment form where their credit card information is inputted.

    When the customer submits the form , the system...
    See more | Go to post

  • VB.NET: Logging out a session after 30 mins inactivity

    Hi all,

    i am creating a website and i want to log out the user after 30 mins of inactivity. how do i do this using vb.net.

    Also, if the user tries to login and not getting through. after 3 tries i want the system to lock the user out and after 10 mins the user can try again.

    can any1 help me?
    See more | Go to post

  • information already on file problem - Reader.HasRows

    Hi,

    i created a register form on a website. The information from the form has to go in the customer table in a database in MS Access.

    the information is going into the table perfectly. however, if i don't want a repeat of information and the system checks to see if the user is already in the database i get an error. it's either i get the error message "The user name you entered is already on file." all...
    See more | Go to post

  • i got the code to work by naming the columns in the INSERT INTO statement. Before, i had only named the VALUES fields and not the columns in the database. Also the autonumber field (CustomerID) had to be left out. So the query now would be:
    Code:
    INSERT INTO Customer [B](FirstName, LastName, Address ect...)   [/B] 
    VALUES('"FirstName.Text + "','" + LastName.Text + "','" + Address.Text ect..)
    See more | Go to post

    Leave a comment:


  • Inserting records into MS Access where there is an autonumber for a primary key

    Hi,

    I am creating an ecommerce website using Microsoft Visual Studio, VB.Net and MS Access 2003. I am new to VB.Net

    When someone wants to register on the website, they fill out a form and the contents of the form is inserted into the MS Access database.

    The Customer table in the database already has 30 records (with CustomerIDs 1 - 30) in it (from when the database was first created). The CustomerID...
    See more | Go to post
    Last edited by NeoPa; Aug 4 '08, 09:22 PM. Reason: Please use the [CODE] tags provided
No activity results to display
Show More
Working...