Search results

I have a combo box which selects for facility. I want to use that selection to filter a query which is the data for a second combo box. The code properly identifies the selection from the facility, "DefinedUnitList" but I get a runtime error "The field is to small to accept the amount of data...

I have a dropdown list generated from data validation that allows a user to pull various sheets based on the list selection in field d17 of home sheet. A macro "Go" button executes the code on click. If Sheets("Home").Range("d17") = "3B" Then Sheets("Home").Visible = True...

I have a module with the Microsoft suggested median function as below: Function Median(tName As String, fldName As String) As Single Dim MedianDB As DAO.Database Dim ssMedian As DAO.Recordset Dim RCount As Integer, i As Integer, x As Double, y As Double, _ OffSet As Integer Set MedianDB =...

I have a multiselect text data element (listbox) on a form that stores data in a main table. From this main table (and only this table) I have a query that correctly displays the multi-select objects as text. However, when I add the field into a report, using only the query based off only the...

I have a multiselect listbox which is stored in a table. I then have run a query from that table and it accurately displays all the selected field items. (as descriptive text, not as numerical code). However, when I build a report and pull the query field into the report, it displays as the...

I have a query which sums a yes/no selection box resulting in a negative sum. I then pull this value into a report. In the past I have been able to multiple the Sumof Field by -1 to correct the value to a positive integer within the field properties in the report. However, my mental block...

I am using Excel within Office 2007. When I add a data table to a chart, the data table is docked on the x axis of the chart. A coworker's data table is separate from the chart, allowing for additional flexibility. We have been unable to identify how to convert one type to the other, though...

I am having a problem with setting the alternative row color. Some reports work and some do not. I have both types defining the detail section. Is there some setting I need to check? Everything looks good and consistent as far as I can tell. It appears to ignore the background setting on...

I have a spreadsheet where I was forced to merge cells together. I then have a second spreadsheet in which I enter data. The first sheet with merged cells autopopulates when the data is entered into the second sheet. I know I can write a formula to pull in the data, but because the...

I have a new build with a data entry form bound to a query which pulls from my "main" table and one linked table. The query pulls all the fields from the main table plus all the fields from the linked table. The primary keys for both tables are located in the query. The query runs fine. I...

I am planning a file with about 30 worksheets, 3 for 10 different departments. To make it easier for staff, I would like to create a data validation list of the 10 departments and use this to drive what worksheets are visible or hidden. The simple version is below: Sub...

I have a formula that works fine. I copied and pasted into another cell. After, the copied formula does not work. The formula evaluator indicates there is a constant in the equation. I then built the same formula using the formula wizard, instead of typing it out, and the wizard pulls the...

Am wondering if anyone knows of a way to create an ad hoc data query from a form, which also shows check boxes for all fields. Basically, I would like to have the user be able to check the data box for the fields they want to see, then run the query. The query would only display those fields...

Am wondering if anyone knows of a way to create an ad hoc data query from a form, which also shows check boxes for all fields. Basically, I would like to have the user be able to check the data box for the fields they want to see, then run the query. The query would only display those fields...

I have a query which runs off one table. No calculations, no code, etc. just pulling fields down from the table. End user entered a duplicate record and is unable to delete. Have verified all delete functions are greyed out, and unable to delete record. I would think a simple on/off switch...

I have a spreadsheet with thousands of lines of data. Each of the first 5 columns have selections, the combination of which ultimately drive the display of column 6. Using filters on each column I can narrow the selections that display in column 6. What I need to do is devise a dummy proof...

I am having trouble calculating an average, both in reports and in a query, for a series of calculated time differences. Basically this calculation takes into account times spread across midnight in a 24 hour clock. Therefore if Time 1 was at 23:50 and Time 2 was at 00:30, I'd get 40 minutes...

When building the custom user interface ribbon, I used groups just as much as possible. However, on a few groups, I had to build the pieces I wanted. They work great, but they basically are turned on all the time. If you click on one when not appropriate, you get a macro error and the...

I have a calculation that subtracts two time values to come up with a difference in minutes. I want to take these minutes and generate an average difference in the reports. However I get an error indicating the calculation is to complexed. I thought perhaps to create a new field in the...

I need some recommendations on the best way to write an error scipt in the code. Basically, I want to prevent the "canned" MS error message that includes the debugging, etc. For example, if someone starts to run a report by date range and then cancels before all the parameters are met -...