473,382 Members | 1,368 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,382 software developers and data experts.

change field names

Is there a way to change field names throughout my db? I erroneously named a date field as "Date" and should have been named something else cause this may cause me problems as I start using this field in calculations. Progressive Enlightenment has taught me that this was something I should not have done.
Mar 1 '07 #1
3 2569
markmcgookin
648 Expert 512MB
Is there a way to change field names throughout my db? I erroneously named a date field as "Date" and should have been named something else cause this may cause me problems as I start using this field in calculations. Progressive Enlightenment has taught me that this was something I should not have done.
Well you could just go back to properties > Field Name. But chances are that any reference to this will need to be changed if you are referencing it in code in the forms.
Mar 1 '07 #2
Yeah, I kinda wanted to do it automatically without having to do it manually in all forms, reports and queries, and not using the auto correct in Access.
Mar 1 '07 #3
Rabbit
12,516 Expert Mod 8TB
The only alternative to this is vba code which could take more time unless someone already has code that has been tested.
Mar 1 '07 #4

Sign in to post your reply or Sign up for a free account.

Similar topics

4
by: N. Graves | last post by:
Hello; I have a table that is equipment. This table has a filed called Owner and that Owner filed is Looked up from a table called employee. and the query request the serial number of the...
2
by: Michael Hager | last post by:
Hello all, I have a client that has a database that produces certificates using an access report. The certificate has a picture of the person on it. The pictures were stored by SSN number, and...
6
by: Lauren Wilson | last post by:
Hi Folks, I am totally confused about the following: 1. Is it possible to change the size of an EXISTING TEXT table field in Access 2k or later using DAO or ADO code? 2. If so, does anyone...
5
by: HS1 | last post by:
Hello I have a datagrid to show data for a database table using "seclect * from tablename" The datagrid works OK. However, I want to change the name of the fields in the database to other...
3
by: Jim in Arizona | last post by:
I have a gridview that's being populated from an access db query. The problem I'm having is that the date/time fields in access that are populating the gridview are showing both date and time, when...
2
by: craigkenisston | last post by:
Im trying to make an application using all the out of the box stuff for data displaying. Using (or trying to) use a BLL and DLL. Now, in my database, the tables and columns have names like these: ...
2
by: pripa | last post by:
#1 in my report i need to group my clients and print a color code "Green", "Red" and "Blue" above names of the clients depending on values in the order form. Is it possible to print it from the...
4
by: Bob | last post by:
Hi all, I've got a table that I've imported and it has junk at the top of the table, so after import I run a delete query to remove the junk lines then I'm left with the field names I want for...
8
by: joshapalooza | last post by:
Hi all, What I'm trying to do is two-fold. We'll tackle one and then the other, or whichever is easiest. First Question/Problem: Is it possible to write VBA code that would change a text...
0
by: ryjfgjl | last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.