Search results

Keith, The problem is that I have some formulas in my report, and I had to create those formulas with Variables in VBA, so It can NOT be done in a query. That's why I need either to send my report data to a Table or send the data to a text file with delimited to export it back to my database.

Can anybody tell me how to export a report as a text file with delimited. I am trying to use the "TransferText" but i doesn't ask me for a delimited. I can export it, but without the delimited. Please help

Hi Pat, Thank you for your advice, but I created a formula to run a balance in a report, I did it in VBA using If statement and Variables. As far as I know I can not use variables in a Query. What I am doing now is Sending the report to my C drive as a Text and then import it back as a Table...

I have a report with some formulas, so I would like to convert this Report in a Table or Query. PLease Help!!!:(

Running Balance Can you please tell me how to do it in a report? thanks

I don't want to have distinct values, I don't want to group them. If the invoice number is the same I need to see it multiple times and just sum the invoice that are the same by lines. example: Invoice# amount Running balance 1256545 50.00 50.00 1256545 15.00 65.00 1256545 10.00...

I have a query that have three columns invoice number, tran number and amount. What I would like to do is to sum the invoice number if they are equal. example: new column Invoice #: 1345652 50.00 50.00 Invoice #...

Hay, I use groupwise not outlook, can I use the same code? can I specify the table or query name on this code? how can I create the Sub sendMessage? Thanks a bunch!!!

SendObject Question I need to send 2 objects in 1 email? please, please help!!!

I want to use the SendObject to attach two objects in the same email? Can anybody help me?::(

Hi Folks!!! I need help. I would like to run a Macro that copy or delete all the odds rows. I have some information that needs to be moved. I would really appreciate your help...

I AM CREATING A SECURITY FOR MY DATABASE, BECAUSE IT IS LOCATED IN THE SHARED DRIVE. THE USERS CAN NOT DELETE TABLES OR ANY OTHER OBJECTS, BUT THEY CAN DELETE THE WHOLE DATABASE. HOW CAN I PREVENT THIS? ANY IDEA WOULD BE REALLY APPRECIATED!!! SECURITY FOR MY DATABASE

Hi Hay, I am using Access 2000. From my form I want to call a Customer, so I have a Combo Box, I want to click the customer and get the report. Is that possible? Thanks!

How Can I populate a parameter from a Form using a combo box. Thanks!

Hayley, can you please tell how you do that? Thanks! Are you familiar with Query by Form? I use this alot when searching for multiple criteria. This means you choose your search items in the form and your results then go to the query. I...

:( I have built a query to give an specific info, call it from a form, so if I mispell what I want then I get an empty report. I want to create a combo box from my form, that can run a report from my query. When I try to do it, appear the dialog box form my query. Can you please tell me how that...