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

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

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

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 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 have a function which runs an SQL query and returns a recordset. This function takes two recordsets as arguments for the SQL statement. So far I have this: Private Function Additions(existingData As ADODB.Recordset, additionalData As ADODB.Recordset) As ADODB.Recordset Dim adoRs As...

Hi all Does anyone know how to access the archive attribute for a file? I am writing a backup script with jbuilder (jdk 1.3) which requires setting and reading of the file archive attribute but I cannot find any information on how to achieve this. All help is greatly appreciated Kind regards Ota

Hello all, Does anyone have any examples of how to navigate through an FTP site in a similar fashion to navigating through directories on a hard drive, using I assume a JChooser dialog box, and display the chosen path in a text field? Thanks All help is greatly appreciated Kind regards Ota

Hi, I am trying to find the upper limit of an array in Excel VBA 2003 but I cannot find it in the object explorer nor can autocomplete find it, so I am guessing that there is a missing reference to it's library maybe??? If anyone may know what the problem is or where I can find the missing...

Hi all, I am trying to use a batch file to automate a backup procedure. At the end of a particular part of the script, shown below, the variable bkguid should contain the GUiD of the tape drive and will then be used as part of the NTBACKUP.exe command line. What I currently have is...

Hi, I am hoping that someone may be able to advise me on the best way to manipulate reports using VBA??? What I have currently is a report and in it's record source there is a query. When I run the report the query builds the information and then I can see the information in the report. What I...

Hi, I am trying to write a query that will read some data and insert it into another table. I have tables set out like this: Table1 ====== ProductNo Title Qty Table2 ====== ProductNo Description Amount...

Hi, Does anyone know whether any logs are created during a remote desktop session? All help is greatly appreciated Kind regards Ota

Hi, I am trying to trace some access to an administrative share on a hard drive and am wondering if any logs or tracable material can be found? All help is greatly appreciated Kind regards Ota

Hi, I am using Outlook 2000 and on file menu under open open 'other users folder' I have a list of different accounts which is now getting unmanagable. Does anyone know how I can clear this so I can start fresh? All help is greatly appreciated Kind regards Ota

Hi all, I can setup offline folders between a laptop and a server so that when the user is away and comes back their files are automatically synchronised, and that works fine. The problem is that on the server, the files are in folders but on the laptop all the files are all "one level" without...