Search results for query: *

Thanks Tony, That is awesome. Not that it is anything big but thanks it does exactly what I want it to do. Grover, I know what you are saying but that doesn't help me when I have multiple links pointed to the same spreadsheet wanting them to open up to different worksheets. Thanks for...

Is there a way to embed a hyperlink in a Word document pointing to an excel spreadsheet and specify which worksheet will be displayed when it is opened? Currently I have a hyperlink to an Excel spreadsheet but i opens to the default spread sheet( Worksheet 1) and I would like it to open to a...

Is there a way to check to set if a Object is not initialized? i.e... if Object = nothing then.... I know the above example doesn't work but is there another way other than VBA throwing an error? Thanks, Joe

Thanks MajP, You understood what I wanted correctly.Sorry if the explanation was unclear. The solution is simple but tedious. I am too lazy to go through every one of my classes, so I will be doing it the old way. Thanks for your help and expertise. Joe

Hello, I just was wondering if anyone could tell me how to get my class modules to act like access system object in regards to returning readonly items or defaulting to the value. here is an example - when using a listitem if you specify li.listsubitems.item(3) (it's value will be...

yep I found out how to do it already by looking in the good 'ol object browser. Sorry I must not have looked too hard. Thanks Remou. For those interested - here's a simple example. Dim td As TableDef, f As Field For Each td In CurrentDb.TableDefs With td For...

Hello all, happy new year!! I am wanting to programatically access table and column metadata ( i.e. data type, length (if integer), is it a primary key, such and so forth...). Is it possible? My assumption is that it is but I don't know what keywords to use in help. Metadata doesn't work...

I took the very lazy approach by using excel to split it for me. If you choose excel you must include the excel libraries. The split function looks a little easier. If I had it to do over I would probably use split but I didn't know about it until now. Oh well whatever works. btw - csv files...

I have also seen Warnings On Specifies whether system messages are displayed. Click Yes (to turn on system messages) or No (not to turn off system messages) in the Warnings On box in the Action Arguments section of the Macro window. The default is No. Remarks For more information on how the...

Hello, I want to fill the contents of a form based upon the values of the two key fields. I populate the items of the first key field(combo box) and once the user chooses a value, I populate the second, also a combo box. If they choose one of the pre-existing values, I get warnings because of...

Hello all, I want to fill the contents of a form based upon the values of the two key fields. I populate the items of the first key field(combo box) and once the user chooses a value, I populate the second, also a combo box. If they choose one of the pre-existing values, I get warnings...

Hello all. I am using access 2003 and Listview Control 6.0. Here is what I want to do and maybe you can tell me the best way to do it because I don't believe it to be possible with a list view but I could be wrong. I want to display the data in a listview and enable the user to update the...

I have read this over many times and I think the answer I will give is to simple. I think you would already know this therefore i think I am missing what you are asking but here it goes. sorry if this isn't what you asked for. joe Private Sub Command30_Click() On Error GoTo Err_Command30_Click...

Hello gentlemen and gentlewomen, I am getting an "out of stack space" error as I am perusing through my program. I was wondering how to increase the stack space. Or is there perhaps another reason for my error. Thanks in advance. Joe

Is there a constructor to VBA classes? Thanks. Joe

I am wondering if there is a good tutorial on the net to teach me more about using class modules ( i.e. Classes/object ) in VBA. Can anyone help or give me a few pointers? Thanks. Joe

I agree with Remou, What is AccessionQuickLookup ? If it is a Listbox ItemData doesn't return a value. I am not sure why you are opening the same form twice but as long as you mean to .... wonderful. Joe

Please forgive me for my ignorance and inexperience but I was wondering if it is possible to write classes in VBA and if so, do you have a good link to a site where I might learn. Also, I would like tips on how to search for this info without bugging you guys with silly questions. I alway resort...

Hello, I am using Access 2003 and I want to open a form that will allow the user to peruse through the filesystem and select a file, which control should I use? Is there a premade control given by windows? This would seem to be a common thing but I haven't a clue where to begin. Thank you...

I was also going to suggest like Remou that this be done before the update of the table because if the user has enter the same number in twice you would have to update or delete the record for as many times as they do so. Are they gauranteed to have three guesses?