Newbie Needs To Find Out How To Remove Autonumber From Access Customer Order Template

May 19, 2006

I am trying to use the template provided in the Access database wizards, pages and projects. Its called Order Entry. What i would like to do is edit the template to fit my needs but i need to change the Product ID feild from Autonumber to a product id of my own. I would however like to keep it as the Key.

Any Suggestions?

Mulith

View Replies


ADVERTISEMENT

Newbie Needs To Find Out How To Remove Autonumber From Access Customer Order Template

May 19, 2006

I am trying to use the template provided in the Access database wizards, pages and projects. Its called Order Entry. What i would like to do is edit the template to fit my needs but i need to change the Product ID feild from Autonumber to a product id of my own. I would however like to keep it as the Key.

Any Suggestions?

Mulith

View 1 Replies View Related

Newbie On Retrieving Autonumber From Access

Jun 10, 2005

Hi all, I am new to working with databases. My question is, how do you retrieve the autonumber ID of a field for a row just inserted into a database.

I have read numerous threads/articles, but none give me a clear picture of what the code actually looks like, just pieces(which is like greek to me). Could somebody tell me where I can see a working example of the code?

Thanks,
Mike

View 3 Replies View Related

Access Newbie Needs Help! With Charts And Data Order

Apr 6, 2008

Hi, okay completely new to access. I'm trying to create a chart based on a query with 1 record 8 fields. I can not figure out a way to rearrange the data into two fields 8 records.

The background is I have a hundred units, each with 8 wheels. I have a table with the following fields.
-Unit part number
-Diameter of wheel 1
-Diameter of wheel 2
-Diameter of wheel 3
-Diameter of wheel 4
-Diameter of wheel 5
-Diameter of wheel 6
-Diameter of wheel 7
-Diameter of wheel 8

So, the query tells me how many wheel diameters between a certain range, with the following fields:
- Diameter >530
- 530> Diameter >540
- 540> Diameter >550
- 550> Diameter >560
- 560> Diameter >570
- 570> Diameter >580
- 580> Diameter >590
- 590> Diameter >600

Now I want to plot the range on the x axis and # wheels in that range on the y axis of a bar chart.

Any suggestions on how I can achieve this? How do I create the diameter range as a record rather than a field?

Many thanks!!!

View 4 Replies View Related

Newbie (collection Template Needed)

Apr 29, 2006

Hello all
As i say i know asolutely nothing in regard to access
other than it is a data base.
I was just looking for some way of keeping track of my videos cd's and dvd's
Am guessing that this program might be the go.
At this stage i am in no need of much more, so am just looking for a templete
or tutorial on how to create one such template if anyone could direct me to a video tutorial that would be great as i learn a lot quicker watching how it's done. Yeh i know I'm lazy and don't like to read Nah really it sinks in quicker
if i see it done.
Thanks Guys/Ladies

View 3 Replies View Related

Order Entry Template

Mar 24, 2008

How do I find the order entry template that came with the 2003 version?

I have the new vista and it is not there. I cannot find it anywhere.

David

View 2 Replies View Related

General :: Create Check On A Field (customer ID) Of Customer Table In MS Access?

Sep 7, 2012

create a check on a feild(customer id) of customer table in MS Access , as "Customer ID is of 8 characters, the first 4 are alphabets and the last 4 are digits"

View 6 Replies View Related

General :: Remove Customer From List But Keep All Related Info

Sep 26, 2012

Let's say I have a list of customers. For each customer I have much more info on other lists (order list, personal info list, bank info list, and so on) - all are of course connected properly.

Now let's say a certain customer is no longer my customer, so I want to remove him from the customer-list. But, I want to move him to a different list - past-customers - so all the information that was related to that customer will remain so. In short, I want to remove from the customer-list without affecting the related data.

View 4 Replies View Related

Tables :: Autonumber / Customer Reference Field?

Sep 30, 2014

use an account reference from one field in a table on a second table and add a number after it... e.g.

Table 1 Table 2
PEFA PEFA/001
PEFA PEFA/002
PEFA PEFA/003
PEFA PEFA/004

