Custom Autonumber

Mar 29, 2005

I am in the process of developing a DB for work. The DB is used to track incident reports and lost/found property reports.

I was interested in using 2 custom autonumbers for 2 different reports within the same DB. I would like to use the format of "I" for an incident report, "F" for the found property reports. So when I start a new Incident report it would generate the following number; "I05-03-001" The "I" specifing that it is an incident report, "05" for the current year, "03" for the current month, and "001 as the next sequential number for the reports for that month.

Does anyone have any suggestions on how I can get this done? I would very much appreciate your help.

John

View Replies

How Do I Create A Custom Autonumber

Mar 2, 2005

I currently have a few tables that use an autonumber as the primary key, however, I would like the autonumber to start with a series of letters if possible. For example: instead of it creating an ID of 1, then, 2, 3, 4, and so on, I would like it to append lets say "ABC" to the front of it; ABC1, ABC2, ABC3, etc.

AP

View 2 Replies View Related

Primary Key...Autonumber Or Custom?

Jul 10, 2005

Just a general question...
When you make a primary key is it better to use and Autonumber or a Custom one? I have for the most part used auto...easy, convienient and well I have never had a problem yet (been pretty serious on Access for about 1 year). But I just read that ref integ doesn't work on Autonumbers? which would also mean cascading update & deleting correct?
I have looked at Northwind Access sample and all except "Customer" they use Auto. Well then to make a custom Primary field wouldn't I have to do that at the form level? like "CustomPrimKey = Left([CustFirstName],2 & Left([CustLastName],2) & [PriKeySetAtAutoNum]" or something like that to get what I want. I imagine you would automate this as opposed to letting the operator manually enter them.
And then as in the Northwind sample how do you know which tables need the custom numbering and which ones don't.
As I have learned on my own some of the "basics" elude me until they come back to bite me.

Thanks

View 10 Replies View Related

Bounded And Translated Custom Autonumber

Nov 2, 2005

I was hoping to run this by you guys to see if I'm doing anything horribly wrong. I have done a number of searches related to custom Autonumbers and I think this is okay but any suggestions/confirmations would be greatly appreciated.

I want to create a random Primary Key that will also be used as an item #. I know that in many cases this is frowned upon *but* I do not need the number to hold any significance I just want it to be unique. However I want to represent the item # as a set of 6 Hex digits so the standard Long Integer is too large. 16^6 = 16777216. No 0 index so 16777215.

I create my own bounded number with a macro (=Int(Rand(16777216-1))+1 )and put that as the default value. It is indexed and set to no duplicates. Is this correct?

When I display the field in a form or report I call a module which translates the number into Hex and appends leading zeros. I am currently having a problem where inserting a new record does not display the translated index correctly, but after it has been inserted it is fine.

If you have any comments or suggestions about how this could work even better (or if this wont work at all!) please let me know.

View 2 Replies View Related

Custom Autonumber Based On Lookup

Jul 8, 2013

Custom Autonumber based on lookup. I am creating an access database where autonumbers to be work.

I have a table with Segment Name my main table will lookup the values of segment table.

Based on the Segment I choose Autonumber has to be created

My main table to house each record (tbl_import) has the following fields:

ID
Segment
Port
MOT
TOTAL CIF

Child table - Segment contains
Development
Deployment

Testing

So based on segment field which I choose

Development autonumber has to set DEV-1001 and Deployment has to set DEP-2001, TEST-3001

My thought is if there a way to code the Segment field to lookup the segment what I choose based on the Autonumber series starts (similar to a vlookup in excel), then concatenate the DEV in the Record ID field.

View 2 Replies View Related

Forms :: Custom Autonumber With Year And Month

Aug 12, 2013

I need to create an "autonumber" field in the following format:

FYYMMXX

Where F is a constant, YY is the year, MM is the month, and XX is an incremented number. So for example, the first record in August of 2013 would be "F130801".

I've been checking other threads but haven't been able to follow them to a resolution. I think there is a way to do this within my form...

View 3 Replies View Related

Controlling Autonumber Field - Start Autonumber From 1 Everyday (Composite Key)

Nov 21, 2013

I have two tables linked to each other in one to many relationship. Instead of auto number, the date and shift (Text) is being used as the primary keys (Composite Primary Key). Here is the tables structures,

