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...

: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...

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

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...

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

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...

Hey all, I am setting up my database as such, Table1 will contain personnel information such as Social security number and Name Table2 will contain card information such as card number, date of issue, date of experation Table3 will be set up to have social security number and card number...