Search results

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?

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

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

Hey All, I have created a sub-form that is linked to parent form through a field that is determined by a combo box. I am trying to get the subform to requery the data anytime a new combo box selection is made. I have tried using the "after update" event for the form using code:[sub form...

I am afraid that my problem is infuriatingly simple, but I cannot seem to fix it. I have a table and a form which use a field named "Hours". Originally, this field was set-up to round the decimal place. However, I need 2 decimal places now. I have changed the number of dceimal places in both...

Greetings! I want to create a control in my User Form that runs and prints a report based on a field entered on the User Form. Essentially, I want employees to be able to enter their ID, a date, and some other values in the form and then click a button on the form that will run and print a...