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 TouchToneTommy 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. cochise

    flash remoting netConnection debugger error

    I'm trying to connect to Amazon's web service; however, I get the following error in my netConnection debugger: DebugId: 0 EventType: "Result" MovieUrl: "file:///C|/PathToFlashFile.swf Source: "Client" Time: 1121048284141 Date (object #1) ....."Sun Jul 10 22:18:04 GMT-0400 2005" Result...
  2. cochise

    flash mx 2004 pro and web services

    Looking on the web I've found numerous ways to connect to a web service with flash: Web Service Connect component Flash Remoting NetService class with as2 and PHP Does anyone have any recommendations as to which is best? And if so a good source for some implementation information. Thanks
  3. cochise

    amazon ecs 4.0 web service connection problem

    I'm trying to connect to amazon's latest wsdl web service through the following url: http://webservices.amazon.com/AWSECommerceService/2004-08-01/US/AWSECommerceService.wsdl This is where I got the above url from...
  4. cochise

    mySQL command prompt / remote server

    Is it possible for me to use the mySQL command prompt to create/manipulate a database on a remote server?
  5. cochise

    amfphp

    If my business webhost does not provide support for AMFPHP package, is there a way to install it on my personal server space or do I have to switch webhosts? If I have to switch does anyone know of a good host that supports AMFPHP and MySQL?
  6. cochise

    partial update of table by importing

    Is there a way to import data from an Excel spreadsheet into an existing table, but only replace certain fields from certain records? The fields would be the same for all updated records.
  7. cochise

    consolidating fields

    I have a query with two fields. Each row has 1 or both of the fields populated. If both are populated the value is the same. How can I create a 3rd field that consolidates the two, so that there are no null values?
  8. cochise

    ranking and limiting query records

    I have a simple query that returns supplier and spend data; however, it returns thousands of records. I want to sort descending on spend value, and return only the top 50 records. How can I create a field that ranks by top spend? I appreciate the help. Here is my current SQL: SELECT [Raw...
  9. cochise

    Query autonumber

    I have a simple query that returns supplier and spend data; however, it returns thousands of records. I want to sort descending on spend value, and return only the top 50 records. How can I create a field that ranks by top spend? I appreciate the help. Here is my current SQL: SELECT [Raw...
  10. cochise

    CInt error

    I an table I have field [DiscType] as text (this can't change). Some of the values are numbers some are actually text. I need to convert the numbers to integers. In a query I'm using CInt to convert these values to integers, however, the ones that aren't numbers are returning an error...
  11. cochise

    * in a number field

    Okay, I figured it out. If curious, I created a non-visible text box which either had a value of my combo box or a "*" and changed my query criteria to reference the new text box.
  12. cochise

    * in a number field

    I have numerous queries that refer to a combo box on a switchboard form for the criteria value for the query. On my queries in the criteria field under a EmpNum field (number/integer) I have the following text: Like [Forms]![Switchboard]![Report Form].Form.cmbEmpNum I would like the query to...
  13. cochise

    How do I reference the 4th column v

    How do I reference the 4th column value (DateCriteria) in a table (tblReports) for the current record (ReportName) selected from a listbox (lstSelectReports). My idea is to set the list boxes RowSource so that: WHERE tblReports.DateCriteria = " & [4th column value] Do I have to use a...
  14. cochise

    can't go to specified record

    Sometimes when a user starts to enter a record, he may need to clear all fields and startover. I thought the best way to do this would be to null all the fields. I guess I could just delete the record, but was curious what was actually happening.
  15. cochise

    can't go to specified record

    On a form I have a clear button that nulls all fields. However when trying to perform another operation after clearing fields I often get the following error message: 'can't go to specified record'. After pressing the escape key, the problem seems to be solved, however, I do not want my users...
  16. cochise

    filters on a tab control

    Thanks. It was extremely helpful.
  17. cochise

    filters on a tab control

    I'd like to try your method, however, not sure exactly how to go about it. Right now my record source is set to the underlying table b/c, most often, when the form is opened the user will enter new records. Only occassionally will she use the search feature. So how would you go about setting...
  18. cochise

    filters on a tab control

    I have a tab control. Each tab has a form on the control. Each form has a filter property and a search button. My intention is to have the user hit the search button, enter the 2 field values (always 2) and have the form display that record. For example, one form (based on a table) has the...
  19. cochise

    updating control source in reports and parameters in queries

    I have various controls in reports and parameter values in queries that reference a control on a form. I recently embedded the form on another form, so the path has changed. Is there anyway to automatically change/replace the old paths with the new one?
  20. cochise

    referring to a embedded control on a form

    Referring from code in a different module, not the same form.

Part and Inventory Search

Back
Top