Search results for query: *

I have the problem of every time I use my mouse wheel in a form it advaces to the next record. I would like the mouse wheel to scroll down the page, if that is not possible I would like to just disable it when using access. I like my mouse wheel and dont want to disable it in every application...

Ok in critera i put [Type Last Name] & '*' When I ran the query and put in a partial last name I got nothing in the query. Is there someway I have to input the info into the pop up box? Like if i am looking for the last name Smith, but I cant remeber how to spell it, remember just an example...

I have a [Type Last Name] in a critera field for a query. I would like to use a wildcard or have a search function just in case I cant spell the last name perfectly. Thanks for any help

Ok I tried the above string and to put it simply I am lost. I want the query If someone has a "SECRET" clearance to add 10 years to the Date of Investigation. If the Investigation is "TOP SECRET" add 5 years to the Date of Investigation to make a Expires date. The SECRET...

I really did not understand that, let me explain a little more. I have 4 different reports that i want to have printed out. When I excute any one of the forms a pop up box asking for SSN comes up. To have the report fill in the persons info I need to enter a SSN. I built a Macro to Open all...

Here is the problem. When a person arrives in my unit the must come see me to "inprocess" which involves several forms that need to be signed. I have access setup where after I enter their information I can select the report to be printed and access puts in the persons information...

Hey, Kinda, A Clearance B is the best clearance you can get, super secret Squirrel clearance. If at the end of 5 years you do not submit for a reinvestiagtion you automaticly downgrade to a Clearance A which is just Ok nothing speical and is good for 10 years from the orginal investigation...

Thanks, Just one more small thing, When Clearance B expires in 5 years it becomes a Clearance A which will expire 10 years from the orginal investigation date. Did that make sense, and thanks You guys are great

I need help making a calculation. Here is the background I need an calculation for a security clearance expiration. It will like this Clearance A will expire 10 years from date of issue, Clearance B will be downgraded after 5 years and become Clearance A which will expire in another 5 years...

This is my 3rd post of the day, hopefully last. I was wondering if it is possible to build an calculation for a date. Here is the problem I work in security investigations. a type A clearance is good for 10 from the investigation date. a Type B clearance is good for 5 years from the...

Hey, Once again thanks, If I was not so far along in the database, I would go back and redo. The only problem with the database is the table setup. I dont forsee any problems in the future, but next time will not be afraid of big tables. Thanks

As I said earlier the reason i broke it up was so i would not have a massive table. Which is what it would be. Is it ok to have a massive table? Thanks for the help eariler, someone gave me a simple solution, change my join properties in the queries i was doing. Thanks yet again

Thats IT, that is what I have been pulling my hair out over. AHHHHHHHHHH. Thank you both. I just feel a little slow, ok really slow. In case you cant tell building databases is not my job, but something of a hobby. the Join Properties solved the whole problem. Thanks, Thanks, Thanks. I am...

I posted a question and someone questioned my table design, he had good cause this is the 1st large database I have ever done. Here is a quick example of what i have. Table 1. Personal Table This table includes Social Security Number, Last Name, First Name, stuff like that Table 2...

Thanks for the help. I am still having trouble though. I went and made a form and made a add record button. In the record button i but the Db.Execute "INSERT INTO tblOne (SSN) VALUES (" & txtSSN & ");". and nothing happended. The SSN was not added to the other table...

I am building a database that has many tables. The primary key for all tables is a social security number. When I Enter a social security number into the primary table I want all other tables to have a record of that social security number. I want this becuase when I do a query on a person I...