Search results

I have combo-box, with several fields, that are either "active" and "not active" and I was wondering if I can add a check box "check if active" (active and not active fields) And if I check the check box, only active fields apear when I scroll in the combo box. is this possible? anyone...

I can tell you all datatype options: short text long text number date/time currency autonumber yes/no OLE object hyperlink attachment calculated lookup wizard

I got 2013 version of Access. Trust me, it is there.

When I'm in a table, and in design view, I can pick number, short text, long text etc.

What is the difference between "short text" and "long text"? Both seem to have 255 characters limit. Also, and ideas to work around it? Is there no way?? ps. I have Access 2013, and I found a solution, that you can use Memo instead of Short text. But the problem is, that there is no...

Exporting report to PDF works sort of easy. But how does one design the layout of the report, to make it look good on "exported excel files"?

I have finally solved it. Tried making a new database, and the problem remained. You wanna know what helped? *drum roll* instead of having Yes and No, I changed it to "active" and "not active". And it worked. why I don't know. Perhaps access has made a internal rule to not allow...

Do you guys ever use Microsoft InfoPath? for these kinds of things?

got it (i think), tables are BE and forms are FE. 01 So if I want to migrate to SQL server. Is there a conversion option in Access 2013 that one can simply do? I haven't found one, except when I start a new database, I have a "web app" option. But that option requires me to have the internet...

So, I am working on this database in Access 2013, it has forms, reports etc. (you can view my other newbie questions). Anyway, the database is to be converted into SQL (?), and be somewhere on some server of the company where I work. But I just don't "get" how the whole thing works. If I...

So this database that I am working on, it will be viewed by several people, and we would like there to be a button called something like "report error". Basically when you see something wrong on the database, you can report the error by clicking on a button, and you get sent to your e-mail...

im using a formview. And I have tried other fields, and it works to use conditional formatting on other fields, except for this misserable field that in the original table works the same as the other fields (or columns). its called ACTIVE and it the type is "short text". And it says either yes...

no listen, I really am grateful for the help.. :) I will figure it out. At least I know now how to do it, once I get it working. :)

I haven't figured it out. But I have tried to change the conditioning format on several fields, and it works just as it should. The only difference between these and the "active" field, is that I added the field to the original table, and then added it to the form through "add existing fields"...

its not a check box... its just a "short text" column.

No I can't post a photo, rather new to this forum. But I just tried to change the conditioning format of another field, and it worked just fine (!) So I know that I am doing it right. There is just something about the "yes/no" field that doesn't work.

just doesn't work. if as I open conditioning formating for the object (yes/no). I pick "field value is" and "equal to" and then write "yes", and change the formatting (so it gets green). But when I go back to the form, view mode, no changes. still the original black color. Very annoying...

oh cool, yeah I will try that.

doesn't seem to work. I can't pick "field value is" and "equal to" and then write "yes", and change the formatting. it has to be a number right? Should I use "expression is"? Im lost..:(

oh cool. that works great. :) Found it. Thanx.