Hi everyone,

This forum is heaven sent.

I'm having a problem inputing data into a cell.

"03/09 Brighton: Cleaning services" (It's not much, well below the max of 255)

The computer says NO, text too long. But then if I input even just a ".", it displays the same message.

I'm having to record the info on a word doc, and it's driving me insane.

I love Access, but yet I hate it too...

Please help.

By cell I take it you mean field in a table or maybe a control on a form that is bound to a field in a table. What is the field type?

__________________
(RG for short) aka Allan Bunch MS Access MVP - WinXP Pro, Win7 - acXP, ac07
If your issue is resolved...follow this link for directions on how to use the Solved thread tool!
Teaching is not filling a bucket but lighting a fire. Borrowed quote..."Docendo discimus"

Excuse my computer language, I'm new to the game.

Its a field in a form, text formatted?

Do you think I'll be able to find someone in this forum who could make a bespoke database for a fee?

I'm in charge of a database of 270 customers and counting. And I owe it to them to have the best database available.

Queries is the way ahead for me. If only I knew what it all meant???

Thanks ever so much for taking the time to help out.

Your my hero!

If you want someone to do your project for you than I would recommend looking elsewhere because that can be a complicated subject. Are these 270 Customers on-line at the same time because that could be a problem by itself. Do you have a budget for the project yet?

__________________
(RG for short) aka Allan Bunch MS Access MVP - WinXP Pro, Win7 - acXP, ac07
If your issue is resolved...follow this link for directions on how to use the Solved thread tool!
Teaching is not filling a bucket but lighting a fire. Borrowed quote..."Docendo discimus"

My database isn't complicated in the slightest. It's just that little things aren't being done right.

For example I'm keep getting a "Too many field's defined" error message popping up. It won't let me add additional forms (columns) in a table.

It doesn't matter if my customers are on line or not ( I think ).

My challenge is to match up contracts to my customers, depending on their location, industry and price range.

Simple to someone who knows what they are doing, but rocket science to me!!!

By OnLine, I meant MultiUser OnLine to your Database. It sounds like that is not the case. With Access you need to think Tall and Skinny for tables rather than Short and Wide as you would in a spreadsheet. That is probably where you might be having problems. We can probably get your db in a more trustworth condition if you are willing to put in the time and effort. All it takes is time.

__________________
(RG for short) aka Allan Bunch MS Access MVP - WinXP Pro, Win7 - acXP, ac07
If your issue is resolved...follow this link for directions on how to use the Solved thread tool!
Teaching is not filling a bucket but lighting a fire. Borrowed quote..."Docendo discimus"

Oh Please help me get my db in a more trustworthy condition.
I'm ready, eager and ready to put in all the time and effort it requires to make my database work.
Thanks Allan

How big is your db? Is it too loaded with sensitive data to post here? We would need to see how you have your tables designed.

__________________
(RG for short) aka Allan Bunch MS Access MVP - WinXP Pro, Win7 - acXP, ac07
If your issue is resolved...follow this link for directions on how to use the Solved thread tool!
Teaching is not filling a bucket but lighting a fire. Borrowed quote..."Docendo discimus"

16 000 KB (Is that classed as small/medium or huge?)

I'd be more than happy to post the db if I meant sorting out the problems.

The only sensitve information is names, addresses and phone numbers.

What do you suggest?

How will I be able to show you my table design?

Start with a backup of your db. Then in the copy delete all but say two records and then change the names and numbers. Zip it up and post it as an attachment to your post. That will tell us a lot about the database. Remember...backup...backup...backup. Did I mention backing up?

__________________
(RG for short) aka Allan Bunch MS Access MVP - WinXP Pro, Win7 - acXP, ac07
If your issue is resolved...follow this link for directions on how to use the Solved thread tool!
Teaching is not filling a bucket but lighting a fire. Borrowed quote..."Docendo discimus"

Thanks a million.

Attached is what I'm working with now (Zipped), I've followed your instructions.

I'm starting a new db from stratch, with the principle of tall & Thin, not short and long, thanks for that.

I'm really enjoying it!!!

Attached Files

MyZipFile.zip (217.7 KB, 2 views)

Here's a couple of links to Bookmark. Don't use special characters or spaces in names for any objects. I would also start by having an AutoNumber PrimaryKey in each table.
http://support.microsoft.com/?id=826763
http://www.allenbrowne.com/AppIssueBadWord.html

__________________
(RG for short) aka Allan Bunch MS Access MVP - WinXP Pro, Win7 - acXP, ac07
If your issue is resolved...follow this link for directions on how to use the Solved thread tool!
Teaching is not filling a bucket but lighting a fire. Borrowed quote..."Docendo discimus"

In a properly organized RDBMS, the data *only* exists in one table. You establish relationships by putting PrimaryKeys on other tables as ForeignKeys. You should read up on Normalization. Google can find you lots of free sites that describe Normalization. Here's a starter link.

__________________
(RG for short) aka Allan Bunch MS Access MVP - WinXP Pro, Win7 - acXP, ac07
If your issue is resolved...follow this link for directions on how to use the Solved thread tool!
Teaching is not filling a bucket but lighting a fire. Borrowed quote..."Docendo discimus"