Recent content by kowol

Can you post the code or sample file? Thanks

I'd like to send a query result via email attachment daily without user intervention. Is it possible? thanks

I'd like to create the chart from the attached table. But some part numbers don't have quantity in certain month. So those month won't show up in the report as you can see from attached picture (May is missing). is there a way to create the query so that it shows 0 for May? I was going to use...

I made it separate file because it takes too long to update. And I don't want to wait till update query finises.

First, I have a little experience with Access so I just used that code how it works. Anyway, I have two database files. One is for the data input and the 2nd file has a form with Timer interval to update the local table from sql database through ODBC connection. What I want is the 2nd Access...

I found below script from the forum but the objApp.Visible = False doesn't work. Any help would be appreciated. Thanks Private Sub Form_Load() Dim objApp As Access.Application Set objApp = New Access.Application objApp.UserControl = True objApp.OpenCurrentDatabase...

Below is the current VBA to export the query to excel file but I need know how to export the formula from query like "avg=([m1]+[m2]+[m3])/3" to the excel file as well. Private Sub Command34_Click() Dim stDocName As String DoCmd.SetWarnings Off DoCmd.TransferSpreadsheet acExport...

I'd like to know how to copy the value using mouse right click from the listbox. But the listbox data has 6 columns and I want to copy the 1st to 3rd column value so that I can paste the values to clipboard. In other words, when I click and highlight the low and click the mouse right button then...

I'd like the unbound text box to get the value(user name) from text file when open the form. I enter a user name in the text file and save it then display the user name in the unbound text box in the form when I open the form. Thanks

I have the form which takes too long to open due to the list box in the form The list box shows the result based on the text box input. Is there a way to run the list box query after opening the form so that I can open the form quicker? Thanks

It works! Thanks

But I don't know how to enter your code in Macro. It doesn't have SetWarrnings in the Action list

I'd like to run the make table query daily at night and close the access after finish it. I've found some instruction to run the Macro to do it but I also need a macro to clear all the warning message. Thanks

Hello, I'd like to use Union All to join the data from two table. But I've found a couple of records from each table have exactly same data. How to join the table to show all the data from two table including duplicates.

Perfect ! Thanks