Search results for query: *

Dear All, I have a query which produces the results I want, but it takes forever (ca. 25 secs on my pretty fast machine). Each line is repeated 15 times for data of different years: SELECT qryActNENK.PID, Sum([CRev2015]/1.29) AS [WS-Rev-2015], (x15) Sum([CRev2015]/1.29*CProb) AS...

Hi All, I am fighting with a query... A part of it goes like sSQL = sSQL & "IIf(" & rst.Fields(k).Name & " <> " & rst.Fields(k - 1).Name & ", " & rst.Fields(k).Name & ", '') AS MMove, " This works and means: if the value of a certain field(k) <> the value of another field(k-1) then show the...

Dear All: I have a select query, which at one part needs variable vield names via a vba function. The following query works: Select A.ID, A.MS200810, A.MS200811, A.MS200812, IIf(A.MS200812 = A.MS200810,"","X") As GOMS However the query: Select A.ID, A.MS200810, A.MS200811, A.MS200812...

Hi All: I have this 'simple' (and working) query SELECT A.ID, A.[201409ST], Switch([A].[201409ST]="New",1,[A].[201409ST]="M0",2,[A].[201409ST]="M1",3,[A].[201409ST]="M2",4,[A].[201409ST]="M3",5,[A].[201409ST]="vHVM",6,[A].[201409ST]="rhVM",7,[A].[201409ST] Like "*XxX*",8...

Dear All, I have an access form ("frmCover") which displays an access report ("repMonthly") with four subreports ("rptInst1", "rptInst2", "rptInst3", "rptInst4"). The first two subreports are in a group header section of "repMonthly". I successfully reference their recordsource - e.g. for...

Dear All: I use the following code snippet (replace function) to modify the attributes of a text item in a rich text box (Topic1 is a textbox, sFieldName is a variable) ..... Const sTagColor = "<font color=""""red"""">" Const sTagLarge = "<font size=""""3px"""">" Const sTagEnd =...

Dear All: I have a webdb with two queries which are are obviously not web compatible (due to the first crosstab query): 1. TRANSFORM Count(tblDHighLow.DHighLowID) AS DHighLowIDOfCount SELECT tblDHighLow.Update, tblDHighLow.Division, tblDHighLow.Project FROM tblDHighLow GROUP BY...

Hi All, I have a database table with an attachment field. I want to e-mail this attachment... how can I do that? I am familiar with the code for e-mails...: but the code ...Attachments Add... works only for files in folders: With objOutlookMsg .Attachments.Add "C:\Users\georgesOne\Desktop\Cost...

Dear All: I have a form which is used by (at least) two users. The first user will add an attachment to an otherwise empty new record. Later the second user will add some comment in the fields based on the content of the attachment. However, the attachment is not committed to the new, empty...

Hi, I have created an access/sharepoint web database inclduing one table, which is dynamic, i.e. it gets data from users and throws them out after a few minutes for another purpose. This table is a web table and worked well with few users (< 8). Now this application should become available for...

Dear All: I have a combobox which rowsource pulls up lists with various rowsourcetypes; strings, numbers, dates depending on the selection in another combobox. Once a date rowsourcetype has been selected and then the user changes to a text rowsourcetype the combobox does not work anymore...

Hi All: We have a movement calendar in SharePoint where people make entries where they are on which day... such as AX - Tokyo BY - New York Is there a way to ensure that AX is always on top of the calendar entries, if this person makes an entry? Currently, it looks as if the first person who...

Hi All - this has been wrongfully posted as Sharepoint thread (820-1693394)... I start again here - my apologies: I generated a crosstab query which shows people working on specific project duties. With a subsequent select query I select the people active in the duty I am interested in, but...

I have a query like follows - collecting data for certain years, actually for ten years ahead - SELECT qryProjects.ProjectID, qryProjects.Project, qryProjects.Layers, qryProjects.DispenseVolume, Round(DLookUp("WS2010","tblPlateStarts","Project = '" & [Project] & "'")) AS Volume2010...

Dear All, is it possible (I am sure it is) to have a meeting page with a calendar, where you click a previously entered, existing meeting date and it will open all meeting details? What is needed: can this be done with Sharepoint Foundation, Sharepoint Designer or only with full programming...

Hi All, I have constructed a hierarchical access database with a form containing the treeview control. The application (DAO)worked fine for months, but from one day to the other (and possibly I have checked some code with ADO in a different database), the Access window closes followed by the...

I have a table with names and test scores for several years: Name Year Score AAA 2005 750 AAA 2010 730 BBB 2009 320 CCC 2011 650 .... .... .... I want the top ten (name, year, score), but AAA who would be among the top ten twice - because scores 730 and 750 would be...

Hi, I am working with Excel 2007. If I apply a Chart layout with following VBA, e.g. ActiveChart.ApplyLayout (9) how can I test, which layout has been applied? e.g. following VBA If ActiveChart.ApplyLayout = 9 Then.... End If does not work. In addition: how can I rename a chart...

Hi, I have a normalized table of formulations with the structure: Formulation Compound F1 AA F1 BB F2 CC F3 AA F3 CC F3 DD F4 BB F4...

Hi All: I have the following union query: SELECT TOP 5 qryGraph00.FNumber, qryGraph00.FDescription, qryGraph00.CStress1, "1" As fRank FROM qryGraph00 WHERE (((qryGraph00.Model)="3")) And qryGraph00.CStress1>0 ORDER BY qryGraph00.CStress1 UNION SELECT qryGraph00.FNumber...