Search results for query: *

When a gridview row is placed in edit mode, is there a way to set the focus to a control being edited? I've tried and am not having a lot of success. There is only one field being updated. That portion of the gridview is listed below. I would like the cursor to be placed at the RMKS control...

I need help and I am not even sure where to start. We have an existing asp web page that reads a DB2 database to display information about how a specific parcel (property) is effected by our General Plan. This very long page (they call it a checklist) has a section for individual General Plan...

I need to export data from my Access database to this Excel spreadsheet: http://www.co.el-dorado.ca.us/vendor_interface.xls I know how to do a straight export but that leaves a basic grid. Is it possible to export and keep the formatting? Is this possible? If it would be better to import from...

I'm looking for suggestions on how to repeat subtotals at the end of a report. I am working on a billing statement that has a master account with multiple sub-accounts. At the end of each sub-account, the billing charges are totaled. Each sub-account also starts on a new page. There is a...

I could use suggestions on how to write this query. A bit of background first. I work for a small rural county government and they are surveying residents about their satisfaction with their trash company. Once they fill out the survey, it needs to pop up with the overall survery results for...

My PC was just upgraded to XP and Access 2003. And now I am having problems opening my databases (access 2000). Each desktop shortcut has a target path that points to Access, the wkrgrp, and then the database. The open fails because Access is trying to open the mdb as a data access page...

I have what I thought was a secured database. Admin has a password and I created a workgroup for it and created user ids, passwords and assigned groups and permissions. I set-up icons on the desktops to point to the correct db & mdw files and that works fine. But the users have found that they...

I seem to have lost my brain today and cannot figure out how to do this. I have 2 tables, positions & tasks. There is a need to specify if a task is valid for a position. This is a many-to-many relationship creating a 3rd table of position & task & valid y/n. So far so good. On a screen I need...

I seem to have lost my brain today and cannot figure out how to do this. I have 2 tables, positions & tasks. There is a need to specify if a task is valid for a position. This is a many-to-many relationship creating a 3rd table of position & task & valid y/n. So far so good. On a screen I need...

Okay. I have a weird problem. I have an access db out on our share drive. It is very slow to bring up the signon and open the db. I also have a copy of that db that I use for development. It is located on the same share drive under a different folder. It opens very quickly. So what gives? I have...

I am working on a project to send email from my access database. Our email program is Lotus. The sendobject command is working correctly to open Lotus and build the email message and text. The user then clicks Send and has to minimize Lotus to return to Access. But what I want to do is send the...

How do I total an unbound control in a report? The criteria for the control cannot be moved to a query. I have written code to zero a total field when the report is open, add to the total field on Detail_format, and move the total to the report at reportfooter_format. But the total amount is...

I have an Access 2000 application that needs to be accessable from about 20 desktops (not all at once). My problems is some of the desktops have Access 2000 and some have Access 97 (and some have both for various reasons). Will creating an MDE version resolve my problems with the different...

Is there a way to print multiple copies by default?  example: the user always needs two copies of a report.   

I'm trying to export the results of a query to an Excel Spreadsheet. I have a macro that does Transfer Text with the following arguments: Export HTML, (no specification name), QryStatusAll (the name of my query), s:\Project Tracking\QryStatusAll.xls, Yes (has field names), (no HTML Table Name)...

does anybody know how to show running totals in a query?<br> <br> example:<br> <br> name---date----amt----balance <br> item1 3/1/2000 $10.00 $10.00<br> item2 3/2/2000 $4.00 $14.00<br> item3 3/8/2000 ($2.00) $12.00<br> item4 3/3/2000 $5.00 $17.00