I’m using a vb.net app that opens a powerpoint presentation and calls the updatelinks function of powerpoint.
One slide in the presentation is linked to a cell range in an excel file, and the excel file has links to other excel files within it. When my program reaches this slide, it opens the powerpoint slide, then opens the excel file, then it prompts the user to select whether or not they want to update the links within excel....
psuaudi
Last Activity: May 15 '07, 01:48 PM
Joined: Oct 11 '06
Location:
-
psuaudi started a topic use vb to update linked excel file within powerpoint pres. and supress excel update ?in .NETuse vb to update linked excel file within powerpoint pres. and supress excel update ?
-
powerpoint and .net - need to have a program to update powerpoint links
i have a powerpoint presentation that uses links to other files and are put on the slide using OLE.
The problem is that I have different users updating the information on the slides, which is not being reflected on the main slide.
At any rate, I'd like to write an external VB app that can be scheduled to run, update the links within the program, resave the powerpoint pres, and then reopen it on the computer.
... -
How do I use an ADO connection to look up 1 field in a database?
I'm using an ado connection to connect to an access database using VB6.0.
The database structure has a table (Table1), with a unique field1 (ID), and another field2 (Name).
How do I use an ado connection to lookup a Name when given an ID? Within Access, I would use a dlookup command and dump the data into a variable...but I'm not sure how to do that using ADO.
Thanks! -
DTPicker read only error
I have a form that I was creating and I wanted to use the microsoft date and time picker. in the On_Load event for the form, I want to set the date and time picker value to Now()
Private On_Load()
dtpicker.value = now()
end sub
However, in the form that I was creating, it says that the dtpicker is read-only and cannot be changed.
If I create a blank form and insert a date and time picker,... -
Quick help with SQL command in VB
I am having problems with using the IIf/dlookup command in my recordsource query. Is it possible to use this within VB? it works as a regular query. I tried to fix the quotes, etc, but it didn't seem to fix the problem.
...Code:me.form.recordsource = "SELECT [Table].[Number], [Table].[SubNumber], " & _ "IIf(nz(DLookUp('[ID]','Revisions','[Number] = '" & _ "[Table]![Number] & -
Unfortunately, in the startup section there is nothing to prevent user access to certain areas. -
yes, but, they will still be able to go in and modify the actual data tables in addition to being able to modify table data using a form, correct?Leave a comment:
-
psuaudi started a topic Is there a way to prohibit table values from being modified unless by a form?in AccessIs there a way to prohibit table values from being modified unless by a form?
I have a database that is used by several people, however, I have forms that use some vb code to change data properly.
I would like to limit the ability for certain users to change data in the tables without using forms. Is there a way to do this?
Thank you! -
Nevermind, I finally got it to work. I swear I had tried this syntax yesterday and it didn't want to work...but this is what I ended up with.
Count = DCount("[Status In]", "Change Dates", "[Status In] = '" & [Forms]![Main]![New] & "' AND CVDate(Int([Date])) = Date()")
Thank you!Leave a comment:
-
That was actually my first course of action, but unfortunately it will not work because the [Date] field has the date stored in it as a general date (date and time) format, but I only care about comparing it to the current day. I've used the CVDate(Int([Date])) code elsewhere to parse only the date from the field, but in this instance it does not seem to want to work.
Thank you for the reply!Leave a comment:
-
Help with multiple criteria DCount and Date Field
I am trying to use the following code, but I think there is an error in my syntax:
Count = DCount("[Status In]", "Change Dates", "[Status In] = '" & [Forms]![Main]![New] & "' AND CVDate(Int( #" & [Date] & "# )) = #" & (Date) & "#")
I believe that this is the particular problem area:
CVDate(Int( #" & [Date] &... -
I guess I am still struggling with using recordsets and perhaps some of the more intimate details of using combolists. I'm not sure what direction I should head in next.Leave a comment:
-
I am using VBA. All I have is a simple form that has the listbox that is tied to a table with 3 fields: ID(autonumber), Name(text), and Phone(text).
I'm simply doing this as an exercise to try to learn more about recordsets.Leave a comment:
-
recordset will not assign column values listbox columns
I am trying to run through a tutorial on recordsets, so I am following the tutorial here:
http://www.devdos.com/vb/lesson4.shtml
I have made the table as described, and tried to run this code:
Option Compare Database
Dim dbMyDB As Database
Dim rsMyRS As Recordset
Private Sub Form_Load()
Set dbMyDB = CurrentDb... -
What 'reference' is .itemdata and 'newindex' in?
I'm trying to use the command:
Records.ItemDat a(records.newin dex) = rsMyRS!ID
but it does not recognize what 'newindex' is.
do i not have the proper references included? -
that is helpful, but how do you use a query as part of a recordset source?Leave a comment:
-
help with using recordsets - i'm a beginner!
I am trying to use a recordset for the first time with a query as it’s source. I am having trouble getting it to work. I've been quite sucessful with other VB scripting.
My motivation for doing so is that I would like to use a recordset instead of a temporary table for storing some temporary data that will be used to perform some data manipulation.
Can anyone give me some instructions on how to do this using DAO?... -
help with main query using two inner joined subqueries
I have a main query that I would like to call two different subqueries.
In MS Access, I usually just save the two subqueries as separate queries which are then called by a third separate and main query. However, I'd like to put them all into one SQL command. Is this possible? Here are the queries:
-This query calls the other two queries below-
SELECT [Step 1].[Serial #], [Step 1].[Sub#], Format((([Step 2].Date)-([Step... -
help converting date and time field using query
I have a table that creates a value in the field using the now() function.
The data stored, of course, is in the format of 12/4/06 12:44:00 PM.
I would like to make a query that uses only the date part of that field, however, if I use the datevalue function within the query, it says that there is an error in the expression.
I am somewhat in a loss because I thought it should work... -
I agree. I now just figured out how to append the date and time into a single field, which will simplify my operations.
Thank you again for your help. I will try out the nested sql code. I am still learning a lot about SQL commands.Leave a comment:
No activity results to display
Leave a comment: