Search:

Using Access 2007 and Excel 2007.

In a nutshell. Users fill out a cell in excel that contains comments. Total length of comments may exceed 255 characters. The comments are imported into access...

Rory,
Thanks. The example helped a lot. However, I do have one question.

How did you get the starting date of the X Axis to lock to the date? Whenever I set the min and max values for the X...

Fairly Simple Question

Had a request to create a scatter graph. The data series is to plot the due dates of each task. The due date is the X axis, Task is the Y axis.

Data Series is as...

I am goign to assume you are using Windows 7. You could highlight the table in Word, Select Copy, then go to Excel, and Select Paste Special, and then either paste it as an Word Document Object or...

Tom,

If I remember correctly, I do not think Windows Version 7 is compatible with the Snapshot Viewer which would cause the error.

Thanks for the help. Changing to the 56 colors worked. The code was a pain but it is done.

You indicate "by comparing the two tables..."

What field(s) are you comparing to determine if the records in the new data is a new record or modification of an existing record in the existing...

I am using automation to send data from Access to Excel to populate various simple bar chart graphs. The X axis is set as various Departments using either a two or three digit abbreviation.
...

Try this (or something like it)


strsql = "INSERT INTO SubProcesses ( [Process Name], [Process Description], [Process BAU or Project?], [Sub-Process Name], [Sub-Process Description]," _
& "...

Sorry, I needed to read your post closer. You will find the On Print event in the Header portion of the report. (Right Click on Report Header and select Properties) This should get you to where...

Put this in the on open event of the report. I am going to assume that you added a Label called TextTS to the report (i.e,. put it in the header) that you want to add to the report as the timestamp....

Here is an option that may work for you. Go to the record source for the report and add a column for the time stamp so it becomes available as a selection in the report. I.e., add a column called...

Thank you.

I would also like to wish you and others a very Merry Christmas and Happy New Year.

... I hate snow as well - go figure, as we got 21 inches on Sunday.

However, Hans, the picture is stunning. Very nice.

Adam,

Which version of Yahoo mail are you using. I was not aware that Yahoo automatically saves the email addresses (at least in the older version). I thought you would need to update the...

This post has been moved to Non-Outlook email as it should get a response there.

Mike,

The issue you may be having is opening the plans back and forth between 2003 and 2007. If you create the plan in 2007 and then attempt to open it in 2003 (even if you save it to a 2003...

Increasing the Max Locks may work, however, you say you are joining three tables and there is a calculated field. If you remove the calculated field, does the query joining the tables work? One of...

When creating a form in access, there is the ability to create tabs on the form to better organize what the user is viewing. However, I am not sure this is what you are looking for.

When using...

Please follow Stuarts suggestion and post the error message. Recently, my teenage son was on our computer and received a message that a virus was detected on the computer. A pop up then appeared...

I am going to answer my own question after doing some research. According to microsoft, Automation and VB can be used to get the data from Visio to another application such as a database to store...

Several groups of employees are using Visio to create work flow diagrams and then using these diagrams to store the dates when a task or tasks are complete.

They have asked me if there is a way to...

Now that I think about it, if you input the Text Field and changed the Name to Year. You could input Year 1, Year 2, ... Year N in the value of the text fields so that when you want to print a...

The brute force method to do this that will work in any version of Project is to insert a Text Field in your Gantt View. For this example, insert Text6. You could then go to each row in the Gantt...

Did you ever figure out how to correct the Visio issue? If so, could you please post your solution so others can benefit? Thanks.