My Main Tables AutoNumber Playing Up.
Jan 5, 2007
OK, My main table has an autonumber field in it to make records unique.
At the moment, the number 5-34 are all in use on active records. But when I create a new record either in the front end form, or the back end directly in the table, it attempts to start the record off with an already existing number.
No idea why this is doing this at all.
Is it possible to reset the autonumber to say 50 so all new records start at 50, then 51 etc.
I really dont want to lose the numbers already assigned, as there are other tables that rely on that autonumber as the clients ID to record all the other data.
Its probably something very simple, but I cant carry on with my data entry at the moment.
View Replies
ADVERTISEMENT
Aug 10, 2006
Hi all, can anyone tell me what I'm doing wrong? I'm testing the code below that's supposed to enable all commandbars and make them visible if appropriate- but it is causing access to shutdown whenever I run it. If I can get it to work I want to be able to reset a users toolbars after my app has changed them-not perfect, I think this still dumps any customization the user had previously.
Public Function enableTools()
On Error GoTo Err_enableTools
'enable all toolbars
Dim i As Integer
For i = 1 To CommandBars.Count
CommandBars(i).Enabled = True
Debug.Print CommandBars(i).Name
DoCmd.ShowToolbar CommandBars(i).Name, acToolbarWhereApprop
Next i
Exit_enableTools:
Exit Function
Err_enableTools:
MsgBox Err.Number & " - " & Err.Description
Resume Exit_gottaGo
End Function
View 11 Replies
View Related
Mar 10, 2006
I'm new to Access but have made a database of my music collection. Is it possible to get the selected mp3 file to play on the click of a button directly from a form? My music collection is store in several sub directories on my hard drive.
View 4 Replies
View Related
Nov 14, 2007
I'm a bit frustrated with how Jet is behaving with the server (MySQL).Apparently it loves to issues commands like those: 48 QuerySELECT `city`.`ID` FROM `city` WHERE ( 'ABW' = `CountryCode` ) 48 QuerySELECT `ID`,`Name`,`CountryCode`,`District`,`Population` FROM `city` WHERE ( 'ABW' = `CountryCode` ) limit 10071114 13:44:25 48 QuerySET AUTOCOMMIT=0 48 QueryCOMMIT 48 QuerySET AUTOCOMMIT=1 48 QueryCALL BEGINTRAN 48 QuerySELECT `Code`,`Name`,`Continent`,`Region`,`SurfaceArea`,` IndepYear`,`Population`,`LifeExpectancy`,`GNP`,`GN POld`,`LocalName`,`GovernmentForm`,`HeadOfState`,` Capital`,`Code2` FROM `country` WHERE `Code` = 'ABW'071114 13:44:27 48 QuerySET AUTOCOMMIT=0 48 QueryUPDATE `country` SET `Name`='Aruba' WHERE `Code` = 'ABW' AND `Name` = 'Arubz' AND `Continent` = 'North America' AND `Region` = 'Caribbean' AND `SurfaceArea` = 1.93000000000000000e+002 AND `IndepYear` IS NULL AND `Population` = 103000 AND `LifeExpectancy` = 7.84000015258789060e+001 AND `GNP` = 8.28000000000000000e+002 AND `GNPOld` = 7.93000000000000000e+002 AND `LocalName` = 'Aruba' AND `GovernmentForm` = 'Nonmetropolitan Territory of The Netherlands' AND `HeadOfState` = 'Beatrix' AND `Capital` = 129 AND `Code2` = 'AW' 48 QueryCOMMIT 48 QuerySET AUTOCOMMIT=1071114 13:44:28 48 QuerySET AUTOCOMMIT=0 48 QueryCOMMIT 48 QuerySET AUTOCOMMIT=1 48 QueryCALL ROLLBACKTRANI want to use transactions, but with Jet's behavior, it's useless because Jet insists on committing every update it does. Disabling transactions in the ODBC driver didn't stop it. (This is why you see "CALL [Transaction method] in the query- I figured that if I made a stored procedure, disabling transactions, Jet would STFU and let me decide when to commit or rollback the transaction, but it blithely ignores the setting...)There's no "Safe Transactions" value anywhere, and I don't know where I'd look to alter Jet's behavior, already having looked at regedit and reading the whitepaper on JET and ODBC.I also seems can't to use ODBCDirect workspace for bound forms, and even if I set the recordset to a ODBCDirect workspace, I lose all Jet's intelligence in selecting only needed records (in which it does a wonderful job, I'd think). I also can see that if I create a ODBCDirect workspace, I would be creating one more (unwanted) connection to the server, which indicates to me that Jet/Default workspace will connect to the server anyway, and because the default workspace isn't an ODBCDirect, I can't modify/view connection properties.Can I please have my cake and eat it? Anybody knows whether the behavior can be altered?
View 4 Replies
View Related
Oct 2, 2004
Hi - would like some help.
I have a switchboard on which I have items which when clicked should bring up forms or other switchboards but do nothing. They just play dead. They did work in the past (i.e in the last hour) but don't anymore. I haven't edited anything on the switchboards or the forms beng called so am a touch puzzled
Any Ideas or answers much appreciated
Thanks
NW
View 3 Replies
View Related
Mar 4, 2013
I am about to set up a database but wanted to check the relationship of the main tables before I add to it. I have attached the relationship design
For a PROJECT, there can be many TESTS, for a TEST, there can be many PRODUCTS
Is my design reasonably sensible?
View 6 Replies
View Related
Apr 18, 2006
Hey.
My database would like, to make itself feel complete, a rele snazzy opening form.
I have flash 8 and I've created a 1024x768 movie with some simple animation on it.
I've managed to add the movie to the database as a ActiveX flash object and the animations play.
The problem is making the object larger! It's staying very small no matter how I change the properties of the control.
Any help would be much appreciated. For the sake of my databases mental health... of course. :cool:
To attach the movie I did so:
http://www.databasedev.co.uk/flash_movie.html
JoeyTheBean
View 2 Replies
View Related
Apr 3, 2013
Beginner using 2010. I wish to play MP3 files from a command button on a form. I would like to avoid third party / ActiveX controls if possible.
I am aware that use of "CurrentProject.Path" will be useful to locate the MP3 file within a directory within the Project Folder.
But have be baffled by the sparse previous postings about this subject (going back to 2004). Searching this forum yields zero results on the term "MP3".
This accdb/e will be used to present historical information to a small number of people and will be used with runtime without user input.
And all I need is Play / Pause / Stop. No other functions required.
View 10 Replies
View Related
Oct 12, 2007
I have a MAIN table with autonumbering for the project number. In a table related to the MAIN table I have a project number that I want to be updated when the MAIN table has a new project entered. Can I keep these in sinc automatically?
View 8 Replies
View Related
Feb 1, 2008
Hi,
I need to create a table with 2 sets of different information both referring to job types. the problem is that i need the autonumber which created the job number to scale together. so both tables have a primary key of "job number" and i want the autonumber to only ever use 1 number in both tables.
e.g.
job type 1 - autonumbers - 1,2,3,4,6,7,9,10
job type 2 - autonumbers - 5,8,11,12
is there anyway of achieving this?
Any help greatly appreciated
View 5 Replies
View Related
Mar 13, 2006
I have three tables.
EAch has a field called ID that is an Autonumber that is the primary key.
When I enter data via a form each record has a different ID across the three tables.
Does this mean they are not linking up correctly?
I have attached my databaset if that helps.
Thanks.
View 1 Replies
View Related
Nov 11, 2014
I made a simple access project and I want to make a count for my visits, this counter MUST starts from one each morning "every new day", I use autonumber field to give each visit its unique code, I'm ok with that, but i need additional counter that resets each new day,, i watched some videos for making the autonumber starts from different number like 1000 for example using Append query but i didn't figure out how to use this method for resetting counter everyday.
View 6 Replies
View Related
Aug 20, 2013
A slight flaw in the design requires this change. What is the best way to do it?
View 8 Replies
View Related
Dec 1, 2014
My database exports data to one of our customers who then inputs the data into their system.
One field i have is "RO Number" which i have as an autonumber which works for the purposes of my part of the system.
However they have it set as "RO9999", (Their system has been set up for years, we are a new "branch") but they aren't in access.
They want the RO number to be a running serial from RO30000, RO30001 etc
The data in entered on a form.
View 3 Replies
View Related
May 31, 2013
Why one would want a unique index on an ID key ? It can't be effectively used in joins and is never used in a where clause. So why have one ?
View 14 Replies
View Related
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
Jul 8, 2014
I'm creating a database for a travel agency. There are 2 tables, one for customers and one for their bookings. I have established a relationship between the tables so the AutoNumber for customer ID links to a field on the add booking table.
In practice though, it would be easier to enter the customer NAME into the booking table and have it retrieve their ID that way to link them. This seems like I am missing something simple but can't fathom a way to do it.
The other factor is obviously more than one customer will have the same name so I may need to link first name as well to differentiate?
View 7 Replies
View Related
May 30, 2014
I need to restrict the random autonumber feature to 10 digits and a positive number for a primary key. I work in the medical field, and HIPAA privacy regulations require the use of random ID numbers to identify records. Also, I need the numbers to be positive numbers because we will be using barcode scanning equipment and the possibility of truncating the negative identifier creates the possibility (admittedly remote) of having a duplicate PK barcodes. I understand that we cannot change the Access feature, but any VBA code to generate a truly random 10 digit positive number I can use as a PK?
View 4 Replies
View Related
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
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
Oct 21, 2012
I have 3 tables: [SurveyVendor], [Surveys] and [SurveyResults]
SurveyVendor has 2 fields:
[VendorID] - PK
[VendorName]
Surveys has 3 fields:
[SurveyID] - PK
[VendorName] - FK
[SurveyName]
SurveyResults has 3 fields:
[SurveyResultID] - PK
[SurveyName] - FK
[SurveyQuantity]
I used the LookUp wizard to establish the relationships, and I chose to include 3 fields when linking [SurveyResults].[SurveyName] to [Surveys].[SurveyID]. I'd like the ID, Survey Name and Vendor Name to be displayed when making a choice in the combo box. And I would like the column to only display the SurveyName.
However, what's happening is the VendorID shows up instead of the VendorName when I click the combo box for [SurveyName]. And the SurveyID shows up in the column results, rather than the Survey Name.
View 3 Replies
View Related
Jun 10, 2015
I had a backup from a table that I saved to excel. Somehow we lost all the records from the table 10 minutes later. There where gaps in the id numbers due to some delete records in the past, and when I did try to put it back in the access table the records some how shift. is there a way of still using the ID nr that is an autonumber in the table and when I set the data back from excel and use the append when paste that they show up correctly? Maybe I can set the autonumber to start from the last record on the table?
View 14 Replies
View Related
Dec 12, 2012
I got a table with "ID" as autonumber field. However when I have ID numbers:
1
2
3
4
5
6
7
And I remove record 4, then I got
1
2
3
5
6
7
How can I make it fill up the missing "4"?
View 5 Replies
View Related
Jul 19, 2014
I'm making a new database and I want to assign Item Codes to my inventory. For example:
ItemCode (Primary Key) | Item | ItemDescription
I want to generate an automated item code containing the first letter of the Item (as prefix) followed by numbers. Example:
ItemCode: P001
Item: Paper
ItemDesciption: Ordinary white paper
View 14 Replies
View Related
May 1, 2013
I have two tables that are related: BUCKETS & LOCATION
BUCKETS has these fields:ID (autonum)
Type (type of bucket)
Creation Date (when it was created)
Operational (if it is operational or not (Yes/No).
Location (Location of the bucket)
Notes (notes)
LOCATIONS has these fields:LocationAutoID (Autonumber)
LocationCity
LocationID
BucketsOnSite (can have multiple entries)
What I'd like to have done is for LOCATIONS table to be aware of how many different cities there are. So for instance, if there is multiple location entries for the cities of Vancouver and Toronto in there, I want the LocationID to first know how many Torontos there are and in LocationID to combine the LocationCity and a count (starting from 1) to that field.
So for example, if there are three toronto locations and two vancouver locations, LocationID would have TO-01, TO-02, T0-03 for the Toronto locations and VAN-01, VAN-02 for Vancouver locations.
At first I had the expression of [LocationCity] & "-" & [LocationAutoID] in the Expression field in the Field Properties but I quickly realized that it wouldn't count the amount of cities but just add the autonumber and the city (which kind of works, but not ideally).
View 8 Replies
View Related
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
