Using Microsoft Acres Database - Table Named Customer Info To Store Customer Details When Registering

Oct 5, 2011

A registeration sys using a Microsoft acres database I have a table named customer info to store customer details when registering and I need coding that will add the following to my table customer I'd , firstname, lastname , phonenumber and user also has to make selection between radio buttons male or female.

View 2 Replies


ADVERTISEMENT

Sql - How To Insert Customer Details Into Orders Table

May 4, 2012

I've got 6 hours left to finish a uni project. It's a basic database driven e-commerce site. I have a home page, a products page, an orders page, an order confirm page, a shopping cart page and a view current orders page. The site uses an Access database with three tables. A Customer table, with all of the customer details, (FirstName, LastName, EmailAdd, CardNo, CardEx, SortCode, DeliveryAdd, Postcode) A Products table, with all the product information, (ProductID, ProductName, Price, ProductType, Images, ProductDescription). And an Orders table which contains CustomerID and ProductID. I'm trying to create an INSERT statement on the orders page so that when the customer inserts their details and presses the submit button the customers table will have a new record inserted. I also want this to create an entry in the orders table and redirect the client to the order confirm page which will display the details of the order. Here is my code which runs when the submit button is clicked on the order form. EDIT I've fixed the error with the missing apostrophe. Attempting to insert using two sql commands as I've been told that access databases can't handle two at once. Still getting an error though.

Protected Sub btnAddRecord_Click(ByVal sender As Object, ByVal e As System.EventArgs)
Dim strFirstName As String

[Code].....

View 2 Replies

LINQ To SQL Query - Select Customer From Dropdownlist And Then Gridview - Load All Items Of All Orders Of That Customer

Oct 4, 2011

I have the following problem: I select a customer from a dropdownlist and then the gridview should load all items of all orders of that customer. I have the following query:

Dim allorders = From ord In db.Orders

Where ord.CustomerID = Convert.ToInt32(CustomerDropDownList.SelectedValue)

[CODE]..............

I also tried to modify the query as follows:

Dim orderitems = From oi In db.OrderItems

Where oi.OrderNumber = (From From ord In db.Orders

[CODE]...........

But this does not work. I just started using LINQ.

View 5 Replies

Autocomplete Customer Surnames Direct From The Customer Datatable?

Jan 5, 2010

I am trying to autocomplete customer surnames direct from the Customer Datatable, using the code below which I got from another thread, but nothing is happening.

[Code]...

View 6 Replies

Code A TryParse To Get The Input From Customer From A Textbox Named Strands And Convert It To A Number?

Oct 21, 2009

How would I code a TryParse to get the input from customer from a textbox named Strands and convert it to a number (this number will always be a whole complete number, cannot be 5.6 or 4 1/2 or whatever) then have that Strand number be muliplied by the selected item in my listbox1. This listbox has an access database bound to it with 2 columns Size and Area, the Size equals the Area and I set the Value to the Area column but set the Size to show up in the list box. and the Strands textbox has to muliply by the Size picked, but by the Area # not the Size #. And the results of that multiplication showing up in another textbox named total.

View 14 Replies

Design - Company --> Customer --> Orders (ignore The Details Of How The Orders Have Products Etc)

Mar 9, 2009

I have a scenario at hand which has some design discussion going on. To break it down in simple words, think about a hierarchy as such Company -----> Customer ------> Orders (ignore the details of how the orders have products etc) if I was to expose an API to work with this, what would be a better design.

a)
Dim comp As New Company
comp.GetInfo(123)
Dim cust As New Customer
cust.Name= "CustomerName"
comp.Add( cust)


b)
Dim custhand As Customerhandler
Dim cust As New Customer
cust.Name= "CustomerName"
custhand.AddCustomer(cust,123) ''123 is CompanyID

View 5 Replies

SQL Table Creation And Search For Specific Customer

Mar 15, 2012

I am making a booking app in vb.net and I am using sql server as my database. I am confused about table creation. I have increment of 1 in customerid which is primary key in customer table. Suppose if a customer books a room and according to the increment id"1" is assign to the 1st customer. Now after some days same customer again comes to the hotel and books for a room. Now this time a different id would be assign to the customer according the the increment may be id"125".

What to do if I want to search the customer for how many booking has he done so far. Because there would be different id's assigned to the same customer as every time he walks in to book a room different id would be assign to him. And suppose if I make surname as my primary key than may be other people will have the same surname. How to solve this search problem for a specific customer for all bookings he has done so far. And if i give a unique id to customer my self suppose "cust1" than every time customer walks in he has to remember his id.

View 3 Replies

Display All The Data Of CUSTOMER Database?

Nov 2, 2009

In my sales order i use one combo that is CUSTOMER, actually it display all the data of CUSTOMER database.

at run time in SALES ORDER i saw that the CUSTOMERis not available in that combo then i want to add new customer there which save in my CUSTOMER data base WITH OUT LOSSING WHT EVER I INSERT IN SALES ORDER.

View 1 Replies

