Replies

Thanks Tom. This is great info.

Thanks for the offer Wendell – I was going to see if I could find something in my Access book re storing a path. Do I just create a field and put a hyperlink (path) to the file????

Hi Wendell – got late and didn’t read your response until this morning. Thank you very much. I know it will be a lot of work to change but we can’t have the db crashing. The pictures are part of our catelogue.
Thanks again. This is such a great feature (the Lounge) to have available.

I guess it was a question – that I really answered myself when I wrote it – . Thanks so much for all your help and time on both questions.
Robin

Hi Again.
I would link them to the actual .jpg file?
Robin

About the same here. Temp is 7 cel. Have you ever been to Canada. I thought Melbourne was always very warm. This is your summer isn’t it?

Pat I posted that other problem with a table that has gotten very large – any solutions that you can think of?
Robin

Hi Pat – no they aren’t unique – they give the name of the committees that the people belong to (which can be more than one). Thank you very much that works for me.
How are things in Melbourne today (or tomorrow) for me.
Robin

Thanks Charlotte. I had heard reference to ADO and DAO but didn’t know what they meant. I also went into help and read up on References. I went into Tools, References and there is a whole list of them – some checked and most not. I did add a couple that sounded like I might need them. There is sooooo much to learn. Thanks Again. Robin

What kind of dogs do you have. I have an American Eskimo Miniture – her name is Samatha but I call her Sammy. Your day is just starting and ours is just over with – it is now 10:30 p.m. Thanks again take care.
Robin

I live in just outside Edmonton, Alberta, Canada (St. Albert). What is the weather like there. Here it is cold (9 Celcius) and very windy today. Isn’t it funny – here we are communicating from other sides of the world. You are very clever with Access. You must have lots of training (background) with the program. Thanks again for all your help. I was so excited when it worked.
Robin

Oh Pat, Charlotte,John and everyone I love you all dearly – it worked after all that. Thank you so much.

Where do you live???? Oh Oh – now what???? I have Access 2002

Pat – I did catch that name error in qry Query2 and added the msg box you suggested – but now I get a “user defined type not identified error and it highlights the Dim db AS database. Hope I’m not taking too much of your Friday night time up.
Robin

Hi Again,
This is what I typed in at the On Click code. It won’t run at all.

Private Sub Command2_Click()
On Error GoTo Err_Command2_Click

Dim db As database, qdf As QueryDef, strSQL As String
Set db = CurrentDb
strSQL = “SELECT TOP ” & Me!textTopN & “ATA.Surname, ATA.Title, ATA.Prename, ATA.EmailAddress, ATA.HomeEmailAddress, ATA_Committee.Lcomm, Committee.TabComm,ATA.EmailAddress, ATA.HomeEmailAddress FROM ATA”
strSQL = strSQL & “Where…..”
db.QueryDefs.Delete “qry Query2”
Set qdf = db.createquerydef(“Query2”, strSQL)

Dim stDocName As String

stDocName = “Query2”
DoCmd.OpenReport stDocName, acPreview

Set db = Nothing
Set qdf = Nothing

Exit_Command2_Click:
Exit Sub

Err_Command2_Click:
MsgBox Err.Description
Resume Exit_Command2_Click

End Sub

Pat thanks I will give that a try. I create a form with an unbound text box? How do I create a query on the fly . As you can tell I’m new to Access. Thanks for your patience and time.
Robin