Search results

This site seems to have the most on using the ribbon...... http://www.accessribbon.de/en/index.php?Access_-_Ribbons

Take a look at this.... Sounds like what you want. http://msdn.microsoft.com/en-us/library/aa434076.aspx

Sounds like you already know the relationships...... 1 student can have many application headers 1 application header can have many application lines 1 application lines to many courses Each tab would simply be a subform based on a criteria using date as filter. So build your form with...

I've seen the Alpha site.. looked at the Alpha 5.... might play with a trial to see what it's all about..... Don't care much for that Accesstables.com... Looks like it is simply the old Access DB replication...... That never worked right...I can see multiple users changing records.... who wins...

I was browsing the web for DB applications....Sorry to say I'm getting frustrated with the direction MS is taking Access... And found this... Sounds like this may blow the Hell out of the mega price of Sharepoint and allow Access on the net for smaller businesses...... Anyone more familiar with...

Maybe I'm dense here but I don't follow....... Lets say I execute this code from a button.... Would it not with "For Each ctl In Me.Controls" start with the first control and then with the "Next" move to the second and so on? And it would set the value of Textbox21 = “NSS” only if it hits a...

I noticed I left off one thing from my code.... The last line... Public Function FieldValidate() Dim ctl As Control For Each ctl In Me.Controls If ctl.ControlType = acComboBox Then If ctl.Value = “1” Then ‘This assumes the value for answer of YES is 1 in your dropdown Me.Textbox21 = “NSS” Else...

If called from the before Update of the form, why is it necessary to have the "YesFound" assigned a value?

I think you could simplify Steve R's answer even further and skip the Boolean and just assign the value to your textbox...... Public Function FieldValidate() Dim ctl As Control For Each ctl In Me.Controls If ctl.ControlType = acComboBox Then If ctl.Value = “1” Then ‘This assumes the value for...

Right click and put your form in design view, then right click on that same "blank space"... you don't say if it is a textbox or just part of the form, but.... After you right click you will see. Then click on "Properties"... look at "events"... look at the "onclick" and see if something is...

Sounds like your "Comment" field is in the same table with "Photo". To have the setup the way you want it, you will need the "Comments" in a separate table with a one to many relationship to the photo table. One photo can have many comments.

Well, if I am understanding this correctly..... "Modules" are maybe something like classes? ...... I would have a main form... with student information and OptionID. Then a subform for modules. The form and subform would be related on the OptionID field. Thus you could have many module entries...

2007 uses a lot more macros.... Unlike previous versions. You need to first "Convert macros to VBA" then you would be able to see the code. Sorry, I forget where that option is in 07....Only up to 03 on this machine... Maybe someone can give the path.

First, sounds like you are joining two tables on the "Options" table. You need one more field ... something like "OptionsID". Then simply build a query from your tables needed, then build a form using that query as your source.

That code gets a little lengthy..... See if this post helps you out.... http://www.access-programmers.co.uk/forums/showthread.php?t=179760&highlight=validation

So it sounds like you are just trying to have one record in the results of your query....... Put a parameter in the recordID of your query..... Look at the query grid...under the RecordID field "criteria" reference the ID on the form. like...... [Forms]![frmOpenForm]![RecordID]

Do a search on "validation" A lot of info on the forum about this.

Here's a couple of links... and some thoughts on if you really need to do it that way.... "archive records" vs say an "Inactive" checkbox...... http://office.microsoft.com/en-us/access/HA010345681033.aspx http://allenbrowne.com/ser-37.html

OK, I added the concatenated field to the query. It's not too difficult... First I called it "compiled" probably a bad choice of words, but... As you see to build this you click on an open field area in the query grid... Type your field name "Compiled" followed by a colon (:) Then all it is is...

A little searching around the site HiTechCoach gave you should give you a lot..... but heres an example of what to look for.... <tabs> <tab id="MyTab1" label="My Tab1"> </tab> <tab id="MyTab2" label="My Tab2"> </tab> <tab id="MyTab3" label="My...