Search results

Thank you very much. I was able to adapt the teaching to work in my situation. I still don't understand it, but it works. There is no way I could have figured that one out.

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

I couldn't get iserror() to work, but isnumeric() did the job. Thank you.

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

I'm sorry to be daft. This line "copy the combo box and replace it with your textbox if you want to display the corresponding name" makes no sense to me. I don't want to reflect what is in the combobox...the combobox is there to select a search criteria. The textbox displays the store field...

Let me try to clarify. The form has a combo box search field, which allows the user to select a list of stores to search. The same form also has a text box that displays the store the employee works in. The combo box displays the name of the store (not it's number) but when results are shown...

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

I never did it exactly how I wanted/envisioned. I had to have the user log into the database (thus selecting their username). Then the username went into a hidden form (well, not their username, but the primary key for it). The hidden form was always opened and when records were made/changed...

I thought of UNION queries but then I thought all the tables had to have the same number of fields (in my case that wouldn't be true). @GalaxiomAtHome: I thought of that after I posted my question, on my way home from work. My only problem with it is that I can not figure out how to make that...

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

Confused by your question. People will be using forms to enter data, and to look at some reports, but they have no access to the tables or ability to edit any data from the forms. Aside from the designated forms reachable only from the switchboard, the users have no access to anything else...

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

I'll have to explore the unbound form idea. I'm using 2007, which I thought got rid of the user security level stuff.

That tells me the computer's user name, not which user is logged into the access database. I should also add that this is in Access 2007.

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

Oh man, that simple huh? This is a great example of the need to step away from something for a bit and then come back to it. I had just got my mind all twisted and apparently couldn't think straight. Thank you.

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

Ohhh duh. OK, I did turn them off. I read an article about improving network speed with a database which recommended they be turned off. I didn't realize it was those. I'm not attached to them (never use them) but I was afraid I made a change and couldn't recall what I did. Thank you.