Search results for query: *

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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?