and so on...

View 2 Replies View Related

Order Entry / Stock Control Template Db

Jan 5, 2006

I have to provide a Quote/Order/Invoice and stock control system very quickly for one of our satellite offices, and wondered if anyone knew of any "boilerplate" databases that have done all the grunt work, so that I can just edit reports and forms etc to get them up and running. We are happy to pay a (modest) fee for this service, but would expect to get full access to the design/code for later development and customisation if required.

I've tried Googling but get page after page of rubbish !! Any pointers would be gratefully recieved.

Thanks and Regards

Richard Keith

View 3 Replies View Related

Should Be Easy For Someone - Show Only Last Customer Order, By Date?

Feb 22, 2006

Hi all, i have a query which will be used for reports, and only the last order placed by a customer is needed to be shown. Here's the table used in the query:-

tblCustomerPurchases
CustomerNumber
PurchaseNumber - PK,Autonumber
DateOfPurchase
SeasonID
TotalCost

So obviously for one customer there can be several orders, but i just want to show the latest one by the date field. I have tried grouping by the date field on both Last and Max, but with all the other fields from the table in the query (i need to have all the fields from the table for the report by the way) it still shows all the orders for a customer.

If i only include the customernumber field and dateofpurchase field and then group by date i have 4923 records, which is the correct amount, only one order per customer (the latest one) but adding any other fields to the query gives me the full 7000 odd orders (several per customer).

Any help would be much appreciated, many thanks in advance.

View 9 Replies View Related

Tables :: Generate New Order ID For Same Customer In Orders Table?

Oct 3, 2012

how do i get form to generate a new order ID for the same customer in my orders table

View 2 Replies View Related

General :: Use Drop Down Control In Service Order To Select Customer

Mar 1, 2014

I have a client table.
I have a client product table for ski's
Each Client has 1 or more products (skis)

I have a Service Order table and form that I use a drop down control in the Service order to select the customer.In the Service Order Form a I have a continuous Subform for detailed service.

This is where I'm having the problem.In the detail subform I want to select from a drop down box the customers particular ski that I want to service. how to have only that one customers ski's to show up.

View 14 Replies View Related

Newbie Needs AutoNumber Help

Oct 7, 2006

I am trying to change my autonumber field to start at 2000500 for a workorder ID instead of 1. I have read the instructions but still don't sem to understand. Can someone give a more detailed set of instructions than is currently in the online access help?

View 3 Replies View Related

Queries :: How To Find 1st Date Customer Used

Dec 2, 2014

I have a database with 8 years of info on customers orders. I need to find out when each customer first used our services.

View 8 Replies View Related

Jumping Of Autonumber In A Non Ascending Order

Jan 5, 2005

Hello,

I have a simple invoice database with a primary key in the main table (with autonumber as invoice no.) and a subform with the item details which is without a primary key with the data type as numbers. In addition, I had the tables linked as one to many relationship. What happen is that when I am entering the data, the number jumps . For eg: It was suppose to be 7123 but the next entry was 7150. Pls kindly advice.

View 3 Replies View Related

General :: Using Autonumber As Order Number

Aug 13, 2015

i am going to use the autonumber as an order number but I want " SC2015 in front of it so i end up with " sc20151 , sc20152 but next year i want it to change the year SC201650 .how to put the sc2015 in my report without any input from the user

View 2 Replies View Related

Tables :: Autonumber Sorting Out In Order

Sep 2, 2013

I am creating a database for cases. I want to set autonumber into sequence, Let say if there are data numbering 1,2,3,4,5. If I delete no.2, The data will rearrange in oreder from 1,2,3,4. While If I add a new value it would be the no.5.

Instead of data value autonumber 1,2,3,4,5 as I deleted no.2 and add new records. The data has become 1,3,4,5,6.

View 1 Replies View Related

Autonumber Interfering With Sort Order In Report...?

Nov 16, 2005

Need help pls

I'm designing a report that should be sorted by field A, B, C, D, or a combination of BD or CD.

Problem is (it seems) the report ignores the sort order and lists the results in ascending order of the autonumber field - 1,2,3,4,5 etc.

