Recent content by shanl

In the Program/Script area, do you put ONLY the name of the executing program or do you also include the path too since you are also including the path in START IN. S:\pdappstest\crcp.accdb or just crcp.accdb?

You might be on to something? How can I tell? At one time I copied the Access Program to the C: drive to see if it had to be on the same computer that it was scheduled from but got the error %1 is not a valid Win32 application. Lateley I'm wondering if the task scheduler will only run certain...

I am on OS 2003 and have been running our Access programs in "Scheduled Tasks" scheduler for years with no problem. We are migrating to Windows 7 in a couple weeks and in testing whether we can run our Access on Windows 7 in the Task Scheduler I am having problems getting it to run. It's almost...

Dear Missinglinq, Thanks for the code. That was exactly what I was looking for. I decided to make a different text box to hold the contents of the DESCRIPTION field as I realized that my control source for the combo box on this form was pointing to a different table that doesn't hold the...

Thats what I have now. With column count 2, both request number and description show when I use the drop down box but because I have one bound column, when I select the request I'm interested in, then field that shows is the request number. I want Both the Request number and description to show.

I have a combo box that contains a person's request number and about 80 bytes of a description field. The properties on this field identifies 2 columns to show the user when he drops down the list but I only have one field bound. When selected, all that is displayed to the user is the request...

Excellent idea. I was using another application that did that but I didn't know how to enable and disable. Thanks for the suggestion. Where exactly do you put this code? I tried it where I had the error message but that didn't work. I tried it on the command button subroutine and that didn't work.

Figured out the problem so I'll post it. The code above would work fine if you only have one field in your list box but in my case I have three fields in my list box so when I'm checking the length, VBA adds a count in for every ;. 'Check the length to make sure something is selected. You need...

I am using Access 2003 with SQL Server tables. I have successfully coded two list boxes that I can move items from one box to another. I have four command buttons set up that either move all the items to the box or all the items back to the first box or it will move single items to one list box...

It was a six way table join to get all the pieces of data that I needed. Very ugly. It's a vendor table that can't be changed. Is there a way to zero suppress values so the zero won't show up?

Duane, As I read through your scenario, I still asked myself how will I know which totals are coming through for a person so I can supply the correct hard coded descriptions to go with the counts >0? (The whole problem that I've been wrestling with). Thats when it occurred to me that I could...

The reason that the running total worked for me was in regards to how I'm calculating full time people's hours. I don't know the number of Regular employees that I'm processing and since I don't have a field (by choice) that I'm using to sum up a person's regular worked hours, it worked perfect...

Duane, The input file that I get that tells me what a person has worked either stores the number of minutes worked in one of two fields. Either in a field called (Hrs)or (snwkshoursaday) which is what all of my IIf statements above do. I then further divide which category those minutes belong...

Duane, For new users like myself I can't tell you how much I appreciate the explanation on why things work the way they do and helpful insights as to how Access processes things. (e.g. []). I had always wondered and coulnd't find it anywhere so was never sure when you do and when you don't...

Crowley16, I didn't realize the only time you can use the [ ] around a field name is if it's a column from your query. I have brackets in my subtotal line that seem to be working o.k. and are around field names in some of my total calculations. I'll double check. I'm afraid you've given me...