Recent content by coughnut

Wow, it was that simple. Thanks for all your help mintjulep...

Hi, I need some help in what I am trying to do. I have two columns in my spread sheet and I want to compare individual cells and format it accordingly. For instance if cell B1 > C1, then fill the color of B1 to red and if B1 < C1 fill it with green. I want to do this for about 1500 entries...

Sorry I meant to type : rs.Fields("Total").Value = "$" & Round(total, 2) This gets the number put does not put in the dollar sign

This question might sound dumb, but I am not sure how to make this possible. I have created a table using Vba, and some of the fields in the table I have specified to accept doubles, since I am expecting dollar amount here. I want to be able to add a dollar sign as well as the number to the...

Is there a way to know, in vba, when a form is loaded all the available tables there are. The tables that I have to play with are constantly being deleted and created. So what I would like to do is have a list in an array of all the tables that were there when the form was loaded. Thanks for...

I am not familiar with filesystemobjec and I get an error when trying the above code. I get :Run Time Error '424' Object Required. It happens here: Set txt = objFileSystem.opentextfile(strFile, forReading) ' 1 - ForReading

Thanks a bunch Roy, I will give that a try

I am searching for help once again. What I want to do is convert a certain file to a .txt Document MS-DOS Format. The file that I need to convert is coming from a Solaris machine, I want to parse that file and search for certain Item in order to construct a table. The thing is that when I use...

Hi there, Once I again I am seeking help from any one out there. I am trying to import a text file to access into a table named temp. I have looked into the docmd, but I am still a bit confure. Can anyone be of any help. I will greatly appriciate it...Thanks

This is probably an easy task. But what I need to do is search a list box for a specific value. I have a list box name lstName, and I need to search the name list bos for a specicific name. Could any one be of some help... thanks..

Hi, I am trying to open a table that has been named by the user. The name of the table is in a string called tableName. When I run this part of my code I get an error saying that the table does not exist. But I see that the table is there, but why can't I open it. Thank you. here is my...

thanks a bunch. Do you know any good websites that would have good info on this function. The only ok webiste that I know is msdn. thanks once again.

Hi, I need some help in what I am trying to do. I want be able to go to a directory and open every single file in that directory in order to populate a table. I was wonderring if any one new how to do this or could guide lines in doing this. I would need to do this in VBA, Thank you very much.

Thank you very much...

I am importing an Excel spread sheet to a table in Acess. I am then searching every single row and column of that created table in VBA. What I would like to know is, is there a way to find out how many culomns, fields, a table has in VBA. I will be importing spreadsheets that would vary in the...