Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: baggyboy26
  • Content: Threads
  • Order by date
  1. baggyboy26

    #Error when record source changed on form in calculated control

    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...
  2. baggyboy26

    Please don't shout!

    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...
  3. baggyboy26

    Compile Error!

    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...
  4. baggyboy26

    Am I Normal? Normalization

    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...
  5. baggyboy26

    Form Wont Open

    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...
  6. baggyboy26

    Database Structure - Fantasy Football League!

    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...
  7. baggyboy26

    Filter by selection

    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...
  8. baggyboy26

    Dcount Problem!

    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...

Part and Inventory Search

Back
Top