Search results for query: *

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...

When I add a child record to an existing parent, I use a separate form which I prepare by creating a series of globals that hold the data to be transferred into the child. Some of this goes against good data normalization, but it's necessary for this app. When I open the child edit form...

Michael, you're right, adn that's a good idea-I was just trying to get a QAD view into the order of events being called, so my code could minimize the trace convolution. But I'll try it your way (it IS a better solution!) Thanks. David K David 'Dasher' Kempton The Soundsmith...

Mac: you're right. A SendKeys(CHR(7)) selects the immediate window, and a sendkeys(CHR(1)) selects all, but the program now waits for something to do... the Cut is ignored (CHR(24) and I'm not sure how to try a DELETE key. But I'm not going to worry about it. THanks for your help. David K...

Mac, the whole point is to avoid doing exactly that. I don't want to have to go those those steps every time I run a code fragment, but I need to know what events are being triggered and re-triggered. Perhaps I could do this with a SendKeys routine? I'm going to give that a try. David David...

I'm running tests on some complex updates, and trying to trace the progress is very cumbersome. I'd like to have the immediate window display the order the subs and functions execute. To do this, I've added this at the top of each procedure: If isTesting Then Debug.Print...