Search results

or... is there a way for the query from the report to make a new record and bypass the form?

For Access '02. I have a report that does this perfectly (except making the new record). This is the query sql: SELECT TOP 10 PERCENT [all locations].AutoID, [all locations].Location, [all locations].Zone, [Zone Code List].Building, Rnd([AutoID]) AS RandomValue FROM [Zone Code List] INNER...

Thanks for clearing that up. I'm having problems with my code, though. Could you please explain what is wrong? SELECT Qry occurance input.EID, Qry occurance input.First Name, Qry occurance input.Last Name FROM Qry occurance input ORDER BY Qry occurance input.EID Where EIDS = Forms!frm...

Very good. Once again a simple solution has escaped me. lol One more (noob) question. The whole form is saved as 1 record (and as I look in my previous posts, I notice that I did not mention that. My apologies). Since these 3 fields are unbound, will they still be saved with the rest of the...

My form's recordsource is from "tbl occurance input". tbl eidandname is only for the 3 fields outlined in the pic.

The form's recordsource is a different and unrelated table. This method looks like what I'm looking for, if the form recordsource problem can be worked around. Thank you for your help! I did take a look at your db. I might use this for another db that I manage.

I realize this is posted quite often in this forum, but I haven't been able to find a solution to my particular problem. I have 3 combo boxes filled with employee names and an employee ID #'s. They are populated by their own queries, and all the queries pull from tbl eidandname and have a...

Sometimes the simplest things get overlooked. lol Thank you all for your replies!

The main report is unbound. All of the sub-reports have their own queries. They are similar to this one (apart from the shift): SELECT [tbl eidandname].Shift, [tbl eidandname].[First Name], [tbl eidandname].[Last Name], [tbl eidandname].[Tech ID], [tbl eidandname].Job...

I have a report that has 6 sub-reports in it. When I run the report, everything fits in one page, but I have 75 other pages that are identical to the first. For the life of me, I can't see what I did wrong. Any ideas?

Thank you for the quick responses! Mr. B's method was the preference. Thank you!

On my db, I have a generic report that just prints a form for our observers to fill out. How can I make a query so they can prefill their name on the sheet? I've thought about using a query and putting their names in it, but we have a high turn-over, the list would be loooong, and some...

That does help. I've just gotta figure out how to incorporate it with the rest of the issues. lol Thanks!

I've seen a lot of answers about these questions, but I need a little help combining all of these. I have a little experience with access, but not too much. I'm trying to make a form to search one field (Zone) to return 10% of the results from another field (Location) from table "all locations"...

Hello everyone! I'm a safety rep/forklift operator in a warehouse and production line outfit. I'm a dabler in access and usually get tasked to make/update the databases. Outside of work, I'm a family guy with 5 kids (3 girls, 2 boys. Blended family). Love to read on my Kindle Fire, and...