Stupid Question: Autonumber, Legacy Data

Jan 29, 2008

version: access 2000.

OK, i have what may be a fantastically stupid question. i did a search (http://www.access-programmers.co.uk/forums/search.php?searchid=1806902&pp=25&page=2) on this and didn't find anything that seemd to address it.

my issue: autonumber field, sole primary key. i am adapting a legacy (non-access) db into access. it was originally an autonumber field but during import, the data type was set to number and of course, i cannot convert it back now into autonumber.

i already duped the PK field as an autonumber and tried an update query to "correct" the autonumbering PK field as i believe is suggested here (http://www.access-programmers.co.uk/forums/showthread.php?t=138484) but it won't permit me to do this.

b/c it's legacy data, i want to preserve the original values in the autonumber, but am unclear on what next steps might be available to me.

thoughts, anyone?

ed

View Replies


ADVERTISEMENT

Legacy System Access 2.0 Migration Queries

Jun 12, 2006

First post, so I hope I'm following the post-etiquette!

Anyway, I've just been employed by a company who still uses access 2.0 and lotus smartsuite.

Basically I'm gonna have to migrate a few of their backbone databases to access 2000+

I've managed to find the old Microsoft access 2.0 book in the company amazingly, which is a help.

I was just wondering if anyone knows any good sites for migration, or any particular problems that may be encountered. I'm just doing some background work at the moment, this won't be happening for a few weeks (hopefully!)

Any help would be greatly appreciated.

I'll just take this opportunity to say that I've found the site very useful in the last few weeks and hope I can contribute in the future when I break out of newbie status!
-Spud.

View 4 Replies View Related

Autonumber PK Vs. Data PK

Aug 28, 2006

An easy question:

When I create dbs, I usually have to create single field tables that contain data that will never be duplicated, such as race, gender, etc. In the past I have just made the single "gender" or "race" field the primary key rather than assigned autonumber PKs to all the data. Is this the most efficient manner to do this? Are there any specific reasons I should be assigning autonumber PKs to this data?

View 4 Replies View Related

Pasting Data With Autonumber

Feb 13, 2007

Hi, I have a table holding data with each record allocated an Autonumber data type. I accidentally deleted some of these records, although they are still present in another table. How do i paste them from this other table into my current table, allowing them to keep their original autonumbers instead of just adding them to the end?

(eg - I have records with Autonumbers 1,2,3,4,5 and after deleting 3 and 4 i have 1,2,5.
I need to paste records 3 and 4 (from other table) so as they again become 3 and 4 and not 6 and 7)

Thanks.

View 2 Replies View Related

Autonumber Data/Type Mismatch

Aug 20, 2007

I have two tables, one has the autonumber column, sysid, and then in the process of updating the database via forms the sysid from one table is placed in another (text format). I thought I could use that to link the tables for queries, but I am running into a data/type mismatch error.

Any ideas to get around this?

Thanks!

View 2 Replies View Related

This May Sound Stupid

Jan 7, 2006

Ladies and Gents

I am wondering if when i run my report is there anyway that the detail of the report can become objects that say i could drag and drop into a Word Doc for example. I am trying to create a tool that will allow me to see all jobs from our maintenance mangement system at work, i have managed to achieve this but i was wanting to be able to view the jobs on a report and then basically just drag them into something else and wahey i have built my plan for the week.

Maybe i am hoping for to much but i though i would ask anyway.

paul

View 1 Replies View Related

My God, Am I This Stupid? :) Newbie Yes But Still..

Mar 2, 2006

Evening folks :)

Been trying to find this on google for a while, but am not really sure about how to express my self in few words (being the norwegian that I am) so I turn to you for help! :)

Im having two tables which I want to join into one with a query.

I want to keep all data in table 1 and suplement it with info from table 2. Should be easy enough, at least thats what i thought. Cant get it to work here so if anybody can help me out i would be EXTREMELY grateful :)

Table 1:
artnr
description
minant

Table 2:
artnr
minant

Connected by artnr
Table 1 has approx 1500 lines and Table 2 has approx 2100. I want to keep all lines in table 1 and suplement that one with info from table 2, but I end up with a query with approx 1200 lines.
Table 1 does contain 'artnr' that Table 2 doesn't have and vica versa so I assume that the ay i do it I end up with the query only with the ones that has the same 'artnr' in both tables. Still my question is:

