Search results

Thanks Jon K that is a lot more elegant then the code I was cobbling together. :D

With the files and folders have static names or will they change often?

Stu have you had a look at this thread? Moving Documents and Reading for Existance of Server Folders In my reply I posted links to several threads which I think cover most file operations in VBA. If that doesn't help post back and I will see if I can help you further.

I know this is not exactly what you were looking for but it may be an option for you. I basicaly created a table to hold all the report names I wanted to send. Next I did a little code that will loop though the report names and send each of the reports to the recipiants. The only problem is...

ASP(.Net) is the way to go when trying to use Access through a web server.

Check this thread: Help!! User-defined type not defined? Does that help?

It is probably a missing reference. Sometimes they just quit working for what seems like no apparent reason. Open or create a new module and then choose Tools from the file menu. Under References look to see if one of them says missing. If so check it and close the app. After it reopens...

Sameer, I amended my post slightly to make it a little more informative. There is now an example of the Kill command in the post along with some more information about how the dynamic name will come out.

This can be done rather simply with this: DoCmd.TransferText acImportDelim, , "ImportTableName", "c:\FileName", False You can make it a little more complicated by using an Import spec. Of course this code is not automatic in that it needs an event to trigger it. It will be up to you to...

I found it: Is it true that CoverYourASP runs on Access? How? Yes, I'm still using Access 2000. No-one knows "the limit", but my site is perfectly fine with ~10,000 page views a day. It flies in the face of everything Microsoft and many experts will tell you, but here it is. He also gives some...

There is not an easy answer for this question. There are so many variables that I don't think I can answer you in a way that isn't going to prompt more questions. If you are expecting less then 20 people at a time in your form then I wouldn't worry about it in the least. However if you are...

Here is one way to do what you want with a combobox and this will work for controls or subforms. In my example I am just going to use text boxes. First of all create a new module and put this in it. Public Function HideControls() Dim ctl As Control For Each ctl In Screen.ActiveForm.Controls...

As an alternative lets say that you have some code that you want to use to toggle the visibilty of text box controls on your forms. Instead of writing the code behind each command button you can write the code once as a function (Public or Private). In this example I am going to use a Public...

One of these maybe? http://support.microsoft.com/default.aspx?scid=kb;en-us;223206 http://support.microsoft.com/default.aspx?scid=kb;en-us;252502

I am not sure I totally understand what you are trying to do but I think you will find your answer in one of these threads. Moving files in code Check if a directory exist and create a directory Check if Folder Exists Select directory when exporting text Folder Existence Create a folder in a nt...

Ok I am not sure I understand this so please clarify I few things for me. How do you plan on selecting the people. Checkboxes, maybe? This could be handled with a simple If Then Statement (I think). Is the contacts data relatively static? Yes there probably is a way but I have never used...

He is probably writing data to a table separate from the one the form is bound to.

Try it with the HTTP:// at the beginning of the URL and I think it will work for you. Private Sub cmdOpenLink_Click() Application.FollowHyperlink _ "http://www.liberty1st.org" End Sub

You are probably missing the DAO reference so go to the Modules tab and Create a new module. Once you have the code window open goto Tools > Reference (On the menu at the top) and make sure that MS DAO 3.5 is checked under the available references. If not check it and close the modules without...

Oops Rakier beat me to the submit button. This should do the trick for ya: Private Sub cmdAddRecord_Click() Dim strString As String Dim rsCOD As DAO.Recordset 'Set the value of the variable to match the textbox strString = Me.txtTextBox 'Open up a record set from the datbase named...