Recent content by Newbee1000

Access 2003

I am trying to read emails from Outlook exchange into Access from a specific folder. I can connect to this folder in MS Access and read all of the emails in my desired Outlook folder. Now during normal day a person would start a topic by email and then some one would hit reply and so forth so a...

I was trying to do this through a macro that runs every two weeks through a batch file. I got the totals to export successfully. Thanks

I generate a report in Access and then email a excel version of the report using the DoCmd.SendObject acSendReport, "[Report Name]", acFormatXLS, "[email]", , , "test", "Test Message ", 0, False I have subtotal and grand total on my Access report that give me the correct values when I see the...

All I am trying to do is to have the MS Access databse login directly to the SQL databse. Is there any quick fix?

The Function name is Begin()and it is defined in the code.

I have linked tables from a SQL server in a MS ACCESS.This SQL server is on a netwrok drive MS ACCess is on my local PC on the network. Every time I try to run a report or query I am asked to enter in my username and password. I want to automate that or enter it only once and not have to enter...

I tried the compact and repair database and it brings out a dialog box saying. Do you want to save changes to the following forms. "Company" (this is the deleted form) I enter NO but it doesnot change anything after compacting and repairing the database. I tried YES to save changes and still...

No I have not. Could you please tell me how that is done I am new to MS Access.

Yes they have been removed. The problem is now I cannot open certain Form dues to these annoying deleted forms objects which are not going away as I donot know how to delete them. Please help.

I had a form called " Company". I had some event coded to it. I deleted the Form and then Deleted the code associated with it. But whenever I try to write new events I cannot save them as the error pops up "cannto find Form "Company"" Now I have already deleted this form and the code but cannot...

I need to track time for different employees in a project. I was wondering if there is a calendar that I can enter time for employees and than that data can be integrated to MS Access. Any ideas, I am new at this.

I am trying to count records in a report. I made a text box and called it "Count". In the properties of "Count" I set the Data >Control Source to =Count(). It gives me the total of all records and not actually counts the records. I want the output to be 1 - Item 1 2 - Item 2 etc Instead I...

Like I said I have tried to do that but it is still not sortng that and grouping the ouput. I still get the out put as Material Item #1 Material Item #2 etc. is my Query wrong or am I missing something in reporting.

I am trying to write a report. My query brings out the right results. I am getting: Material Item #1 Material Item #2 I desire to get: Material Item #1 Item #2 I tried to use group option but it is still not giving me the output i need, what am I missing. Please help.