How can I keep all info in Table 1 and only suplement with info from Table 2?

hmm.. I agree, not the best way to put things, but it's the best a tired norwegian could do at the end of the day.. :)

All immediate help would be great!

View 3 Replies View Related

Stupid Relationships!

Mar 29, 2005

right, deleted my last post.. think is is more down to the point!!!

got every table sorted so far, just one stupid relation.. I have to link the results of a horse race to the horse but cannot figure out how!!!

I have a table listing all the horses (names, dob, value colour) but need to create a table to list what place the horses finish during the 6 annual races - I tried to create a table with (date, race name, place name, 1st, 2nd, 3rd etc) so I can type in which horse finishes where for each race and then AaRrGgHh cannot work out how to link it!

I know I probably need more tables but Its starting to annoy me.. any suggestions would be greatly appreciated!!

the db can be found at http://www.pokernuts.co.uk/access/server.mdb (200k) and I have attached a picture of what I have so far (relationship wise)

Please help :(

AaRrGgHh

View 3 Replies View Related

Stupid Problem

Aug 11, 2005

hi im stuck and i was wondering if someone could help me.

i am trying to multply values in individual records.

i have three columns in a table, lenght cost per a meter and actual cost. how do i calculate the actual cost for each individual record? thanks

View 2 Replies View Related

Ill Sound Stupid

Aug 7, 2006

i probably want to create a upddate querry or maybe some code but...

i have a light bulb and i keep 300 on hand i just ordered 300 more when i check the box that the order is complete i need the "bulb on hand" feild to update to 600....please help

View 1 Replies View Related

Stupid Question

Jun 12, 2007

I have not used queries or Access for a few years. I have a query set up to search for a tag number which the user enters in. How do I incorporate the * function in with it? This is what i have tried:
SELECT * From Bags_Recieved WHERE Tag_No = *" & [Which Tag?] & "*

I am trying to get it so the user just has to enter in a few numbers in case they do not know the whole number.

View 1 Replies View Related

Stupid Question

Jul 5, 2005

Hi guys,

I have a bit of an embarrasing question, as I`m sure that this is so easy to solve, but its just beyond me...
I have searched but dont get exactly what I`m looking for, looked in all my books to no avail !!!!!

I have a form, which had many data in it.
I have a particualr feild "cust_ref" which is sorted A-Z (asscending)
How would I change this to Z-A (descending)
I have done all the changes in my tables, queries etc, but this doesnt effect the form..
I also have the same problem in one of my reports....

Im sure its really simple, but I think i`m over complicating the solution, and its now giving me a really bad headache.

Thanks guys.

View 2 Replies View Related

Stupid Question

Nov 9, 2005

ok a stupid question but i cant figur it out.

I have 2 subforms and 1 mainform
all i want is that subform1 comunicates with subform 2.
subform 1 had a listbox that is filled with a query. When i click a value in the listbox the othersubform must navigate to that record.

View 1 Replies View Related

Stupid Question

Nov 29, 2005

Here's a stupid question... how can u make a field in a form so that the text in it is allways in capitals, it's for adresses and i need the city and the zipcode to be in capitals, any ideas?

Thanks on forehand

SilverBlood

View 4 Replies View Related

Stupid Question

Mar 13, 2006

I'm sure this is a stupid question, but here goes it. I'm working on a survey database. I want the end user to be able to be able to select a checkbox, if they use that service. Down the line I want to do some charting on the answers to the number of checkboxes selected. Is there anyway to change the default value to 0 and 1 verse 0 and -1

Any help would be greatly apprecidated

View 1 Replies View Related

Sorry For The Stupid Question

Dec 11, 2006

hi everyone, i'm new and almost clueless with all things asp, html and access. i know this is a bad start, but i'd really appreciate some help.

i'm doing a project with a group, we're constructing a website and i'm stuck with my part, a 'staff home page'.

basically what i'm stuck with is:

- writing the code to request the latest 5 orders from our database, and put these in a table.

- linking my drop down menus, which are in the same table, to change the status of each order

- linking my update button to the database in order to send this information from the drop down menus, and update customer orders.


apologies if i haven't worded that very well, or if the answers can already be found on the board. any help would be greatly appreciated.

thank you

View 1 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

Entering Data In A Form - Update Autonumber On Two Tables?

Jul 19, 2006

Hello,

My first post is on something that is troubling me. I have a Form acting as the display and entry point for data for a contact list, which is composed of two Tables as follows:

Contact - (text fields including: first name, last name, phone number home, phone number work, etc)

Industry Role - (yes/no tick boxes including: film, photographer, audio engineer, producer, reporter, etc)

The two Tables have a one to one relationship based on the URN field which is an autonumber. My problem is that when someone enters say a name, and then ticks a box, the autonumber will add two entries because it seems to see the first table then the second tables as sequential, and not the same thing. How do i go about making a form that can enter new records the same autonumber for two connected Tables?

View 3 Replies View Related

Relationship : My Stupid Question...

Nov 21, 2005

i use Ms Access 2000 (home)& 2002 (office)..
can i choose type of relationshp manually..
i mean i can change ony-to-many to many-to-many or some thing like that...
if it possible, how...
plz help me...

View 4 Replies View Related

Foreign Key Stupid Question

Dec 15, 2004

I have done multiple searches with no luck- sorry to ask such a basic question, but I want to know the correct way of inserting a foreign key into a table.....I was told to Insert - Lookup field - in my main table - is that correct?

Thank you :confused:

View 14 Replies View Related

Stupid Message Box Question

Feb 21, 2006

I'm currently trying to get a button working that will check the contents of a field for a value, and if nothing is selected I want it to prompt the user to select something. Here's my code:

Private Sub Command47_Click()

Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "frmCustomerInf"
stLinkCriteria = "[CustomerID]=" & Me![CustomerID]

If [CustomerID] = "" Then
MsgBox "Please Select a Company Name", vbInformation, "Warning"
Else
DoCmd.OpenForm stDocName, , , stLinkCriteria
End If

End Sub

For some reason I can't get this working, what am I doing wrong?

The error I'm getting when trying the button is Run-time error 3075: Syntax Error (Missing operator) in query expression '[CustomerID]='

View 4 Replies View Related

Totally Stupid Question...

Mar 19, 2006

Right.. I'm a complete noob @ access...

Ok.. I have a yes/no column in my table and I want to build a query on that table so it returns all the records with NO (unticked box).

How do I do that?



Any help appreciated :)

View 1 Replies View Related

My Stupid Loop Idea

Jul 6, 2006

I've got 20 checkboxes which i need to do the same thing but individually.

If IsNull(DLookup("[question 1]", "qryQuestions")) Then
chkQuestion1.Visible = False
Else
chkQuestion1.Visible = True
End If


I tried this:

Dim loopy As Integer
Dim tmpquest As String

For loopy = 1 To 20
tmpquest = "question " & loopy
tmpCheck = "chkQuestion" & loopy
If IsNull(DLookup(tmpquest, "qryQuestions")) Then
tmpCheck.Visible = False
Else
tmpCheck.Visible = True
End If
Next loopy

tmpquest works.
tmpcheck doesn't.

I tried dimming tmpcheck as lots of things but no luck.

Any help?

View 6 Replies View Related

Stupid Newbie Question

Nov 4, 2004

New to Access and learning quickly, but some things just throw me.

I have a database that adds rows to a table as certain command buttons are selected. It frustrates some of the users because every time they click the button, a warning comes up, "You are about to append 1 row(s). Once you click "Yes".... and on and on.

What's the easiest way to remove this notification?

View 3 Replies View Related

Tables :: Autonumber Field - Can't Create Record Because Data Will Be Duplicated

Feb 12, 2014

When I tried paste some data using front end to my database, Access showed error (can't create record because data would be duplicated). I thought it's impossible because it is autonumber field. So I checked it (manually). I did copy of my database and then for testing, I created record. I was shocked. Next record should has a value of "160" but Access gave "130" then showed an error "Can't create record because data will be duplicated". Of course after compact and repair everything is fine.

View 5 Replies View Related

How To Reset Tables To Change Data Type From Number To Autonumber

Dec 4, 2013

So I have decided that I want my ID's to be AutoNumbers, but at the moment they are currently set as Numbers. I have already inserted data, to test, which has been deleted, however I am now unable to change the ID field back to AutoNumber.

How can I duplicate the tables so that this field can be changed again?

I have like 10 tables with heaps of feild, so remaking them will take long, but I know there is a way using queries, I am just not sure how...

View 2 Replies View Related







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