Search results

Man, that is nice. Great job

Nevermind, I figured it out! Here is what i need to do to get the author of the TXT file: Sub Test() FileDetails "C:\temp2\", "export.txt" End Sub Sub FileDetails(fpath As String, fname As String) Dim objShell As Object Dim objFolder As Object Dim vFile As Variant Dim i As...

Once this is run, how is the information displayed. I run the code and nothing happens?????

Yeah, with an active document you can pull the author with objwd.activedocument.author (or something like that)

I've searched high and low over the internet, but I cant seem to find how to pull the Author/Creator from a file. Any one else have any ideas?

Ahhh I stand corrected... Thx

I am not sure how to get the author, but this gets all the other properties of a file: Dim fso As Object Dim f As Object Dim TBfile As String TBfile = ("C:\fileName.txt") Set fso = CreateObject("Scripting.FileSystemObject") Set f = fso.GetFile(TBfile) Me.Text1 = f.Name...

In the properties for the combo box, is the "Limit to List" Yes or No? It should be marked as "no" Bones

Try this Dim stDocName As String Dim stLinkCriteria As String stDocName = "NameOfForm" DoCmd.OpenForm stDocName, acFormDS, , stLinkCriteria If thats not what you mean, change the properties of the form from Single to Continuous Forms under the Default properties.

If you look at Ghudsons example here, it will answer all your questions: http://www.access-programmers.co.uk/forums/showthread.php?t=97787 if you import the DOpenfile Module you can open a file with a code like: openfile (C:\temp\file.pdf) or openfile (C:\wordFile.doc) its a great example...

Hi All, I have been working with Access for a while and I am ready to put my front end on the web. Where do I begin???????? What should I use? Is Mysql the way to go? If so where do I begin? Thanks! Bones

If your form is bound to a table, then in your combo box bind your control source to the field. right click on the combo box>properties>control source>select the field from drop down menu. bones

Hi All, I am using a date function that will send an email out on the first of the month. It runs on an "on open" event. My question is how do I get it to run once? Because the way I have it set up now, if the database is opened 20 times on the first of the month, it will send the email out 20...

Thanks the codes works great. I had to change the following line: strAddress = left(strAddress, len(strAddress)-2) to strAddress = left(strAddress, len(strAddress)) I've been working on this for 2 days! Thanks so much!

Hmm thanks but now it only emails to the first email record.... anythoughts? If I could send one email, that would be great.

I think you need to declare excel as an active document: for example Dim objXL As Excel.Application Set objXL = GetObject(, "Excel.Application") objXL.Save

Hi All, I've searched the forum and I cant seem to find a solution to a simple problem. I am trying to gather a bunch of email addressed into a string, to send out a mass email to all my admins. The code below only emails the last email address in the record. Thanks for the help Dim rst As...

Make a table called "companions". This can be the child table to the customer table. Make a relationship between them. for example, If the customer_id 3 (thisi s your primary key, indexed, no duplicates), then there should be a column in the companions table called custid. Make a one to many...

Download the sample I posted in the thread. Its real easy, one table, a query and a form with a textbox and list box. If you want post your DB and I'll look at it. Bones

Thank you!