Search results

There are some examples of using comboboxes here: www.databasemakers.com

..by the way when you get to 10 posts then you can include links!~)

I'm glad you got it sorted... and regarding resources then they are unlimited with MS Access just Google away!~)

..or DoCmd.GoToRecord , , acNewRec

You could use this one!~) DoCmd.RunCommand acCmdRecordsGoToNew

There is a download with some free examples of combo boxes here: http://www.databasemakers.com and if you upload your database here then we could have a look at it!~)

Not really without it getting to messy... You could do it on the Enter event of the combobox: Private Sub YourComboBox_Enter() Me.YourComboBox.Dropdown End Sub There is a download with free dropdown box examples here.. http://www.databasemakers.com/

..yes that's true if you want case-sensitivity. Regarding your code then this part: If txtUsername = DLookup("[Username]", "tblUserLogin", "[UserType]='Research'") Then 'Close logon form and open The Research Form Me.Visible = False DoCmd.OpenForm "frmCountry" ElseIf txtUsername =...

if you just want to use what you got then: If txtUsername = DLookup("[Username]", "tblUserLogin", "[UserType]='Research'") Then would be: If txtUsername = DLookup("[Username]", "tblUserLogin", "[UserType]='Research' AND [UserName]='" & txtUsername & "'") Then

it's these onces that's wrong: If txtUsername = DLookup("[Username]", "tblUserLogin", "[UserType]='Research'") Then The DLookUp will find the first person of that UserType..

..we would need to see how it works now... can you upload a version or show us the login vba code?

..actually all you need to do is add a field to the Activities table called: SchoolID make the data type number and leave it at standard setting. Then go into the design of the Statistics Form. All the week subforms has to have their Link Master Fields property and Link Child Fields property...

yes... a relation to the id on the main form.. Upload the database as it is now and I will show you how to do this!~)

yes, that's right!~)

By the way I changed from filtering through a query to filtering directly on the form. I think that will be easier for you to update, when you have to add new weeks!~)

Go through your week subforms (I've done the first 3) and do the following: 1. Change the Recordsource on the forms to Activities 2. Add the to yellow fields, it's a hidden year field and a hidden weekno field. In the following I use week1 as example: 3. Add Default value 2012 to YearInCity...

Hi, when I get a moment I will have a look!~)

You need a year field and a week field in your activities table. Then you need to change the record source on your week subforms from activities to a query that filters the specific week. ...and then you need to remember that you need to add the fields to the week subforms. You can set visible...

When you go into design view on the form notice that the event On Dirty on the property sheet is set to the value false. This is telling the form that when there is being made changes it will fire a macro named false, but you don't have a macro called false. Therefore the error message...

Hi, Change qryIncome2010 to: SELECT tblIncome2010.IncomeID, tblIncome2010.ID, tblIncome2010.Type, tblIncome2010.Amount, tblIncome2010.Frequency, tblIncome2010.Notes, iif(not isnull([Frequency]) and not isnull([amount]),(DLookUp("Multiplier","tblFreq","FreqID = " &...