Search results

Hey all, Here is my basic table structure Table 1 SSN Name Access Table 2 IDnumber Name Access Table one is for US citizens and table 2 is for Non US citizens. I would like a query that shows everyone from both tables that has access. The problem I run into is I have multiple results for...

Thanks, It works perfectly.

:confused: Hey all, I need more help, yet again. Here is my table set up Table Name: Personnalinfo SSN Name PCSETS SEADABrief I have the following quieries: Query1 returns the all people who have a NO in PCSETS Query2 returns all people who are NO in PCSETS and have a valid date in...

Thanks for the advice. The reports I am looking to generate are a list of personnel that are no longer current on certain briefings.

Hey all, I would like my database to open a series of reports once a month. I would like to add this to the startup so say on the first of every month when I open the database these reports open. Can anyone point me in the right direction. Thanks

That was it. Thanks and YOU ROCK.

I would want to add this into the footer of a report.

Ken, Sorry I am confusing so much today. As far as the code you posted I am afraid that is above my head. I am not even sure where I would add that.

I have not wrote any SQL. I just go into design mode and write in the critera. Whatever SQL is written is by access. If this request is above my level that is fine. This is something that would have been nice but not required.

Ok here is a basic sample. I only want the percentage to run on the people who have a no in the PCS field. If you have a Yes in the PCS field I pretty much want the query to ignore you. I hope this helps. Thanks

Hey all, I need a bit of help with percentages. I have a table that the basic set up is as such: Name Brief Date (Date format) Brief Date Expires (Date Format) PCS (yes/no format) I have a query that runs all people that are have not passed the experation date. The criteria in the date...

MStef, That was it, I can't belive how simple it was. In my defense this is the first time I am messing around in visual basic. Thanks so much :)

Hey all, I have a button set up to save information, close form 2, and requery a subform on form 1. The requery is set up in visual basic as forms!subformname.requery. I keep getting the error can't find subformname . Any ideas as to why? Thanks

Ok stop making things so dang easy. Thanks for the help

Ok, I think I may end up doing that. Can anyone think of a way to say hit a button and it will print out a list off all the people that have left in the past 2 years and then delete them. I am requiried to destroy the records after two years.

Hey all, I thought I had this problem solved but I ran into more problems. I would like to use the database attached to create a log of all the cards I issue out. The problem I run across is when a person quits I want to be able to delete them out of the database, but have their record of the...

I will give ya that info as soon as I get the basics set up and test it. I think I am going to cut Table3 as there is no need for it. I "borrowed" the idea from a key control database I saw but there is no need to use it here, until I add in the key control database wich should be easy since...

Thanks, I think I got it solves a big problem and it works well, just have to tweak the critera so it only adds the one record. I tried a basic test without critera and it kept doubling the info each time, but that should be easy to figure out to add only one record. Thanks again

That sounds great. Not sure how I would need to do it.

I wish I could, but not everyone gets a card and I would like to keep my records as small as possible. I think things could be messy if I just moved them to an inactive status in stead of outright deleting them.