Search results for query: *

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

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

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

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

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

I'm new to Access so bear with me if this is basic. I've created a form in Access that allows users to select employees from the appropriate dept to be printed on a payroll report. At the point in time I open my report I have all the data to print all the employees selected in that department's...

I am printing totals and description of the activity for a person's payroll activity. There are approximately 20 different categories that a person can post time to which I need to calculate to determine if he took any of this other time. There are too many misc categories to have them as...

I am writing an Access Report where I need to calculate fields in the query that feeds the report. The query references SQL Server tables. Is there a way to calculate two If statements in one calculated results field? This is what I had tried without luck. If a person has taken a whole day of...

I have moved a list of employees into a List Box that I would like to create a report on. The list box contains three fields. zLName, zFName & zBadgeid. I don't know how to code my query so that it will reference the list box and be able to point it to the correct field. I've tried...

I'm hoping this will be obvious as to what I'm doing wrong and why my VBA query is failing. The entire query works fine in my Access application as long as I take out the reference to Null. I've tried using (EmployeeDept_qry2.dtActEnd) Is Null without luck and my last attempt was using the...

I'm sure this is basic but I'm new so bear with me. I have two list boxes of which I will populate the first list box with names and then will select names from the first list box to be moved to the second list box for additional processing. The first list box I populate is based on...

I'm new to VBA and this may be very basic so bear with me. I'm trying to develop a process where I have multiple list boxes. I want to populate the first list box and be able to select records from the first list box and move the selected records to a second list box for additional processing...