my form seems to be blocked... help!

[virgosam20]

Um.... something has happend and i dont know how it did!

On one of my forms, which i haven't done anything to in a while, wont let me enter any new information. The computer just makes a noise when i try to type in a text box.

I don't know whether i have changed something accidentally, but i have even tried to create a new form using the same table and the same thing happened again.

I have looked at the 'enable', 'data entry', etc, boxes, but they're all set to yes....

...any ideas...?

 

[WayneRyan]

Sam,

DataEntry = Yes

Means that the user can only add new records.

Wayne

 

[virgosam20]

but thats the thing... i can't enter anything. not even new records.

I've tried making a new form, but it does exactly the same thing. i have other forms that are fine, and i can add a new record whilst i'm in the table's datasheet view format, but not when they're put into a form.

Its really annoying!

 

[WayneRyan]

Sam,

Then your individual controls must be either:

Locked=Yes

Or

Enabled = "No"

Otherwise, post a sample DB.

Wayne

 

[virgosam20]

Where is the 'enable' property? I can't seem to find it...

 

[boblarson]

Did you add a field or table to the underlying query of the form. Perhaps doing so turned it into an non-updatable query.

 

[virgosam20]

ok, i've found it, but they seem to be set right. 'enabled' is set to YES and 'locked' is set to no.....

 

[virgosam20]

its a form to add information, but it might be possible i have changed it somehow without realising... how would i have turned it into a 'non-updatable' query and can i change it back?

 

[WayneRyan]

Sam,

Bob has a good point. If your form is based on a query, you could have
modified it and the result would be a non-updateable recordset. If that's
the case, just run the query and see.

It could also be an input mask or field-length problem (with the Insert
Key on).

It could be a lot of things.

Need to either see it, or just keep guessing.

Wayne

 

[virgosam20]

ok.... i have found something else that might help you to help me.... when i move the cursor over the first data entry field in my form, it turns sideways!

 

[WayneRyan]

Sam,

That is obviously not standard behavior!

I'd have to see this before rendering anymore thoughts.

Wayne

 

[virgosam20]

wait a minute... i've just managed to change that back. i'm gonna try and see if its something to do with the query

 

[virgosam20]

I would send it as an attachment, but its too big, and i can't send just one form?

 

[boblarson]

I would send it as an attachment, but its too big, and i can't send just one form?

Have you tried compacting (Tools > Database Utilities > Compact and Repair) and after doing that, zip it using WinZip (or something like it)?

I've had a lot of people tell me their database is too big to post and I asked them that same question, they tell me yes, and when I have them email it to me I try the exact same steps and it gets it small enough. So, pardon if it sounds like I am trying to be harsh, but I'm not, I just want to ensure that you have tried BOTH of those steps, in that order, before telling us it is too big.

 

[virgosam20]

i've done both and it's still 2,570kb when compressed..

 

[boblarson]

i've done both and it's still 2,570kb when compressed..

Okay, just had to make sure. I'll PM you and you can send it to me.