Search results

  1. H

    code for a recurring event

    Thanks for the response. I think this is a great start. I guess it is a simple thing to do, I am just very new at this. I guess I could write some code to re-set the date in DatetaskDue to the current date at the 56th day so the message will pop up every time the event is due
  2. H

    code for a recurring event

    I am teaching myself VBA and have come to a roadblock. I have an event (task that needs to be completed) every 56 days, with the countdown starting on a specific date. I would like to show a warning when my database main menu starts up. I would like the warning to only show up 5 days prior to...
  3. H

    automation through VBA code

    I am new to VBA and trying to learn some code. I have developed a database with Access 97 and I am now just realizing the capibilities of access and VBA. I have many questions but right now I would like to know if code can be written for the following: I would like to see a Dialog box with the...
  4. H

    Changing a text box conditionally

    I'm not sure what you mean by continiuous form and the type of form. The number is just a number with no decimal point. I have a form that opens when the database is open. I use the following in the control source for the textbox =DCount("*","INITIAL REVIEW not complete LIST") to get the...
  5. H

    Changing a text box conditionally

    Sorry I did not say I am using acess 97 right now.
  6. H

    Changing a text box conditionally

    First I am a beginner, but I am trying to learn VBA. I have a form that has a text box that contains the sum of records generated in a query. My question is: can I change the background color of the text box when the number is higher than 0. I would like the background to change to red when the...
Back
Top Bottom