Search results for query: *

Running this for January 2008. Date ((Year (CurrentDate)),(Month (CurrentDate)-1) ,Day (Maximum (LastFullMonth))) Why am I getting, "a month number must be between 1 and 12?" I think I know the answer, 1-1=0, but why? How do I get around this? I am trying to get the lastfullmonth data, which...

I have this code to scroll through a listbox using a command button on a FORM: On Error GoTo Error_Handler ' ListBox must have the Focus Me.LstITM.SetFocus ' Force ListBox to start from the top ( I am having a problem here, because it is not starting at the top, running the report...

Is it possible to put in a Form, some sort of link or code to run a query in another database. The query in the other database is a make-table query. docmd.OpenQuery ???

I am using the "Build Report Criteria via a Form w/list box, text box, date range faq181-5497" and I have the Listbox with "Month" and another Listbox with "Choose a name". The Listbox choices "Choose a name" can be Multi Select. How do I get the Commmand Button to run a report Using the...

Does this faq181-5497 work in Office 2003. The Tag Where=Invoice Data Entry.Month is not working in my Listbox. I keep getting Syntax error (missing operator)in query expression.

When I startup my application written in VB 2005, I get it running, click on another application like MS Excel, go back to my VB application to check it and the Form is all White and in the Title Bar it is not responding. Actually it is still working. How do I go from another application back to...

When I startup my application written in VB 2005, I get it running, click on another application, go back to my VB application and the Form is all White and in the Title Bar it is not responding. Actually it is still working. How do I go from another application back to mine without getting the...

Should this script work in a web page? When I look at the log file the date is still an old one and nothing is being copied over. <% 'Setup source and destination locations strLocation = "\it\call" strSource = "\\server02\d$\inetpub\websterstaging\" strDestination =...

We had a Username, from Domain A, that we are running robocopy script on a web page. The Web Server is on the B Domain. The A Domain was terminated, without the knowledge that this User was needed to access this web page and run robocopy. When we go to the page it comes up with "Server...

I was just given the role to manage IIS 5.0. What is the proper way to shutdown WWW Service and then bring it back up. The issue is sometimes when we RoboCopy over from our Staging Server to the Live Server the files get updated, but in Internet Explorer it is still showing the old ASP page...

If I create a web page using ASP that needs to pull off information from a SQL database when a certain user logs to display information, say a news form, how do this get displayed on the page. Say Jane Doe logins with Username: jane Password: doe to the network. She opens the web page. How does...

I am getting this error message any Clues?: Microsoft VBScript runtime error '800a0046' Permission denied: 'GetObject' /first_visit.asp, line 255 'Can't find user profile...must be first visit to Intranet... 'Are we actually adding the user? If WT.GetVariable("action", "string") =...

I have 2 tables. Both Tables are linked together by one field called Company. I run a monthly report based on Company and Month. In this instance, first time it has come up, the Table "Resources" has no data in any fields, but the other Table "Projects" does. I have a report that Groups the...

I have created a batch file on the network, but want users to click on the file, have it copy to their local drive(c:\temp), run the batch file, then delete the file copied file and close. To simple aye?? The file clears out some temp files on the local share C$, then goes to a folder on the...

How do you display the dates from: and to: if you use the Date Range "LastFullWeek" to run a report thank you in advace.

I know you can do this in Crystal, but how do you add another section to the Detail section in MS Access 2003. So you have detail a, detail b, and so on. Be descriptive I am going blind trying to find the solution. Thanks

I have Open and Closed Calls Incident # Seconds Opened Seconds Closed 1111 12 2222 10 For Open Calls if {Incident.State:} = &quot;O&quot; then DateDiff (&quot;s&quot;,{Incident.Open Date &...

I am using Crystal 8.5 and 9. I use a formula written in 8.5 to group the fields together in a report if {Clients.ClientText06} = &quot;&quot; then {Clients.Country} else {Clients.ClientText06} My report comes out like below which is great Company Allocation First Name Last Name...

I have some Incident calls opening 24/7. I don't need to see incident calls open during the times or 8:00 am to 5:00 pm, I do need to see any opened from 5:00 pm to 8:00 am. Using Crystal Reports 8.5 If Time({Incident.Open Date & Time}) = ??? then ???{Incident.Open Date & Time} = &quot;&quot...

Running a report just for the month of Oct 2002 and the days of the week are 10/06/02 to 10/12/02. Why does the report show Support Calls opened in 2001 during Oct.? Using Crystal 8.5 Pro. {Incident.Open Date} in &quot;10/06/2002&quot; to &quot;10/12/2002&quot;