Search results

I have a report that pulls from 2 tables with the following fields: employeeid, lastname, firstname (table 1) date, hoursworked (table 2) I am trying to run a simple report that shows id, name and total hours for a given time period. in the report i need to group by employeeid, but want the...

ok, this should be very easy, but is not working out that way. i have a report that is based on a query that has a yes/no field. this field indicates whether or not the employee is entitled to an overtime meal bonus (working over 10 hours in one day). if yes, the box is checked in the form...

Hello. I know there is a way to take data from an Access query and have it automatically generate an Excel chart. I have seen it done, however, I cannot seem to figure it out. My VBA skills are NOT GOOD! Is there a quick and easy way to have a graph/chart automatically generate in Excel...

Hi there. I have a large form. Within that form there is a field where a user needs to enter a client contact name. If the name is currently not in the drop down (the related table) I would like them to be able to double click on the field and have the form pop up to enter the new client...

Hi. I have a query that pulls multiple items, of course. Something like this: Name, IDNumber, Date, HoursWorked I have a parameter set on the date field so user can enter the date they want to run hours for. However, rather than have a heading of HoursWorked in the query results, I want...

Hi there. I am attempting to change the output in a query field. Meaning: if the equipment code=x,y or z, I need the query to print a,b or c. I know I have done this in the past but cannot remember how nor can I find it in help or my book. Any help would be appreciated. Thanks.

Is it possible to take certain data from an Excel spreadsheet (specific row/column) and then transfer that data to an existing Access db automatically -- meaning upon SaveAs can the data be transferred? Would this be done using a macro within Excel -- this is all new to me, any help would be...

Anyone know how to have fields automatically fill in on a form based upon data stored in a linked table? How to you specify where to go get the info from the table. Thanks.

Have a db that prints several ole objects on a report and currently have to store the ole objects in a field of a table in the db. Is it possible to print these ole objects (bmps) in an Access Report, without having the bmp's stored in the db -- want bmp's pulled from path name only. Just want...

I have just switched over to Access 2000 and am designing a db and ready to create the switchboard. When I select addins switchboard manager is not there. Did a complete reinstall and still not there. Any suggestions