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

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

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

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

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

Hi, hope someone can help me with this. I not up to speed on LDAP. What I would like to do is get the users ID (SAMAccountname) and pass it as a filter in the code listed below. I hope that made sence.... Thanks Chuck <SCRIPT language=VBScript> Sub Window_OnLoad Dim objRootDSE...

Source page to bring up popup form with filter (KEYID) this part works fine..... <SCRIPT language=vbscript id=clienteventhandlersVBS> <!-- Sub Command0_onclick newDlg = window.showModalDialog _ ("\\xxxxx\xxxx\xxx\xx\Databases\POPUPCOMMENT.htm" , _ document.all.KEYID.value, _ "dialogHeight...

Not real sure how to ask this question? I have a data access page with a popup form that uses the server.filter to pull only associated comments. The key field is a autonumber in another table but is also in my comment table a releationship link. My problem is when I add a new record to the...

How would I write this in VBscript. Thanks in advance. <SCRIPT language=javascript event=onclick for=Command0> try { if (MSODSC.CurrentSection == null) MSODSC.DataPages(0).NewRecord(); else MSODSC.CurrentSection.DataPage.NewRecord(); } catch (e) { alert (e.description);} </SCRIPT>

I currently have a Data access page with a Iframe in the banded header section. As long as I display only one band this code works great, but can I display multi bands and have each record display its own ifram(subform). I have tried to set up a loop for each current section and then set up the...

Trying to write data to cookie so that I can pass parameter to next page. Errors at setVariable. strParm_1 is a text field and pID is numeric. I've included the sub that is called from setVariable. Any help would be greatly appriciated, thanks in advance. <SCRIPT language=vbscript...