I usually try to avoid VBA in Excel, but it would be convenient to be able to type text into a cell, and have its column get wider or narrower to accommodate the text remaining as it's entered or deleted. This would be subject, of course, to the lengths of the text in the other cells in the column. 'Auto-fit as you type', I guess you m...
How can I write the control source into VBA instead of in the properties window For example if I have a textbox that divides two amounts in other text boxes, then i put =[textboxA]/[textboxB] in the control source of the properties window. how do i accomplish this in vb so that I can trigger it by events?? i know it is not the same b...
Ok so I add all these text boxes on an unbound form, and everytime you open a form, it sort of jumps to the first text box so you can enter some information into it. How do I get rid of that, because I do not want it to auto jump to the first text box when the form opens...i do not want it to jump to any text box when the form open at a...
Using Visual Basic for Applications, how can I find out which version of the MySQL ODBC driver is installed in Windows on a user's machine? I have a Microsoft Access application that uses the MySQL ODBC driver to make a connection. The connection string looks like this: ODBC;DATABASE=mydatabase;DRIVER={MySQL ODBC 3.51 Driver}; OPT...
I have an Excel VBA macro which I need to run when accessing the file from a batch file, but not every time I open it (hence not using the open file event). Is there a way to run the macro from the command line or batch file? I'm not familiar with such a command. Assume a Windows NT environment. ...
Given I have the following <Sheet 1> Item QTY A 5 B 1 C 3 <Sheet 2> Item QTY A 15 B 4 C 1 D 8 What is the best way to generate a report showing the difference between sheet 1 and 2? Like <Difference> Item QTY A 10 B 3 C -2 D 8 ...
So I have a little db that is used for new hires in terms of who, where and what they are issued. One thing that is issued is laptops with little barcode/ID numbers, and I would like the db to auto assign an available ID number when the user is saved to the db. So I have a form that users use to input the information, and it is unbound,...
I had stored procedure MySPOld in Sybase db. I created new sp MySP. This new sp returns data while executed from Sybase Sql Advantage. But not returning the data when called from VBA - Excel 2003 (EOF property of recordset is True). Here is my code.. Dim dbCon As ADODB.Connection Dim rstTemp As New ADODB.Recordset Dim query As String qu...
Given the following data values 12 2 0 -2 -12 I want to add a 3-color scale conditional formatting to the values column such that cells < 0 are green = 0 are white > 0 are red Using formulas like =$A$1<0 for Minimum =$A$1=0 for Midpoint =$A$1>0 for Masximum does not seem to work. cell value > 0 is red, cell < 0 is green, but...
In PowerPoint 2007, PickUp/Apply does not capture some paragraph formatting, such as bullet formatting, when used programmatically (VBA). Adding the PickUp and Apply buttons to the Quick Access Toolbar (QAT) and trying this manually confirms this. However, if you triple-click on a bulleted paragraph and select PickUp from the QAT, then...
We have a massive spreadsheet which does a lot of calculations and not much drawing / writing to spreadsheets My question is : Does monitoring the spreadsheet whilst it is running via RDP actually make this slower?? Put differently if rdp was disconnected would this result in improved speed?? ...
In MS Access 2007, I want to switch between datasheet and form views, without filtering, and remain on the current record. Should I use a bookmark ? How ? or How might I place a button on the ribbon to switch views, without having to search for the record or use a filter. I need this to run Access 2007 Runtime, since it will be impleme...
Good Morning, I need to parse huge volumes of data that looks like the following and need to run through multiple columns and put it in 1 column. the data looks as follows. Col1 Col2 Col3 Col4 Col5 Co6 Col 7 a b C d 1 2 3 e f g h 4 5 6 The output post macro, need to look like follow. Col1 ...
I used Docmd.OpenReport "Report1" from another form and it seems to just want to print the report without actually displaying it. I want to display the report, not print it ...
I have an excel sheet I need to import in my Access database. The sheet looks like this: DATE RECEPTION DENOMINATION ITEM N° QUANTITE RECUE 06/01/2010 DVD-Sex ...
So there is a parameter box that open after a button click event runs an sql statement in vb for a list box to populate data. something like: me.listbox.rowsource = "SELECT tblMain.ID, TblMain.FirstName, TblMain.LastName, tblMain.MobileNumber FROM tblMain;" then i count the result for display like: me.recordcounter = me.listbox.listc...
I have lots of orders in tblOrders and a few deliveries in tblDeliveries. SELECT tblOrders.SkuBestelId, Sum(tblDeliveries.delivered) AS TotalDelivered FROM tblOrders INNER JOIN tblDeliveries ON tblOrders.SkuBestelId = tblDeliveries.SkuBestelId GROUP BY tblOrders .SkuBestelId; Of course, this gives me lots of "TotalDelivered" fields wi...
Odd phenomenon started six to nine months ago. Many of my "clients" (non-technical co-workers) create/edit documents for other clients. Part of my job is to minimize things that make them hate technology :-) One of those things is puzzling me. Some of the Word documents, when I open them, warn me that they contain macros. But when I...
Is it possible to display an HTML page in an Office 2003 and/or 2007 task pane via VBA? Background: We have a complicated configuration file that our users maintain in Word (using a real editor is not an option for our audience). We would like to create several toolbar buttons that display a basic HTML page in a task pane as a form of ...
I found this code that is missing the funtion call in thelast line, any ideas on what the save to file command would be?, I'll just kludge it in. 'CODE to SAVE InkPicture to FILE Dim objInk As MSINKAUTLib.InkPicture Dim bytArr() As Byte Dim File1 As String File1 = "C:\" & TrainerSig & ".gif" Set objInk = Me.InkPicture2.Object If objInk....