Search results

Name Position Arrival Date Joe Schmo Human Resources 7/1/08 John Doe Human Resources The name and arrival date are pulled from one table, but the position is in a separate table. Both tables are linked...

Yes, but for those that are already there, it will return their information, but not those who have not arrived yet. Since I did not design this database, I cannot add a simple Here? Yes/No box in the table to simplify my life.

See, now you're confusing me. Queries have never been my strong suit. Here's what I have for criteria: Position = "Human Resources" Arrival Date = ??? <--Where I'm stuck. Again, I don't want to return just those who are already there, but I also don't want to return just those who...

As much information that I can give on this (which isn't much) is the following. Table structure is pretty basic, Name (First and Last), Position Title, Arrival Date I'm using all three for the query, which isn't too hard to build a query looking for the specific info, it's when I get to the...

I've got two fields in a table that I need in a query. I've got one set to show who all is in a certain position, but I've also got another field that I want to show people who will be filling that same position, but haven't arrived yet. So, in the end, I want the query to pull the names of...

Understand not to use the Macro for running the query. My problem lies in the fact that the coding is a foreign language to me, I've never been able to understand it. Would you be willing to post an example of what you mean? I would probably understand all of this much better that way... :D...

Yeah, I guess I can leave them separate. I found a database built by someone else using a macro and the TransferDatabase option, so I figured out part of my question. I don't know that doing that will replace the information that's already in the table, or if it will just add-on. Which...

First of all, I don't know if this is possible. I've got two tables that a query will pull information from for a form. One, the information doesn't change, the other gets updated roughly every week via a download of an Excel spreadsheet. I want to merge the two tables into one, but the...

Ok, well I solved that problem on my own, but now I have another question. I want to have this separate table/form for tracking. I want to have a remarks sub-sub-form pop-up off the tracking form, with the information saved in the tracking table. So, for instance, I received a document...

I've got a table with all the people that work in my department's information. What I want to do, is create a separate table that will track different things. In the end, the main goal is to have it so when I click on a button on the main form to open this tracking sub-form, that it...

Alex, Copy the db, make the copy a skeleton with one sample entry, then zip and upload that db.

Certainly, you were right in your post and I was quick to dismiss it. In the query, I had the wrong expression typed in. Instead of [Form]![frmPersonnelData]![LAST_NAME], I had [Form]![tblPersonnelData]![LAST_NAME]. Simple mistake that'll ruin your day.

This is something I'm totally new to, creating a table using partial data from an already present table. What I want to do (don't have this established yet) is use a table that will hold data on personnel and take from that table only the persons name. Using the information from that...

I'm an idiot. I found the problem and fixed it.

This might be what you're looking for... http://www.access-programmers.co.uk/forums/showthread.php?t=156450&highlight=image+combo+boxes

I checked the all three. I've got a macro set to open the form, then open the report. It's not an SQL, just a simple (well not right now) MDB. I've got an old database that I did it on, and I checked with that one to look at my work. I can't think of what I'm missing. I don't see any VB...

Ok, for some reason everything is in correctly (I figured it out by the way), but when I go to run the Macro which in turn runs the report, the query that it's supposed to pull from is not being supplied with any information. I double-checked the table and the query and both come up with the...

Are you going for expanding left to right or up and down? If you're talking about going up and down, simply change the Can Grow/Shrink options to yes. This will allow the box to expand when necessary. This might not be what you need, but it sounded like a problem I had in the past.

I've done this in the past, but my mind is old. I've got a form that I have buttons to pull reports on. I want to avoid using parameters in the query and simplify the process by having the report automatically filtered to that individual. The form is pulling and storing it's data to a...

As soon as I saw the query the lightbulb went off. I was drawing a blank...thanks again!