Payouts Table:
Date: Primary Key
Shift (Day or Night) : Primary Key

Bills Table:
Date: Primary Key
Shift (Day or Night): Primary Key
Autonumber: Primary Key

The tables Payouts and Bills has one to many relationship. One payout row can have many bills. The problem is that I want to start the Autonumber in bills table everyday from 1. As date and shift are different for every day so even if i start bills from 1 everyday, it wont make same primary key. I can do it manually but I want to make it automatically.

View 4 Replies View Related

Custom Toolbar

Mar 29, 2006

HI all, I have recently created my own custom toolbar for my database which works fine on my computer, but when the database is transfered to another computer via a memory stick (needs to be done as it is going to be used on remote laptops away from the main network), the custom toolbar does not carry over. Instead of the custom toolbar being shown, the normal, main toolbars are reset to the default ones shown.

Is there a way of stopping the toolbars reseting when transfering the database so that my custom toolbar is the default toolbar?

Thanks for the help!

View 1 Replies View Related

Custom Toolbar

Jul 13, 2006

I have a custom toolbar in my application. However, it isn't visible at the top of the application window and when I try to make it so - via View - Toolbars - it doesn't appear on the list of available bars.

I had assumed that I had somehow deleted it, but I know it's still present somewhere, as when I try to recreate it, I get a message saying so.

How can I get the toolbar to be displayed? :confused:

View 8 Replies View Related

How Do I Create A Custom Msg Box

Jan 1, 2007

I have a database for call outs, i had a problem with double booking, but cured that, my problem now is every time my work mates try to book me in that go into the debug box (accidently) all i need is a ok button only msgbox to say the time is already booked. can anyone plaease help.

here is my db if any one want to have a look

View 2 Replies View Related

Custom Help File

Feb 13, 2007

Hi all. I have tried searches on here and via google but can't find a difinitive answer to my question. What i would like to do is create a custom help file that will run when the user requests it. I know there is a property option to set a custom help file within a form but i am unsure of the correct process to do this to get it working.

Could someone please help me understand what needs to be done.

Thanks in advance.

View 2 Replies View Related

Custom Toolbar

Mar 6, 2007

Hi folks:

when I create a custom toolbar on my db, would that custom toolbar be carried to other copies of my db? I'm hiding all toolbars using code and I need to display only one.

thanks

View 1 Replies View Related

Custom Menus

Oct 25, 2007

Since the introduction of 2003 when you create a custom menu you always get the 'Type in a question for help' tag and the min max close buttons. Is there any way of removing them or disabling them?
:confused:

View 1 Replies View Related

Custom Autonumbers.

Jun 17, 2006

I would like to create a custom autonumber to use as my primary key in one of my tables in my database.

I would like my records to be displayed as such C000001 , C000002 and so forth. Does anyone know how todo this?

Thanks in advance.

View 1 Replies View Related

Custom Relationship - Need Help!

Jul 31, 2006

Hello, I am trying to set up a relatively simple relationship between numeric fields in two (already related) tables. The problem is Access doesn't really support this type of relationship... or in fact, doesn't have an interface for coding your own custom relationships (if it had one, this would be ridiculously easy).

But it doesn't. So I have to turn to you.

To explain my problem better, I'll use a visual aid.

http://img269.imageshack.us/img269/9123/db1zx2.jpg

My two tables are as follows, the master is called [Raw Materials] and details is called [Raw Materials Details] (the aptly named).

