Search results

I have a strange problem (strange to me) with opening a report. The report is based on 2 tables. (1main 1 sub) It is opened from a form using DoCmd.OpenReport "rptVenue", acViewPreview, , "VenueID = " & [VenueID] This works fine if both the main table and the sub table have data but if...

Sounds about right to me thanks

It does work but i am not sure why you should have do do this as on load it is set to exactly the same thing through the SQL. Access is a funny thing!! Seems to work fine with the full search form. If anyone knows why this is the case could they please explain. Thanks MaxJam Steve

There is no set recordsource for the search form as it is not used to display records as such. Only the list box is based on records. Does that make sense? It seemed to work fine before i put in the calculation on the load sql! Steve

On the load of form 1 can you not just set me.Filter = "" and me.ServerFilter = "" or am i missing something here

Try this link to Common Naming Conventions Steve

SQL in a form - Problems I am using an SQL query to update a listbox in my form but as the form loads i get an error that i don't understand. I have created a query that seems to work but when i use the sql in the form it doesn't :confused: :confused: (In frmSearch) I have attached it in 97...

I didn't notice ... I musta put it in correct when i typed it in automatically ... Either that or i can't read properly!! :D :confused:

Thanks a lot mile - Works like a charm!! :D :D

find record problem I am using a simple search to goto specific records but. Dim rs As Object Set rs = Me.RecordsetClone rs.FindFirst "[IDCode] = " & "'" & strPersonIDSelect & "'" Me.Bookmark = rs.Bookmark I have a couple of records with a " ' " in them and it...

Go to the windows/font folder in the file menu click "install new font" That should do it.

What is the definition of embarasment? Running into a wall with an erection and breaking your nose first! These four guys, an accountant, a chemist, an architect,and a govenment employee, are discussing their cats, each claiming to have the best trained. The accountant says "Calculate, do...

Thanks mile Knew it was something simple that i was missing.

I am sure that this is fairly simple but nothing ever is with a listbox. I have a cmd button that runs some code but i need it to check to see if there is something selected in the listbox first. The listbox is set to MultiSelect - None Thanks for any help Steve

i use something like Private Sub Command2_Click() If IsNull(Me.Combo0) Then With Me.Combo0 .SetFocus .Dropdown End With End If End Sub Hope that helps

in form current event put call cboClientType_AfterUpdate That should do it Steve

What have the hulk and michael jackson got in common? They both change colour and put the willies up the kids!!

Q. What do you call a sheep tied to a lamp-post in Wales? A. A leisure center

HeHe it's one of the reasons i never go into Hull unless I can really help it. I live outside of Hull in a different county "i think".

A few miles outside of Hull!! It's a great place honest lol