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!

Register Log in
  • Congratulations Chriss Miller 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. marabozu

    401 Unauthorized / Published of profiles failed

    Hi, Why am I receiving this error when I try to publish a profile: The refresh page on the site could not be accessed. The returned error is: 401 Unauthorized I already try to access the refreshApp.asp (http://servername/msib21/refreshapp.asp) directly with the browser and I can access the...
  2. marabozu

    Error: Cannot disable control that has focus?

    Hi, I guess that just setting the focus to the subform doesn´t work. I think you must set the focus to another control in the same sub form of the control that you are trying to disable. Hope that helps
  3. marabozu

    using access color pallete

    Hi, thank you for your answer, but I guess I didn't express correctly. What I want is open the pallete color when I am in the Form View (in Run Time). I want to build a macro that runs when the user click a button and then the color pallete apears, the user choose a color and, finally the...
  4. marabozu

    using access color pallete

    Hi is it possible to use the access color pallete in order to change the backcolor of a control? Let's say I click a button, the color pallete opens, I choose one color and then o use the return color value to change one other backcolor control. Thanks
  5. marabozu

    Use access color pallete

    Hi is it possible to use the access color pallete in order to change the backcolor of a control? Let's say I click a button, the color pallete opens, I choose one color and then o use the return color value to change one other backcolor control. Thank you
  6. marabozu

    Getting Memo Fields to completely show up on report

    I don't know if this will help anyboby, but my query had the memo field set to "group by". I changed this to "first" and then the hole characters apear in the report which was based on this query. M. Neto
  7. marabozu

    Getting Memo Fields to completely show up on report

    I have the same problem and I really need to use a query, is there anything I can do? tanks M. Neto
  8. marabozu

    group / sort problem

    Hi, I want to build a query that groups records by one field but, I also want to be able to choose which record will be choose by the value of another filed. In Access one can choose the First and the Last, but what I want is the possibility to choose the record whithin the group by the...
  9. marabozu

    Exit newrecord and go to a specific record

    Hi, I have a form that, when I'm introducing a new record, if the primary key is already being used in a previous record, it exits the new record and go to the respective record. Well, this is what I want to have, but i'm having a problem I can exit the new record "mode". Here's the...
  10. marabozu

    Limit Number of Records in a Contiuous Form

    Hi, Does anyone kwnow if it's possible to limit a continuous form to, let's say, 5 records? Note: the form record source is a table not a query thank's N. Neto
  11. marabozu

    how do I use \r\n in VBS?

    Hi, I want to have a new line to a txt file. In php I use: echo "\r\n"; and in vbscript? I tried Response.write chr(13) but only works in .csv files, but in .txt files doesn't work! thanks in advance M. Neto
  12. marabozu

    Group by pairs of 2

    Hi, How can I group by 2? I know how to group by date, datepart, samevalue, but by a pair I don't know... For example: table A with the records already sorted: a b c d e f g h i j and I want to group (ab) (cd) (ef) (gh) (ij) how it is possible? thanks in advance M. Neto
  13. marabozu

    Query to return the TOP 25, BUT from the last records

    rafe & Gord, the query that Rafe give me works just fine, thanks! But, belive it or not I have a problem that is similar to Tigis one. I have a db that has daily quotes, in particular it has the Open, High, Low and Close of each day. It very easy to get the High and Low for the days (because...
  14. marabozu

    win2000 profissional and win2000 adv. server ODBC problem

    Hi, I have IIS5 running on win2000 professional and a ASP page that connects to a MS Access database. The connection code is: Set imdb = Server.CreateObject ("ADODB.Connection") imdb.Open "imdbConn" and I use ODBC to create a DNS named imdbConn. The ASP page works well in...
  15. marabozu

    Query to return the TOP 25, BUT from the last records

    Gord, Once again thank you. As I can see it's not possible to make the request in one SQL query. In this case, I'm programming using ASP and I don't know how can I create a query based on another query. Do you know how can I do that? Thanks M. Neto
  16. marabozu

    Query to return the TOP 25, BUT from the last records

    ghubbell, thank you for you attention, but I think the way that your say doesn´t work for my particular case. Imagine I want the last 5 records of this table in the field test: 1,2,3,4,5,6,7,8,9,10. If I order by test desc and get the top 5, the query result in: 10,9,8,7,6,5. But what I want...
  17. marabozu

    Query to return the TOP 25, BUT from the last records

    How can I make a SQL query that give the last 25 records of the table? A Query like this: SELECT TOP 25, returns me the first 25 records, but I need (according to my request order) to get the last 25! Any help? M. Neto
  18. marabozu

    inser data

    Hi, I used mysql on a recent project, and, once one enter in the linux system I remember to introduce this comand to insert values on my database: mysql -h server_name -p database_name < file_name.mysql Does anybody knows is that is also possible to do with Microsoft Access 2000? thanks M. Neto
  19. marabozu

    insert data

    Hi, I used mysql on a recent project, and, once one enter in the linux system I remember to introduce this comand to insert values on my database: mysql -h server_name -p database_name < file_name.mysql Does anybody knows is that is also possible to do with Microsoft Access 2000? thanks M. Neto
  20. marabozu

    schedule tasks

    Hello, how can i schedule tasks on a server? i'm using win2000 advance server, have this software some scheduler? thnaks PS - I also need to update my server db from another db every 15 minutes. how can I do this?

Part and Inventory Search

Back
Top