Search results for query: *

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

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

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

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

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

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

Hello all, I am using Access 2003. I need to allow the user to select a file and then ofcourse that will return the path and filename. I am wondering what is the easiest way to go about doing that and what object do I use to display the directories? It is not a common tool on Access but is...

I have a CSV file which has several hundred lines of data. However, I use "line input #" command to pull entire string of data. It only returns 4 lines of data before EOF is hit. I thought that "line input went to the end of the line" Here is my code: Dim text, x As Integer, li As ListItem...

Hello all, I need help. I have tried to no avail to figure out the Excel libraries and functions. I have data inside an Excel spreadsheet that I want to read only. I was told the following statement would open file: Excel.Workbooks.Open("C:[...]\file.csv") This seems to work and returns a...

Hello, I am sorry to ask this with out looking further. I am trying to do this quick so I would really appreciate your help. I am needing to open a file ( given a filename) in excel through the use of it's libraries. I can't see anything on Application that looks as simple as open file. I am...

Is there a way to return the value of a column where there exists a row for each type that I specify for example, if I have the following data: K M M G 1 123 Five 6 5 123 eight 2 3 123 four 6 6 123 Five 3 4 123 one 6 1 123 Five 4 5 123 ten 6 3 123 four 4 2 123 three 2 1 123...

Ok the particulars are MS ACCESS 2003. Table 1 ID pk Text Table 2 FID (Table 1) pk FID2(Table 3) pk miscfield pk Ok - I am given text with one or more strings matching that of the Text field in Table 1. I want the rows in Table 2 where the FID2 field is the same where the Text in Table 1...

how would I capture the Delete Key. More specifically I want to capture the delete button on a listview object. It seems that OLE objects tend to have all the same functions that other form objects have. I have tried keydown and keypress events to no avail. Are there any other options? Thanks...

Hello, I have had some wierd things happen with Access Forms. First the linkcriteria is getting passed correctly(set properly in the openform command) when the form_open function is called in the new form the openargs variable is null, why is that? Also some global variables are getting lost...