Search results

Maybe I'm reading the question wrong, but I've been doing it (or at least what I think he's talking about) that way for 10 years. Maybe I just haven't evolved enough. :) Yeah, I use afterupdate on the first combo box and in the second one limit by the value in the first one. I'm a dino.

I have a product table similar to what you have, and just leave certain fields blank.

Sounds like you need a combo box and a query with an SQL statement for the Row Source for that combo box that should look something like this: SELECT [Table1].[LastName] FROM [Table1] ORDER BY [LastName]; The control source for this combo box would be the table that you are writing the...

On your report go to sorting and grouping, and group on the Product ID Field. Right click on the detail bar in the report in design view. Select Product ID as the field/expression. In the group properties of the Product ID you will want to group on each value.

Peters way looks like it would work better than mine. I needed to keep track of the last time I perfomed the action, so I had to write that record to a table, but the thought process was the same. Just make sure you narrow your time range enough so that you don't keep getting a message box...

Heck, I've done stuff like that at 3 in the afternoon. :-)

I was afraid you were going to say that. Thing is, I'm in distribution, and I carry 20 lines of products, and have almost 25000 products that I import from vendors. Some vendors have hyphens, some don't. Some vendors have hypens in some of their products, while other products by the same...

Yeah, but it worked so well in 97 - and worked for 10 years that way. I haven't even had 2007 installed a week, and now it's little things here and there that grind me. So - dumb question - how do I get the hypens to be recognized in a query sort?

Instead of the time being a specific time, how about a range? I had something similar to this where I would want the inventory to be updated from my database to the website. I of course only wanted it to run once when I opened the database, not every time because it takes a while. So I made a...

What is the error message when you attempt to add data?

I had been using previous versions of Access, and just recently "upgraded" to 2007. I used the search function, and didn't see exactly what I was looking for, so hopefully I don't get flamed too bad if I missed an obvious thread, but here's my situation: In the previous versions of Access that...