Search results for query: *

Hi every one, We got some troubles with our SQL server 2000. Our technicals made the setup of SQL Server Enterprise on a Windows 2000 Terminal. We have on this server some SQL Databases, all using the same application. After few access to one of these DB, doesn't matter which one, the virtual...

Hi, After a good reflexion and many tests, I've finally found the solution. Here is the SQL : SELECT EMPL_NO, MAX(Date) as MaxDate, (SELECT Group_Nr FROM <Table_Name> TN WHERE TN.Date = Max(S.Date) as Grp FROM <Table_Name> S WHERE Date <= <Date> GROUP BY EMPL_NO Sorry for this thread ; I hope...

Hi every one, I've a little problem to acheive this query. There is table with the following fields: Empl_No Date(Numeric) Group_Nr Now the datas: 001 001 001 001 5400 5440 5470 5485 A B C A I need to retrieve the group at a distinct date...

Hi Crowley16, I've found the problem. To open the form from the menu I use a macro, and the data mode was read only. Sorry I apologize for so a stupid thing. :-( Thanks again.

Hi, I've created a custom menu with few controls. One of these opens a form which retrieves data into a listbox. This is done using VBA code ( lbo.rowsource="select..."), not from the listbox properties. I get the results in the listbox but can't select any row. The Locked property is set to NO...

Hi guys, I'm really in trouble now with a little application I've developped for a customer in Canada. There is a big application which is in charge among other things to import a text file. The datas are imported in an Oracle v8 DB .If the import succeeds it is possible to run an external...

Hi Cranebill, I've created my listbox using a SQL statement. Here you can get an overview of the result: ID CompanyN NbEmpl Seller 1 Ardatis 240 Max 2 GialTech 110 Miguel The first row which is the heading is the row I want to change the colour. They...

Hi cranebill I'm not sure I understand well what you said but when You go in the listbox properties (format), you can select for column heads. I want to know if it is possible to change the back and the fore color of these labels generated by the SQL using VBA ?

Hi everyone I've a form (Company) which retrieves company information. In this form I also have a tab control with some tab pages; in one of them I've a form (Contact:company) with 3 subforms. In one of these subforms I display the information in a datasheet form about contacts made with...

Hi eveyone Is there a way to change the column heading of a listbox ? Thanks for your answers.

Hi everyone, I've got a custom menu like this: query/report --> Company status Company FollowUP Contract FollowUP and a unique form which needs to know which choice was made. How can I retrieve which option was chosen in the menu in order to run the...

Sorry everyone I've found my error. The code needed was: Me!SubQueryByForm.SourceObject=&quot;qryFrmContract&quot;

Hi everyone I've a form that I try to make it reusable. This form displays three listbox and a subform which shows the datas according to what was chosen in the listbox. For the moment I have made three identical forms doing the same thing.In these forms the subform sourceobject refers to a...

Hi everybody I have my Combobox in the form header which lists all the companies name. When I choose one in the list, the detail section displays all the informations about. My problem is that I want the Combobox to be refreshed in order to show the same company name when I go through the...

Hi Golom You are fantastic you work also on saturday. It works really good; I've try many options without success but now I'm happy and I've learned something. Thanks a lot Golom Have a nice Sunday. Akinia

I've forgotten something important. I also don't want to see the records in table B which are in table A. Thanks again for the answers.

Thanks Golom for your fast answer. I try it and let you know

Hi every body I've a little problem with my query, I can't figure it out. I've three tables: Table A (EmployeNr, Date, Code) Table B (EmployeNr, Date, Code) Which is an historic of Table A Table C (BegD, EndD) I can have all the records in table A that doesn't match in table B but not from the...

Hi every body I've got a little problem with my form (&quot;frm_Company&quot;). It is divided in two parts: - first one is filled with some text fields over the company. - second one is filled with a tab control and give informations about contact persons. On this tab control there is also a...

Hello everybody, First I'm using Access 97. I've a form which gives some informations about customers. In this form I've a subform which shows (in datatsheet form) the last status for products where the customer is interested in. When I double click in the status field it opens a new form...