Search results for query: *

Hi, Keybd_event VK_SNAPSHOT, 1, 0, 0 The code above should copy only the active window. Instead it copies the whole screen. Changing the "1" to a "0" provides the same result. When I press Alt+PrtScr on the keyboard, it works properly. I have Windows 2000 Server. Any...

Hi,<br><br>I need to be able to run a report multiple times.&nbsp;&nbsp;However, I need to have a different caption each time I run it.&nbsp;&nbsp;How do you change the caption property of a report with code without opening it.&nbsp;&nbsp;<br><br>The helper suggests that a report is in the...

Hi,<br>I would like to include a rank field in a query that sorts descending. I believe the row number would be equal to the rank. For instance, in a query listing in descending order of revenue generated the top 10 sales people, the sales person at the top of the list would be ranked 1, the...

Hi,<br> <br> I need to develop an Access DB where some fields are in English and other fields are in Japanese. The field names are English. I want to store both in the same table. For instance, one field will store the last name in English and another field will have the last name in Japanese...

Hi,<br> I have an Access app that doubles in size when it runs. I would like to automatically compact and repair it on exit without the user getting involved. The VB commands I found always ask the user for database names etc. When the app is open however, compacting and repairing the database...

Hi,<br> I'm trying to automate the import of a *.dbf file. However, it is not part of a database. Using &quot;DoCmd.TransferDatabase&quot;, I get an error saying that the path is invalid. I believe that this is due to having only a table file and not a whole database. What code could I use to...

Hi,<br> I'm trying to automate the exportation of a table that contains only text fields as a fixed-width text file. I am able to export it manually using the menu and the export wizard. When I use the code below I get an error 3027 (Can't update. Database or object is read-only).<br> <br>...