Recent content by Geodon7

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...

It is the FinConID that is coming up Null. If I hit "End" instead of "Debug", and then enter more records, the sum works, so it's only for the first entry that it comes up Null. Do you know how I could avoid this?

Thanks for getting back to me so quickly. I used the code that you provided me. (gol4: it is via a form). I will paste my code below. For some reason I get an "Invalid use of Null" error when trying to update the PaymentAmount in the subform. Any suggestions as to why? Thanks...

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...

dz, For some reason, I can't connect to my email right now, so I figured I would post this to you here just to let you know I finally got it to work! The selections are visible and the query runs perfectly! I had to do some tweaking, but I have the gist of it now. Thank you so much. You don't...

I'm pretty sure the second combo box contains items because when I look at the records in the corresponding table, I see a value entered in the project field. As for the things that need to be clarified: -Projects2.ProgramID is a Long Integer. It is the Autonumber field of the Programs table...

dz, So I'm almost there, and yes, I'm still trying to figure this darn thing out! But there's one (maybe one and a half) more problems. In the second dropdown box, the options are not visible. I can tell there is more than one option because of the size of the dropdown box, and it also...

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...

There's only one column in the combo boxes. Here is what I have in the AfterUpdate Event. Private Sub ProgramName_AfterUpdate() Dim strQuery As String strQuery = "Select ProjectName From Projects2 Where ProgramID = " & Trim(Str(ProjectName.Value))...

dz, I put that code in using the combobox names and field and table names that I have and I'm getting an error. My entries are numeric, so I used the second list of code that you included and I received an error saying, "Syntax error (operator missing)in query expression 'ProgramID =' Do...

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 added a field to the table, and the dropdown box selection now gets entered into a field called "ServiceBoundBy". Everything else is still basically the same. Am I missing something else? I changed the code so that everything works as it did yesterday, but I still can't get the...