The reports run off queries and the queries work fine - they sort the fields in the proper order.

Is the autonumbering somehow interfering with the sort order in the report?

HELP!!!

View 1 Replies View Related

Tables :: Autonumber Order In Existing Table

Jul 9, 2015

I was adding an autonumber field to an existing table and I assumed the numbering would follow the order of the primary key but that doesn't seem to be the case.

View 9 Replies View Related

Queries :: Sort Order In Query Based On ID (Autonumber)

Sep 10, 2013

This is something I occasionally see in Access and has been bugging me for quite a while.

As an example, when I have a table (all text fields except for the ID field which is an Autonumber with a unique index - ie just what Access creates when you import data) and I try to make a new table from a query by indexing the Autonumber field in descending order (ie to reverse the order of the table), it doesn't work properly.

So if I have:

SELECT [mytable].* INTO [mytable sorted] FROM [mytable] ORDER BY [mytable].[ID] DESC;

When I preview the data (ie run the select query to have a look at it), it looks fine.

When I change the query to a 'Make Table' and I then I check the table it makes, the order changes part-way down the list, so looking at the ID field it runs from number 2669 down to 2087 correctly, then it goes from 1960 to 1956, then 1803 to 1799, then 1751 to 1747, etc etc etc. After a while it seems to correct itself again, and orders normally down to #1

I'm using Access 2002.

View 5 Replies View Related

Queries :: Find Duplicates From 2 Tables And Remove From 1 Table

Jun 29, 2014

I have a report with 2 access tables (1 Master table and another a daily feed table)

The Master table keeps a log of all incoming records. (once append it to this table, should not show in future reporting)

The Daily feed information within the last 48 hours. (uploaded from an excel report into access temporary table)

When the daily feed table gets completed, I append the records and updated them into the Master to avoid duplication.

When I upload the daily feed table and I match it against the Master table to find duplicates, how can I delete the duplicates from the Daily Feed table?

This is my code to find duplicates:

SELECT CMPreport.ID, CMPreport.MbrName, tblMaster.ID
FROM CMPreport LEFT JOIN tblMaster ON CMPreport.ID = tblMaster.ID
WHERE (((tblMaster.ID) Is Not Null));

View 9 Replies View Related

Queries :: Find Cost At Time Of Order?

Jan 27, 2014

I have stored the costs in my database with a date they apply from so I have a series of costs which I can then refer back to using the order date to see what cost I should use at any one time. My table structure is as follows:

Code:

tblExtruderCosts
ExtruderID PK - identifies the extruder
FinishID FK - identifies the finish
Cost - the cost for that finish from that extruder
DateFrom - the date the cost applies from
tblExtHead
ID PK
ExtruderID FK
FinishID FK
Orderdate

View 5 Replies View Related

Add Customer Name Into Table Each Time Unique Customer Added To SaleTable

Dec 11, 2013

I have a Table Sales - that lists customer and order information

Most of the customers are new - is there a way to populate Customer Name Table with a new entry each time a new customer is input into the Sales Tale

(Without having to add the custome to Customer Name Table - then going to Sales Order)
OR
Failing that - is there a way to use a list box that points to Customer Name Table (and if it doesn't find the one you want, will allow you toadd a new record) In the SAME form as you use to add to Sales Table.

So:
Date (textbox linking to form.Sales) Customer Name (List Box linking to form.CustomerName + adding the info to form.Sale)

View 6 Replies View Related

Combining Customer And Customer Contact Tables

Dec 24, 2011

I have a DB set up with a debtors table (Customers) and a Customer Contacts table, I was thinking of combining these two tables into one.Most of the Debtors are companies, but a few are actual people. With the current setup, i need to have both a debtor and a customer in two different tables, but with exactly the same data.

View 1 Replies View Related

Accessing An Outlook Template From Access

Nov 15, 2005

Hi there,

I am not the best in Access, I will admit. But need a function to open up a MS Outlook template (.oft file) within Access which is hosted on an internal server. Anyone help with quick steps on how to do this, It would be greatly apprciated.

View 4 Replies View Related







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