Search results for query: *

Hi all, I am in the process of converting all my access 97 databases to access XP and I have come across a situation were there was no need to convert the database to XP. That same database I can open it in 97 and XP at the same time. Would anyone know why this is happening and I do not have...

Thanks a lot for all your help. I was able to work it out, combining the suggestions of all. Thanks again. Shcuck

I have a database that has many records everyday. I want to find out what the last action code was for the day. example database: Account# Date Time(hhmmss) action code 123456 12/20/02 124536 paid 265897 12/20/02 133252 unpaid 365898...

When I run a query using the "Last" or "Max" criteria, it will give me the last entry for each of the different fields. For Example: If I am running the query with the following fields: Date, Name, action, termination. Using the MaxofDate, the query will return the max date...

I am trying to send an email through lotus notes, when certain conditions are met on an excel worksheet. any ideas as to how to do this?

Hello everyone. I am trying to write the code that will open an Access Form when I click a button in a message box through Excel. Right now I am able to open the entire database, but then I have to manualy open the form. Is there a way to open the form from automaticaly? I do not want to use...

Thanks a lot for you prompt response. And I want to say that both of them work. Zathras: I would like to use what you wrote, but instead of the "20021213" of the DBDate being a constant, how can I change that to read the value of a cell instead of a set value. For example, I want...

Well here is the situation. I import data into Excel from Access, which is transfered over as a number. I want to change the format of that cell from number to date. But when I do so, I get all "#################". I have tried to resize the column but still no go. I want to...

Thanks for your assitance. I will try it out and see how it works.

Hi everyone. I am new to this forum, so I might be asking questions that have already been asked, but here it goes anyway. I am trying to run a macro with a command button that will open another excel file. But what I need it to do is when the second excel files opens, I need it to run a macro...