Search results

...but now I have a problem getting this working! I get a run time error on the line: Me.frmsubClients.Form.RecordSource = "SELECT * FROM qryClientData " & BuildFilter "2001: You cancelled the previous operation" Why??

Understand that - thanks very much for your help.

I have two drop-downs on a form along with a child form that shows data based on a query. If both drop downs have selections, say date and dept. then the query would change and the child would show the data - that works fine, but what if one of the drop downs didn't have a value selected, as in...

Sorry, Bodisathva, you've lost me there a bit! Could you please explain a little more...

Application.CurrentProject.Path shows me the path of the current db, which is what i need, but it shows as the mapped drive letter when waht i really need is the full UNC path - can this be done?

Is there any way to edit the hyperlink field in my table, I'm thinking along the lines of an update query? The database has thousands of records and the user has not typed any text into the 'Display Text' part of the hyperlink. This means that the stored hyperlink is double size because if no...

Is there any way to edit the hyperlink field in my table, I'm thinking along the lines of an update query? The database has thousands of records and the user has not typed any text into the 'Display Text' part of the hyperlink. This means that the stored hyperlink is double size because if no...

Well, rodger me with a fish fork! That works perfectly. The only thing is that i don't undertand exactly how it is achieving the goal. If someone has a few minutes maybe they could help the learning along?...

Have searched the forum but cannot find a suitable answer... I have duplicates in my table that I need to delete but leave one existing record, e.g.: ID Part Family Colour Cost 1 123456 HHH M98765 12.99 2 123456 HHH M64975 12.99 3 123456 HHH E79461 12.99 4 123456 HHH...

Have searched the forum but cannot find a suitable answer... I have duplicates in my table that I need to delete but leave one existing record, e.g.: ID Part Family Colour Cost 1 123456 HHH M98765 12.99 2 123456 HHH M64975 12.99 3 123456 HHH E79461 12.99 4 123456 HHH...