Search results

I have two problems in one query. I've been working on this one for a couple of days now, so I'm ready to say UNCLE! I am writing an update query where the update is conditional on a calculated field - if Unused Credit ([AT03]) is at least 80% of Total Credit ([AT01]), then update field XYZ...

Sure - email me the smaller file and I'll take a look. SLH

Many thanks - I always know where to go for the right answers! SLH

I'd put a subform on that second tab that displays all call notes for the employee, linked by employee ID, or SSN, or some other exclusive field. In creating the subform, I would take care to show the fields that one might want to filter on, because when the list of call records gets lengthy...

Sometimes it's the pebbles that trip you up... I have criteria in a query that references two dates (text fields) supplied by a form. The criteria is "Between [DateBegin] and [DateEnd]. Now, if the user supplies values for each of these, everything works great. However, what I want is for the...

Yes, it all happens in the macros. I rarely write code in Access because I am able to do about 99.5% of everything I need in objects rather than crankin' code... :-) SLH

I do something like this currently when a deadline date passes in my project management database. I created a separate database named "Apprentice." Apprentice has an OnTimer event that updates a form with the correct time every few seconds. The table containing the project dates is linked to...

I'M stumped... I am using a SetValue statement in an macro to take three concatenated unbound values and poke them into a memo field (Bound) on another form. So that the (memo) field will be ready for the next entry on a fresh line, my macro also does a SendKeys {ENTER} following the SetValue...

Worked Great!! Simple question, simple solution. Thanks. Somehow, I've managed to use Access for six years and never have need to set a date field to Null. SLH

Sheesh! This seems like a simple question, but I don't know the answer. If I have a pair of fields, such as Score and ScoreDate, and some records have no score but DO have a score date because of a previous global modify, how do I globally modify these records to blank out the date when the...

Through my macros, I am passing via Echo Statements, helpful info to let the user know where s/he is in the series of tasks in the macro. I don't seem to have control, however. For example, it will hit the Echo statement, begin the query following it, but the status bar will not reflect the...

The DateAdd approach worked great! As a control source in a macro, it was the more compact of the two suggested. Thanks to pdx_man and Axis for saving me a bunch of work! -SLH

I remember a similar problem to this awhile back. I don't have the complete answer, but I remember being told that it can't be done in object code such as you are trying to do (I tried the same approach!). To name dynamically, it has to be done in VB code. Unfortunately, I don't know VB very...

Is there an easy way to start with a date, say 7/11/2001, and then write a calculation for the next date in line, taking into account that different months have more or less days? My plan at this point is to write a series of If/Thens using Month([date]) and then attaching the correct number of...

Getting records from T1 to T2 is easy. Write a macro that contains an OpenQuery command that fires an Append Query appending T1 records, field for field, to T2. For the T1 to T3 piece, you could run a similar Append Query with criteria specified for the five fields involved in the test. If the...

I am writing a macro that fires a query. I want the query to run x number of times, with x being a value on a form. I set the Repeat parameter to =forms![form]![RepeatVal], but the macro doesn't repeat. I couldn't get it to repeat with a literal number, either. Is there something not obvious...

I assume you have observed that the form does indeed update successfully, that is, you see the value change youself. If not, I would try this. Second, I would try a diagnostic test where I predicate the condition on whether the count EQUALS some value, testing for both true and false conditions...

If what you want to do is open a form for additional input fields upon the condition that ZIP="40062," I would approach that by setting the AfterUpdate property on the field in the first form to be tested. Set that field's AfterUpdate property to run a macro that tests the value just entered. If...

Add a RunCommand command as the last line of your macro, and select CompactDatabase as the argument.

Just last week I tried to do this same thing. I tried separating object names with the semicolon, as you would for multi mail recipients, but it failed. I tried commas too. The command line thought my attached object was "file1;file2" and didn't interpret the separator. I'm thinking it is not...