Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by Otacustes

  1. Otacustes

    Variable Scope Question

    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...
  2. Otacustes

    Cumulative Query

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

    Cumulative Query

    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...
  4. Otacustes

    Cumulative Query

    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...
  5. Otacustes

    MSFlexGrid

    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...
  6. Otacustes

    Ignoring Plotter Settings

    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...
  7. Otacustes

    Registry Keys

    I cannot find anything here on changing via the registry!!
  8. Otacustes

    Frustrating Multi Dimension Arrays...

    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.
  9. Otacustes

    Registry Keys

    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
  10. Otacustes

    Frustrating Multi Dimension Arrays...

    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" &...
  11. Otacustes

    Formatting Text

    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.
  12. Otacustes

    Formatting Text

    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...
  13. Otacustes

    Formatting Text

    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...
  14. Otacustes

    Combining Queries

    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...
  15. Otacustes

    Combining Queries

    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...
See more

Part and Inventory Search

Back
Top