Search results

Complex queries are my enemy, but then even slightly complicated queries are my enemy too. I have two tables. Table 1 holds current employee records (id, name, current department, current location, etc). Table 2 is related to it and holds the performance rating of each employee. The tables...

That subject's a mouthful. I'll try my best here... I have Form A, which has a sub form on it (Form B). Form B has only one textbox which displays the result of a query. Form C is launched from Form A, and some of the information from Form A populates a textboxes on Form C. This is where...

Hopefully that subject is accurate. I have a Form that is populated off Table A. Table A has employee information (name, department, store, date of hire, etc). The store field holds the store's code number, which is related to Table B which has the store code number and the store's name and...

I'll try my best to describe what I need to do. I'm sure this is covered many places, but I have a hard time coming up with good search keywords. I have two tables. Table A holds employee records (id, first & last name, position, etc), and Table B holds the employee's rate history (id, rate...

Sorry for my subject vagueness, I just couldn't think of how to summarize my question. I'm building a database that tracks several different types of incidents. Originally I was going to have one table that had all the fields required for each type of incident, but then I would have several...

I've looked at the 2007 version of the Northwind sample database and it's just too large and complex for me to break down. I understand the concept of how this is done (I think) at the table and relationship side, but I'm having trouble understanding how it is implemented with forms. Obviously...

In the company I'm at, I'm the only person with Access. Every other person who will be using a database I made will be using the Access 2007 viewer. The very nature of the viewer doesn't allow the end user to have access to anything to change...no stand alone objects that aren't clickable from...

On this board I've found some really cool code for creating user login forms and tracking/auditing, however I can't find out how (if possible) to record the action of a logged in user name and not the logged in user's workstation name. For example an Access database has a user called jdoe and...

If I could punch, kick, bite, strangle, and gauge Access I would be brought up on assault charges right now. I am that frustrated with how complicated it is to do basic actions. I know VBA quite well (in Excel), and am not intimidated by it; however, I want to do this without VBA, and I have...

OK, I have no idea what this is called... When I open a table there used to be little plus signs next to each record that could be collapsed showing which records are associated with that particular record. Well they are gone now, and I have no idea what I did to make them disappear. How do I...

I feel silly asking this, because I'm thinking it's very obvious. So obvious I can't find a search result here or on Google because no one can't figure it out but me. Maybe it's how I'm using it...which is I have a form that is used for data entry only (no ability to cycle through existing...

I've Googled this and see that it's possible but I can't find out how to execute it. I'm making a database that will be split, and I would like to have two different front ends to the single back end. The users will not have Access on their computer, just the Access viewer so everything will...

For the record, I have gone to the form's properties, under Other and Cycle and set it to Current Record. This allows the user to tab around the form, HOWEVER when all fields are entered and the user tabs around it enters the data as a new record and still allows them to tab around. I want my...

I have found similar issues, but I'm either daft or so green that I can't relate the solutions to my problem. Sorry. I have a form with a subform. The form is designed to search for an employee and then display a few facts about the employee in the subform (e.g. first and last name, hire...

On my main form (frmSearch) I have an Option Group with two possible selections, "search by employee id" and "search by last name". Then there is a textbox where the user enters an employee id or last name. The user clicks which of the two options they want to search by, and then enters the...

I have to preface this with: I'm new to Access, and I have searched for solutions to my problem here & everywhere, and while I have found people asking for the same help not one answer has helped me (which is more frustrating than not finding anything). Purpose: the database hold incidents, and...

I can't find an answer to this, because I probably am searching for the wrong keywords. I have an Access database with a query I want to use in a pivot table (Excel 2007), however when I try to make the connection only the tables in the database are shown. So far I have discovered one reason...

I've been struggling to learn Access for awhile now, which usually forces me to run back into the arms of Excel where I'm secure and happy. I've tried to create a little database to track job duties for someone and while I feel like I did it correctly, I'm just not so sure. Here is what the...

Sorry for the unclear subject. I am totally perplexed as to why this isn't easy to do. In a report I have a group made up of stores. Each store then has values listed by a date, with the next line listing values for a date 7 days back. After that, the next store is listed with the same...

New to Access, and having a heck of a time learning it...or rather learning how to correctly design databases. All my expertise is with Excel. I'm creating a project where I use Excel to parse a non comma delimited text file, then feed certain figures into an Access database. This is all...