Numbering Starting At 4000

Feb 20, 2007

I have a form to enter RMA data. I need to start my numbering at 4000 without using an autonumber. The ID field is text and cannot be changed. The Customer_Order table is a linked table. A letter is going to be added infront of the ID depending what the user chooses from a combobox. The letter(R,A,C) signifies what type of transaction it is. Here is an example -

R4000
A4001
A4002

Currently there are about 100,000 records in the database but none with an ID between 4000 and 10000. The majority of the records have a letter preceeding the number. Any ideas on how to start numbering at 4000?

View Replies


ADVERTISEMENT

Percent Won't Change From 4000!!!???

Jul 16, 2007

I have set a field in table to be a 'percent' However, try as I might am unable to type in 40 and get 40%

I seem to get either 4000% or 0. I have tried differing settings.

Has anybody else had this trouble and could offer some advice?

Thanks :confused:

View 5 Replies View Related

Starting Over

Dec 28, 2005

i just had a good talking to. My boss was expecting to show him alot more than I did. Please help me if you can.

I work for a hard drive company. Harddrives are divided up into categories and sub categories. The highest level is "Family." Next is "Model Number," then the lowest is "Product Number." All of these are included in each of the worksheets and they all have different heading names.

The hard drives are stored in many different warehouses that are potentially in 3 different regions (AMERICAS, ASIA, EUROPE)

I am concerned with three excel worksheets that contain all or some of the fields listed above. The different worksheets represent different states of the hard drive: "InTransit" "Customer Shipments" and "Inter Company Shipments"

The goal is to consolidate all of this information into one worksheet.

The other 3 Worksheets represent the data I am pulling from. Ive written a module in access to import all of the excel files into their own individual tables. I've also written some queries to pull the info i need, im stumped though, I'm feeling like I should wipe the slate and start from scratch.
What is the best way to go about this?

View 10 Replies View Related

Starting Point For Db.

Jul 27, 2005

Hi All.
This may be a bit of a strange one, but was wondering if anyone had any ideas.
I would like to create a db which is a bit like the directions bit of multimap.co.uk

As per the attached jpg, i would like a db so I can input a starting box and end box, and it would tell me the shortest distance, longest distance, route via boxes etc.

e.g
Box A as start and Box F as end. Shortest route is via Box D, longest route via boxes B and C etc.

The db would obviously not for measuring distances between boxes!!!....but thought this may explain it.

Does anyone have any ideas?

Thanks for taking the time to read this.

Frank.

View 5 Replies View Related

Starting New Database

Mar 30, 2008

I am new in this and would appreciate any help.
Here is what i have to do.Have 2 tables ,employees and equipment.
People form table1 are signing for equipment from table2.After certain time they turn that equipment and some1 else is getting it.
Should i make 3rd table with only signin and signout dates or something else?

View 1 Replies View Related

Starting Letter

Jun 15, 2005

I want a criteris in access to get the records having field 2 starting with "num". Num is example. I want to do withdifferent letters.

number
numbiur
numg
numds

the first three letter should be num in this example. i want for different words i.e, i need to enter the paramter message box.

View 2 Replies View Related

Starting A Field With A Zero

Sep 13, 2007

Now I know this has probably been asked before, but the search function filters out the word "zero" and "0", so I couldn't do much good with that.

What I want to know is; how do I start a field with a 0 in Microsoft Access?

This has been annoying me, as my database requires phone numbers which start with a 0, and it has been removing the 0 from every entry.

Thanks in advance.

Edit: Oh darn, I seem to have posted this in the wrong forum. Sorry for any inconvenience.

View 2 Replies View Related

Just Starting With Forms

Aug 25, 2005

Background:
I have the foloowing tables
tblClient:
ClientID (PK)
ClientName
other client details

tblMachine:
MachineID (pk)
SerialNumber
ClientID (fk to tblClient)
other machine details

tblProduct
ProductID (PK)
ProductName

tblReadout:
year_date
month_date(pk fld1)
day_date(pk fld2)
ProductID(fk to tblProduct)
MachineID(fk to tblMachine)
ReadoutAmount

