Recent content by Soundsmith

Robert, the problem is that what I desire is to delete (or not) the records that are displayed, and then update the tables that are affected, changing several controls on the main form based on the fact there are perhaps no longer records matching this criteria. So the process you and Roy...

Sorry, Roy. The msgbox event continues to activate. I need to open the report in a modal form, but can't see how. I I created a modal form, with the OpenReport method in the Current event, but the modal window stays in front and won't let me change view to print, or even scroll. I tried hiding...

Thanks, RoyVidar. I'll try it. David 'Dasher' Kempton The Soundsmith http://www.thesoundsmith.com

I have the following code in a cmd button. I want the user to preview the report, optionally print it, and then have the option to delete the records involved. dim delXcpt DoCmd.OpenReport "rptMONRExcept", acViewPreview delXcpt = MsgBox("OK to delete ?", vbQuestion +...

Thanks, Estruardo. That does not seem to change the problem. I hasve four fields in trhe main table. The combo box gets its data from the monrLink fields and when I select from the combo box, the data in the subforms is updated, but the main form monrlink field is overwritten, rather than...

I have a form whose job is to display matching results in two subforms (three tables, the form holds a master table, when I move from record to record, the subforms show matching results from the other two tables.) Everything works fine when I use the nav buttons or record selector. WEhen I use...

After working with some recordsets and SQL queries, my mouse cursor disappears, and will not return until I exit Access 2000. I do virtually identical recordset and SQL operations in many other places in this app without problems, and am not changing Echo, Hourglass or any Visible properties...

That worked perfectly! Thanks, Stretchwickster! Dasher David 'Dasher' Kempton The Soundsmith http://www.thesoundsmith.com

I am transferring data from an Access 2000 table to Excel 2000. The numbers export fine, but I need one column to be formatted in Accounting format with $. The code looks like: Public Function XferXL() As Boolean Dim xlapp As Excel.Application Dim xlbook As Excel.workbook Dim xlsheet As...

OK, I got it (finally!) Let the INSERT INTO call the query. Thanks, Ben. David 'Dasher' Kempton The Soundsmith http://www.thesoundsmith.com

Thanks for the reply, oharab, but I don't understand. Where does the transform query reside while I'm appending? I guess I could run the query with DoCmd.OpenQuery, but I don't want it displayed onscreen. Could you give me a brief example of the code? Thanks. David 'Dasher' Kempton The...

How can I get the results of a TRANSFORM query into a pre-existing table? (Access 2000) I have tried this: DoCmd.RunSQL "DELETE * FROM tblServRpt" strSQL = "INSERT INTO tblServRpt TRANSFORM Sum([tblBySsn].[cost]) AS SumOfcost SELECT [tblBySsn].[serv_code]...

I have a TRANSFORM that must be run monthly to generate a YTD report. Every fiscal year will begin with July, and July's report will contain data only in one column, each month adds an additional column of valid numbers. I create a table of current "serv_date" values (like 200207...

Thanks, WildHare. I didn't try tie IS function, but Case "frmAddTrans" worked just fine. (Of course, CASE theform="frmAddTrans" worked perfectly for six months! Go figgur [ponder] ) David 'Dasher' Kempton The Soundsmith http://www.thesoundsmith.com

I have a routine in Access 2000 that has worked fine for months, like the following: [code] Select Case theForm Case theForm = "FrmAddTrans" Set rst = Form_frmAddTrans.RecordsetClone obal = rst("orig_bal") Case theForm = "FrmRecalcAll&quot...