Search results

Ok I hacked and slashed this code from the help files of access. Help index keyword = CreateProperty -> Example It will now do exactly what your asking. (for a single table, you can change it to work with more then one) Sub ChangeDescr() Dim dbs As DAO.Database Dim tblDef As...

That's exactly what I was looking for. I was just being brain dead. Thanks.

As the subject says I'm looking to export a file to excel. I'm currently using: DoCmd.OutputTo This, however, opens the file in Excel. Is there some way of exporting to Excel without it directly opening the program? Thanx in advance.

I'm not sure your code is correct anyway. It looks as if it will give you the first items in your listbox to the number of items selected. to illustrate a b(selected) c d(selected) e your code would return a and b (if you had selected three items it would return a,b,c) You need to have the...

You only need to create a reference to the Excel's object library. Tools->References->Microsoft Excel 10.0 Object Library It should run smoothly from there.

The most obvious problem I can see is that you haven't give stLinkCriteria a value in your BEditProducer_Click Proceedure (or anywhere else except for the Command2_Click. Private Sub BEditProducer_Click() On Error GoTo Err_BEditProducer_Click Dim stDocName As String Dim stLinkCriteria As...

Ok this is just off the top of my head... but... Couldn't you create a seperate database for the users that only has linked tables to the original database? Then you could run your macro on the original without worrying that the users will mess it up... Drevlin

I forgot to change this in my post. Since your using a .prn file instead of a doc file you'll want this line to look like this: Set wdFile = _ GetObject("C:\My Documents\Hello.prn", "Word.Document")

These statements are both true. However, it is possible to do what is being asked. You do actually have to open the file. But the person running Access would not know that it is going on. I didn't write this to be pretty, just to show what you need to do: Sub replaceInPRN() Dim wdFile As...

VBA runs through the code in sequence. Ergo, one at a time. Also, instead of having Five buttons you could also set up a Sub Procedure for each of your clients. Have one Command Btn and 4 Check Boxes. For your btnCommand_Click event you would have: If me.ckOne = true then procClient1 End if...

Just call the click event of the buttons you want from the Do All button Private Sub Command0_Click() MsgBox "BEEP" Beep End Sub Private Sub Command1_Click() MsgBox "BEEP" Beep End Sub Private Sub Command2_Click() MsgBox "BEEP" Beep End Sub Private Sub btnDoAll_Click() Command0_Click...

First I apologize for not seeing the line that read: Dim MyArray as String As far as your problem goes. I believe the reason your having trouble is because the Array() function uses Variant data type. What you were trying to do is place an array inside of a string variable. This of course...

God I hate it when the answers are that simple. *sigh*

Your problem probably isn't with the Array coding. The problem more then likely is the variables you are passing to the code. What type of information are you holding in the Array? Cell addresses or actual variables? What type of calculations are you making with the variables?

In many of my databases I use date criteria to run different reports for different days. In order to expediate this format I have created a form that excepts the first and last date requested and then places that data into a global variable. This allows me to just place getStartDate() and...