Search results

Hello all, I have a problem that I need solving. I am working on creating a new database for a summer camp program. On the table, I will have Registrant Info, Class Info, etc. Under "Class Info" I want to add a drop-down box to select either "Session 1," "Session 2," or "Session 3." There are...

Simple... as you hinted, the data type needed to be changed to 'memo'.

Nevermind, issue resolved!

I'm not sure... the 'Selection Type' is set to text box. Is that what I need to change?

On my form, I have a text box for entering notes on a particular contact. While enter extensive notes for a contact, it stopped mid-way and would not let me enter more text. Is there a letter/word limit? Any ideas of how to fix this? Thanks!

Oooh, that did it. Thanks!

It's already in single form view, so I suppose that's not the problem. I tried switching it to continuous view and that didn't seem to change anything. Any other ideas?

Hello, In design view of my form, I have placed a few fields in the header area, so that they will remain stationary as I scroll up/down my form in form view. However, when I switch to Form View, the header and the fields in the header are no longer visible. Can anyone help? Thanks!

No, the person who held my position at my job before me created them. My boss hired me to clean up the mess.

Thankyou for the help. Sometimes I feel like it will take a lifetime to re-do the mistakes of the original designer of my db's :eek:

Thanks for the help. What I'm wondering now is why this is happening now? The default value was never set to "0" before, yet the boxes never appeared this way until recently.

The only ones that are ticked are the ones that I have already ticked when entering the records. If I don't tick them, they stay green. If I untick them, they are empty.

Okay... hope I'm doing this right. Under the "categories" tab on the form, you can see all the check boxes are green.

Classic newbie statement: I'm not sure how that's done!

I did, but they were already set to "No" :confused:

Thanks for the suggestion, but that didn't seem to fix the problem at all. Any other ideas?

@boblarson, Not sure how to do either of those... can you help?

Tried it, didn't work...

This may seem like a silly question, but I know little to nothing about Access so here I go: I have a form used for registration. One of the elements in the form is a check box to identify whether or not that particular registration was canceled. I have used this form for a very long time, but...

No worries, we cracked the case! It was a really simple problem, too. My supervisor was opening the database from a folder on her desktop. She thought she had created a shortcut to that DB, but she had actually just copied it to her desktop, creating a whole new file. She had been entering the...