Search results

I know this is an older thread, but it has been quite helpful in helping me build my search screen (which builds a filter string). By request of the user, I am using a multiselect combo box for a data collection. I know this is not the best way to go about it, but I am sort of stuck. On my...

Hello All, I have a table that contains an inventory of boxes (BoxNumber is Auto-Numbered) when added to the table. This is an effort to create a FIFO system for the boxes. When an invoice is created, I want to update "n" number of boxes from the inventory with a new status. Of course this...

Hello all, I have 2 tables. Table A contains a list of employee names from an outside source. Table B contains a list of names from HR. I would like to compare the list of names from Table A to the list in Table B, but I would like to match on a "fuzzy" lookup. Example: Table A LastName =...

Answered my own question with a bit more detective work! I know that someone would have jumped in to help out soon. http://office.microsoft.com/en-us/access-help/link-outlook-contacts-to-an-access-database-HA001116581.aspx

Hello, Is there a quick and easy (or not so easy) way to use Microsoft Outlook Address Book to populate a dropdown combo box? I am creating a form that needs to pull in Business Process Owners, all of which would be in our corporate address book. Thanks in advance! Mark

Hello all, I have a report and forms that do a points total to 3 decimal places. I would like the display to be all 3 places. So if the result is 122.3, I would like the output to be 122.300 Is this possible? It just looks much nicer on the output. See my example attached. Thanks!

Plog, You are a hero! Thank you so much for your help. If you are ever on the East Coast of the US look me up and I will feed you some top notch BBQ! Mark

Hello Plog, Thank you so much for jumping in to help out with my question. I hate to admit it, but I am just not sure what to do with the code that you took the time to write for me. I have attached a copy of my database to this thread. Can you take a look and give me some more direction...

Ok, I got rid of the "duplicate" table. Didn't need that after all. It appears that my problem is this, I want the top 5 scores from a list by team_number. If the scores in the database are 160, 140,135,135,135,135,135 the result of the query gives me ALL of the 135's. I only want to go down...

I guess I took this line in the Points to Note as I needed duplicate tables: -Since we have two copies of the same table, we need the alias. Programming is not my strength, so I was probably reading too much into the note.

Thanks for the lead Brian. I tried that method and it keeps returning more records than I seem to want. I made a duplicate table named Dupe for the Chicken_Points table and here is the query (I attached the results of the query to this post). Ultimately, I want to take the Top 5 results from...

Here is table in excel format

Hello All, I am working on a database that will track points for BBQ Competitions. Only the top 5 highest points results are to be counted for each team. Team_ID is the Unique identifier for each team. I would like to sum the top 5 points finishes for each team and order them high to low...

That was perfect! Thank you much plog!

Hello All, I have the following =DSUM in a box on my form: =DSum("[NON_Value_Total]","[NON_Detail_Records]","[Employee_ID] = " & [Employee_ID]) Works great, but I want to include a parameter that only gives me results for the current year from a field named NON_Date_Proposed. Not sure at...

Thanks again Paul, I am getting a #Name? in the control box that has the DSum when I use that code. I have attached a screen shot of the design view and form view to take a peek at. Mark

Thanks Paul, I put in the DSum and it works like this: =DSum("NMC_Value_Total","NMC_Detail_Records","Physician_ID=2") but, I want to sum based on a control box on the form called Physician_ID. I try to type it in and the editor keeps changing this...

Good Morning All, I am creating a database to track gifts to employees. The admin person will fill out a form for each gift and create a report with a total $ value for those gifts for the history of the employee. I would like to create a box on the form that totals all of the $'s for the...

I think I am going to try the Table idea. This is an odd one for sure. Thanks again! I will let you know how it goes.

Thanks Paul, When I try that I get a Type Mismatch error and I know that I have a 4 character text field in the database. I tried to shorten to just 2 instead of the 55 that I was looking for in query builder and the syntax looked like this: WHERE (((dbo_lkSJMINSURER.SJMPHSINS)="M11M" Or...