I have a database that has thousands of records. In my main table I have a primary key named "Social Security." I was asked if I could change that name to...

Hello when I appended some data into my main table, the autonumber jumped from around 544 to 26300. There are only 276 rows in the table. The most rows I've...

Set tbl = db.TableDefs("Invoice") tbl.Fields.Append tbl.CreateField("amount", dbCurrency) the above code is working well. However, the below code, I cannot...

I would like to change my web page but I can't get into page editor

I copied a database that I have used for years. It has always worked on these two computers. I made some minor changes to a form using Access 97 SP2. Everyhing...

hi all can someone please help, i am using the above template. I have created a unit cost field in the products table i just need to know how i can get...

I copied a FE and BE to a users laptop and re-linked the tables. When he came back to the office I copied the updated BE to the network, changes to some of...

I'm making some changes to a Ms Access 97 application. In order to support some functionality changes, I need to make a couple of changes to the structure of...

I need to change a field from a date format to year only. So instead of it reading 1 Apr 2008 or something similar it now only contains the year, ie, 2008....

I am working on a database that someone else designed - and the problem I'm having involves two tables. The first table is Subject_Info (this is the...

What is the easiest way of amending a Field in a table that has thousands of entries in it to be Autonumber? I have managed to copy structure and amend an...

I have a inventory database with tables for items and item sales. tblitems itemsID item Iprice active y/n tblitemsales itemsalesID itemsID

Novice/XP/2003 I have a large number of forms that share some subforms. On the Open event of each main form I have some code that puts a Select statement...

Hello, I have an access project in which I want to change some tables names dynamically using visual basic code. is there any way doing this? thank...

I realize this is a bit unorthodox and reflects a questionable table design, but I am coming in on the end of this saga....... We need to massage a small set...

I've inherited an Access 2003 database. The colors on one of the tables are dreadful, to my eye. How can I change the colors for the background and the font...

I am building a project database for my team and we need to use 3 status levels in order to inform management quickly about project status. The statuss are...

Hey Guys, Is it possible to change font color of query data? If so, please help! Thank you Majic

I have the main form onto which I have inserted pages. However, I can not to change the color of the inserted pages from white. I would like them to match...

I need to change a column from "text" to "date/time". This particular database has numerous queries that I suspect include this column. What system table...