I guess I should rename the [Raw Materials].[Stock] to something else (as this isn't REALLY data redundancy). But anyway, what I want to do is have the [Raw Materials].[Stock] automatically equal to Sum(Stock) FROM [Raw Materials Details].[Stock]. To rephrase, I want the Total Stock field to be automatically equal the sum of corresponding stocks.

Either way, I have no idea how to go about doing this. Can anyone point me in the right direction?

View 14 Replies View Related

Help Again With Custom Query

Aug 27, 2005

Hi all,

I cant make work, a query with creteria filled within controls of a form. I will be more specific to make u understand what i want to ask.
There are 2 text fields and 2 combo boxes. All of them call a report (by pressing a button) from the main table.
in the "totalquery" query i call each control this way:

select tblPeople.name,tblPeople.tel,tblPeople.age,tblPeop le.Car from tblPeople where tblPeople.Name=[forms]![frmMyform]![combo1] OR tblPeople.tel=[forms]![frmMyform]![text1field] OR tblPeople.age=[forms]![frmMyform]![text2field] OR tblPeople.Car=[forms]![frmMyform]![combo2]
GROUP BY tblPeople.name,tblPeople.tel,tblPeople.age,tblPeop le.Car;

I want to make it display (the right) results if one of the text filed/combo is filled or with data, or all together or in combinations.
i use the OR statement,but it doesnt work if I fill in two fields/combos together and etc.
Anyone? :rolleyes:

View 4 Replies View Related

Custom Queries

Sep 12, 2007

Hello all!

Basically what I am wanting to know is how difficult is it going to be to do the following.

I want to have 8 searchable fields, first name, last name, MO, Job code, etc etc. I want to be able to type somthing in any one of these fields and then when i hit a submit button I want to to return to me all the data that corresponds to what I am looking for. I know I could just create a simple query from the query wizard but i want everything in the program to look uniform as to not throw every one off. How difficult would this be and how should I go about doing it. If you need more information let me know.

View 2 Replies View Related

Custom Order By?

Oct 17, 2007

Wondering if it is possible to order by particular values??

That is I have a column (varchar) named "Status" with values such as; Entered, Active, Completed etc (I didnt design the DB).

What I need is to order by Entered, then by Active then Completed etc.. Is this possible??

Ive got this code for SQL; but it doesnt work in Access (03)..

ORDER BY

CASE Status

WHEN 'Entered' THEN 0

WHEN 'Active' THEN 1

WHEN 'Completed' THEN 2

ELSE 3 END, Status

View 2 Replies View Related

Custom Tab Order

Oct 27, 2005

I have a form with tab pages which I can not change the tab order.
When I bring up the Tab Order box no fields are displayed only a Custom Tab Order! Never seen this before.
Question is how to get rid of this and be able to change tab orders.

Thanks

View 2 Replies View Related

Custom Button

Jan 16, 2006

I'm just creating my first db. When I'm on a form looking at a previous record (in this case a transaction), I need to be able to make a minor change to that record (such as the date for a repeat transaction), and then save the record as a whole new record. The button commands I found in the wizards only let me save over the current recond after an edit. Anyone know the easiest way to creaet a command button that does this? Thanks for any insights.

View 3 Replies View Related

Custom Yes/no Textbox

Dec 22, 2006

I trying to setup a custom yes/no.

In the table I set the yes/no format "Made";"Recieved" � lookup 'text box'

I made the form and in the textbox and did value list with made and recieved. but it's giving me the could be text when number should be used and vise versa thing.

View 2 Replies View Related

Custom Toolbars

Mar 8, 2005

i must be overlooking something obvious, but....

how in the world do you put in the little gray separators in a custom toolbar? you know, to keep similar buttons in logical 'groups' on the toolbar...

View 1 Replies View Related

Custom Menu

Apr 6, 2005

I have a custom menu on my db, but when another user logs on they have the same toolbar buttons and the same menu but more items that I have originally added. Is there a way to fix this?

View 9 Replies View Related

Custom Search??

Jun 3, 2005

I am currently creating a new part of my database which will enable users to store data for Storage Job which we do. the form has a number of fields called "pallet ref1 / pallet ref2" etc. now when the customer phones up and gives the pallet reference number, the user will need to search these fields to find out where in the warehouse the pallets are stored. But i want to create a search that will only search fields "pallet ref1 / pallet ref2" so that it will not have to search all the feilds within each record.

ne help would b appreciated

View 3 Replies View Related

Custom Menu Bar

Jul 21, 2005

I asked a similar question some time ago, but the answer I got didn't help out a whole lot. Maybe someone else could help me out here. I have a split db which resides on our server. This will soon be joined with MySQL so that multiple users can log on simultaneously. I have created a custom menu bar with the only buttons that I want my users to have. So far the only person that has the buttons I chose on their screen is me, everyone else has more than what I specify. Is there a way that all of my users will have the buttons that I specify? Can this be done with code? Any help would be appreciated.

Scott

View 2 Replies View Related

Custom Menus

Oct 15, 2005

How do I make my own menus? Is there some kind of wizard or what? I know how to select a menu to use, but as far as making one I've never done/seen it done before.

View 1 Replies View Related