Search results

Rich, you are the man! Was able to use this for a very similar situation, summing the totals of all contracts based on whether they were repeat customers or non-repeat. Thank you for this syntax!

Looking at the Payments table, I see that the "Payment Amount" field is formatted as currency and the Default Value is 0. That would seem to indicate that I shouldn't be getting any nulls, but those records where no payments have yet been received are just not getting included...

michaeljryan78, thanks for the code. But, when I insert this into the query, and run it, the list I get still looks like only contracts that have received at least one payment (there are no zero results, which is what I'm looking to include, as well as the 'partial payment' contracts). I just...

oops, should have said "accounts receivable". In other words, anyone who owes us money gets included, so any contract that has so far received zero payments (a null) needs to be included as a zero!

Hi all, I have always relied on Design View to create my queries, usually with great success, but in so doing, I have not become familiar with SQL view, so can't solve this problem: I have a very simple query whose only function is to sum the payment amounts received for each contract number...

TUSSFC: Drag in FORM VIEW - Thank you! I have been trying to figure this out for years!

Pat, this was invaluable a couple of nights ago, as I was trying to create a report that my boss needed! After reading this, I stopped spinning my wheels trying to sort by a calculated field that was on the report itself and eventually found a different way to make it work. Even posts that...

Thanks, Bob! That worked great, and I see the distinction between null and zero now. I would never have gotten there using my If IsNull! I noticed you used a wild card in the first argument (expression), instead of calling out the field in the table. Is this because the field is specified over...

:confused: I am trying to get a form to check and see if the contract number already exists before allowing a user to enter it. The form has a cumbersome name, which doesn't help with coding, but I'm stuck with it. The following code is meant to find out if the contract number the user is...

Not exactly what I want to do, but very similar! In our contract writing program, ONE client may have MANY vendors. Usually, all the vendors are reporting to the same address - the one on the client's contract, so I usually want all of the vendor contracts to display the same location address...

You were right rainman89! I was referring to a check box in the option group, not the actual Addendum Yes property, so that was what was causing the error, not the LIKE operator. I didn't actually see your reply in time and got the following to work, but it is very similar to your solution...

Hey, this is getting closer - the de-bugger actually kicks in now (was just ignoring the code before). I found that I had to refer to the check box specifically (there is an option group with two check boxes, yes and no). Here is what I tried next: Private Sub Notes_AfterUpdate() If...

I would like to open a custom dialog form if a user includes the word "Addeudum" in a text box AND the property Addendum Yes is No (False). What I have so far is: Private Sub Notes_AfterUpdate() If Me.Notes.Value Like *"ddendum"* And Me.[Addendum Yes] = False Then DoCmd.OpenForm "See Addendum...

Hi, I have gotten in the habit of just copying and pasting my database to a new folder, then changing the name to create a backup copy (for instance: mydatabase_backup_090408 for today's date. But is this a bad thing, as far as the integrity of the database goes? In other words, is there...

Hi, I'm working with a database that I didn't design (but have modified since I worked here). As I found it, everywhere a person's name is required (client, employee) has two fields, first name and last name. Is this a standard design practice to aid in searches? an indexing issue...

Uh-oh... Upon further experimenting, I see that my DCount didn't actually work after all. I'm running out of time here, so I'm going to give the users two buttons, one to view existing matching records and one to open a new record and set it to the matching number of the contract. Not ideal...

OK, I'm back! Sorry, dumb question: I have seen code tags on another site consisting of and (see the window!), but how does the # work? Encase code between ##? End line with #?

Changed it in the table, on the target form and in the code, but same result. I'm not sure that's the issue, since in works with my experimental button that ONLY opens a new form and sets the value: Private Sub Command797_Click() On Error GoTo Err_Command797_Click DoCmd.OpenForm...

I'm not sure... [Event ID] is the text box in the new form that I'm trying to set to the same value as [EventID] in the parent form (lack of a space in the second one is not a typo - was this way when I inherited it - not good naming...)

OK, that really helped! Apparently, you don't need to tell DCount you're refering to a table, it's assumed unless you specify queries instead? Also, I didn't need the = sign in criteria? It now opens the form and finds matching records, if there are any. But, if there are none, it opens a...