Search results for query: *

Does anyone know a command that will open an excel spreadsheet file.

Hello, Does anyone know how to make a number on a report be a different color if it is a positive amount, but black if it's a negative amount. Thanks, Jeff

No, it is not a part of the control source of the form. The parameter is a part of the row source for a list box. When I open the form before the form will open, it ask for a parameter which I do not want it to. I Only want it to ask for a parameter when I click the command button I Have set to...

Hello, I have a form that has a list box box on it. It is hook to a parameter query, so when I click a buttom i type something in and it comes up in the list box. The problem is when open the form the parameter box comes up and I dont want it to. I only want it to come up when I click the...

Does anyone know about C++ Error that may come up in OutlookXP.

I think INSERT did not get copied, but I found way qround using the SQL statement in VB i just made 2 strings one for each query in VB, so the the actual queries run one after the other.

You want to type in >=#1/1/98# And <=#12/31/98#, but make sure your field in your tabel is a date field not a text or it will not work.

I am putting out this new thread, because the response May make a difference, but it is not why it's not working. I only had the first SQL statement in VBA when it didn't work. I Just threw the second in there to make sure if there were something wrong with both that I would get both answers in...

I tried copying two SQL Statements from an append query and delete query, because I want to move all records into a table and then delete the records I moved. It works fine on the querys, and when they were shorter they worked fine in a macro, but I can not get them to work in VBA. Can you tell...