Does anyone know how to Open Excel and have it Jump to a Cell given in the command line.
Example:
I have a PowerPoint Slide with 7 Bars and when you Click on Bar 1 it opens ExcelFile and jumps to Cell A1 but when you click on Bar 3 it opens the same ExcelFile and jumps to Cell A3. I am trying ot do this using the Hyperlink Function in PowerPoint.
Thanks.
DLN
DLN
Last Activity: Dec 9 '08, 03:29 PM
Joined: Apr 23 '07
Location:
-
Open Excel and Jump to a Cell
-
You're trying to update the Excel File?... -
I ran a query that just did a SUM on one table and the total came up 15.
I added the Group By and the total came up 15.
But if I added another table to the query (Even if it wasn't used) the total came out 125.
Do you have more then one table in the query?Leave a comment:
-
I deleted this post 3/25/2008Leave a comment:
-
I got to thinking about this last night and you're right, the problems I had in the past with inner-joins had to do with the one-to-many relationships....Leave a comment:
-
Under Image properties there is there is Picture and it has the address.
C:\mypictures\i mage1.jpg
What you'll need to do is add some code to so then the record changes it uses the hyperlink address to update the location of the picture.Leave a comment:
-
I looked in my Access 2000 book and it says
The following properties of a query prevent you from appending and updating records.
The Unique Values property is set to Yes in the query properties window.
Self-Joins are used in the query.
Access SQL aggregate functions, such as Sum(); are employed in the query.
Crosstab queries, for example, use SQL aggregate functions.
No Primary-key...Leave a comment:
-
It has been my experience that Inner Joins will cause this problem.
I don’t know of a work around, except don’t use an Inner Join.Leave a comment:
-
You can create the table with the field type as a Hyperlink and use the Hyperlink to hold the link to the Image.
In the form you can create an image that is set to the field that is Hyperlinked and when it changes records on the form the image should change.
Is this what you were asking?Leave a comment:
-
I just did something like this I did a Do While .EOF = False loop to delete the files in the table then I did a MoveFirst to go to the BOF then when I wrote the first record to the table I did a !MyAutoField = 0.
The table is not related to any other tables and the field is not the Primary Key so there wasn't any problems and it works great. Everytime I have to delete the table it restarts with 0...Leave a comment:
-
Yes it does help.
I would like to thank all of you for you help....Leave a comment:
-
Thank you, this is very helpful....Leave a comment:
-
Thank-you for your help.
I don't think you understand what I'm asking and that is my fault, I'm sorry if I didn't communicate it correctly....Leave a comment:
-
What do you suggest?
I don't have time to rewrite the whole db. I'm not going to break out a table that has 60+ Fields per record to 60 tables.
But I got the problem down to 15 lines of code that works....Leave a comment:
-
This is what I did
...Code:Set rst1 = db.OpenRecordset(“tblCompounds”, dbOpenDynaset) Set rst2 = db.OpenRecordset(“tblMyHold”, dbOpenDynaset) rst1.FindFirst “CompoundName = Water” With rst1 With rst2 Counter = 0 Do Until Counter = rst1.fields.count If rst1.fields(Counter).Value = True then rst2.AddNew !ElementName = rst.Fields(Counter).Name rst2.Update
Leave a comment:
-
The table looks a little like this
So when I run a report I want only Oxygen and Hydrogen on the report for Water and I don’t want a blank spot for Lead....Code:Name | Oxygen | Lead | Hydrogen | WATER |Yes | No |Yes | SUGER |No |No |No |
Leave a comment:
-
Report Question
I’m trying to write a Report.
I’ve a query that selects 1 record from the table.
The Table has 20 or 30 fields all Yes\No.
I want the report to only have the fields that are Yes so it would look something like.
Report Name
Product “WATER”
----------------------
Oxygen
Hydrogen
End of report -
Anyone have an idea?...Leave a comment:
-
Error: TABLE Contains No Fields that can participate in a Relatonship.
I am trying to create a Database access page and I get the above statement when I try to add a table to the page.
All the tables are linked tables. This table has 20 fields one of which is related to 10 other tables.
When I try to expand the table to get to the field list, I do not get any fields.
What could be the problem? What do I do to fix it? -
What did work.
Going to Tools...Startup and unclicking the Allow Toolbar Changes.
2 Tylonal later.....Every thing is working like I want it to....Leave a comment:
No activity results to display
Leave a comment: