Search results for query: *

OK - well this seems to work. How stupid of me not to take that logical path towards getting it work. I must make sure I learn the PowerPoint Object Model to at least 20 levels. </rant> oSlide.NotesPage.Shapes(2).TextFrame.TextRange.Text = &quot;This is a note&quot; Thanks Mincefish

Hello, My request is a simple one (I hope :)) I want to know how to add notes to a slide. I know how to add the slide, and format the title, etc. Once I've done that, I want to put some standard text into the notes. I figured that as the notes are slide specific, adding notes would be a method...

Here's my 2p worth. I'd say that 5.5Mb isn't that big for a front end db. You've got alot of forms in the db, and the code, and objects takes up a lot of room. I've had plenty of front ends about that size - with less forms too! As long as it doesn't change size, apart from fractionally when...

Hello, I hope someone can help me, as I'm confused, and I think there may be too many variables that could be affecting this issue to truly discern what is going wrong. I'm using Access 2000 (with ADO 2.1) as a front end to an MSDE back end. I'm writing some code to calculate quintiles, and...

...the table is the same name as the spreadsheet, we want to remove the .xls 'from SpreadsheetName.xls to use as the table rstWrite.Open &quot;SELECT * FROM & &quot; & Left(strName, Len(strName) - 4) 'open connection to spreadsheet conTemp.Open &quot;DRIVER=Microsoft Excel Driver...

...import routine (which I've speculatively called fncImportFiles(): Function fncGetFiles() Dim strName As String strName = Dir(&quot;C:\Temp\Files\*.xls&quot;) While Not strName = &quot;&quot; Call fncImportFiles(strName) strName = Dir Wend MsgBox &quot;Finished!!&quot; End...

...Set fTemp = fsTemp.CreateTextFile(&quot;C:\Temp\Output.txt&quot;) strName = Dir(&quot;C:\Perl\Scripts\*.pl&quot;) While Not strName = &quot;&quot; fTemp.WriteLine(strName) strName = Dir Wend MsgBox &quot;Finished Writing File Names&quot; End Function HTH! Mincefish

...'doesn't present them in the same order as they are in the table rstFields.ActiveConnection = CurrentProject.Connection rstFields.Open &quot;SELECT * FROM [&quot; & strTableExist & &quot;] WHERE 1 = 0&quot; 'loop through rst.Fields collection, and create a new column in the new table For...

Hello, hope I've picked the right forum here! I need to make an exact copy of a table, and rename it something similar, just without any of the data. I'm using Access 2K here. I am basically trying to automate the process where-by a user manually selects a table, copies it, and then clicks on...

I think you would need to .movenext, load the value(s) in a variable and then moveprevious, and then do your update... HTH

Dude....well I'm glad you sorted it out :)

Presumably when you say choose a date, you have some kind of event, which puts the date into the text box? In this event, you could do: Me.txtTextBox.Value = Format(Me.Calender.Value, &quot;dd/mm/yyyy&quot;) .....Or have I utterly missed the point ;-)

Why don't you have a function like below that clears all the controls of their old values (This function assumes that all your controls are 'properly' prefixed - i.e. txt for text box, cbo for combo box, lst for list box...) Function fncClearControls Dim ctrl As Control For each ctrl in...

...holds the order id, and that needs to be added to tblOrders. And to answer question 2 also, I'm assuming this is the layout of tblOrders: OrderID* IngredientID* DateAdded ------- ------------ ---------- 0001 0001 12/12/2002 0001 0002 12/12/2002...

One way you can refer to controls would be to use the controls property of the form - so for example: Do While rsaddress.eof Me.Controls(&quot;address&quot; & intSub).Value = rsaddress!address Me.Controls(&quot;diesel&quot; & intSub).Value = rsaddress!diesel intSub = intSub + 1...

I think its because the Category1 field is always the same - when you choose an item from the drop down box, it makes the value of the dropdown box the value of the bound column, and because the bound column is always the same, it chooses the first value. The only way to solve this is to change...

I agree with rookery - I've found the answer to so many problems on here, and the more experienced you get, the more answers you find - sometimes I can take the slightest hint from an answer and modify it to what I want it to do - You'll gradually pick it all up, and it will all start to hang...

...String) As Boolean On Error GoTo ERRHANDLE Select Case strType Case &quot;csv&quot; strType = &quot;CSV (Comma Delimited) (*.csv)&quot; + Chr$(0) + &quot;*.csv&quot; + Chr$(0) + &quot;All Files (*.*)&quot; + Chr$(0) + &quot;*.*&quot; + Chr$(0) Case...

Thats what I thought John - I'll have to have 'words' with the developers! Thanks again Tom

I have been given a copy of a FileMaker 5.0 database, which was developed on a Mac, and then converted (At least I assume it has to be converted??) to run on a Windows Millennium machine. I currently get error messages when updating certain fields, saying that the fields are read only...