Search results for query: *

I'm banging my head against the wall trying to work this one out. I have the code below: protected override void OnDragOver(DragEventArgs drgevent) { try { if (this.GetItem(position) != null) { BaseVar baseVarElement = this.GetItem(position); } else { BaseVar baseVarElement...

This looks great, thanks very much for your help :) All help is greatly appreciated Kind regards Ota

This is the bit I struggled with for some time and needed it explaining... The first 150 come in on PO_ABC123 so we have 150 in stock but is less than the 650 we should have in stock The second 300 come in on PO_ABC124 so now we have 450 in stock and is still less than the 650 we should have in...

Hi, I need some help with writing an update query in Access which will update the stock column of the table below. This is designed to determine where the stock is used and a tricky one to describe.... Here is a sample of the data ProdID In_Stock PurchaseOrderQty PurchaseOrderNo Stock Prod123...

Hi all, I have a MSFlexGrid on a Userform and I was wondering whether it is possible to fit rows and columns to the full width of the control to get rid of the grey unused space? Secondly, are there any examples out there which shows how to automatically wrap the text. I have seen plenty of...

Hello all I have written the following code: Sub MainTest() Dim objConfig As AcadPlotConfiguration Dim blnResult As Boolean Set objConfig = ThisDrawing.Application.ActiveDocument.PlotConfigurations.Add("New") ThisDrawing.ModelSpace.Layout.RefreshPlotDeviceInfo With...

I cannot find anything here on changing via the registry!!

Ah...:) knew it was simple. I had done this purely by accident that morning however I just couldn't quite get back to where I was. Thanks guys.

Hi, Does anyone know how to change Outlook so that it starts up in the inbox rather than outlook today? I know you can change this option through tools > options... but I need to be able to script it. All help is greatly appreciated Kind regards Ota

I have an an input string to a sub which is delimited by tabs and carriage returns. I have a test sub as follows: Sub arraytest() Dim Arr As Variant Dim Arrs As Variant Dim i As Integer Dim ip As Variant ip = "A" & vbTab & "B" & vbTab & "C" & vbLf & "1" & vbTab & "2" &...

Got it working after all JB... I went back to a regular textbox (not one from the activeX menu) and changed the code to delimit by vbcrlf and not vbcr. I managed to change the font as well!! Thanks for the pointers.

Hi JB I cannot get the font to Courier. There is not a property that enables me to change the font and if I try to do it programatically it is ignored!! There was not even a property to set when I tried programatically so I tried .font = "courier" and it accepted it even though it does...

I have a problem formatting text in a rich text control on an Access Form. On the clipboard I have an array in the following format: ITEM<TAB>PART<TAB>QTY<TAB>DESC<CR>1<TAB>ABC123<TAB>1<TAB>WIDGET<CR>... As you can see each record is delimited by a carriage return whilst each field is...

Hi guys, @jaxtell, I am using a MS Access database @PHV, When you view the the query it gives a result which doesn't look as if it has consolidated the part numbers. Although when you try to run the query it gives an error: "Operation must use an updateable query" Thanks for the help guys...

Hi all, I have the following tables and need to update data between them: TableA Desc PrevQty abc def ghi xyz TableB Desc Qty abc 10 def 15 ghi 20 abc 30 xyz 10 I need help with a query to get the total Qty from tableB and update the PrevQty in TableA. When the query is run, TableA should...

Hello Guys, I am in need for some help with SQL code to search multiple columns in multiple tables in an Access database. We have a database supplied to us, as part of our CAD software, which contains multiple tables each with slightly different column counts and headings. One thing in...

I took out adLockReadOnly but it still complains!! I am only trying a simple SELECT SQL statement nothing that would require adding data...that comes later. I am beginning to think that I should abandon this and go for plan two!! Thanks guys. All help is greatly appreciated Kind regards Ota

Hi Geoff Yep, the file has been saved on my desktop so there is no security on the folder. As an experiment, I added readonly=false to the connection string but it thengave me another error: Could not find installable IASM Thanks for the reply. All help is greatly appreciated Kind regards Ota

I tried that Skip and now have this error: [Microsoft][ODBC Excel Driver] Cannot update. Database or object is read-only. and stops here: adoRs.Open SQL, cnn, adOpenStatic, adLockReadOnly, adCmdText I cannot believe it is so hard to run an SQL query on a recordset in excel...surely other...

Galom, How do you connect to the excel workbook that you are currently workng in? As I understand it ADOConn is a connection but what do I connect to if the code is being run from where the data is? Hopefully that makes sense? All help is greatly appreciated Kind regards Ota