Search results

I have a spreadsheet that has 133 columns that represent categories. On the row side I have about 1700 project numbers. Each project will use up to 14 of the 133 columns. The columns that are used with a project will have a cell labeled with a number 1. Example below: Project No. Column...

Thanks for the help I appreciated the code. It works! Thanks again. Dick White

Date Format From what I understand, the first 3 characters are the number of years since 1900(104) and the 114 is the number of days so far in calender year(April 23) Dick W.

I am working on a query which is based on a table which was populated by a comma deliminted file. One of the fields is a 6 digit number(calculated date field) which I need to convert to a six digit date. Is there a function which will convert that number to a date. I have tried various...

I am having a problem trying to set the autonumber in a table back to 0. I worked through the help info and was able to do this on my laptop(Win 98). I did this by creating a temporary table with one record with one long integer field with a default value of 0. I would append this record to...

I have been trying to filter a report by setting the value using the following code in the "Open" event on a report(based on a crosstab) Private Sub Report_Open(Cancel As Integer) 'Dim RegionString As String 'RegionString=InputBox("Please enter region code") Me.Filter = "RegionCode='wf' "...

Thanks for your help! That worked. Dick White

The sub totals net out both negative and positive numbers and I am trying to find where to place the filter to eliminate those groups. I tried the report filter, but it does not recognize the text field which calculates the sub total, so it could be how I reference that control at the report...

I have a report that prints out both detail and summary. I want to eliminate the groups that sub total to 0. I have tried placing an expression in the group footer(txtSubTotal]<>0, but it still picks up those groups. Is there a better way to do this. It would eliminate a lot of wasted paper...

I am using an Acess macro to send data from Access to an Excel Spreadsheet. This creates the worksheet with the data. I will then run an Excel macro while the spreadsheet is open to format the spreadsheet. What I want to do is have the Excel macro run automatically after the spreadsheet is...

I am working on revising our check format. I want to find out if there is a way to convert a numeric like 60 to "sixty". Thanks for any help. Dick White

Does anyone know the coding and where to place it on a main report to keep sub reports visible when there is no data?

I want to keep sub reports visible on the main report when there is no data behind it. I have tried using the HasData property in the print event of the detail section of the main report. I can get it to respond to message boxes, but still can't make the sub report visible. Thanks for any help!