Search results

Good point, act in haste, look a fool for a enternity. Cheers.

Going loopy-ignore, have answer Hi, Can someone take a quick look and tell me where I have gone wrong, on compile message I am getting is 'Loop without Do'. Dim qdef As QueryDef Dim db As Database Set db = CurrentDb Dim rsProcObjects As Recordset Set rsProcObjects = db.OpenRecordset("select *...

What are you trying to achieve? At the least, you need something to join them on?

Hi, what does the code look like?

If it's just creating the path that shouldn't be too bad. You can either use a form and put some code in that or use an update query. Either way you will need to create an expression that build your path. Should be something like:- "C:/turnings/cards/" & [Product Name] & ".jpg" Cheers.

Like it, thanks.

Cheers, is that saying, my field's value = result of dlookup. My resolved objective would be e.g. item (derived from dlookup) on form's visible property, amend to true Is that what this would deliver? Cheers.

Hi, Northwind is the sample database that is delivered with Access. This might help with the path http://support.microsoft.com/kb/824265 Re driving your images, from memory Northwind does have that does this so should help you. Cheers.

Hi all, Trying to use a dlookup to drive the visible property of the tabs in my form. I'm up to:- DLookup("[Menu_Name]", "tMenus", "[Menu_id]=" & [Forms]![Menu]![ffMenuChoice]).Visible = True Hope what I'm trying to achieve makes sense, if anyone can help that would be great.:confused: