Search results for query: *

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

I can't seem to find the problem and this seems like something you should be able to do but I'm obviously violating some rule or don't have the right syntax since it's not working. I have set up a text box in the subtotal footer called Hrsworked. The Control Source for this field looks like...

Duane, You have hit the nail on the head. Since I'm calculating info on each detail record for various counts and categories it is very much un-normalized. This is fine as I process all the detail on the report without any problem and also because I make those lines invisible.My problem (and...

Remou, I do base my report on a query but I wonder if I'm missing your point. I have many calculations added to my query for all the fields in question. I then build my WHERE clause in VBA code from a previous form that users fill out which allows them to select which people should be on the...

I have created an access payroll report that has many categories that a person could charge time to but if a person has not charged time to those categories I don't want to print them. Currently I've hardcoded all those categories into my report as text fields but I would like to suppress those...

Darrylle, You're a gem. I appreciate the explanation and when I plugged it in, it worked great. Shan