Search results

I have a form where a user inputs a value. The conditional formatting evaluates that value and sets the back color of the text box to the corresponding color. This works ok so long as the number entered is less than 100. Once it's over 100 it seems to evaluate only the first two digits of the...

I've tried looking this up in a number of different locations, but cannot find an answer. I'm running Access 2016 and up until about a week ago it was going well. Now, when I modify a query in the query builder on a form or report, it won't save. I'll make the changes, save it, close the...

Has anyone been able to adapt this old code for use with Access 2007? http://www.access-programmers.co.uk/...d.php?t=155950 I don't know enough about Jet to know what I'm missing. Thanks, Billy :banghead:

I'm trying to use vba to check for a record then open a form with the that record showing. The problem I'm running into is that my IF/Then keeps skipping over the openform command even if it tests "TRUE." Here is the code I'm using Private Sub ISBN_AfterUpdate() Dim strFind As String Dim...

I would like to add an additional field to the "AddtoOutlook" function, but cannot seem to figure it out. I updated the template to create the requisite field, but I can't get the function to populate it. Does anyone have experience with this function, and if so can you please point me in the...

I'm running an append query in VBA, but would like to disable the prompt after it begins running. Right now, when the query runs, it asks the user to select yes if it's really what they want to do. I want to have it automatically select Yes and move on. Any suggestions? Billy

I'm creating a DB to track training for the technicians at my plant. One particular requirement has the technicians giving oral presentations to a panel of graders. The graders have an assessment sheet where they track how well the technician described the associated task. I would like to be...