Search results for query: *

the situation is as following: There are two servers in LAN: "server1" and "server2" database "db1" is running on the SQL Server in "server1" database "db2" is running on the SQL Server in "server2" Table "t1" is in "db1" Tbale "t2" is in "db2" I wrote a trigger on "t1". When a row is...

Hi,thanks for your reply but I already looked at the permissions in the folder containing abc.mdb and found nothing. What else can I do?

When I try to compact the access file, the following error message is shown: "Can't read the records. You don't have the rights to read the data of ....\abc.mdb". If I look in the directory after I tried to compact the tables, I will see that Access automatically created a...

Thanks for all of your replies. But I have to say sorry, I didn't mention my question clearly. Actually, I want to know how to get the name of the current report. For example, I preview report "abc" in access. I can get the file "abc.rtf" via the toolbar command "publish...

In access, I can use toolbar command "publish it with Microsoft Word" to export a report to rtf file. How to do it via VBA code? Thanks.

My email address is zonnebloem@email.com I dropped my email here yesterday. But now it is not there. It's strange. Plz send the code/form to me. Thanks.

I have a file C:\temp\abc.doc I'd like to write VBA code for a button. When the button is clicked, the file abc.doc will be sent out as attachment via email. How to write such a script? Thanks.

I use Access 97. I don't have a snapshot viewer. I can send a snapshot file to someone by using File->Send->choose snapshot format. But if I try to use the following code < DoCmd.SendObject acSendReport, reportname, &quot;SnapshotFormat(*.snp)&quot; > to realize the same function. An error...

No. How can I set ShowWarning to False? I tried to search such an option in Access Menu: Tools -> Options... But I got nothing. Isn't it there?

I wrote a procedure to copy records from table A to table B. I run this procedure in Access 97. When one row is inserted into table B, a message box is always showed to ask me if I want to save the change. There are thousands of records. It is terrible if I have to click Yes each time. How to...

I looked through the items in Format tab of Properties of the list box for several times, but I did not see Text Align. And after I click a list box in design view, Text Align icons in Tools bar are grey.

There shows three columns in a list box. The first column is for numbers. The default setting is that numbers are left aligning. Can I change them to right aligning? If I can, how to do?

When a report is produced as a word document, its format is lost. Is there a method to solve this problem except using snapshot?

Thanks for your answer. But I hope the extension of the produced file is &quot;doc&quot;, not &quot;rtf&quot;. are there any methods to do so?

Our users would like to have the reports produced by our MS Access application in DOC format . Are there any methods to produce reports in DOC directly?