Search results for query: *

OK, found solution.

Hello everybody, Let say I have simple form: 1 command button, 1 textbox. On click button - user gets Open File dialog window, chooses any file in any folder (no multi selection), on click Open/Save - show full path & file name (like c:\temp\test.txt, NOT just test.txt )in text box. I have...

OK, it's resolved. IEfix: http://windowsxp.mvps.org/IEFIX.htm

Hello, I have WinXP SP2, IE 6 sp2. After some install/uninstall different programms, when I open any page in IE and trying using right click to open some link in new window, second window looks like frozen. On a second window I should click "Stop" and "Refresh" to get context. Some kind of new...

Hello! I have some linked table (MSSQL Server). When I analyze this object using Documenter (Tools->Analyze->Documenter), I get report. It includes for section "Columns" 3 columns: Name, Type and Size. Some fields have Type - ": Delete Query" and Size = 16. Could somebody explain me (or point)...

Hello all! Here is the problem. User gets some Email, using Netscape Mail. This Email message has some link "abc.jsp". When user clicks, it's opening also in Netscape, but I want it to be opened in IE (because of some NS bag). Is it possible? Thanks in advance

Hello all! One of our clients has Office 2000. Does anybody know thread or procedure how to import from Outlook to Access: 1. Foldes/subfolders list and their structures. 2. List of messages, subject, bodies etc. 3. If some folder is located in MSExchange server, does it make any...

mirtheil, thanks for your response. One of our clients is using Macola 7.6 and Access XP. He is using old Pervasive 32-bit driver. Some of the tables are huge (more than 100000 records). Access queries (based on linked tables) run >=45 min. I'd like to test it using stored procedures and...

Hi, I created test form with 1 Combo Box (cbID) ( RowSource: "AT123456";"AT123457";"AT123458") and 3 text boxes: AT123456, AT123457, AT123458 This procedure (After Update event) works fine. Private Sub cbID_AfterUpdate() On Error Resume Next Dim ctrl As Control...

Hi, Try SELECT Table1.Name, Table2.Relationship, Table1.ID FROM Table1, Table2 WHERE Table2.ID1 = Table1.ID OR Table2.ID2 = Table1.ID

Hi, In form's design view for txtDate put for ControlSource Property: =Now()

Hi, what about your criteria for selection? Bound Column for both controls has the similar data? Do you have selected row(s) in your List Box when you change your Combo Box value? Let say you have cbID (Combo) and lstID (List) and MultiSelect = 0. Try something like this: Private Sub...

Hi, I have table with a lot of columns (>100). Lets say first field FLD1 Char(12) is a primary key. I need to create procedure, that returns me all columns, using 2 parameters: par1 and par2 (WHERE FLD1 BETWEEN :par1 and :par2). Thanks

Thanks for stars. I think, my star should go to Golom, because he actually showed the right way. StarScream, if your question came from real system needs, could you test time reaction for both our solutions and let us know? Thank you and Golom for your time.

Golom, you are right. But lets do it using 1 query only: SELECT DISTINCT A.Country, B.Job, (select Count([Job]) from [CountryJob] WHERE [CountryJob].[Country] = A.Country And [CountryJob].[Job] = B.job) AS MyCount FROM CountryJob AS A, CountryJob AS B ORDER BY A.Country, B.Job;

Hi, SELECT Country, "Teacher" AS Spec, Sum(IIf([Job]="Teacher",1,0)) AS CountJob FROM Table1 GROUP BY Country, "Teacher"

Me.OpenArgs - just string. You can use expression Forms(Me.OpenAregs).Refresh , if your Me.OpenArgs is valid form name.

docmd.Close acForm, "Form A"

hi, instead Format(Me.FYYear.Value, "yy") use Right(Me.FYYear.Value,2)

Hi all, thanks for nice words. giest4, try just: Nz(...,0) +1