Search results

Thank you for the suggestion. I've tried it and it still doesn't work. I'm probably doing something very stupid. I've attached a stripped down copy of the database if anyone could help. On the form Proposals, I want to select a category such as "Painting" from the Box with the Green Label...

I've spent so much time on this, and now I am almost there. Any help would be much appreicated. I have a form in which I select a category of work from ComboBox "WorkTypeMain". Now I want to filter out all types of work under this category from table "z_ProposalDetailList". In this table...

I'm having a horrible time figuring this out. It's not from lack of trying. Any help would be wonderful. On my proposal page, I want to select the "Type of Work" from a dropdown list, and then select the "Proposal Details" that filter out various types of work depending on what I selected at...

Again, thanks for all the replies. It has been very helpful and I am almost done. I have taken the suggestions and am using another table for the paper trail. But I do wish to still modify the checkbox in my query from my event procedure. It is necessary for what I am trying to accomplish...

Thanks again for your reply. I already have a table set up of all my individual transactions. I don't need to worry about this. I will try to work something out to sum these records up. However, I still would like to be able to change the check box in my query from my event procedure. I run...

Thank you for your reply. I know it's usually not best to modify a table as such, but I feel it is the best way for what I need. I'll give what you said some thought and see if there is another way to do it. The reason I'm not using the dsum and such, is that I'm creating a database for my...

I'm trying to replace a value in a query from an event procedure in a form (afterupdate). I enter a deposit amount, then I select the invoice this is for via a form. I then open up a query on all unpaid invoices. This query shows the total bill, the amount paid to date, and a check box for when...

Thank you so much for your help. Although when using your code how your wrote it, it didn't work (most likely I did something wrong...I'm not very experienced), but using the Me! with SetFocus and RunCommand acCmdPaste that you suggested, I was able to get it to work really quickly. Dim...

I'm trying to take a number entered into a form, then update another table via a query with the same value so I don't have to enter the number multiple times. I've tried everything and nothing works. I'm sure there's a very simple way to do this. I have a form (Transactions - Deposits) with a...

I've tried everything and nothing works. I'm sure there's a very simple way to do this. I have a form (Transactions - Deposits) with a subform (Transactions - Deposits Subform). In the subform I enter an amount paid (AmountSubform is the box name), and then select my Invoice Number from a drop...