Search results

PivotChart how to show data bars using PIVOT SQL? Greetings. I am trying to create a PIVOT Chart in form and allow the users to select filering (e.g. date from and to). I was able to make on easily using Query Design -> PIVOT Chart View but this doesn't allow the users to filter. This is my...

Greetings. How do you write the code to execute something when OK or CANCEL button is clicked on a fileDialog? Set f = Application.FileDialog(3) f.AllowMultiSelect = False If f.Show Then For i = 1 To f.SelectedItems.Count sFile = Filename(f.SelectedItems(i), sPath) Next End If...

Hi guys, I have been looking for a brief tutorial in using MSGraph but failed to find a good one. Most of the search results points me to forums. Mainly, I am trying to change the chart type on a MSGraph control that I have added on my form. However, there is no graph.ChartType OLE Class...

Hi guys. I am not sure if my coding is efficient or not but it takes so long to read lets say tbCOMPANY 40k records and find if values of two columns exists in tbRESULT which holds 30k records. Then if it doesn't find any records in the tbRESULT it will just insert the row otherwise an update...

Hi guys. I would like to be able to keep the textbox value or store it in a variable so that I can get that value out whenever I jump from one form to another? The only way I know is storing this on a temporary table somewhere.. but is there a more standard way/best practice to do this?

I realised the tab indexes were already in chronological order in each tabs. However, I figured out a way to fix this by creating a subform and set the Source Object as the problem form.

Greetings. I have a form with a tabControl that contains many textboxes (about 80-100). Whenever the tab page is selected/activated the focus goes to somehwere down below. I want to be able to set focus on the very top/first textbox so I tried txtBox1.setFocus on TabControl change event...

Thanks for the link. I had a look at it, but it seems that the example given is showing how to change the 'TextBox' color instead of the ListBox control. I would like to be able to set the font color of a specific row and column in the listbox.. so far I haven't seen any examples most only...

Hi. I have a listbox and whenever I clicked on a row it will highlight black background and white font color. How can I disable this or change the formatting? Thanks in advance.

I added the Microsoft ListView 6.0 control via the activeX controls option. In the object browser, I can see Class: MSComctlLib.ListViewCtrl.2 and OLE Class: ListViewCtrl. I am using microsoft office professional plus 2010 if this makes a differences?

Greetings. I am following this tutorial below for the listview 6.0 control in VBA but I don't seem to have this properties .. such as: With Me.ListView1.ColumnHeaders With Me.ListView1.GridLines = True .ListItems.Clear tek - tips.com/faqs.cfm?fid=6025 Any idea why I don't have those ?

Thanks. I did it the other way since in my case it is possible that the sum of all time may cross the 24 hour limit.

I have two textboxes where each contains hh:mm:ss values and I have to get the sum of these two. Currenlty, I was able to split them up and converted hours to minutes and seconds to minutes. However, I am facing a challenge converting minutes back to hh:mm:ss. Is there an easier way to do this...

Thanks you are right. Would it be better if I change the data type to memo as it can hold 64k characters? I understand that it cannot store formatting.

Greetings. I have encountered an issue when I was inserting a string (with newlines about 176 characters) into access table. This field in access has the data type TEXT and it was truncated after the insertion. It is strange because I have three other fields with the same format and no...

Hi Guys, I finally was able to make this work, however, I have a question. In excel I have a cell containing a paragraph with carriage returns or multiple lines and I want to keep this format in access table. What data type should I use in access and how should I pass this value into the array...

Thanks for the warm welcome Paul. The problem is I don't know how to loop through the PROJECT PLAN 1 and PROJECT PLAN 2 in excel and store these in table1 and table2 in access. I have seen numerous examples but are too complicated to understand. I am trying to use this code I found below but...

Hi guys, I have been trying to understand which method to use for looping through excel cells and storing these into access tables. However, I am having difficulty with so little knowledge in vba. I have lets say two tables (rows for each table are not fixed) in a worksheet and I want to...