Search results for query: *

DateSerial was the magic bullet, Thanks.

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 got the error handling problem sovled Thanks again.

Thanks!!! Is there any reason you need to start at that element and loop through?: When the reports run they are inserted into an email. Before the reports are sent, the report are previewed in order to verify what is being sent is correct. It is just a check. Cannot get around this. Why...

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

Great response, I had to adjust to my report and it work great what you suggested. Thank you!!

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

I followed the directions in the FAQ181-5497 Simply add to the Tag Property Where=tblEmp.lngDeptID,Number;. That's all there is to it. But you say to put in - where [Value that you didn't specify] = [Invoice Data Entry].Month If I am using a Listbox isn't this the [Value that you didn't...

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.

With all the responses I have started to read up on Threading. Thanks you for your comments.

The application is working at the time of the white screen. Your comments, "Off loading any processes from the primary thread to a worker thread will help keep the screen refreshing correctly" is something I am not familiar with. I have 1 Drop down box, 2 text boxes and a progressbar running at...

Same white screen comes up.

I have 1 GB of memory. Is there some code I need to write if I return to the program.? I am not aware of where this goes or am familiar with what code to write. Thanks...

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

Thanks will do. Did not see that fourum.

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

Fixed the script, but it still does not run. I will check the permissions, thanks.

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