Recent content by Scottie

I guess I'm a little delusional in getting this working :) I'll keep plugging away and if I stumble onto something, I'll let y'all know!

I've kept trying, and to simplify it, I've been attempting to create a query that displays fields which might be similar... Company table includes (in field [Company Name]) Daryll's Plumbing Henrys Housing Pauls Pipes Professional Plumbing Services Tim's clothing blacklist table includes (in...

Sorry to bring up an old(ish) thread guys. I had given this a further look recently after getting my DB to a good solid working state. I am looking back into this because I'm not going to be around long where I'm working and would like to make this feature a bit more user friendly to manage...

Thanks for showing me that R.G, gives a good explanation of why it's only displaying 255 characters. I'll use UNION ALL! Thanks again for your help!

I have this same problem, although when I enable the 'can grow' field, the text still gets cut off. I think what's (frustratingly) happening is the text box isn't showing more than 255 characters even though the field it is displaying is a memo field. A label can probably display the amount of...

Thanks for the tip! I'll give it a go!

Ok, yeah I tried that string from another thread Bob, but I guess it was the apostrophe that was getting in the way. Thanks again for your comments guys, I'll see how an SQL query goes and if not, I'll get to implementing ID's. Thanks again for your time guys! greatly appreciated! Scottie

I've managed to get the criteria working (thanks to this thread: http://www.access-programmers.co.uk/forums/showthread.php?t=128253&highlight=dcount ) but is there a way to use a wildcard in it to allow for any 'like' entries? From what I've tried, the LIKE operator cant replace the '=' in the...

No ideas? I've had a look through MSDN and through these forums, but I haven't managed to get the criteria working. Here's the database I'm working on: again, any help would be greatly appreciated. Scottie.

I've hit a snag... It seems the error is in the criteria... a test I have run is: txtCount = dCount("[name]", "[blacklist]", Me.Company_Name.value = "[name]") returns 0 even if there is a match txtCount = dCount("[name]", "[blacklist]", Me.Company_Name) disregards the criteria and counts all...

woa didn't think of that! Yeah she's working a charm now! Thanks again for your really fast and accurate response Bob!

Thanks guys, I was able to get this going by using IF Statements to get the check box results and enabling the appropriate buttons in a switchboard as required. Cheers, Scottie.

G'day Guys, I'm trying to include a variable Blacklist of sorts in my database. I have my main form entering company details into one table. In another table, I have a list of names which I would like to refer to to prevent them going any further in the database. I'm trying to get the form...

Ok, when creating my example db I got it to work with placing the WHERE statement in the union query and referring the particular field to the form control value. So after fiddling around with my actual db, that ended up working also. Now to try and create a link to the more detailed forms...

Ok, so I've kept digging, trying to find different ways of doing this... Referring the query to the form control was close, but it kept getting confused as the form opened as the combo box wasn't displaying a value. Other methods included general filtering and search methods, but the area...