Recent content by cstuckey56

No, I was getting an error message. :banghead:

Thanks for everyone's input. To David R: When I say "No Such Luck," I meant when I entered a duplicate name to test, it did not warn me.

I tried your code and no such luck. Can you write it out the way it should be? Thanks

I see this question is asked a number of time but I tried to use the code that is suggested but it doesn't work. Can someone please give me advise on the proper code to prevent duplicate records in my form? I'm using: Private Sub Ctl_Lname_BeforeUpdate(Cancel As Integer) Dim dupCount As...

I Used Bob's code to prevent duplicate entries in my form but it doesn't appear to be working. Am I doing anything wrong? I'm using my table name and First and Last name in replace of the example above "yourTableNameHere" = "Clients" [FName] = "FirstName" [LName] = "PreferredName" Private Sub...

Can you be more specific. I can't get the criteria to work.

Can you tell me how to run a report to show a Client if one or of the following fields are blank or unchecked(Yes/NO? Fields Client Assessment Date(Null) Placement Fee Paid(Check Box)(No) TJ Completed(Check Box)(No) So basically, if one of the above fields are null or unchecked, please show...

Perfect! I was try to sum them using the Fields in the control box. Thanks

Please help, I'm trying two add a field in a report that totals two Summed fields in which I already calculated. I thought this would be simple: :banghead: Any clues would be helpful. Ex. =Sum([Field1]) =Sum([Field2]) Total: =Sum([Field1]) + =Sum([Field2]) Thanks Chris

Let me clarify, when I say the parameter is "Null", I mean I do not put anything in the parameter to get all records or "Pymt Types." EX. Like [Enter Pymt Type] & "*" When I pulls all my records in the report it shows the first record "Pymt Type" of the first record like "check." the next record...

In my report I added a text box in the header of the report to show the payment method I selected from the parameter query. So it shows: check, cash, PayPal, etc. I have other parameters in other fields I select for the report. Sometimes, when I run the query I leave the "pymt method" field...

Thanks Neil, I was afraid that was the answer. I made a table with all the variations and will continue to populate.

Hello, I working with different business groups who have vendors assigned to them. I have table of vendor names for each business group. I'm getting data from different sources with vendor names that are unlike table. example: ABC company, ABC. Even through these are different they are they...