Search results

Private Sub PartNum_AfterUpdate() If DCount("*", "tblLicense", "LicenseNeeded='" & Me.PartNum & "'") > 0 Then 'Part Number might have a Windows license If MsgBox("Does This part have a Windows License?", vbYesNo + vbQuestion, "Windows License Check") = vbYes Then 'Ask if it has a Windows...

Not yet. I believe our posts crossed. That does look like a better option. Then if I do have to add additional part numbers in the future that require a Windows license it is just an entry in one table. Just to be sure I understand this: X = DCOUNT( "[License]", "PartsTable", "[License]='" &...

Part Numbers that require Windows License: 030799 031290-A ContlrA DisplayB (Plus a few others I would add in after I figure this out.) Examples of Part Numbers Being entered: 220123 B700005-QA 030799 031290 211456-A When the 030799 or 031291-A is entered I want the Windows License check to...

What I want is any part number that is entered that matches one of several part numbers would trigger the Windows license check. A Part Number would look like this: 123456 or S123456 or even AB600008-A. If the entered part number matches 123456 or S123456 or 456789-A for example, the License...

Unfortunately I cannot force them to enter a license number as a part number may exist with or without a license number assigned in our system. I may be processing a part before the license has been assigned. We do have other systems in place to verify nothing goes to a customer with out a...

Fantastic Discussion on various event triggers and when to use them. However I think I may have used improper terminology. I am not sure if Data Validation is the correct term. Some parts I deal with have Windows License numbers on them. Currently less than 10 out of over 200 part numbers...

I love to see these types of discussions when ask questions. It really helps me see the pro and cons of different methods. Isaac, Just curious as to why you would chose Exit or lostFocus over BeforeUpdate

Just a few things I want to be sure I am understanding properly: 1. In my DB I use a PartNum field set as text. The part numbers consist of a series of numbers (usually 6 numbers but not always.) On occasion the numbers will have a letter suffix (123456-A) or a letter prefix (S123456) or...

As a Noob, maybe a forum that is for those just starting out in Access/VBA

Thanks. THAT was not explained properly in the book I am using. (Or maybe I miss-read it. Time to re-read it) So the error is not a "True" error, just the programs way of telling me I am trying to do something that it cant do. yeah a MsgBox ("It Worked") will tell me if things are happening the...

I used the copy function on the Microsoft page. (See Beep Source.png) There is no line highlighted. (See Beep Fail 1.png) I was looking up to see if I could change the tone of the beep (I saw there was a way to do that but that is for future me) and saw this code that wil beep 3 times and...

(Running Access365) As I am trying to learn VBA I am experimenting with the On Event feature of some of my forms. Just something simple so I can understand what is happening and when. Just a simple place to start. I tried to set it up so that when the cursor left one field the program would...

The_DOC_Man, Would you believe my management is asking if there are any formal studies or Technical documents stating that Access should not be used over Wi-Fi? They claim anything else is just "personal opinion." So I guess for the foreseeable future, I am going to have to be content with...

You are correct. And I fully understand it is the absolute worst environment to try to run Access in. But my Management does not know that. They say, " I use Word all day long over Wi-Fi with no problem." To them one Office program is just like all the other Office programs. And we all know...

And this finally explains to me the heart of why using Access over Wi-Fi is such a bad idea. Wi-Fi drops for a microsecond, Access thinks you left the form and does its thing before you were ready for it to. Thank you. I will add this to my argument with IT and Management over getting a...

Also New to Access. As I understand it, Access will save the data entered into a field as soon as you exit that field (move from one to the next on a form for example.) If I am understanding your statement correctly, I can stop that automatic save (allowing a person to go back and edit field...

Is this using a Barcode font that has been pre loaded onto the PC? In short how can I get my reports to print either a Code39 or Code 128B barcode based on a Particular field? I have a Part number field (Text as some Part numbers have letters in them) I would like to be able to print as a...

I totally get the self taught advise. And using this site. My problem is that I was not understanding what I was looking at while searching for answers. I think with just a little bit of book background, I will be able to A. understand the answers better, and B. Ask better questions. I have been...

I am designing a form to enter date and employee information to use to run some reports. The basic form functions as expected but does not look like I expect. I have attached 2 screen snips showing the Design View and the Form view. Why does the form fill the page when I give it a width? I...

Thank you to all that responded. I was able to watch the videos from home. The work "Net Nanny" blocks them. Working with IT to fix that. I was able to order a couple of the books. Others are out of print. One book had 1 copy on Amazon for $395. The Kindle version was $20. Most of the books...