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 bkrike 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: cochise
  • Content: Threads
  • Order by date
  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

    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...
  10. 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...
  11. 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...
  12. 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...
  13. 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...
  14. 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?
  15. cochise

    referring to a embedded control on a form

    I have the following path: Form [frmMain] Tab [tabMain] Page [pag1] SubForm [sfrmA] Control [txtAccelID] I'm trying to reference the txtAccelID in my code, however, can't seem to make it work. This is where I am now...
  16. cochise

    sub routine

    Is there a way to exit out of a sub routine once a certain condition has been met? I have an If statement, which if true, I would like it to exit the sub routine and not continue with the rest of the code. Any help would be great. I tried exit sub, but it doesn't seem to work.
  17. cochise

    turning a week # into a date with a specific and constant day

    In a query, I group a range of dates into a week number with the following formula: WeekNum: DatePart("ww",[Date],4) How can I take that WeekNum and turn it into a date that is always a Tuesday with a label EndDate. For Example, if: WeekNum = 1 EndDate = 1/2/03 (tuesday) or...
  18. cochise

    printing microsoft office docs and spreadsheets

    Does anyone know how to create a button that prints a excel file or word document? Or the code I would put behind the button?
  19. cochise

    sorting a query

    I have a query and I need to set the criteria so all records with a field value of 15 and 18 in Source do not show up? I put in the criteria Not Like 15 and that worked, but I don't know how to make it so 18s are not included as well. Any help?
  20. cochise

    conversion

    I have a field that has a string in the following format: hours:minutes, for example 58:14, for 58 hours and 14 minutes. Because the hours exceed 24, I can't use the time format. How can I convert this string into an number?

Part and Inventory Search

Back
Top