Search results for query: *

I have a document from someone else that has various fields and text form fields in it. I can open the document and all fields are populated, but when I print the fields get blanked out for some reason. HELP!!! :-) Jim DeGeorge (MS Access Programmer) [wavey]

Hi I inherited a table that has 207 fields in it. Yes, I know it's approaching the 256 field limit but I can't change the table right now. What I'm trying to do is change all of the TEXT (10 characters) fields to NUMBER (9 digits, auto decimal) fields. I'm able to change about 10 of these...

Hi I have 2 cells. A1 is formatted as hh:mm[/color green] and contains the value [COLOR=green]44:37[/color green] and A2 is formatted as [COLOR=green]dd:hh:mm[/color green] and the formula =(a1)*24/8 , where the "8" represents that there are 8 hours in a working day. The resulting value in...

Hi I'm a Business Analyst who's trying to make the lives of my developers less painful. I see them writing lengthy code just to put boxes and lines on IBM iSeries Printer Files. Does anyone know of a windows-based program that would allow someone to create report formats with objects and then...

Hi My company's policy is that they don't provide much email storage space for users on the LAN, so they suggested that I change my default delivery location to a PST file on my hard drive, which would remove the limitation. I'm about to do that but get a warning message I expected only the...

Hi My default font in Outlook 2003 is TAHOMA. But when I email a document as an email attachment through Word 2003, the email font changes to COURIER and my auto signature doesn't show. In Outlook I have Outlook selected as my email editor not Word, because I have an html autosignature. But...

Hi I have an Excel file with only 2 columns. It's a 30-page document with a lot of leftover space. I'd like to see 120 rows print in column format on a page rather than just 40 rows. Is there any way to make Excel "snake" the columns before printing? Thanks! Jim DeGeorge [wavey]

Hi I have a document in MS Word 2003 that has section page numbering PAGE of SECTIONPAGES If I print to my HP LaserJet 8150 PCL 6 the page numbering appears correctly in PRINT PREVIEW and prints correctly (i.e., 1 of 8, 2 of 8, etc.). If I print to my Xerox Phaser 7400DN PS the page...

Hi I have a spreadsheet with simple conditional formatting to change the color of a cell (A1: Target Date) if that cell's date value is equal to today or earlier: Condition 1: Cell Value Is between TODAY() and 1 There is a 2nd cell (A2: Closed Date) that I want to bring into this condition...

Hi I have a table with a date field that defaults to DATE() for each new record. When I export this file to CSV format, the date becomes 5/9/2006 00:00:00 rather than 05/09/2006. If I look at the table in Access only the date appears there in the desired format 05/09/2006 but gets messed up...

Hi Every time I close down Windows XP Home, I get error messages that 3 or 4 Dr. Watson files aren't closing down normally. It's a new PC...could there be something wrong with Dr. Watson or is there some way to move up closing these files earlier in the shut down process so I don't see the...

Hi I have the following code in a form's ON LOAD propertyDim db As dao.Database, rs As dao.Recordset, sql As String sql = "SELECT Count(tblGaps.GapID) AS vCount FROM tblGaps " sql = sql & "WHERE tblGaps.Gap_Status = 1 And tblGaps.Conversion = '" & [Forms]![frmSignOn]![ctlConversion] & "';"...

Hi I'm trying to open FORM2 pointing to a record that was selected in FORM1. In FORM2's ON LOAD property, I have the following code Me.RecordSource = "SELECT tblGaps.* FROM tblGaps WHERE tblGaps.DateClosed Is Null " _ & "AND tblGaps.Conversion = [Forms]![frmSignOn]![ctlConversion] "...

Hi I have a control box with this code in the On Change event:Private Sub ctlGapNumSelect_Change() On Error GoTo Err_ctlGapNumSelect_Change Dim stDocName As String Dim stLinkCriteria As String stDocName = "frmGapEdit" stLinkCriteria = "[Gap#]=" & "'" &...

Hi I have a form with some conditions that must be reviewed prior to closing: If Not IsNull([ctlDateClosed]) And ((Not IsNull(Me!ctlResolution)) Or Me!ctlResolution <> "") And [ctlGap_Status] = 1 Then strMsg = "RESOLUTION and DATE CLOSED fields cannot be entered" strMsg =...

Hi Every time I make changes to a form and save them, it takes at least 10 minutes for the form to save and for the database window to reappear. After a while, the form's window header adds "Not Responding", but eventually it saves. Is this normal? Thanks! Jim DeGeorge [wavey]

Hi I have conditions in the Form's BEFORE UPDATE property that when met, I get the desired error message box and the OK button: Private Sub Form_BeforeUpdate(Cancel As Integer) Dim strMsg As String If Not IsNull([ctlDateClosed]) And ((Not IsNull(Me!ctlResolution)) Or...

Hi I have an MDB that's corrupted and nothing in this world's going to save it, not even the JETCOMP stuff from Microsoft. I can't import from the corrupted database to a blank database, but I can export item by item to the blank database. It's VERY painful! :-( Does anyone know how to...

Hi Does anyone know a way to sort by more than the 3-colum option provided by sort (Sort by, then by, then by)? I have a need to sort by 4 columns and am perplexed! [banghead] Thanks! Jim DeGeorge [wavey]

Hi I have 7 numbers and I want to get all the combinations without any of the digits repeating. I know from Excel's COMBIN(7,5) function that there are 21 possible combinations. Without having to sit there and manually write them out, is there a way to generate the list? I'd appreciate any...