Search results

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

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!

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

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

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

Getting error that says the ORs part is too long for the query builder. This is the only way I know how to do it. Can someone give me an idea? SELECT DISTINCT dbo_SJMPatientNames.PatLastName, dbo_SJMPatientNames.PatFirstName, Step4CombineBillingsAndPayments.Histno...

Hi All, I have 2 subforms on my mainform. I need to get data from a control on subform 2 over to subform1. Can someone help me with the syntax? Mainform name: frm_restitiutionDataEntry Subform1 (where I want the data to appear): sfrm_restitutionDetails control name: decRestAmount...

Hi All, You have been a great help to this novice in the past, and I am again asking for some help. I have 2 tables, the first is CASEDATA and the second CODES contains a list of codes. The CodeNumber is the joined field between the tables. In my form, I have a Combo Box that lists the...

Hi everyone, I am really stumped here and I am not sure how to make this work. If my password is correct, it works fine. If the password is incorrect, it shows the MsgBox and then cycles through the loop until the count is 4 and exits. I can not set it to allow me to re-enter another...

I have built a database to store case files. The case number is automatically assigned starting at number 1 on January 1. I use this code to get my next sequential case number when I click to save the record: Me!txtCASE_NUMBER = DMax("CASE_NUMBER", "tblCaseDetail") + 1 MsgBox "Your Case...

This is my first post to the forum. This group has been extremely helpful and I want to first thank you all for your good work! I have been using a sample of Allen Browne's Search Form to do a search form of my own. If anyone has time to look at the example at...