Search results

Does anyone know how I can write a code to define a variable to use a different bound column in a listbox? I have a listbox which is bound to pull the code in one report, but I need it to pull the description in another report so I can concatenate two elements. I want to use the same listbox...

Sorry, can't easily do that as it's on the order of 70 meg and has confidential materials involved. :(

am not sure what you mean by breakpoint? or how to define it. With the code as defined stDocName2 = Me.FacilityUnitListBox it does correctly identify the unit highlighted when run, as it will pop up in the error message, and you can hover over the code in the DoCmd line and see the...

thanks, will give it a try.

yes, my bad.... filter is "FacilityUnit = '3A'" field is a text field running off a query.

sorry, that doesn't work. It pulls back a blank report, as if the filter did not recognize the FacilityUnit. Am not quite sure I understand your use of the quotes. Are they correct? :(

I have a DB when selected audits were initially defined for staff to enter each observation. Over time, the desire has been to change to monthly summaries. I have created new fields etc to accept the new data and new queries to pull across both data types (y/n vs. numerical).. so far so good...

Remember, dates are defined as numerical codes in the system background, so you can use a numerical entry. Select the field on the form design, then go to properties. In the data tab, Validation rule, enter <=date() for dates equal to or prior to today. Then you can add a Validation...

I have two list boxes on a form, one to drive the report selection and one to filter the data. I have the following statement: Private Sub GraphListBox_AfterUpdate() stDocName = Me.GraphListBox stDocName2 = Me.FacilityUnitListBox DoCmd.OpenReport stDocName, [acViewPreview], ...

I have built a listbox which pulls several editable queries. One of the queries, "qrys_Facilities" is linked to "tbl_Facilities" table. This facility table is linked back to "tbl_Main", as the "Facility ID" field. I would like to be able to open "qrys_Facilities" from the listbox and select...

I figured out my own problem... FYI, I changed the query expression to read as follows: Audit Quarter:Year([qry_Master]![Audit Date]) & "Q" & DatePart("q",[qry_Master]![Audit Date],0,0) It therefore reads ... 2008Q1, 2008Q2... My guess is that by including the alpha character it no...

I have a report that is acting screwy... I have a query that drives a report that has the following expression to sort the data into quarters: Audit Quarter: DatePart("q", qry_Master![Audit Date],0,0) & "-"& Year(qry_Master![Audit Date]) As a result I get 1-2008, 2-2008, etc. This works...

I have found that this works much better by simply defining the validation fields in the main table for [Audit date], instead of either defining a macro or code. By setting the required field to yes (which I already had), and the validation expression to > date()-45 I was able to get the...

see attached jpeg. This occurs following the message box[

Private Sub Audit_Date_BeforeUpdate(Cancel As Integer) If (Audit_Date < (Date - 45)) Then MsgBox "The data you are attempting to enter exceeds the 45 day limit and cannot be accepted." Cancel = True End If End Sub That's it....

No, do I need it in the table as well? Would it function better to define only in the table and not in the entry form - as this Audit date is spread across several audits and all tie into the same field in the main table. Thanks

I made the change, but still get the validation error.

I have defined the following code: Private Sub Audit_Date_BeforeUpdate(Cancel As Integer) If (Audit_Date < (Date - 45)) Then MsgBox "The data you are attempting to enter exceeds the 45 day limit and cannot be accepted." DoCmd.CancelEvent End If End Sub JANR, Thanks...

I did mention that, as will tie into the Before Update property of the [Audit Date] field - although that is not the issue, it is the syntax of the validation statement that has me confused.

I had the same problem. In part due to staff minimizing the application. I built a small warning form and set a macro to display this form after the timer (on open property of the form) got to 30 minutes. They could continue or exit the application. After one minute, if no responce, the...