Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Geodon7

    Running a query upon the click of a button

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

    DSum Criteria Question

    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?
  3. Geodon7

    DSum Criteria Question

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

    DSum Criteria Question

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

    Summing Values from a Subform

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

    1 form, 2 tables

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

    Select Case/If-Then-Else Help

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

    Select Case/If-Then-Else Help

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

    Select Case/If-Then-Else Help

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

    Print Value of Access Dropdown

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

    Select Case/If-Then-Else Help

    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))...
  12. Geodon7

    Select Case/If-Then-Else Help

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

    Select Case/If-Then-Else Help

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

    Table Lookup

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

    Dropdown box help

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

    Dropdown box help

    Caution- Your first suggestion worked perfectly with the value=null. Thank you! But I'm not sure I understand your second suggestion. How do I bind the dropdown box? Or if I use the other option you mentioned, how would I go about doing that? Thanks for your help! G
  17. Geodon7

    Dropdown box help

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

    Option Groups Help

    Thank you for your help, I just have some questions. I'm pretty new at all of this, so I was basically just using the wizards. So I drop an object frame (unbound or bound?), then I put the option buttons inside. I tried this, first with a bound frame, then with an unbound frame, but both...
  19. Geodon7

    Option Groups Help

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

    Error Message while creating a command button

    By the way...that's OLE server, not IOLE, sorry about that

Part and Inventory Search

Back
Top