Search results

Thank you for the reply arnelgp. I tried the inner join and when a field was changed from null to anything, it was omitted from the result. I'm not sure what you mean when you say to 'add a criteria that concatenate all fields on both'. Can you give a short example of what you mean? And will...

Hi everyone, I have two tables (ClaimDoc) and (ClaimDocCopy) in a database (CIS) that are not linked. ClaimDocCopy is used by other people and they need to change data in any field when necessary. I import the ClaimDocCopy in every week after deleting the previous copy. ClaimDoc is...

pbaldy, being pretty new to all of this, I was still reading through what you advised and I see why you sent it. Thanks a lot as it did help me understand what GinaWhipp sent the second time! GinaWhipp, your last post did the trick exactly as I was hoping. I thank you for making what...

Thank you to pbaldy and GinaWhipp for the reply. GinaWhipp, I still have an issue figuring out what the criteria of txtFieldOnForm is for my form. I tried Nz(DMax("ClaimNo", "ClaimData", "[AuditCode] = " & Me![AuditCode]), 0) + 1 and get error 2471 produced by a query parameter. I forgot...

Hi, I am somewhat new to Access code. I am trying to make a number field in a table default to the highest number in that table plus 1 within a given client. I have a table (named ClaimData) that I input data through a form which gets filtered by an After Update, Event Procedure macro...

Hi, I am pretty much a novice at programming but am surely learning as I go along. I run a startup company that I have become the CEO, IT and janitor so when an issue needs resolving, I'm the one called on. I really appreciate how you all help people be more efficient and productive...