Search results for query: *

Hi All, I'm hopping that I can get some advice on how better to design to my form. I currently have a form that is called my spend plan. It currently has about 16 columns. (Craft, work type (st,ot,pt) Craft Disc, Prv YR, Oct, Nov, Dec, through Sept, FY Total, Future Yr, Grand total). This form...

Is it possible to create a crosstab/pivot query to change output from this table. SORT MONTH YEAR ENG FSEU LOG 0 Oct 2009 2 8 0 1 Nov 2009 9 13 6 2 Dec 2009 9 17 6 to this DEPT MONTH COUNT ENG OCT 2 FSEU OCT 8 LOG OCT 0 ENG NOV 9 FSEU NOV 13...

Does anybody have any ideas on how I could achieve this type of dynamic field naming. I'm tring to pull current month and the two previous months at any period of the year. Thanks again....

Thank you.

New to SQL server and was wondering if the following snipit of code can be done. I would like to name the column in the query to the month with the AS statement. Thanks in advance. SUM(CASE WHEN datepart(MONTH, (DATEADD(M, - 1, GETDATE())))= DATEPART(MONTH, dbo.ACTION.ACTION_DATE) THEN 1 ELSE 0...

Can the dropdown arrow (filter) be remove from field labels. Access 2007, Eating up real estate. thanks in advance

Thanks Genomon, I'll give it a try and let you know....

Does anybody see any errors in this code. I have this code on a onclick trigger. No errors but field data does not change color or font to bold. Any help would be great. Thanks Chuck Private Sub DESCRIPTION_Label_Click() Dim objFrc As FormatCondition Dim lngRed As Long lngRed = RGB(255, 0, 0)...

Hi all, Not sure if I'm in the right forumn for this question. I'm working on a web app. The main form has a button that opens a modal form. Modal form creates report . I have a print button that prints the data and when I close the form the loop opens the next recordset and the process...

Thank you very much that did help me out. Have a great day..

I have a data access page with several option groups(FRAMES). How would I retrieve the value selected by user.I have tired the following any help would be great msgbox WINDOW.MSODSC.CurrentSection.HTMLContainer.children("ELECTSHOULDBEMAINTAINED").checked msgbox...

Yes, This is Access DAP. I might be in the wrong place to ask this question. Not sure.

Thanks for the input but I'm working on a Data access page that has bands and I think I have to use something simuliar to the code I've listed. Thanks

I have a data access page with several option groups. How would I retrieve the value selected by user.I have tired the following any help would be great msgbox WINDOW.MSODSC.CurrentSection.HTMLContainer.children("ELECTSHOULDBEMAINTAINED").checked msgbox...

NEED SOME HELP. I HAVE A DATA ACCESS PAGE THAT I'M TRING TO FIND A RECORD AFTER REQUERY PAGE. I HAVE PUT SOME MSGBOX TO SEE IF THE PARAMETERS ARE THERE. MUST HAVE A SYNTEX PROBLEM IN MY FIND STATEMENT. ANY HELP WOULD BE APPREICIATED. MSODSC.CurrentSection.DataPage.Requery msgbox...

Hi All, Not sure if I'm in the right forum, But here is my question/problem. I'm using a Access Data Page. When the page opens I can update the records shown. I then use dropdownlist to gather parameters and then set the rootrecordset for the page. Data refreshes and it pulls the records I want...

Is it possible to show toolbar on a Modal form? here is my code. Thanks in advance. fResync = showModalDialog("WUC.htm",DOC, _ "dialogHeight = 900px; dialogWidth = 1200px; toolbar =yes")

I'm currently useing a Microsoft Data access page to display data from my database. During the page load databinding of data takes place which causes my movie clip to not work properly. I would like to start the movie clip after the page has completed. I was thinking that I could use the...

I'm tring to print a report from a Access database from web page. The following code prints the report but I would like to hide the Access application from showing on screen objAcc.visible does not seem to work. Any ideas would be greatly appriciated. <SCRIPT language=vbscript event=onclick...

Is it possible to have a Data access page print a report that resides in the ACCESS database. I have a ADODB connection set up in the DAP page to the database where the report is. dbPath = "\\Kscboc2\Share\Jbosc\Rpi\Databases\FERB.mdb" Set objConn = CreateObject("ADODB.Connection") objConn.Open...