Search results

Ok.. I have been racking my brain for hours trying to figure out how to do this. Maybe someone here can help me figure this out. I have 2 tables. "AR94" & "RPIN" I need a query to look at the "Provider_PIN" field of both tables in order to find duplicates between that field in both separate...

Thanks for that piece of code; it did the trick. Is it possible to add a line of code to that where I can say If anytext has "LLC" Or "MD" Or "PC",etc. (as a seperate word) then AutoCap those? They would always be at the end of the provider name. I know Moniker said to use a table/dLookup...

That is a good question. I was hoping in situations where the code doesn't work correctly it could thow an error message to the user and then have the ProperCase function ignored for that situation. Unfortunately I didn't write the original code and I couldn't quite understand how it was...

Ok new problem I have run into with this code. If someone uses the name "Scott" or "Scot" it is throwing an error: "Run-time error '5': Invalid procedure call or argument" and these are the lines highlighted in the code. (From the code I listed in my previous post) If...

Very helpful code, but how do I do this? How would I go about adding more capitalization features to this code above? This works great for individuals, but the problem I am having is with Credentials, Company information, etc. not capitalizing. Also if you ever use the name Merrimack this...

Got it working: Ok. well for some reason any time I removed the stLinkCriteria code an error would get thrown everytime a provider number was entered into the field even if it the count was 0 so here is the code I used and was able to get everything working like I needed. On Error GoTo...

Moniker Thanks for the Case usage for error handling that works good. I guess I should explain better what I was trying to get the code to do. I tried using your code and everytime I enter a number (regardless of if it is in the system or not) it keeps throwing the error message based on SSN...

Any Suggestions on how to accomplish this? Here i go again. lol. I think I am making things more complicated than they need to be. How would I go about conquering this to do what I want it to? I am trying to get it to say Within the "IF DCount" statement IF [SSNLookup]=Null Then Do MsgBox...

So IIF statements are more or less 1 line statements without the need for EndIf / ElseIf / etc.?

@The Doc Man I might be able to work with the Case statement. I hadn't used it in that sense before. I will have to try it out. @oldozziesubby I am not very familiar with using the IIF statement; for some reason I thought that was used for criteria in queries.

Could you give me an example of how to use Case statements for this situation? I had thought about that after reading someone else saying Case statements are good when nesting is needed, but not sure exactly how to go about it.

How do I use IF statements within an Existing IF statement to accomplish different outcomes? I have been trying different code for a while now and can't seem to get it to do what I want it to. Here is what I want the code to do. 1st - if the field "Provider Number" conists of 6 or 8...

For the purpose of the numbering for this database I have to stay away from autonumbering and use the DMax function. I was able to get it to work. After looking at it some more it is in fact pulling the newest record and showing that in the provider number field on the report. I just needed...

I have a report that prints based on the current record showing on the New Provider form/subform. This is working alright so far and the only trouble I am having is getting the "Newest" provider number (from the subform data) to show in the "Provider Number" unbound text field. I have attached...

Thanks for the post. :) Is there supposed to be a DLL file to go with this? When I opened the database it is throwing an error: "Access database or project contains a missing or broken reference to the file 'AmpX.dll" version 1.0."

HOLY CRAP! I finally figured it out!!! After hours and hours of trying different code out. I finally got it to do what I wanted. Here is the code for anyone in the future. It is crude, but it might help. If anyone has a better way to do it please let me know. Private Sub...

Is it possible to reset the DMax function on a particular field (Extension) for each new record. I have been racking my brain all day trying to get this to work to no avail. I know it is possible to have a numbering sequence reset each new year, but I need it to reset on each new record...

I did see that, but how do I have it look at the previous records "extension" value in the subform table and then add +1 to that value as long as it isn't Null? I'm just not sure how to do this part. Here is DMax code I usually use. (To answer the question about looking at the VBA help) If...

I'm not sure what I am doing wrong, but this is the only part I am stuck on. I am trying to use the DMax function to increment the "Extension" by +1. I am trying to do it using an IF THEN statement. What I have it doing is when you click on the "Add Reassignment" button it adds a new record...

Thanks works perfectly :) But is there anyway to make the "HH" show in 12 Hour format instead of 24 Hour format? so 2PM would show as 02 or 2 instead of 14.