Recent content by USnick
-
U
macro for increasing table values
one point though... you are mixing alpha and numeric values in this nested iif, which leads me to think you are doing the same in your tables/queries. I do this sometimes as it is effective for certain data structures, but in order to increment it you need to use a conversion function like... -
U
Requery subform
I am trying to do the requery after update of the controlling date field on the main form. If I understand your message correctly I need to put the suggested code in under VB. But I would rather avoid that as I am new to VB and not comfortable with it. Is there a way to call the same function... -
U
Requery subform
A little confused (or maybe a lot) I am looking at a similar issue. I have a form set up with a sub-form showing dates (columns) and rooms (rows). The range of dates is entered on the main form. I can't get the subform to requery (except by clicking on a subform field and pressing Shift-F9)... -
U
macro for increasing table values
Say your table is as follows: NAME GRADE Johnny 4 Sally 3 Joe 3 Create an update query that updates GRADE to GRADE+1. The SQL statement is: UPDATE Table1 SET Table1.GRADE = [GRADE]+1; You can build it in design mode really easy. I attached... -
U
Pause macro to get user input?
I need to pause an Access macro to get the user to have a "second chance" - i.e. "Are you sure? Y or N" dialog with control buttons to click for yes or no response. The problem is, I can't figure out how to stop the macro from continuing while the dialog is pending. I know that I can always...