Search results

This is a discussion in theory / best practice only. How do you decide when to create a second, or third etc. database instead of just adding more tables to your existing database? What so called "tips the scales" one way or the other? I am still very new to this so kind of looking for a...

Being new to VBA, I was not sure if I needed them or not. And it helped me follow my options as I wrote the code. I will try again tomorrow with a fresh reboot on my PC. It does strange things sometimes. Thanks for helping.

Option Compare Database Option Explicit Private Sub Serial_Number_AfterUpdate() With Me![SubFrm-History1] .Form.Requery End With If DCount("*", "tblLicense", "LicenseNeeded='" & Me.PN & "'") > 0 Then 'Part Number might have a Windows license If MsgBox("Does This part have a Windows...

Thanks for your help, It works. I think. If I start with a blank form it works as expected. If I go back and change the S/N, lets say I noticed I have a typo in the number, It does not update the second time. Not sure why that is or if it is a problem or not. For the moment I can live with it...

So I should put "SubForm-History1"? I still get confused on Controls and their names. And when to refer to a field by its Name as called in the table and when to use its name on a form.

I had a form with a Sub Form. When I entered a product Serial number on the main form, the Subform would update to show any prior entries for that serial number. No programing was needed. It worked great. Then I added a second Subform for Windows License information. I added a routine to the...

To Tell you the truth, I never thought about where the passwords are actually stored. Good to know that though. I MIGHT trust them a little more now.

I have no clue about the programming issue but the primary reason I use Firefox on my home PC is that I don't want to surrender to all things Google. I don't travel and when I do I have my laptop. I do not need to log into a browser and have it be the same no matter where I am. To the best of my...

OK Very interesting. But who wakes up and goes "You know, I think I will look at the flight stability of the Killer Fly." And somebody else had to agree to pay for it.

Back in my day buying "Colombian" meant something very different from coffee.

I have a form where I am trying to use the data from one table on the main form and the data from a second table on a sub form. I created a query using al the fields from the main table (feeds the main form) and all the fields from the second table (feeds the sub form.) doing as you outline...

I have a continuous Form for logging paperwork received. Very Basic. Just the reference number of the paperwork and how many items were received, along with date etc. Would it be possible to invert the Continuous Form? Currently it lists the first item entered at the top with the second item on...

Welcome! Pay attention to your object names (Tables fields forms reports etc..) I just had to spend 2 days fixing the mistake of not paying attention to that. No reserved characters A dash (-) is a reserved character. Do not use spaces either. Access will think the names on either side of the...

Oh it was much more F'ed up than that. I had mixed naming conventions and errors within the same form or table. Plus I am still new to VBA. On the upside, I did take the chance to fix a couple minor design/layout error on my forms and I discovered that I had the margins messed up on a couple...

Just want to pass along this incase any other newbie is reading this. I started out making my database and I really did not pay enough attention to my Table and Field names. (Or queries or reports either.) I read things that said do this or do that. And at one point I started doing things the...

Sir, I believe this entire thing comes down to a miss-communication on my exact situation. Your points were all valid. Unfortunately they did not all apply this time. I believe I understand the points and theory you were putting forth. Although not all applicable here, I will keep them in mind...

Until one gets a hang nail. Then you would think they were being murdered. No you are correct. There is basically non-stop action in Soccer.

You left the best sport off the list. Hockey. For participation, I was a US high school Football and youth Baseball official for 18 years. That is where my user name came from. I hate watching Baseball on TV but enjoy watching it live.

I am asking the question because I was told to ask the question. And the answer DOES matter. A NO answer matters just as much as a YES answer. I just respond differently. " ... get management to change the process." I don't know about your management but mine is not in the habit of of letting...

Thanks for your comments. you bring up some valid points. Short answer is that an Identical part number may or may not have a need for a Windows license. I deal with parts from our production line and from our customers. I may get parts from any point in the process. The windows license is...