Recent content by mincefish

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...

Don't know if you still need the import part, but here's a way you could do it. I'm also not sure how you'll know which spreadsheets need to be imported to which tables - I'll leave that up to you to figure out!! - I've made a suggestion though. Function fncImportFiles(strName As String) Dim...

I can help you with the getting all excel files from a specified directory, but the import may be a little more tricky. Here's the getting the files to pass to the import routine (which I've speculatively called fncImportFiles(): Function fncGetFiles() Dim strName As String strName =...

If you wanted to write the code to do it, you could get all the file names by doing the below (seaches for an file with the extension .pl, in C:\Perl\Scripts, and outputs to a text file called Output in C:\Temp. Function fncGetFiles() Dim strName As String ' name of dir Dim fsTemp as Object...

No-one answered this, and I wasn't sure why. Anyway, I worked out how to do it, and I thought I'd paste the code here, incase someone is searching for the answer to the same question, and stumbles across this question. These two functions take input of the name of the old table (to be copied)...

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...

This could be quite long winded, so I'm going to write the code here, but it might be easier if I could send you a sample database!! As an overall idea, I'd have a unique list of ingredients from tblIngredients displayed in a combo box. When a user selects one of those ingredients from the...

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...