Question:
I would like to build some kind of a form where the user will be able to enter data for readouts (ProductID, MachineID, readoutAmount, year_date, month_date, day_date), but I would like them to only be able to do that, I mean I do not want them to be able to modify any of the other data in the table or even see it, so only adding a record that is it.
Also I would like them to be able to enter the ProductName instead of ProductID , how do I go around that ?

View 1 Replies View Related

Starting In Subform

Mar 8, 2006

I made a form (My_form) with subform (sub_form) and when open main form cursor is in the first (tab = 0) field of the main form, but I want that it is in the first (or desired - for example Name) field of the new record of subform .

How can I do this?
Thanks.

View 1 Replies View Related

Starting Autonumber Higher Than 0

May 18, 2005

Hi,

I want to use an incremental number as a reference for records in a database. No probs, I use an autonumber. But the user wants the reference to start from 275.

Does anybody know how to start an autonumber off from a higher number (eg 275), without first creating and deleting 274 records. Is there an easy way of doing it.

Or should I not be using autonumber for this, but rather some other wizzy method which somebody is prepared to show me.

Thanks,
Adam.

View 3 Replies View Related

OK, I'm Starting Over - DB Basic Help Needed

Oct 2, 2005

Hi
I posted a thread in the tables section but two things have made me decide to try again.
1) No one answered my Question
2) I Asked my question in a way that was VERY confusing.

So I'm trying again here. I have a DB that will be used for invoicing clients. Some of the data is variable between jobs, clients & vice versa. Some of the data is recurring.

I have several tables that I need to link. They hold information that is labourious to enter over & over in a spreadsheet so I thought a database would be the answer.

One table is called tbl_Consumables
This table has data which varies from time to time but not all data is changed (IE the price of an item may change from month to month. This presents a problem because if I use a table to store the consumables data & the table is linked to an invoice via the ConsumablesID field I can't change any of the consumables data without changing past invoices that should show the old price not the new price.

Basically I can get my head around how the basic design should be set up. I have two main problems.
A) Trying to link a days work to an invoice & be able to change data in the future without affecting past invoices and,
B) I don't know how to set up the relationships & tables so info is linked.

I have a copy of the DB here. The tables are only minimal fields & data at the moment as I don't want to go to all the trouble of setting this up & then having to change everything.

Thanks in advance.
Regards
Mik

View 10 Replies View Related

Starting Access At The Last Record Instead

Mar 23, 2005

When you start access it usually starts at the beginning of the file. How can I make it start at the last entry?

View 1 Replies View Related

How To Get Data With A Starting Letter.

Jun 14, 2005

I want a criteris in access to get the records having field2 starting with "num".

number
numbiur
numg
numds
the first three letter should be num

View 1 Replies View Related

Week Starting ? Criteria

Feb 16, 2006

Want to use criteria in a date field to query data a week at a time. Open the query and have it ask for week starting MM/DD.
Date input will normally use the Monday of each week and expect data back for Monday through Sunday

View 1 Replies View Related

Week Starting With The Date ######

Mar 29, 2007

Ok,

I am making a database which has a set of lessons which have been booked for a particular date.

What I want to do is be able to have a pop-up box ask you for a date for the start of the week. e.g. I want to find lessons from the week starting 02/03/2007 for 1 week (e.g. 2nd - 9th), so I type in the box "02/03/2007" and it comes up with records from that week.

I have tried this in the criteria box:
[Enter date]+7
and
=Date([Enter Date])+7

But nothing works. Also, I decided to add a record with todays date, and then use the criteria =Date(), but that didnt work either!!!!

Help would be greatly apprecated :p

Thanks
Michael

View 3 Replies View Related

Changing The Starting Number Of The Autonumber

Apr 7, 2007

I have a table with a compound key, and one of the two fields in the compound key has to start at 100 and finish at 999 and I'd like it so that each number didn't have to be typed in individually.

So I thought about using an autonumber that somehow starts at 100 but doesn't go over 999 if thats possible? Or if you have any other ideas on how I could achieve this?
Thanks

View 1 Replies View Related

Searching A Recordset Starting From The Last Record To The First

Apr 23, 2008

