Search results for query: *

My database contains inspection data for inspections done on food facilities in the area. My task is to build a report that will show: FacilityID, InspectorID, Last InspectionDate. The following sql works, but when I add the InspectorID, it no longer shows the last inspection date, but all...

I have a combo box that pulls information from a table. The table (FDAcode) lists over 400 FDA food codes. Codes are set up with the first 2 digits defining which part of the code it refers to. So you may have codes IE: 22-601.13; 31-401.23; 11-101.423 So in this example the 22 & 31 & 11...

I designed a report that invoices food facilities license fees. The invoice is designed with page header/footer Business Name Group header and a Billing date header/footer and Detail section. All works great. However, I would like to add a second page that would be a questionnaire. How would...

My Select Query reads: SELECT Food.FacilityID, License.LicenseID, Food.Priority, Food.Status, Fees.FeeID FROM Fees RIGHT JOIN ((Food INNER JOIN License ON Food.FacilityID = License.FacilityID) INNER JOIN Invoice ON Food.FacilityID = Invoice.FacilityLUID) ON Fees.FeeID = Invoice.FeeID WHERE...

Currently we are manually entering annual invoices for 300+ food licenses. The invoice is using 3 different tables: 1) Food: with fields FacilityID; Priority; Status (Priority dictates the risk factor and fee level) 2) Invoice Table: InvoiceID; FacilityID, Billing Date; FeeID 3) Fees...

I have a client DB that records visits. I would like to add a field in the table that will count the actual number of visits a client has in their history. I'd like it in the table so that the field can be used effortlessly in a form, report or query. If I use the count function in query it...

Is there a way to either have a yes/no check box highlight or change the 'check' to red when the box is populated with the check? I would like the check box 'stand-out' so that a user sees it if the value is true. Thanks again in advance to all the guru's out there!

I would like to trigger an after update event to populate a field when a certain value of another field is chosen. The choice field is a combo box. When the user chooses "Write-off" from the drop down, I would like to have the field "InsPayment" to be populated with "0". The InsPayment field...

I have a command button on a 'Inspection' form This command button is to open an additional form that shows the inspection details. When clicking on the command button, the form opens to a blank form and not showing any data. Any idea why this is not working? This is the code I have behind the...

I would like to have a popup message box that warns the user that data has been changed and they must verify the change or cancel the if the change was in error. This is the code I have: Private Sub LastName_BeforeUpdate(Cancel As Integer) If MsgBox("Last Name has been changed, is this...

Currently I have a form that records outcomes from a restaurant inspection. A list of violations is used that reside in a table. Obviously, most restaurants do not have a lot of issues and only those that are found are recorded in the 'Inspection' However, even though only a couple...

I have a combo box on a form with the following code in the After Update event: ' Find the record that matches the control. Dim rs As Object Set rs = Me.Recordset.Clone rs.FindFirst "[Name] ='" & Me![Combo77] & "'" If Not rs.EOF Then Me.Bookmark = rs.Bookmark End Sub I...

I have a report which has a calculated field - see attached. What I would like to have this report do, is to print a month at a time using this calculated field. Usually this is easily done in sorting and grouping, however, since this is a calculated field on the report itself, I do not have the...

I have a field in a table that has descriptions of type of inspections done. Some of the fields are: Routine, Follow-up; Liquor, Opening, etc. I would like to have the text in the field for Liquor be red, and all the others in the standard black - is it possible to do that?

=IIf([Priority]="1",DateAdd("m",4,[LastOfInspectionDate]),IIf([Priority]="2",DateAdd("yyyy",1,[LastOfInspectionDate]),DateAdd("yyyy",2,[LastOfInspectionDate])))

I have a patient table which includes names, dob, sex, etc. Of course patients could be adults; children and dependent adults. I want to be able to have all these people in one table; but also want to be able to identify Jane Doe as a parent of Bobby Doe. At the same time Jane Doe is also a...

I have 2 databases. The source database contains Customer Names (Customers) The destination database contains Customer Information (CustInfo) The tables used to link the two databases are: tblCustomer from Customers with the field CustomerID as primary key; and tblCInfo from the CustInfo...

I have a table that represents times of day for an appointment data base. The field is a number field with data entered as: 06:01 AM, etc. I also have a query based on that table. I would like to set the criteria in the query to only show times between 07:00 AM and 06:00 PM. I first tried the...

I have a query with the following fields: "InsPayment" and "Fee" I want to have a calculated field named Adjustment. The Adjustment should calculate what to 'write-off' only after insurance pays their portion of the fee. This is what I have for the Adjustment field: Adjustment...

I have a form with 3 parameters. These parameters dictate what to display on a report. The user will choose their name from the Employee combo drop down box and then choose a date range for the report. I have the following code in a command button to open the report. DoCmd.OpenReport...