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...

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

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)...

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...

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

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...

I am trying to get random rows from the same table using a union query. If I run the first half of the query by itself self I get random rows on refresh but once I add my union for another category they are ordered by RandomValue but the query no longer pulls random rows. Any help is greatly...

I have a project that I haven't stated yet and I'm looking for advice on some best practices. essentially I will have a table with personnel information, standard stuff First Name, Last name, ID number, ect. Then I will have a table with some on the job training information such as Academic...

I am looking to add a button to a form that will allow the user to select an image file from their computer and copy it to a shared folder. Then copy the full location and paste the location into a text field on the form. Im not even sure where to start my search for something like this.

I am using Access 2010. I have one table question bank and a few queries that pull random question by category for the bank. I have created reports based on these queries. The output is simply something like 1. Question contents a. Answer one b. Answer two c. Answer three...

I have a table being used as a question bank. When I started using it I was only generating test on one subject at a time so I used a query that looks like this SELECT TOP 10 Questions.ID, Questions.CAT, Questions.Job, Questions.Department, Questions.Question, Questions.Answer1...

I have a report that is bing used as a quiz it has 4 conditional formatting rules that highlight a correct answers. I am looking for a way to disable to rules with a button so the quiz can be printed out without the answers highlighted. Thanks.

I'm looking to Sum IIF with multiple items being true. I can't seem to figure it out Sum(IIf(([TD]![COMPLETE]="YES") And ([TD]![NOAC]>1),1,0))