Recent content by tjkalb

I have it also checking when the user clicks a Close button, which works fine. The Close button says that it must be entered and goes to the SSN field. There's also a Cancel button that just closes the form without saving any data changes. I wanted to do the code in question so the user...

Just to explain what I want this form to do - SSN is the first field. From other researching, I have it checking to see if the SSN exists already in the database when the user goes to the next field - so, the code runs On Got Focus on the next field. (Someone suggested checking on next field...

It didn't work moving it to BeforeUpdate.:(

:banghead:On my form, I have a SSN and name field. If the SSN is blank, in the On Got Focus on the name field, it looks to see if SSN exists. If it's NULL, it tells the user they must enter, and asks do you want to enter now? Yes - goes back to SSN field (works fine). For No, I want it to...

Thanks guys! I was trying the parent/child in the wizard and that's why I couldn't get it to work. It works perfectly now! Sometimes you just need someone to brainstorm with when you are having a dah moment and you guys are the best!

oops! Forgot to compress it.

Forgot to tell you (and can't figure out how to edit post)- When you open the database, open the form frmEthEntityCatNameYrLup. This will open a lookup screen. Pick a name from the pull down menu in the first field, and then pick a year in the bottom field. The year is the value I'm using for...

You cannot link on a unbound field in the form - which is Yearvar and a bound field in the subform - which is EthYear. I attached a mini database. Not all the buttons will work because I didn't include all the forms, tables, queries, ...

Yes I do have master and child links based on another common field between the form and subform. The field is called cat in master and category in child. I cannot post the database due to confidential info, and there's too many forms, tables, queries, etc. to post the whole thing even if...

I hope this makes sense because for the life of me, I'm having trouble finding anything that I want, and it's probably how I'm typing my search. I have a form (beforeform) that opens and passes a value to another form (form). The value is a text field called EthYear. Since this field does not...

Thanks for your help. I ended up adding another field to the table, a computed field, and extracted the last 4 numbers, making sure they were an integer. Query works fine now! Thanks for giving me ideas!:)

Nope - it always has a value. I double checked to make sure.

I am having problems with my query. Here is the SQL: SELECT qryFinance.SectionNo, qryFinance.AbbrevSect, qryFinance.GLAccountNo, tblFinCodesCapitalAsset.Description, qryFinance.DESCRIPTION, [highwayname] & " - " & [Project Description] AS RepDescrip, Right$([GLAccountNo],4) AS vExpense FROM...

Thanks for your reply! I am a network person, and I can access all computers on our network. As far as shell command goes, I'm only seeing the shell command for the current computer, not a remote computer. I want to open up the registry on a remote computer using Access vb code just like I...

Hi! I can't figure out how to open a remote computer's registry in vb. My database keeps track of all our IPs. I have buttons to ping, open shares, open computer management, etc. for the computer with that IP. I want to open the registry for a certain IP for viewing and possible manual...