Search results

Hi All, I have a query that merges data from two sources and creates a spread of data for use in a report. This all functions and the report works great. What I want to do now is add subtotals to the report. However, when I go down to the second grouping, I need to sum a value only once...

I programmed this. Essentially, when the user updates the Remarks field, a prompt asks if they'd like to update the Last Contact Date. If they click yes, it sets Me.LCD.Value = Date. If no, it does nothing. The issue is apparently a non issue as I can no longer produce the problem. I...

Hmmmm... That's what I intially thought...More testing has revealed that it seems to be occurring if you go to the new record and then update the Remarks and say yes to the prompt to update the Last Contact Date Field. I will test some more... But the field is definitely bound...

Hi All, Obviously I cannot use vba to update a record by using a simple me.control = blah because it will update all of the records. However, is there a way to grab the PK of the record so that I could use it to run an update query? I just want to be sure I am grabbing the PK from the...

I was able to isolate the problem to the CboBox. I copied my report and query and changed the form to one with a text box and had the code call up the form. This happens so fast the user can't even see the form and the batch printing is working!

Thanks for the post. What you linked to works for that particular application, but for this I need to set the filter criteria to limit my result set in the sub report. I am pulling data from the MDB and a sql server and then having to use a UNION ALL on an empty table to add concatenated notes...

Hi All, I have a report that works flawlessly when a user runs it and enters the specific job number they want the report on. What I'd like to do now is allow the user to run a batch of these reports by Client. (Clients own the Jobs). In order to do this, I created a form in which the user...

The users will do far more editing than deleting. This is mainly a way for them to delete a line item created in error. It is extremely rare to actually delete a line item if it was legitimately created. Since the user will want the ability to edit multiple line items quickly, selecting the...

Hi Paul, I definitely need the data editable. The variant identifies if the record has been selected in the list box correct? And if nothing was selected, it would have nothing to delete. I assume I could run a check to see if this is null as part of the event to stop the procedure and tell...

I haven't considered that. So your suggestion is to create a multiselect listbox that contains each line number (A unique value for each record) and is bound to the LineID (PK). Then allow the user to select multiple and click the delete button. This button then deletes the records by using a...

Hi All, I haven't been able to figure out how to call the selected records in an access continous form so I may create a new recordset from just those records. Here is what I'd like to do: 1. Have a user be able to select multiple records using the built in access record selector. 2. Create...

Oh, here is the vba version of the sql code: Function Snapshot() On Error GoTo Snapshot_Err DoCmd.SetWarnings False DoCmd.RunSQL "INSERT INTO zMREQ ( MRID, MRReqS, MRReqF, MRReqA, MRtoCR, WEdt ) SELECT MREQ.MRID, MREQ.MRReqS, MREQ.MRReqF, MREQ.MRReqA, MREQ.MRtoCR, Date() AS WEdt FROM...

Yeah it would because I am selecting all records from the table and stamping the date the snapshot was taken. Here is my sql code: INSERT INTO zMREQ ( MRID, MRReqS, MRReqF, MRReqA, MRtoCR, WEdt ) SELECT MREQ.MRID, MREQ.MRReqS, MREQ.MRReqF, MREQ.MRReqA, MREQ.MRtoCR, Date() AS WEdt FROM MREQ...

A colleague that does a similar thing in sql server just suggested that i use a simple select insert to copy the tables at a specific time, adding an extra field that labels the week ending date of the data (The current date - 2 days). I could then run more historical data and purge after a...

Hi Wayne, I see what you did and while this is a good utility for me, having a manager analyze data like that would be a chore. I think ultimately the best solution for my issue is writing the code to update the table and append new records to the table. So, I would have a table MREQ and...

Thanks Wayne. I will check that out. I am really hoping to be able to run these change reports easily as it is critical to identify things that are moving.

I am trying to figure out a way to make a copy of some of my tables once a week so that I can run a report that idenitfies what has changed since the prior week. I figure I will create the tables and then create code to update existing data and append new records. I would also like this to be...

Hi All, This has been discussed in an older thread, but I still wasn't able to get this resolved. I was informed to start a new thread and go into more detail so here goes: 1. I want my form to only add new records. 2. Like it should, when you start typing information in one of the fields...

I have been fighting with this for a little while now. Here is the code I have: Private Sub Cancel_Click() On Error GoTo Err_Cancel_Click If Me.Dirty Then DoCmd.DoMenuItem acFormBar, acEditMenu, acUndo, , acMenuVer70 End If MyAction = "Cancel" DoCmd.Close Exit_Cancel_Click...

I figured out the error. It didn't like my currency field. This ended up not functioning exactly how I wanted so I have decided to scrap it. Thanks for the help!