Search results

I have an application that uses the Microsoft excel library reference. What's the best way to deal with different library versions installed on end users, computers? For example, the version I have installed on my computer is 16; one user has 15, another has 14. How can I prevent the missing...

I have a form that only has a Richtext box on it and Save button. the only thing that happens when the button is clicked is DoCmd.Close acForm, "Comments", acSaveYes I want to add an If statement that checks if "Me.Comment" is blank and then deletes the record. For example, the user starts to...

I have a continuious form that I would like to change the visablity of one of the fields. Initatally I attempted to put this in on Load, but that sets every record to false on load if the dlookup is true. On current works, some what, meaning when I click on that record where the dlookup is true...

In this case, I am using the query to randomly generate an exam. The report uses conditional formatting to highlight the answers, so the idea was to allow instructors to print a key if needed, then disable the highlighting to allow the exam to be printed for students. So, in this case, the query...

Is there a way to prevent a report with a query as its data source from refreshing when going to print preview or printing?

Got it working. I needed to change the format of the combo box Column Count 3 Column Widths 2.5";0";0"

CourseID is text

I have a combo boxed with this query as the row source. SELECT tblApprovedCourses.CourseName, tblApprovedCourses.NumberTD, tblApprovedCourses.CourseID FROM tblApprovedCourses; I have an after update set to Private Sub CourseName_AfterUpdate() Me.NumTD.Value = Me.CourseName.Column(1)...

Thank you!

I have a temp table that I would like to remove rows from if the value of one of the columns matches a query result. DELETE Task_Temp.*, CompletedTask.TaskNumber FROM Task_Temp, CompletedTask WHERE (((CompletedTask.TaskNumber)=[Task_Temp].[TaskNumber])); If I view that in the datasheet view I...

Basically I only have two forms, one for single equipment edit allowing for notes to be added and one continuous form for bulk edits. Same table just different form names. Im trying to adapt an audit/changes bit of code to include the SN when changes are made on either form. Thanks this works...

Is it possible to use Screen.Activeform to reference a specific field value? something like? Dim SN As String SN = Screen.ActiveForm.Name.EquipSN.Value

That did it. Thank you for your help.

Yes

The same result. Using F8 to step through gets to "Set rst = dbs.OpenRecordset(query)" line then jumps down to "Resume ExitProcedure" line

Just now yes

Thanks for the reply, I tried your amended query but still face the same issue no errors and no string output to the CommentsBox.

After a bit of googling, I came up with this query. When I open Update form then run the query, I get the desired results. SELECT * FROM StatusComments WHERE EquipSN = Forms![Update]!EquipSN ORDER BY CTimeStamp desc So I move on to changing the code get the comments to push to the CommentsBox...

I Use the free Microsoft Bug tracking template in my office. They use the following function to get comments for any bug and push them out to an unbound text box on a bug detail form. I would like to reuse this code for almost identical reasons. Below is their relations ships Option Compare...

This gave me a syntax error but works if I drop off the first ( and last ) think this is a subquery?