Fetch The Address Of Each Customer From Database?

Aug 14, 2011

I am able to loop through all the customers in db but unable to fetch the address of customer to disply to the using using vb .net?

View 2 Replies

VS 2005 = How To Deliver Database To Customer

Dec 4, 2010

i have made a database using vb.net 2005 and SQL Server 2005, its completed now. how do i give to the customer in a full form, I mean as a professional software?

View 6 Replies

How To Run Database On Customer Side To Get Application Start Working

Jun 1, 2011

i have completed my application successfully and now i want to deploy it on the Customer End.How i can have to do this i have to install SQL Server 2005 on the Customers End and then have to create all the Tables and Views and Stored Procedures that SQL Server once again or is there anything else ???

if it is then its a big task coz i have about 12 tables and how i can get all the data stored in my Computer already of the Customer during testing...

View 7 Replies

Install Database On Customer Side To Get My Application Start Working?

Jun 1, 2011

i have completed my application successfully and now i want to deploy it on the Customer End...How i can have to do this ??i have to install SQL Server 2005 on the Customers End and then have to create all the Tables and Views and Stored Procedures that SQL Server once again or is there anything else ???if it is then its a big task coz i have about 12 tables and how i can get all the data stored in my Computer already of the Customer during testing... ?

View 4 Replies

VS 2008 - Use A Northwind Database To Display Customer And Order Information

Apr 20, 2011

I have to use a northwind database to display customer and order information. Populate a combo box with the CompanyName sorted in alphabetic order. Display the customer information in bound labels and the order information in a grid. For customers, display id,name,title,phone. For orders display the order id order date required date and shipped date. how to connect the access database file to vb.

View 3 Replies

How Much Car A Customer Can Afford

Jun 2, 2011

[code]A customer can not exceed a debt load of 36% of their gross monthly income including house rent or a mortgage.[code]I basically know how to code this. I get the information from the user (income, rent, and other monthly payments) and then ask if they have good, ok, or bad credit (this will be the percentage part) and I know mostly what to do, but the hardest part is the actuall coding part, basically the calculations part, im always confused on what to do, my example shows basically what to do and I know how to get the users info, but how to program the calculations, is where im also stuck at My example is (the money for the income, rent, and other monthly payments the user entered already)

1. If there monthly Income is:$2,000.00

2. Monthly Home Rent/Mortgage:$500.00

3. Other Monthly Payments (alimony, child support, student loans):$100.00

4. Then there allowable Monthly Car Payment:( 36% of 2,000 (income) = 720)( now I subtract debts 720 - 500 (rent) - 100 (other) = 120) :$120.00

5. Display Maximum Car Value (interest rate based on credit):Present Value Function (16% per year (this is where I check one of the boxes for the credit, which in this case its an ok credit), 6 years (I have to keep it at 6 years), 120 (this is the allowable monthly car payment) per month)So basically PV((0.16 / 12), (6 * 12), 120) : $5532.03.

View 5 Replies

Check If An Customer Number Is Already In Use?

Jun 4, 2011

im using a datagridview, and it is connected to ms access. every time i have an input same in the column where primary key is I already got an error. can you guys how to show a messagebox if the Customer Contact number is already in use? here is my code.

[Code]...

View 1 Replies

Display Customer Orders That Have Been Placed?

Jun 28, 2009

It's a basic Access database driven e-commerce site. I have a home page, a products page, an orders page, an order confirm page, a shopping cart page and a view current orders page. The site uses an Access database with three tables. A Customer table, with all of the customer details, (FirstName, LastName, EmailAdd, CardNo, CardEx, SortCode, DeliveryAdd, Postcode)A Products table, with all the product information, (ProductID, ProductName, Price, ProductType, Images, ProductDescription). And an Orders table which contains CustomerID and ProductID.I've managed to get the orders page to work, this leads to the order confirmation page which displays the details the customer just placed.Here is what I have in the order confirmation page load event so far. Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs)

[code]...

This returns this error "Syntax error in FROM clause." I'm guessing my SQL code is wrong. I noticed when I placed the order in the order page it added an entry in the Access database where the generated CustomerID was 12 on the customers table and 4 in the orders table. Shouldn't these numbers be the same when they are generated?

View 2 Replies

Example Of A Customer Binary Serializer In .Net?

Apr 14, 2011

So, I want to implement my own binary serialization. I'm looking for some examples to head me in the right direction.

View 2 Replies

How To Display Customer Orders That Have Been Placed

May 4, 2012

I have a home page, a products page, an orders page, an order confirm page, a shopping cart page and a view current orders page. The site uses an Access database with three tables. A Customer table, with all of the customer details, (FirstName, LastName, EmailAdd, CardNo, CardEx, SortCode, DeliveryAdd, Postcode)A Products table, with all the product information, (ProductID, ProductName, Price, ProductType, Images, ProductDescription).And an Orders table which contains CustomerID and ProductID.I've managed to get the orders page to work, this leads to the order confirmation page which displays the details the customer just placed.[code]This returns this error "Syntax error in FROM clause." I'm guessing my SQL code is wrong.I noticed when I placed the order in the order page it added an entry in the Access database where the generated CustomerID was 12 on the customers table and 4 in the orders table.

