Search results

Please help! How do you set a checkbox in Excel sheet to True from Access? Thanks.

That's because I need to open more than 1 queries (diff. tables) in the form.

I haven't done Access programming for so long and I forget even the most basic thing on how to open a recordset in vba. I need to open a table and select certain records. Are there 2 ways to do that? Which way is better? How do you write codes to create and open a recordset? I'm using Access...

Hi, I created an ms access app in office 2003 that has 11.0 object library. When I gave it to my client, he had only 9.0 object library. He couldn't run the app. Is there a way to update his object library to 11.0 without too much trouble on his side. Thanks.

Thanks for your reply but I think there must be a better way to do this in one event instead of doing it 44 AfterUpdate events for 44 controls.

I have 44 checkboxes, each has a textbox next to it. What I want is when the user selects a checkbox, the textbox next to it will be enabled. Also, when the user unselect a checkbox, the textbox next to it will be disabled and any value entered is cleared. Another way is whenever the user...

Write a function for user to select a path in a module then call that function in the File Name. For example: Let's say you create a function call FilePath that return the path as the string Function FilePath() as string ---your code here End Function Then put =FilePath() in the File Name of...

Set SetWarning to False

No criteria is needed. You need a group by clause like this SELECT ClientID, Max(DateVisit) AS VisitDate FROM Clients GROUP BY ClientID;

You can either set the Control Source of the text box to the field or execute an Update SQL statement in your code.

Default value only appear once in combo box when you first open the form. If you want it back to "None", you should set those combo box to "None" by code under click event of your Reset button. Because you set them to Empty, that's why it returns Null instead of "NOne"

Use Count([YOurNameField])in a group footer or Report Footer

I have a report that display those who are >=57 years old and has their (Age + Years of Service) >= 75 for any chosen year or years. The names are grouped by Department. Now I need to display a little summary that tell me how many employees are gonna retired in each YEAR for each DEPARTMENT...

Make a combo box for your location and place it in a main form. Have your other fields in a subform.

Are you saying you have 32 forms and 32 queries, or 32 forms and 1 query as the record source of these forms? You set the criteria to Last Name. Does that mean you have 1 form for each person? 1 suggestion would be to make a Criteria form that lists out all the Names, then set your query...

Create a form called frmCriteria. Make 3 unbound text boxes on this form: txtStartDate,txtEndDate, and txtType. In your query's criteria row, under your Date field, type: Between [Forms]![frmCriteria]![txtStartDate] And [Forms]![frmCriteria]![txtEndDate] Under Type field, type...

Set that text box Visible property to False by default. Then,write a little VB code that set that text box Visible property to True if the other text box is not Null.

You can make multiple selection in a list box, not in a combo box.

Create a command button. A wizard box will pop up. Choose Form Operation, Open Form. Click Next. Select "OPen the form and find specific data to display". Click Next. Click the common field name (let's say ProjectID)in both form, then click this symbol <->.

Try to Refresh the text box on AfterUpdate event instead. In this case you have to type in the whole word, press Enter, then your combo box will be updated. Another option would be to make the text box a combo box (cascading combo boxes).