Search results

Does anyone have any thoughts on this? Still having the problem... Still not sure why... Thanks again. --Sara

Hi, everyone... I've got another problem... I've created a query to try to generate a report, but it's giving me some duplicate results. It doesn't duplicate every result, just some of them... Here's my sql: SELECT qryApplication.AnnouncementNo, [qryApplicant].[LastName] & ", " &...

Okay, RichM, we're finally at the home stretch here... I just have a few more questions... :rolleyes: 1) How do I get a message box to say "Are you sure you want to hire [applicant] for Position #[positionNo] ([PositionTitle], [Office])? (So If I applied for a Secretary I position it would...

Thanks, Rich. I found it... why does that work? What does it do? What do the single and double mean? Is there a way to do it without having to type in the decimal? --Sara

Hi. I've searched for this topic, but the only thing I found was from April and had no replies... So here goes: Anyone know why my percents are rounding? I have a field for TestScore, which should hold a percent... I have the field set up as a number field, Integer, Percent, with Decimal...

Yes, I'm using primary keys and all that... When I first created the table, I indexed the field, but I had to change it for some reason (I can't remember what the reason was...) thanks for your reply. I'll see what I can do to fix it. :) --Sara

Thanks for your relply, pdx_man! Oh, I'm not mad at Access... Just didn't know if there was a quick fix or something else I could do.... Is there a way to set up a validation rule that says "no duplicates?" Thanks again :) --Sara

Anyone have any idea why creating an index (no duplicates) on a field in my db screws up my relationships? There were already no duplicates. I can provide more information if it's needed, but I thought someone might have a thought... The field in question is a foreign key to another table...

Hi, Rich! Thanks for the response... I ended up using secret option #4... let me know if this is a bad idea... but I used 2 queries on top of each other... The first was an update query which asks the user to assign a tdNumber to the current record (in tblApplicant.) The second appended to...

So now I'm working on an append query for if the person is not an employee, and I'm running into a bit of a problem. Because the TDNo is blank for them in tblApplicants, the query won't append the info into tblEmployees (whose PK is TDNo.) I tried to put [Assign TD Number] in the criteria...

UPDATE tblPostings INNER JOIN (((tblApplicants INNER JOIN tblApplication ON (tblApplicants.SSN = tblApplication.SSN) AND (tblApplicants.SSN = tblApplication.SSN)) INNER JOIN tblEmployees ON tblApplicants.TDNo = tblEmployees.TDNo) INNER JOIN tblJunction ON tblApplication.ApplicationID =...

You said: <<I think your next step should be: make a script of all the detail actions that should be done to complete the hire(use business terms for the actions), review list with users, make queries and other things to move data from here to there. >> Okay, here's what happens when a...

Thanks, Rich, I've actually done all that... what I meant was that I don't know where to start to do the procedure explained in my original post (moving new employees into the employees table, changing the information of current employees, etc.) But it was nice to read your post and see that...

I do need help.. I don't even know where to start. (besides onclick)

Aha... no, my form was called frmHire. We're good to go now. I guess I was confused about what [FormView] meant... (Insert obligatory explanation of my complete lack of programming knowledge here...) All right, so I have the form all set up. I haven't set up an onclick event for...

When I open the form, or go from design view into form view, or when I click on another option in lstPosting (my list box) I get an "Enter Parameter Value" message box, asking for: Forms!FormView!lstPosting. If I click "OK" the lstApplicants (my second list box) comes up completely empty...

I have the syntax completely correct, and everything is spelled right... could it be something else? What about control source? My text boxes are unbound...

RichM, I've taken your advice and put [Forms]![FormView]![lstPosting] in the criteria for AnnouncementID in my qryApplicationslstbox. I am, however, still getting the same problem. Is there a way I have to format it in the query design grid?

All right, I've finally been able to hunker down on your form suggestion (I've been sidetracked a couple days...) but I'm having trouble getting it to come out right. I searched the forum for how to do it, and came across a very helpful post, but I'm doing something wrong. (Help with combo...

RichM, All right, I can see that. Still working on creating the form, though. (Haven't done too much, been busy with another issue most of the day...) Anyway, I don't know much about VBA (though I'm learning... currently fighting with a message box, but I will conquer!) So I think I'm...