I need to change a column from "date" to "text" in an existing table. When I highlight the column, it does not give me any other options on the formatting,...

I have a reference/lookup table named StartTime, StartTimeID PK, autonumber, with field StartTime (format date/Time, medium time format) I bulit a form on...

I'm trying to run an append query that that concatenates data from one Text field and two Memo fields into a single Memo field in the destination table....

Allen Browne wrote a response called "Creating an Audit Log" in which he states that if the database is distributed (front-end forms, back-end tables) the...

Hello, Hoping someone can help because haven't been able to find info online, and it's driving me crazy, and please bear with me thru the background info, as...

I have a small app in A2003 similar to Northwind. If you change a customer address in the customer table, it changes all orders in the (previously entered into...

Albert, Enlighten me if I am confused. His user is using a different FE, hopefully on his own computer. Since he is opening the FE, wouldn't his .ldb files...

I am looking for a quickie time management template.

I have been thrown into the world of MS Access due 2 a school project! Being a complete beginner and have no idea where to begin with the project! The project...

Hi, I have the SelectOject macro attached to a command button that opens up the database window. But because I have the DW hidden by clearing "Display Database...

Are there any sample databases available within Access 2002?

I need to convert an enrollment date to the month of enrollment. I have tried several things with no success.

I'm looking for help on database construction. We have a current database that would appear to be not normalised so I am looking for help on the correct...

How do I make the splash screen visible for a longer period of time. It appears but not long enough to read it. Thanks, Steven -- Message posted via...

I have a query which includes a field - 'Risk'. This is rated on a scale of 1-10 and is calculated from 2 other fields 'Severity' and 'Likelihood' in another...

Over a year a go I got the error "your Microsoft Access database or project contains a missing or broken reference to 'dao2535.tlb" version 3.5. The database...

Hello, I have created a Linked table via ODBC. My ultimate goal is to create a 'differential' report in Excel. By this I mean I want to display data that...

I would like to know if i can turn the usualy database warnings off. i know the option on the tool bar, but i want to turn it off in the database itself. i...

Good evening! I have built a database that stores data about a given product in form of a tree. I didnt have any idea of how to make it, so I created a...

Greetings, We have an Access database that was originally designed back in Access 2.0 days. It's since been added to and convert numerous times; today it's an...