Recent content by Vulfson

Hello everyone. I've spent a while searching these forums, and I can't seem to find the solution to my problem. I have a form that updates a main table in my database. The main table has two ID number fields, that reference other tables. On the form I have a cascading combo box, that inputs...

Hello everyone. I am trying to create a drop-down box that displays the values of another field. The problem is that the combo box is both related to the other table, and is part of a composite key. Table1 ID -Pkey ContractNo -Fkey ContractID -Fkey Table2 ContractNo -Pkey ContractID -Pkey...

Thanks, that did help. I had to do a little bit of work converting it for use, but that was pretty much what I was looking for.

On one of my forms, I have a print form button that prints the form to the default printer. It's the standard button added by the wizard in design view. How do I change it so that rather than printing to the default printer, it opens the print dialogue window, so I can choose which printer to...

Thanks for the reply, and I did find a way to do it. It's not the most elegant solution in the world, but you can brute force the problem by making a custom query that accesses the table multiple times. I think this would be a problem with a database that was intended to grow, but this one will...

Hello everyone. I have an odd question, and I'm not even sure its possible. One of the projects I am working on requires me to display the status of 8-10 items on one page. Normally this wouldnt be a problem, I would simply build a form in tabular format, or the like, displaying each record...

Thank you EVER so much. This solved the problem on the first try. Thanks again!

Thanks for the replies. I've got a relatively limited version of the same query posted below, that gives me the same error. The real query also includes more details from each table, but no attributes related to any other table. SELECT Action.[Action ID], Action.[Document Number]...

Hello everyone. Total n00b here, trying to accomplish what should be very easy. I am running a query which looks through two different, yet related tables. In each table is an ID number for a company. I am trying to get the name for the related company (which is stored in a separate table) to...

That's Great! Solved all my problems, especially when I enable the DAO software. Thanks a bundle!

Hello everyone. I am attempting to calculate the number of working days over a period of time for my company. I found a neat tutorial to write a public function that calculates the number of days between two dates that aren't Saturday or Sunday...