Search results

Sure! There is a third field with quantities in it. Using this, the unique ID and the sequence field, I am going to create a field that tells me how that number has changed since the last transaction. So if customer A has 3 transactions with 10, 20 and 30 in the quantity, I want a new field...

Greetings! I have done this before, I just cannot remember the most efficient way to do it. I have a set of transactions with a Unique ID field and a date. I want to add a field based that gives me the sequence of events for each Unique ID in order of when it happened. For example, if...

I tried to write a macro that would export a set of queries to a dynamically named excel file referencing the date. Here is my code: Function Export() On Error GoTo Export_Err DoCmd.OutputTo acOutputQuery, "Bernie Sandoval", "ExcelWorkbook(*.xlsx)", "C:\Users\kamend\Documents\Data Clean...

I have an after update event that sets a field to value [Query]![Field] Access is giving me the error that the "Identifier [Query]![Field] could not be found". Any ideas on what is going on or how I should proceed?

Yes. Thank you all very much!

Ok, I tried this and it does work, but it stores each change in the audit trail table four separate times.

Applying Audit trail Module to Multiple Controls in a Form Greetings! I have a module that is designed to create an audit trail for me. Here is the code below: Option Compare Database Const cDQ As String = """" Sub AuditTrail(frm As Form, recordid As Control) 'Track changes to data...

See attached.

And that is what I want. It just is not returning any data for some reason.

I have a Query that runs off of a combobox selection as it's criteria. Specifically the criteria is: [Forms]![Print Coupon Form]![EECmb] Is this not the right syntax? Do I need to specify the column within the combobox that matches the field that I am using the criteria on? Why isn't this...

I am not really sure what happened when I used your current solution. There were no error messages, and my subform just almost disappeared. At this point, I am trying to figure out what went wrong when I created the subform in the first place.

This is exactly what I want. What steps could i have possibly missed? The main difference between my db and yours is that your data is all in one table. My data is linked across two tables through a 1 to many relationship. ANy ideas of where I might have screwed up?

Here is the file... I realize now that some of the data is linked to another database. If that causes any problems, let me know. Otherwise, thanks a lot for your help.

Ok, my bad. I was thinking about this the wrong way. The combobox actually filters two other fields whose control names are Description and Code Definition. When I made the adjustment (below) I got the error message that "Object does not support property or method." Does this mean that since...

No, I think you misread that. It doesn't say anything about the "DescriptionKey" field. It says it can't find "Description Key" field. Which is the control name for the text box in my subform which contains the "DescriptionKey" data. I am confident that that is the name of the control.

I get Run-Time Error 2465: Access can't find Field 'Description Key' referred to in your expression. I noticed that the code used does not have any reference to the subform. Is this a problem? The DescriptionKey field is an Autonumber data type.

Subform Control: Description Key Subform: Crosswalk subform Combobox:Combo11

The field in the combobox on the form is "Description," and the field on the subform is "DescriptionKey". If they need to have the same name, I can fix that.

I am a little confused. What code should I use on the subform's On Filter event? And wouldn't the filter still only be triggered as it is being done without the code? I am trying to get the subform to update every time the value in the combobox is changed by a user. So, to me, it would make...

I just used a parent/child relationship as built by access to create the sub-form. I just want that relationship to work differently. So I have attached the Me! [Form Name].Requery code to the AfterUpdate and OnChange event of the combobox. I am open to trying other methods. I just need the...