Search results

Hello. I am using Excel '07. My spreadsheet has two tabs that get data from access. How do I get values (Employee Name) from the 2nd tab (Roster) removed if they show up in the first tab (NL)? The NL tab is filtered as well to show names from a previous month. Will the code work with the...

I know there was a reply by @CJ_London to this, but got wiped out after the back-up before I could implement his suggestion. Please see the enclosed attachment. What I would like to accomplish is to make a report similar to this, except make it automated so I won't have to change the dates...

I'm trying to get my code to copy certain fields from one table into another after a button click. I got it to where I stopped getting error messages, but my tables aren't updating. I want data from tblForm2Input copied to a new record to tblBosTracking. Private Sub saveandnew_Click()...

Hello again. I have a query (Drawing Query) based off of two tables: "tbl eidandname" and "tbl occurance input". What I'm looking to do, is build a report to include all names off of eidandname but exclude them if they show up in occurance input. The common field between the tables is "EID"...

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

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

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?

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

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