VBA
Access copied graph in VBA
I have copy and pasted a graph onto another worksheet: With ActiveChart .ChartArea.Copy End With Worksheets(\"Legends\").Paste[详细]
2023-04-13 00:28 分类:问答New styles added to Word 2010 (Heading 1 + Not Bold)
In Word 2010 the new styles are created automatically, I woul开发者_StackOverflow社区d like to suppress this behaviour.[详细]
2023-04-13 00:25 分类:问答How to copy a cell or a range of cells from one Excel spreadsheet to another Excel Spreadsheet with VS 2008 VB
I have created a GUI (the easy part) in VS 2008 VB that has two text boxes (one to select the target Excel file, and the other to select the destination Excel file). They both are accompanied by a bro[详细]
2023-04-13 00:23 分类:问答Access Listbox based on value list - sorting on column
I have a Listbox with 3 columns on an access form which has as it\'s row source a value list (not a recordset from the db), which is passed as comma seperated string. The third column is a numeric val[详细]
2023-04-12 23:42 分类:问答Macro button to change filter
I want to have buttons to change my excel filter. I filter my fields with contains=something so each button should change that something text.[详细]
2023-04-12 23:24 分类:问答MS Access: Can't complete the Output operation
I\'m not an experienced vba programmer and working with access is not my cup of tea. I\'ve been asked to fix some errors in an MS Access 2010 VB application. The sole user previously ran the applicati[详细]
2023-04-12 21:42 分类:问答How do I save an embedded image in Microsoft Access to a file?
I have a lot of images embedded in an Access database.I need to save the images 开发者_如何学运维to a file.How do I do this in VBA?You need the GetChunk and AppendChunk functions.[详细]
2023-04-12 21:25 分类:问答Access vba: listbox additem multicolumn truncating on comma
I have a combobox with two colunms, but the first is hidden that adds values onto a listbox in the same manner. I am noticing that the list box is truncating the string in the second column.[详细]
2023-04-12 21:06 分类:问答Going Back and forth between Userforms
Hello everyone on my userfrom I have a previous and a next button the previous button on userform 1 contains a next button which the code looks something like this[详细]
2023-04-12 20:53 分类:问答Excel VBA - Code used to work, can't find the issue now
I was using this code and it was working just fine before, but now for some reason I\'m getting an error that just says \"400\" and I didn\'t think I changed anything.[详细]
2023-04-12 19:44 分类:问答