Recent content by michee

ok - I seem to have resolved the issue - I have a cascading combo box in a continuous subform. I was setting a value on current record there which was messing up the status of the main form. I'm not certain why that only happened with the client filter nor am I certain it will really fix the...

I have tried removing "errors" from the underlying query and I still get to the point where everything is locked. I also tried changing the data to inconsistent updates with no positive results.:banghead:

The exact recordsource is Q_Client_Names (see query in last response) and the exact filter is ([ATTY_CK] = 2) AND ([CLCL_Display_Name] Like "*e*")

So I've done some additional testing and narrowed the problem down to the unbound control that is used to apply the client filter. I can change the atty filter back and forth without a problem, but as soon as I filter by client the recordset becomes not updatable. the filter is applied...

The form that is currently exhibiting bad behavior is a maintenance form. The main form has a query with multiple tables behind it, driven by CLCL but including the ATTY table for ATTY and an errors query. The main form is not supposed to be updated. I could change all of that to dlookups...

if anyone is still watching this - I could use an assist. Most of the time my new way of filtering seems to work great. However I keep running into the recordset is not updateable problem. I'm sure someplace I'm setting some value that is triggering it but I can't track it down. Is there a...

I closed the search form but opened the maintenance form Overall User Story: The user to searches for a client on the search form using the search filters in the form header. They find the client they want by scrolling through the continuous form client list on the search form. They click...

I changed the form so that it used the filter property instead of parameterizing the query. It works. Still don't know why the other way didn't.

I have two forms, both allow for the user to filter the records with two unbound fields. The first is a search form - a multi form set up where they can search through a list of clients and then click a button to pull up the maintenance form - a much more detailed tabulated form which has one...

Continued testing - still stuck 1. I officially retract my "the msgbox fixes it" statement as I tried again resetting - recompiling - closing out completely and going back into the form and it is doing it again. I choose "error" for the atty, the msgbox clearly shows me the correct value for...

I'm seeing some strange behavior with form filter fields that are set. I am trying to get the behavior to occur consistently but not always succeeding. I have a form with two fields in the header meant for filtering the form data - SelectAtty and SelectClient. The query under the form is...

:D success! After a couple of variations I figured out the right solution. I'm posting the final answer here ... of course if you have any simplifying suggestions that would be dandy. If you want to import data into an access table, and you want data not populated in the source to come...

Ok - that was ridiculously easy... and worked, thank you. I think what got me into this loop is I started out writing a function to replace empty string with a defined replacement value similar to the nz function. When I passed Null as an argument I got an "invalid use of null" error. So how...

I have a module that creates records into a contacts table in my access database. When there is no data in the field from outlook, the data is populated as an empty string "" instead of a null value, creating problems with subsequent queries and processes. I'd like to create the data as a null...

Thanks for the help! I figured access VBA forum was appropriate but probably just because I'm writing in access. I'll try that one next time. Worked like a charm! Do you know why? I'm curious to understand why the general date format wouldn't have done the trick?