Search results

Well like I say, I'm not really sure. I know very little about SQL, as I tend to just use Access' query designer (I know it's quite lame but hey, i'm lazy and can't be bothered to learn SQL in any depth!) so I'm probably not much help. But I have had many problems with wildcards before and it...

I am probably wrong but you could try enclosing the Like in single quotes: 'Like "*"' I seem to recall having similar problems such that the Like has to be included as part of the query criteria - not just the wildcard. Like I say, I'm not exactly sure but hey, it's something right! :p

Ok thanks. In the end I remade my data structures and is seems to work better. Thanks for the reply anyway!

Hi all, I have two tables, TBL_Students and TBL_Email. Each of these tables have a field called Category, which allows multiple values from a list. Is there a way to return records from TBL_Students where at least one value in TBL_Students!Category = at least one value in TBL_Email!Category...

Stupid me. That's only 10 characters! Thanks

So why would 10 characters be rejected?

Try in the criteria for manifestnum

Hi all, I have a primary field in my table called Membership_Number. This is a Long Integer data type. Is there any reason that anything more than 10 characters is being rejected under run time error '-2147352567 (800200009)' The value you entered for this field is invalid TIA

It OK, I just needed a 'Like' at the beginning. Thanks

It does have to pop up, but it just wont show anything unless I click everywhere on the screen. Anyway, I got around it by requerying the form after 5ms, and then setting the timer interval back to 0. This sort of works. Thanks anyway.

Ok. Its for a badminton club. If the league format is mens, show only men. If the league format is ladies, show only ladies. If it is neither (i.e. league format is mixed or combo ...) show both men and ladies.

Hi all, I need an iif statement in my query criteria that works as follows: iif([Field] = "FirstPossible","str1",iif [Field] = "SecondPossible","str2",*) The problem is, I'm not sure how to display all of the records if neither the first iif or second iif returns true. Any ideas?? TIA

Unfortunately, this doesn't work :( It seems to be fine, unless I set pop up to Yes. Then it breaks...

Its OK. Thanks for all your replies. I decided I was completely over complicating it and thus didn't even need the SQL. Thanks anyway!

Hi all, This is driving me mad! I currently have a report in my database which, when opened, should maximize. Private Sub Report_Open(Cancel As Integer) 'Maximise the window DoCmd.Maximize End Sub Every time this runs, my report looks like picture123.png To actually view the data I have to...

OK. This is what it returned: INSERT INTO TBL_MemberLeagues ( League_ID, Member_ID, Registered ) SELECT TBL_League.League_ID, TBL_Members.Membership_Number, False AS Expr1 FROM TBL_League, TBL_Members WHERE (((TBL_Members.Membership_Number)=56545210)); I don't know much about SQL so is this a...

Still no luck. It's really confusing me. Thanks for the suggestion though! Keep 'em coming!!

Hi all, I have the following code: Private Sub Membership_Number_AfterUpdate() Dim SQL As String SQL = "INSERT INTO TBL_MemberLeagues ( League_ID, Member_ID, Registered )" & Chr(10) & _ "SELECT TBL_League.League_ID, TBL_Members.Membership_Number, False AS Expr1" & Chr(10) & _ "FROM...

Oh OK. I think this works now: Private Sub Export_Click() Dim projPath As String Dim checker As Integer Dim bool As Boolean bool = True checker = 1 projPath = CurrentProject.path & "\Exported Data " & Day(Date) & " " & MonthName(Month(Date)) & " " & Year(Date) & " (" & checker & ")" If...

I thought by changing the variable, "checker", this would update "projPath"