First I will open a form and choose a salesman. Then based on the salesman selected I want to open a recordset and start searching for the last record for the salesman selected. When the record is found some of the information from that record is pulled on the form.

View 9 Replies View Related

How To Select Records Starting From Number?

Dec 2, 2005

Hi!
Can anyone help me how to create query selecting only the records starting with the numbers?

Thanks a lot in Advance

View 1 Replies View Related

Forms Created From Starting A New Switchboard

May 13, 2006

This is probably elementary, but I'm entirely lost. Here's my issue:As most of you probably know, when first creating a switchboard in a database will automatically create a form based on it.Somehow I managed to delete that form, and have no idea how to make a new one with the same default switchboard format (where command buttons are automatically generated, and there's a default title label with the shadow effect, etc.)I thought I might try to just delete the switchboard and create a new one so that another form would be created, but it won't let me delete the switchboard!If I understand correctly, I have to create a switchboard without any other switchboards already existing for Access to create a related form for me. Any suggestions?

View 6 Replies View Related

Changing The Starting Number Of An Autonumber?

Apr 7, 2007

I have a table with a compound key, and one of the two fields in the compound key has to start at 100 and finish at 999 and I'd like it so that each number didn't have to be typed in individually.

So I thought about using an autonumber that somehow starts at 100 but doesn't go over 999 if thats possible? Or if you have any other ideas on how I could achieve this?
Thanks

View 1 Replies View Related

Tables :: Starting With A 0 In A Number Field?

Mar 23, 2015

I have a field to record the last 4 digits of a credit card number in regards to tracking payment information.

The field is currently formatted as a Number field. When I try to enter a set of 4 numbers that start with "0" (e.g. 0123), Access removes the 0 from the start automatically (so 0123 becomes 123).

That function makes perfect sense under normal circumstances, but in this case I want to be able to keep the 0 at the beginning because it is part of the 4 digit sequence.

View 5 Replies View Related

Modules & VBA :: Why RecordSet Not Starting From Record 1

Sep 1, 2014

Why my Recordset start from record # 301 instead of # 1 Here's part of my code:

Set db2 = CurrentDb
Set rst2 = db2.OpenRecordset(strTable2)
If rst2.RecordCount = 0 Then
MsgBox "No records to process."

[Code] ....

Table has 12,000 records and the first record has an ID of 1. So why is it starting from the record 301? What am I doing wrong?

View 3 Replies View Related

Block Shift Button When Starting Up Application

Apr 27, 2006

Hi, in some application I have made using a switchboard after starting up, I saw that when the user holds the shift button, this switchboard does not show up automatically. How can i fix it that the user cannot interfere holding this button?

View 2 Replies View Related

Error Message While Starting Up Packaged Solution

Jan 30, 2008

Hello,

I made an application in access 2007 wich runs perfectly on my computer.
But when I package it and distribute it to a user he gets the following error message on opening:

"A potential security concern has been identified

Warning: It is not possible to determine that this content came from a thrustworthy source. You should leave this content disabled unless the content provides critical functionalitiy and you trust the source.

Filepath C:/program ....../myapplication.accdr

this file might contain unsafe content that could harm your computer. Do you want to open this file or cancel the operation?"

I have set the security level for macros tot enable all.

View 2 Replies View Related

Wizard Not Starting When Command Button Is Placed In A Form

Aug 9, 2005

in access 2003 i am not able to get the wizard to start. as per MS KB site the wizards are diaslabled due to security risk and i have to installed KB patch 829558 still unable to get the wizard to come on. anbody having same problem pleeese help

sekra1959

View 2 Replies View Related

Content Source Help (probably Easy But Im Just Starting Access)

Aug 8, 2006

Im just starting to use access for a small business. Im fluent in visual basic but i cannot seem to get this to work. so im using the wizard for the "Order Entry" and it works great. However, on the Preview Invoice where you can also print it, i would like it to include the credit card number, payment method, experiation date, ect. which all can be found on the payment form for the order. I have a text box but i cannot seem to get the write content source. what would be the content source so it can access the payment details from the other form and print it along with the invoice.

View 1 Replies View Related







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