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.
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
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.
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?
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
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
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.
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?
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
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.
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.
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?
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?
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.
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.
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?
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).
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?