Search results for query: *

I need to run a query upon the click of a button that will check to see if the Project Name entered in the form already exists. If it does, then I need a message to come up saying it already exists. If it doesn't, then no message is needed. I'm not sure how to do this (or set it up), but I...

What criteria would I use to sum all payments made on a single invoice? Each payment has it's own ID (PaymentID) and each invoice has it's own ID (InvoiceID). I need to have the criteria sum the payments relating to an individual InvoiceID. Any suggestions would help! Thanks everyone.

I have a subform that is linked to the parent form through a field, BillingID. On the subform, there is a field for payment amount. There can be more than one payments made for each BillingID. I need the payment amounts to be summed and display the total amount paid so far for each BillingID...

I have one form that asks for information that I want to be entered into 2 tables. I'm pretty sure I have to use "Cascade Update Related Fields" but I'm not sure how to do that? I'm also pretty sure that means the fields have to be related, but I wasn't sure how they should be related...

This is a very simple question, but I don't know VB well enough to know how to do it. I have a dropdown box, and I want to know what the value of it is being stored as so I can know if I am referring to it correctly at a later point in my code. This is the code I have: Dim test As String...

My problem is that I need the contents of a dropdown box to change based on a previous selection in a different dropdown box. More specifically I have a table with 2 fields, Project and Program. There can be Programs with more than one Project associated and there can be different Programs...

I have a table that has a lookup field with 2 options that I have entered, "Project Request" and "Contract". Then I have 2 other fields, one called Project and one called Program. Depending on the choice made in the first field, I want the table to look up Program values in...

I am having 2 problems with a portion of a form I am creating. The way it is set up is that there is a dropdown with 3 options (contract, project request, and other). If contract is selected, another dropdown appears with projects related to contract, if project request is selected, a dropdown...

I've posted questions about this before, and I'm making progress but I still can't get it to work the way I need it to. So I have an option group with three options: contract, project request, other. Next to the contract and project request options there are dropdown boxes. The dropdown...

I'm trying to create command buttons for Next, Previous, New, and Save/Close. I've done this on one other form, but I tried to do it on another form and I got the following error message..."The expression On Click you entered as the event property setting produced the following error: A...

Sorry for the basic question, but I'm not very familiar with queries. Anyway, does a query update on its own (ie. when it's opened or referred to) or do you have to update it? If it needs to be updated 'manually' is there a way to auto-update? Thanks in advance, G

Very simple question here that will hopefully allow me to figure out my bigger problem. What exactly are BeforeUpdate and AfterUpdate, meaning when would an event procedure take place if I made it for Before/AfterUpdate? Thanks for everyone's help with my questions!!

In the database I am creating, I have an option group with 3 options. 2 options, if chosen, are followed by drop-down boxes. The third, if chosen, is followed by a text-box. When one option is selected, the other two are disabled. The problem is that if you choose one option, then select...

Is there a way to password protect the click of a command button? If so, how? Thanks!!

THis is a fairly simple question that I can't figure out...When the user gets to the end of a subform, I want a new record to be created. Instead, what is happening now is that it cycles back through the existing record. I'm sure there is some simple answer, I am getting frustrated and can't...

I am trying to create a form in which for the first field you have 3 options (say option1, option2, and other). Only if the user chooses 'other' do I want a field below that to become accessible where the user can enter what the 'other' is. Can anyone help me?