Search results

Current structure is smooth. I, too, don't like the stackoverflow structure. Very confusing. I urge no change to the current format.

Do your lookups from a Form. Read here: http://access.mvps.org/access/lookupfields.htm

Col, I knew that you were referring to Grand Theft Auto. It was the crack that made me respond. It is as if you believe that GTA is a microcosm of life in the USA. GTA is not reality and does not represent life here any more than Harry Potter represents life in GB.

I must be living in a different country than the one Colin talks about. In my 60+ years, I have not been a party to or know of anyone who has been a party to stealing a car or having a car stolen. You must get a very stilted view of our country from your hyped up media people because that is...

try changing the "or" to an "and"

This link should help you to understand RDBMS design. http://sbuweb.tcu.edu/bjones/20263/Access/AC101_FundamentalsDB_Design.pdf

Try this: If rs!TermsID <> 4 Or rs!Terms <> 3 Then

Why would you have a table for each different date. This sounds contrary to data normalization. Perhaps if you normalized your data, it would be easier to extract or find or search for the information you seek. Look at this white paper on RDBMS fundamentals...

Try this in the afterupdate event for the ComboBox containing "Yes"/"No" If me.comboxName = "Yes" then me.wifeTextaddress1=me.HustxtAddress1 me.wifeTextaddress2=me.HustxtAddress2 me.wifeTextCity=me.HustxtCity me.wifeTextState=me.HustxtState me.wifeZip=me.HustxtZip End if

Here is a link to a tutorial on permissions. http://www.mrexcel.com/forum/microsoft-access/248191-tutorial-access-menu-permissions-system.html You may be able to use/modify this for your specific issue.

Here is a tutorial on how to limit what forms a user may see (as Dave mentioned). I am directing you here so you can see how Environ works and then apply it to a query in the critieria. http://www.mrexcel.com/forum/microsoft-access/248191-tutorial-access-menu-permissions-system.html

Congratulations Guys. Keep up the good work.

Crossposted: http://www.accessforums.net/modules/vba-code-calculate-inverse-matrix-42197.html Please read this link: http://www.excelfox.com/forum/f25/message-to-cross-posters-1172/#post5326

Col; It is not a casual event in the US. It is unfortunate that we have these issues here. It does indeed get reported through all printed, visual and audio media. Politically, here it is a very hot issue. Gun control is a topic that has very divided points of view. In a Republic, as we...

Look at this and see if you can modify for your use. http://www.datapigtechnologies.com/flashfiles/expandcombobox.html

crossposted to: http://www.mrexcel.com/forum/microsoft-access/752854-update-table-based-another-query.html Please read this: http://www.excelguru.ca/content.php?184

freezes on the

According to this MS site, those keyboard shortcuts are still valid in AC2007 http://office.microsoft.com/en-us/access-help/keyboard-shortcuts-for-access-HP010091394.aspx

when the sun

pounds of fermented