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 strongm 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: *

  1. allanon2

    Help Displaying Error Messages

    If you put this line of code: <message-resources parameter="ErrorMessages" key="errors" null="false"/> into the struts-config.xml file it sets up a pointer to a message file called ErrorMessages.properties In this file I only have two line right now cause I cant get thigs to work quite right...
  2. allanon2

    Help Displaying Error Messages

    Thanks for the help. I turned it off using <controller locale="false"/> but no luck. Still does the same thing.
  3. allanon2

    Help Displaying Error Messages

    I am trying to display error messages and the are displaying but not correctly. They display like this: ???en_US.Invalid userId or Password??? Here is the code that I use to fill the errors: <code> public class BaseAction extends Action { public static final String APP_WARNING_KEY =...
  4. allanon2

    Remove the time.

    I only want the date to display in a field but when you click in the field the time displays also. I have tried setting the format to mmm dd", "yyyy which looks great until you click in the field. Is there anyway to prevent the time from displaying short of formating the field as text?
  5. allanon2

    font colour in text that is not enabled

    If this are is never to be enabled then change it to labels. If it has to be enabled occationally then instead of .enabled = false try .locked = true Just a thought.
  6. allanon2

    Files claim to be read-only but they aren't

    Sometimes when you link to a table if the table has no primary key access makes it read only.
  7. allanon2

    Interesting problem with stopping application

    Check the references on a machine that does not work. Might be missing a dll.
  8. allanon2

    Interesting problem with stopping application

    If the client machine in Xp or anything other than NT you may have to compile it on the client machine before it will work right.
  9. allanon2

    Suggestions? How should I approach this DB problem?

    SELECT DISTINCT in_grp.TheData FROM in_grp WHERE (((in_grp.TheData) Not In (SELECT DISTINCT GrpMaster.GroupName FROM GrpMaster ))); This selects all of the distinct records from in_grp where they do not already exist in GrpMaster
  10. allanon2

    text file to table using vba

    Ok. Try This One. Public Sub Text() Dim strLine As String Dim strACOD As String Dim strCNUM As String Dim rs As DAO.Recordset Set rs = CurrentDb.OpenRecordset(&quot;table1&quot;, dbOpenDynaset) Open &quot;C:\My Documents\gl0340.txt&quot; For Input As #1 Do While Not EOF(1) Line Input #1...
  11. allanon2

    Check boxes on a form, used in a query to give an output?

    Check the 'Order By On' to make sure it is yes. It is on the data property tab for the report. There is also an 'Order By' property. You may have to set that.
  12. allanon2

    text file to table using vba

    Try this and take it from here. Public Sub Text() Dim strLine As String Dim rs As DAO.Recordset Set rs = CurrentDb.OpenRecordset(&quot;table1&quot;, dbOpenDynaset) Open &quot;C:\My Documents\gl0340.txt&quot; For Input As #1 Do While Not EOF(1) Line Input #1, strLine If...
  13. allanon2

    Check boxes on a form, used in a query to give an output?

    The if has to be in your click event as well.
  14. allanon2

    Check boxes on a form, used in a query to give an output?

    TI would not do that. I would leave the testing of the cbo in the same routinve as the call to your function. It should go in this procedure: Private Sub cmdPrintSpecific_Click() Dim strSQL As String strSQL = &quot;SELECT tblSalesLedger.InvoiceNumber, tblSalesLedger.InvoiceDate...
  15. allanon2

    Check boxes on a form, used in a query to give an output?

    Oh. Ok. Where are you putting the statement &quot;If cboPrintOrder = &quot;Customer Name&quot; Then&quot;? What event? What Module? What Form? Etc.
  16. allanon2

    Check boxes on a form, used in a query to give an output?

    What displays in a combobox is not always what is returned. Before your &quot;If cboPrintOrder = &quot;Customer Name&quot; Then&quot; type this: debug.print me.cboPrintOrder. You may be surprised at the result. Look in the immediate window for the result.
  17. allanon2

    Check boxes on a form, used in a query to give an output?

    Opps. Logic erro on my part. Change the line: CreateWhereString = CreateWhereString & &quot; AND &quot; To Read: CreateWhereString = CreateWhereString & &quot; OR &quot;
  18. allanon2

    Find latest record to fill data

    Ok. I copied you query and created a couple of tables to match your field names. Ran you query. It worked just fine. The I changed it to be this: INSERT INTO tbl_AirBird ( Record_Created, AP00, AD00, AA00, AR97, AR98, AC00, AC01 ) SELECT Whole_Data.Record_Created...
  19. allanon2

    Run-time error 3146 - ODBC-call failed

    Does the odbc connection exist?
  20. allanon2

    Find latest record to fill data

    I can help you. I think that you may have to change your append query just a little. Here is what I did and you can see if it is somewhat like your situation. 1. I copied the function to a module. I had to make a slight change so my function looks like this: Public Function LastNonNull(var As...

Part and Inventory Search

Back
Top