Search results for query: *

Once again, exactly what I needed. ; ) Thanks very much, all of you.

It is, as suspected, rather trying to enter the entire product details to find the match - is it terribly complicated to shift it so that a partial match will produce results? I think I've tried most of the possible combinations of brackets and asterixes known to man to try and allow...

Aha! It worked on second try, for some reason. Thanks awfully. -Ciz

Removed the dots from the criteria... the return, alas, is still the same. Fancy that.

Ideally they'd be able to enter a partial match since we're working primarily with biological and chemical compounds (and no one in their right mind wants to enter Boc-Z-Ala-etc-etc-etc), but right now I'm more concerned with getting the query to work at all. Any help on the latter would be...

Here goes... SELECT Products.ProductID, Products.[Catalog Number], Products.[Product Details], Products.UnitPrice, Products.SupplierID, Suppliers.SupplierName FROM Suppliers INNER JOIN Products ON Suppliers.SupplierID = Products.SupplierID WHERE (((Products.[Product Details])=[Search products...

I'm trying to create a fairly basic parameter query that will prompt users to input search criteria to looks for specific products in our database, but something off is happening. Once I have everything in place (including the bracketed "What do you want to search for?") and try to run the...

Well... I'm not using the autonumber *yet*, but the order ID (which is the primary key for the order table) does correspond to the Order PO# - which may, indeed, be a mistake, though it seemed like the most specific and concrete way to number them. Is there any way to set the Order ID to...

I'm building a series of databases to keep track of my company's orders that we will eventually switch to to place orders as well (with printable and send-able POs, etc). As I've been entering data, I've been entering old PO numbers as the Order IDs, but I would like to switch to an autonumber...

Ah! Of course - thank you.

A problem that I'm sure reflects my extremely rudimentary knowledge of how this all works - where do I indicate the file to be attached? Because erm... I keep getting a missing reference notice, but it seems to otherwise be working like a charm. Thanks again. -Ciz

Thank you very much!

Sincere apologies that this question is posted twice - it occurs that this may be a better forum for it than the VBA module forum. I'm creating a database for our company that is letting us put together orders quickly (we order items from about 75 different companies, so moving them all to a...

I need to figure out a way to automate the sending of e-mails from a form that will be diverted to different recipients based on a value in one of the controls. (To one recipient if the value is under 500, another if the value is 500-1000, another if it is 1000-5000, etc). I'm pretty much a...