is it possible to change a name in tables, forms, queries etc in one input
for example I have a spelling mistake in my table , forms etc , can I do a change it in one go throughout the database
We sometimes make an error in entering a stock code and have to change the code.
Our main table is = Investments01_tbl
Other tables that use the same stock codes from the above table are
= Alerts_Stocks
= Investments01_tbl_SubForm
The table = Investments01_tbl_SubForm = can contain the same stock code many times.How can we create a query that can be used to enable us to change the stock codes in the 3 tables at the same time?
I'm trying to change database name, and not the one in database properties and changing the title. I've done that already.
View 8 Replies View RelatedI finally found and eliminated all duplicate entries in my tblStoreProducts table, so that I could create a 2-field Index called UniqueProduct that would prevent duplicate entries. Without it, uploading information from Excel (not the preferred method) would result in duplicated entries in this table which would ultimately reflect in the Hazardous Materials reports that must be submitted to the fire marshal.
Today I was going through data entries in the Product table and noticed some that are STILL coming up with the UPC (a text field) in Scientific Notation.
I know that I have to change the information in the linked table tblStoreProducts first. The most simple way would be to just change the UPC of the product in that table to the correct UPC. It shouldn't be causing a problem, because it doesn't create a duplicate record. I'm getting the error "The text you entered isn't an item in the list" now that I've created that index.
I changed the index to Unique = No and still get the same error.
I removed the index all together...still get the same error.
I'm making the changes directly in the BE database right now. If I can't enter information directly, the forms aren't going to work either.
Is it possible to show an alert/reminder any time data in a particular field is entered or changed? It would have to show up if the data was changed in table view or query view.
Until I can write something that will store historical data for these fields, I want to make sure anyone entering information will record the old information in a separate table. Yes, I know this is not the ideal way to store the type of data; but this database has been running for 10+years and is tied in to so many aspects of the company re-writing it is just not an option ...
I have a form with a sub, and that sub has a sub. I'm on the first sub trying to change the rowsource of a combo box on the second sub, and none of the following want to work.
Code:
'Me!frmRentalsSubDetails.Form!cmbEquipmentID.RowSource = EquipFilter & Me.ToLocation & "));"
'Forms![frmrentalcontainer]![frmRentals].Form![frmRentalsSubDetails].Form![cmbEquipmentID].RowSource = EquipFilter & Me.ToLocation & "));"
'Me.frmRentalsSubDetails!Form.cmbEquipmentID.RowSource = EquipFilter & Me.ToLocation & "));"
Me![frmRentalsSubDetails].Form![cmbEquipmentID].RowSource = EquipFilter & Me.ToLocation & "));"
VBA syntax for changing various "Field Properties" on an EXISTING table. Specifically, the field properties I'm trying to change are:
Field Size (I want to make this 'Double')
Format (I want this to be 'Standard') and
Decimal (I want this to be '2')
The Data Type is already set as 'Number'.
I have copied our company access database onto my lap top and linked the front end to the back end. My problem now is that when I open the switchboard it is looking for the data and tables on the G drive, this was where it was on our server. How do you change the path for the switchboard.?
View 10 Replies View RelatedI have a database where I would like to change a fieldname to something different.
I know I can use edit replace in the code and that works ok, but is there a way to change the fieldname in the code, the Table, the queries, and sql all in 1 foul swoop or do I have to do them all seperately by hand.
before ACCESS Excel was used to create orders etc,we are up to order number 16223 now I have access and the auto number will start at 1.how can I get the auto number to start at 16223.
View 11 Replies View RelatedI have a database with two tables: taskTable and volumeTable. On the task table I have the list of task performed in my team and the time it takes to perform the task related to a category, and on the volume tasks I have the volumes of workload based on the category moth after month. Then I have a query that multiplies the time it takes to perform a task with the volume in the category and returns me results for each month.
Now, if a task changes on march and the time to perform it its reduced or increase I change it on the table, howerver, ALL results for all months. I would like to know if there is a way for the change to be applied from the month it is changed and not retroactively.
Example Task Table:
Task Time to Perform Task Category
Buy ticket 5 min Business Visitor
Create profile 10 min Business Visitor
Example Volumes Table:
Month Year Category Volume
March 2014 Business Visitor 39
In this query I have setup I need to get my Dates field into short date format and another field needs to be with 0 decimal points. I take it there is code I have to enter but I cannot find it anywhere.
View 4 Replies View RelatedI've got an Access 2010 application that currently links to a SQL Server 2000 database. I need to change the link to a SQL Server 2008 database on a different server. Where do I go to change the link? When I click on External Data, ODBC Database, I only get an option to import source data. I don't want to import any data. I just want the application to link to a different external database. If I go ahead and click OK, I choose my ODBC connection and log in to the 2008 database. Now I've got a list of "import objects" to choose from. I choose one table (just for testing; I actually want to link with all tables), it says it imported successfully, but when I view the data in that table from Access, it's the same old 2000 database data.
View 5 Replies View RelatedI am trying to change a field to be required. I know where it is...
(Navigation Pane > Design View > Select field I want required > Properties Pane > General Tab > set Required property to Yes)
But I don't see that General Tab at the bottom of my page.
The closest thing I have to properties is on the right-hand side. It opens when I right-click, then hit Properties. It displays...
Format | Data | Event | Other | All... but that's it...
[URL]
How do I change a txt box to a memo field on a form? (I need to allow for more than 255 chars...) I've already set the backend DB (sql server) to accept the many chars, and the linked table access see's the datatype as memo. But I can't figure out how to get a memo field on the form, or how to change the current txt box to a memo control to support the extra characters.
I've been looking for 20 minutes... I guess I never used a memo field before, since I can't find/see how to set this.
I'm using the changebackgroundcolor.zip sample that I found here at Lebans site. URL....I'm trying to find a way to keep the color that I picked after the database closes. I tried to follow the example here URL....but couldn't get it to work.how to get the color to stay on the color that was picked from the dialog box?
View 1 Replies View RelatedI have a log in form and user combo box.
I want to add photo of each user in this log-in form.
Just want to ask if possible to change photo depends on combo box value?
Is there a way to change the formatting of a numbers column to the formatting :
1 = 0001
11 = 0011
111 = 0111
1111 = 1111
But that would have to apply to this also
1 - 2 = 0001 - 0002
11 - 22 = 0011 - 0022
111 - 222 = 0111 - 0222
1111 - 2222 = 1111 - 2222
If that makes sense ....
I need to change the password to the front end of my split database. How would I do this?
View 1 Replies View RelatedI have created access database having field currency but it shows currency in $ by default I want to changed it to Rupee. How could it do?
View 1 Replies View RelatedI am working on a database,
structure of database tblaccounts: glcode,description.
tbltransaction: transaction ID, glcod, tranxtype, amount
Everything is going well, when i make a transc ,transcid genrated
i,e 1,2,3,to 47,48,49,50 and so on. In this case there are minimum 50 transaction on daily bases, it is difficult to remember the transaction id after two or three months. Here i have an idea that daily after 11.59pm ,i mean after changing date ,when i make a transction, transction id or sequence no start from 1, and my last day data will also remain safe . I am sure that i have to create another table for appending data to that table for reusing of transaction id from 1 but i am failed while making this.
I have a CheckBox and a Field Date.
The latter has two conditions: If it is >=now() to be the font is RED and if <=Now() that the font is GREEN
Now, what I need is that pressing the CheckBox, ignore both conditions and that the font color is set GRAY
I have in my DB a lot of tables, queries and macro and every time I spent too much time by choose the right object.
Would be really useful give a color or change the character on each object. Is it possible?
I have a database that was created in Access 2003. I'm using this MDB in Access 2010.I need to change a user created menu. The update involves changing an existing entry and adding a new menu item. The menu looks like:
Project
Time Entry
Time Spread
I need the "Time Spread" to change to "Time Spread Daily" with a changed macro name. After that a new menu entry is "Time Spread Monthly". This menu will run a new macro that will display a form.I think the only way to do that in 2010 is to use VBA.
I have two versions of the switchboard items table. (A2003 switchboard). I have a login form, and I want to be able to change the switchboard items for different users
so I have code that does this
close the switchboard,
copy the new switchboard items table
reopen the switchboard
And every time, it says it cannot copy the table because the switchboard items table is in use. The code in the switchboard opens recordsets, and I have quadruple checked that they are closing correctly, after use. The switchboard itself is bound to the switchboard items table
I have just tried something different which is to manually close the switchboard - and then I CAN copy the tables.
Might the code be atomic in some way. The switchboard does not release the locks until the code completes?
I thought about it, and got round it now, by just copying the data from the new table to the master table, rather than trying to copy tables, but I am still curious.
A few years back I saw a program which helped with database changes. I want to change names of fields and tables, queries etc. in a rather complex database. Does anybody know where I can get this tool or program to run through the database and change it in all corners and crevices on a search and replace basis?
Thanks