Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: sepia
  • Order by date
  1. sepia

    Editing template images

    I want to replace an image in the template .psd with one of my own. After I selected the layer(blue highlighted), I try to Ctrl-click on its name in the Layers palette. In previous versions, this will immediately give a selection box(marching ants) around the corresponding image on the screen...
  2. sepia

    Mapping drives via wireless/access point

    Hi all. My current home network consist of Linksys 4-port wired router and Belkin access point which my cable modem is connected to the router. I have one desktop and 3 laptops that access the internet thru the access point. I'm attempting to map a drive from a laptop to another laptop or the...
  3. sepia

    IsNull in Record Selection formula

    Hi all. I'm trying to format a field on a report using the IsNull function. Unfortunately, I'm getting the following error: "The result of selection formula must be a boolean". Here's the code: If IsNull({rpMIGroupAuthDetail;1.Service_SubCategory_Desc}) THEN...
  4. sepia

    greatest value

    Hmmm. Never considered the case statement. Thank you very much, guys.
  5. sepia

    greatest value

    Hi all. I'm looking for assistance to get the greatest value from 3 or more different columns. I'm assuming that the best way is to put the columns into a temp table and use 'max' function to return the greatest value but don't know how to code it. Thanks in advance.
  6. sepia

    table creation errors

    Thanks guys for helping out a novice.
  7. sepia

    table creation errors

    Hi all. I'm trying to create a couple of tables which both are related by primary/foreign keys. Unfortunately, I'm getting the following errors: Benefits_Test table errors - Foreign key 'FK__xbMISSN_B__Benef__5D5A1895' references invalid table 'xbMISSN_Benefits_History'. Could not create...
  8. sepia

    Select statement error

    Can anyone tell me why I'm getting the following error: "Incorrect syntax near the keyword 'where'" Here's the code: Select Distinct Residence_Type = luSvc_Residence.Svc_Residence_Desc ,Begin_Date = Residence_Begin_Date ,End_Date = Residence_End_Date ,Room_Number =...
  9. sepia

    16 colors after installing windows me

    Hi. I installed Windows ME on an old Compaq Armada laptop (300mhz) but for some reason it is only displaying 16 colors. I went into Control panel, display to try to adjust it to display more colors but it only list 16. How can I get it to display more colors? Thanks.
  10. sepia

    Netware 4.11 for SB install error

    Thanks for all the help. Actually, after last night, I made some progress. I reformatted the drive (Seagate 4.3Gb IDE), did a new install. It copied all the files but after getting to the "Installing Netware 4.11 for Small Business...Please wait" screen, it just hanged. I might...
  11. sepia

    Netware 4.11 for SB install error

    Hi all. I'm trying to install Netware 4.11 for Small Businesses but running into the following error: Abend: Page Fault Processor Exception (Error code 00000002) OS version: Novell Netware 4.11 Initialization process The CPU encountered a problem executing code in SERVER.NLM. The problem may...
  12. sepia

    NDS Tree

    Hi all. I'm new to Netware and I wanted to know from the experts what would be the most simpliest way to design the NDS tree with 3 users, 2 printers and internet access? thanks.
  13. sepia

    Mail-merge problem

    Can anyone tell me why some mail-merge (from a MS Access query/table) docs displays multiple records on a page when a merge to a new doc is done and others displays one record per page? Thanks.
  14. sepia

    Mail-merge problem

    Presently, I'm producing docs in Word via mail-merge from a Access database. As of now, there is one record per page. I would like to display two records per page. I tried using the {next record} command which will work but the second record on the previous page is displayed as the first...
  15. sepia

    ODBC error

    I"m trying to create a Crystal Report (v.8) accessing a SQL Server database. I'm getting the following error: 'ODBC error: [Microsoft][ODBC SQL Server Driver]Fractional truncation' Anyone have the solution? Thanks
  16. sepia

    ODBC SQL Server error

    I'm trying to produce a report that has a stored procedure running behing it. I'm getting the following error: ODBC error:[Micrsoft][ODBC SQL Server Driver][SQL Server] Error converting data type varchar to smalldatetime Can anyone help? Thanks.
  17. sepia

    Multiple records on mail-merge

    I'm trying to produce a mail-merge report using a microsoft access query that has 3 records per page. There are over a 100 records in the query. I'm using the next record Word field to get the next record in the query. Unfortunately, I can get all the records in the query but the records only...
  18. sepia

    Eliminate blank lines

    I have a text box that list the name, address on a report using an expression. Unfortunately, sometimes it list a blank line where the second address (apartment number) is blank. How can I eliminate the blank line using a expression or is there another method of doing this?
  19. sepia

    Labels viewing problem

    I'm a newbie using Access 2000 and I"m trying to create labels. When I try to view the labels, all I get is this: "#name?". Can someone tell me what I'm doing wrong?
  20. sepia

    Multiple IIF statements

    I'm trying to build a report from a query that has some boolean fields. I want to put some text in a unbound text box after evaluating the boolean fields (put text if true). There are 9 boolean fields which will be evaluated so there can be up to 9 "pieces" of text in the unbound text...

Part and Inventory Search

Back
Top