Search results

OK so after playing around with things. I have managed to make things work from one form. I just need to look into making some controls visible or invisible based on processing sequence. but this is my current code: Option Compare Database Private Sub Command56_Click() 'RecordSets Dim...

Working on a subform I noticed my issues. I forgot because the keys are null I have to grab a record count after a field is filled in and assign the new record count value to the key field for autonumbering. Still working on the subform but now I at least I found my issue. I had to do the same...

After reading another post I am wondering if putting a subform in this form might be the ticket?

I suspect you have a key relationship issue. Not enough info on how the forms are getting the data. Is the form using a query and what are the properties of the combo box? I am not familiar with Allen's code you uses it look like it was setting the combo box up using VBA and meant to refresh...

instead of opening a subform why not open a report based on your selection. If the issues is with the results that are returning then ask yourself what is missing and why. It could be the query used in the combo box or form is using the wrong Join type. If the form is based on a query does the...

Background: So I have been working on a tracking database for our backups. The original product was in excel. I created all my desired tables related them wrote some transformation code, imported the data into some temp tables then used my code to transpose from the temp tables into the desired...

Resolved the issue. It turns out the problem was that the field int he form being audited is not tied to a table. The main form query sets the field called status based on other tables properties. so removing the audit tag resolved the issue in the form resolved the issue. Is it possible to...

OK So it looks like the issue is a null value issue. using ?ctl.Name in the immediate window indicates a field I did not change and appears to have no value. But I think one of the subforms actually starts the process with a default value which would leave me to believe that value is never...

I started with Martin Greens Audit code and added the fix from this thread to get it to work. I would have sworn it was fully functional the first time I checked it without errors. But when I was testing the DB to find any other fixes I noticed this issue. But It does record the changes in the...

Ok So I ocmmented out the error handling and get error code 3251 for this line in the audit code: If Nz(ctl.Value) <> Nz(ctl.OldValue) Then Audit module code: Sub AuditChanges(frm As Access.Form, ID As String, UserAction As String) 'On Error GoTo AuditChanges_Err Dim cnn As...

Yeah double checked them, had to remove to but it did not make a difference. I also checked for hyperlink fields. Going to see if I can add a message box to audit code to see if give me a better idea of where and when.

No Debug option. Just a pop box that states the operation not supported.

So I got my auditing to work with this fix. But I get an error on the parent form when I click the next record icon or use tab to move to the next record after editing a field. The error I get is "operation is not supported for this type of object". I original thought it was because one of the...