Search results

I'm sorry, I was looking at another line of code which was after the THEN - WHICH (the Then) WAS WORKING - DUH !

Yes, I find that works as well as long as it is the control source of a field on the Form

findcust = Mid(Me.Text0, InStrRev(Me.Text0, " ") + 1) & " " & Left(Me.Text0, InStr(Me.Text0, " ") - 1) ' If Nz(DLookup("[city]", "customers", "[customer]= '" & findcust & "'")) Then If DCount("[city]", "customers", "[customer]= '" & findcust & "'") > 0 Then The findcust HAS the proper value in...

This one did it !!

I see that complicates it more ...

I thought for sure I tried that and ran into a failure when testing? I will try again tomorrow.

This is in a sql insert

“John and Mary Jones” s/b “Jones John” “Jim & Bob & Mary Jones” s/b “Jones Jim”

SOLVED: This issue was that the report was printing well enuf on my Brother laser printer while the Report labels were printing very faint on my customer's Canon pixma printer. I found out that on report labels in Access, the default is "50% lighter". Once I removed that - all was fine!

I tried a dlookup and that seems to bypass all errors !

Field1 sainx Dates 12/21/2019 Customer Cavi-2 Am 0630 Pm TOTALS Daily 0.5 Weekly 30.5

All are alpha

I have a report reading from a query. I have a column with defined as alpha which has mostly characters in, but on certain rows (with "Daily" in field1, there are some totals, left justified, e.g., 0.5 and 2.5 I keep getting a "data mismatch" using" =IIf([field1]="Daily" And Not...

I'll have him check that .... Maybe an important fact? Before, I transferred the report data file over to Excel, and he printed it from there, and it was perfectly readable/bolded. Now, the entire application is within the Database and printed from there w/o the transfer over to excel...

I have office 365, my client has office 16. I print out a report and it looks fine. He prints it out (using the same database), and it is really FAINT and rather hard to see the data detail, logo, etc. ???

I'm good, it's solved!

Yes, thank you. I think I wili have to build the table field used for the axis that way, since I cannot use more than 1 field for the axis.

Using the 2016 graph version, is there a way to display a "stacked" x-axis Category for my graph? See attached.

[code]Set rstquery = fDAOGenericRst("weeklytotalMatl")[code] Wow - looks like the above actually BYPASSES the ERROR !! All who responded to me here are pretty much AMAZING. I will continue on tomorrow, if NOT hungover, to finish up my "update" coding VBA. Thank You!