Search results for query: *

Hello. This is confusing me. I'm getting #Error in some calculated controls. An unbound combo box updates the RecordSource of my form (Alters the WHERE part of the SQL) but does not always do it withouth producing the #Error. I've tried requerying, refreshing even setting the RecordSource to...

I'm completely self taught ( I can hear you groan) and I'm sure there must be an easier way to do this. When I first started my project the simple Select Case function did just the job. But then as my users demanded more and more options my select case became nested and grew very quickly...

Hello, I've written the following module and when i call it from a button i get a compile error, it expects an =, and i'm not sure why! Any ideas? Public Function WhichWeek(WeekDate As Date, FirstDate As Date, LastDate As Date) Dim db As Database Dim rs As Recordset Dim dteDate As Date Dim...

Hello! I'm sure I'm one of the users of this forum that is not very popular as I'm completely self taught! As a result I have left learning about normalization to last. I know, I know, after reading MANY articles today i now realise how stupid i've been. I think I now have a basic...

Help! I've almost finished creating a form. I have saved it many times before with no problems. As i was updating my form i saved it and was told that there was not enough memory to do so. I then had to exit access. On reopening, the form is there but when i try to open it it does nothing...

Hello, I've been asked to create a database for a friend to help him run his Fantasy Football League. I'm not new to access though I am having problems with structuring my database. So far I have two tables, one with all the football players in. Containing their ID, Name, Postion, Club...

Ok, this is confusing me. I have a database that i need to disable menus etc in order to not confuse my users. One of which is filter by selection. I have used the button wizard to create a filter by selection button. This button does not work on my form but the filter by selection in the...

Hi I'm trying to count some values from a table to display in a textbox. This is the vba code i am using. Me.Ctl4bP2.ControlSource = "=DCount(""[2007]![MathsSum1]"", ""[2007]"", ""[2007]![MathsSum1]='4b' AND [2008]![Year]='Year 6'"")" It returns a value of 8 but when i count them myself...