Search results

Too many columns If you compact and repair the database you should be able to add columns again up to 255. However, I agree with the comments above that you may have to review your design. Good luck.

What is the question? Wile I agree with the posts above there is something I like to add. I have noticed that frequently people are not able to explain in clear language what their problem is. I read the question several times and I still don't understand what they mean. Sometimes another user...

New Record In the Properties of the Form change Data Entry (on the Data Tab) to: YES.

Tab Color Don't know RGB but try ColorCop, a handy freeware program that gives you the color info on any item on the screen. Here's the link: http://www.prall.net/ Good Luck

Combobox Check out this link: http://www.utterangel.com/pages/access_downloads.aspx You can download an example called 'Combobox - Populate a Form' that shows you how to do it. Good Luck

Relink tables Perhaps this link helps. http://www.rogersaccesslibrary.com/download3.asp?SampleName=RelinkOnOpen.mdb Good Luck

Lookup Check out this link: http://www.fontstuff.com/access/acctut20.htm or this one: http://www.microsoft-accesssolutions.co.uk/not_in_list.htm

Buttons Open the Tool Box, make sure the Wizard is selected and drag the button control onto the form. The wizard will guide you through the process. PS. Please next time post your question in the right forum. :) Good Luck

Filter May be this link helps: http://www.techonthenet.com/access/forms/filter_form.php

Arrow Check this link: http://www.applecore99.com/frm/frm011.asp

Combo Box It doesn't work because the necessary code in the After Update Event of the Combo Box is missing. Check out this link: http://allenbrowne.com/ser-03.html Or search this forum, there are many good examples around

Date Try this in the form: Me.Datefield = ""

Forms Instead of Datasheet you can set it to Continuous Forms. A lot easier to format and control.

Tab colors Please search the forum, there are several posts regarding this subject.

Calculations If you search the Forum you will find plenty of information about calculations and how to implement them, as well as tips about importing spreadsheets.

Sum OK, try this: =Sum(IIf([Field]="Novice",1,0))

Sum Try this if 'Novice' is the name of the field. =Sum([Novice])

Flickering Are you using Access 2003? The flicker problem is a known issue, it happens with labels on the tab control. You can work around it by changing it in a text box.

Sum Set the Control Source of Field 4 to: =[Field1]+[Field2]+[Field3] Set the default value for fields 1,2 & 3 to '0'

If-Then In the On Mouse Down property try something like this: If Me.label12.Visible = True Then Me.label12.Visible = False Else Me.label12.Visible = True End If