View 2 Replies

Inherit The Same Controls To The Next Customer?

Mar 25, 2009

i created a sales form and it is using currency also the project is working greatthe thing is when the form loads everything works great shows the decimal and dollar sign's for the first customer but when i click on the navigator for the next customer there is no decimal and dollar sign's how can i inherit the same controls to the next customer.

View 9 Replies

Query For Searching Customer ID?

Jan 20, 2011

I'm currently in the middle of attempting to create a query that will be used so that the application user will be able to search the a customers id number. I'm completely new to adding queries using the query builder so I've become slightly stuck on trying to get this to work corrently.

I have a database which is set up and in this case the table is called 'cid' which defines the customers id column in the database, this is a primary key and the column has a data type 'AutoNumber'. I've become stuck as I'm not sure what I would have to put into the filter to make this query work.

View 2 Replies

Report View With Customer Name

Dec 15, 2011

how to view report particular Customer Name. in this code when i m type from date or To date report is showing all customer information but i need single customer info with name or Date this is my code.

[Code]...

View 1 Replies

View Report With Customer Name?

Nov 15, 2011

[code]... i want to add CUSTOMER NAME in this code how to view each customer datewise

View 2 Replies

Adding Customer Information To An Array?

Nov 8, 2010

I'm trying to add 3 customers to an array that I can then display in 4 seperate text boxes on my form. First Name, Last Name, Account Number and Balance.

Public Class Customer
Private firstName As String
Private lastName As String
Private accountNo As Integer

[code]....

Error 2 Argument not specified for parameter 'account' of 'Public Sub New(first As String, last As String, account As Integer, balance As Decimal)'.

View 8 Replies

Calculate The Maximum Mortgage Possible For A Customer?

Dec 3, 2011

I have to calculate the maximum mortgage possible for a customer. If it is a single application, the customer can borrow up to three times their salary plus any savings and investments they may have.

If it is a joint application, the customer can borrow 3 times larger salary and 2 times the smallest, also borrowing against any savings and investments. In either case, the applicant is not allowed to borrow in excess of 90% of the purchase value of the property (including stamp duty and legal fees).

I have declared everything and done out the code, yet every time I calculate the max amount they can borrow, it comes up as 0. My code is below if anyone can spot problems.Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) _

[Code]...

View 2 Replies

Create A Customer Data Form

Nov 20, 2011

I working on a program that I am trying to create a customer data form.Along with the form I have their vehicles related to that record.Now I have setup a dataset in the form.I am pulling data from the database, however when I enter a new record on the customer part the customerID is in the running order, everything seems to be working on in this table.But when I create a vehicle for this customer I have a running vehicle id.Example: I have in the database 4 customers.IDs 1,2,3,4 customer 1 has vehicle ID1,2.customer 5 has a car there 1st car but the database gives is a ID of 3.I want this customer to ID 1 for car one.My problem might be because it was set in the database as Unique Identifier.Maybe I should make the license plate the unique identifier.

View 4 Replies

Create An Application That Queries Customer Name?

Jan 23, 2011

I am sure some of you have seen this project before. I need to create an application that queries customer name (first and last) and there addresses. I need more than that but once I figure what i am doing wrong with that, I should be able to figure out the rest on my own. I am using VS 2010. I can not figure out the proper syntax for String.Format. I can only get it to display the first and last names of the customers.This is the code I have so far:Public Class Form1

[Code]...

View 2 Replies

Customer Editable Resource Files?

Dec 10, 2010

I have an application that uses resource files (.resx) to switch the application between languages.These resource files are compiled at development time to create the dll'sHowever, there are many times when an application gets deployed onsite, and there are spelling mistakes, or general mistakes in the translated text.

View 1 Replies

Find Customer With A Beginning Letter?

Sep 10, 2009

I've done a customer register in a win form app. and I need to be able to search for a customer fast. If I have more than 100 customers I'd be spending all day to find the right customer by using the previous and next buttons, so I want to have a textbox and a search button. If I write for example just an "A", I want my program to show all customers beginning with an "A". If I write "AN" I want my program to show all customers beginning with "AN".

View 6 Replies

Forms :: Selecting Customer Id From Listbox?

Oct 19, 2010

Private Sub lvList_DoubleClick(ByVal sender As Object, ByVal e As System.EventArgs) Handles lvList.DoubleClick
'Select Customer ID from lvList
frmEdit.txtCustomerId.text = lvList.Select("Customer ID").value
End Sub

my code for selecting the customer id from my listbox doesn't work..

View 4 Replies

Online Chat Customer Care?

Sep 23, 2010

i m doing a project using vb .net visual studio2005 . i need to develop a online chat application on my website for customer care supports. where i should start and which technology i should use for this web based application..

View 1 Replies







Copyrights 2005-15 www.BigResource.com, All rights reserved