Search results

I have two tables in the same database. One of them is linked to another databse. The tables in the same DB have some fields that are the same. Can I make it so that when I type something into a form it is added to the corresponding fields in both tables?

I have a database that was created in access 2003. When I try to open a form in access 2007 i get an error message that says "the expresion On Click you entered as the event property setting produced the following error: the expresion you entered has a function name that microsoft office access...

Does anybody know of any incompatibilities between access 2003 and 2007?

I have a query that finds an average. How can I get the average to only show two numbers after the decimal?

I have a report based on a query that finds the average response time. When I run the report it prompts me for a begin date and an end date. Then the report shows the average resopnse time between those two dates. How can I get the two dates I entered to show up on the report?

I need to make a query which counts the number of days between "Date of Complaint" and "Effective Date". This is what I have so far: [SELECT [Customer Complaint Log].[Complaint Number], DateDiff("d",[Date of Complaint],[Effective Date]) AS Expr1 FROM [Customer Complaint Log] WHERE ((([Customer...

I have an access 2003 database that shows when customer concerns were reported and when thay were resolved. I have a query that calculates how many days it took for each concern to be resolved. I used the query to make a report that shows all concerns which took more than 14 days to be resolved...

How can I count the days between 2 dates and then make a report that shows when there are more than 14 days between the day something is reported and the day it is resolved.

I accidentally moved my task bar to the side of the screen and now I can't move it back to the bottom. I click on it and the icon with the 4 arrows pops up but the task bar won't move. The only thing I can do is make it wider. How do I move it back to the bottom?

I have recently been getting these pop up on my computer that say that a recent attack has been detected. When I click on them it takes me to a website for software that cleans your history. Sometimes the just the website itself pops up. Also an add becomes my background sometimes. Any idea why...

I have a customer concerns database that contains the dates for when the concerns were reported and tyhe dates for when the concerns were resolved. I am trying to make a query that finds the average of how long it takes for the concerns to be resolved. How can I do this?

Hey, we're trying to set up a link between two workbooks in excel 2003. Basically we want to copy rows of input into the new workbook and have it automatically update whenever information in the original workbook is changed. However, the information includes words as well numbers and I don't...

I know how to output my tables to excel using a macro but I need some code for a button that will ask me what table I want to output.

Hi, we're working with a file in Excel where we are having people insert pictures into the spreadsheet. The spreadsheet with no pictures is 2.3 MB. The picture is 730 KB. But when it is inserted into the worksheet the file becomes 24 MB. If I add the picture again it goes up to 45.8 MB. We used...

I am making a powerpoint presentation that has a bunch of screen shots from an excel worksheet. The pictures are supposed to pop up one by one when I click on the screen. Most of the pictures do this but there are a couple that appear before the title does. I also have a slide where all three...

How can I add a screenshot of my main switchboard to a form in access 2003?

How can I get an animated image on my switchboard? I found an animated image on the internet and I copied it. I went into design view and pasted it onto the switchboard then I went back to form view. I can see the image but it is not animated. How do I animate it?

I need to put a button on my main switchboard that will unhide the thing that has all the forms and tables on it. Does anyone know how to do this?

Is there any code that I can write in an excel spreadsheet that will prompt the user to enter a picture instead of text?

I need to do something in excel but I have never used excel before. I need to make a form with a box. When you click on the box it shhould promt you to add a picture to the box. It should also format the picture so that it is the same size as the box. So far we have the box, but we still need to...