Search results for query: *

I think I have it. I'll have a play around with the code. Thank You. Private Declare Function OpenProcess Lib "kernel32" (ByVal dwDesiredAccess As Long, ByVal bInheritHandle As Long, ByVal dwProcessId As Long) As Long Private Const SYNCHRONIZE = &H100000 ' Wait for the App hProc...

Hi All, I am building an Access DB to control the running of Essbase loads and recalcs on a number of different cubes. I believe that I can use the shell command to start the dataloads and recalcs. As some of the recalcs take hours and I can't wait until one load/recalc has finished before I...

...I can get my PHP/ASP/SQL etc (<-- web stuff) skills up a bit (well actually get some) so the results can be viewed online. The map is about 100 * 75 squares and the character can be on any one of them and looking in any of 8 directions and I can't see any other way of getting a characters...

Hi Everyone, I have a report which shows the view of a fantasy world. The view consists of a number of image controls stacked on each other. The view was created by placing the furthest controls and bringing them to the front, placing the next nearest and bringing them to the front etc etc. I...

Here you go, see help on CASE, very versatile. Dim IntValue as Integer IntValue = 5 + 6 Select Case IntValue Case 1 To 10 'blah Case 11 To 12 'blah Case Else 'blah End Select

Hi, Should your SELECT statement be surrounded by quotes, so Set rst = dbs.OpenRecordset(strSQL) becomes Set rst = dbs.OpenRecordset(""" & strSQL & """) I think. Graham

...table, remove the duplicate data, reload, then rerun the job. Also, after the very first failure I ran a simple query against the table "SELECT * FROM ZY8C WHERE NUDOSS = 12345" and I was shown NUDOSS OTHER DATA 12345 xxxxxxxxxxx 12345 xxxxxxxxxxx 45678 xxxxxxxxxxx 12345...

...Recently, this job has been failing, seemingly at random (we had zero failures last week) then three this Tuesday, issuing the following message. *GE01BQL-BBAD0001-------------------------------------------------------------------------------------------------------...

Hi, Got it sorted. Thank for replying though. The valid characters are Value 'CHANDLER`S FORD' is not facet-valid with respect to pattern '[A-Za-z0-9 ~!"@#$%&'\(\)\*\+,\-\./:;<=>\?\[\\\]^_\{\}£€]*' for type 'null'. (finally got the XML validator going correctly)

Hi all, I have a schema for P14 returns to the inland revenue. I am having a problem with <line> when validating the file. The <line> is part of <xsd:element minOccurs="0" maxOccurs="1" name="Address" type="InternationalAddressStructure"/> and for some reason the XML we have is failing the...

Hi Grofaty, Not really, thats the actual SQL that I need the count adding to. If I simplify the SQL, it might invalidate any answer that I am given. Thanks for looking though.

Hi, I have this query which is listed below. The main sort is field E.VTARECLK and I have the report grouping these with page throws etc. I have been asked to provide a number of unique A.SERNUM within each group of E.VTARECLK. I can get the count of records in each group, but I have been...

Thanks for the help everyone, Just for info the graphics card on the laptop is a S3 Graphics SuperSavage/IXC 1014 with 16MB ram (it is an IBM T23). My home PC has a GF4 5900 with 128MB. It seems to be something to do with the form controls themselves. I put in a progress bar which shows the sub...

Aye, turned off.

Hi Ken, Thanks for replying. The bitmaps are all around 1kb in size, very small and only black and white. My home PC should beat my works one hands down as far as disk access goes, but it doesn't seem to. I believe that SATA drives are 50% faster that ATA (could be wrong). I am hoping that...

...seconds to show the form while my works PC takes about 3 seconds. I have shown the code below and it amends the picture property of a grid of 15 * 15 controls. Does anyone have any idea why my home PC should take so much longer given it's higher spec? The only difference in the references...

Bump, because I really need help on this please

Hi Duane, I put >"" as I tried things like <> Null or = Null and it didn't work properly. I have tried this expression in the database above and it works fine, hence the comments re the vertical gaps between fields still showing (any thoughts on this btw). I would expect that actually having...

Hi jacque427, You could change all your labels to textboxes and put the following code in the control source and set the 'can shrink' to true on each of them. =IIf([text16]>"","Relationship","") That will allow report detail to shrink and remove a lot of the white space on your report...

Aye, Each order is 1 record on the table with up to 12 parameters (or instructions if you like) for each order and 1 string field for the 'one big long message' What I am trying to get across, is that I will always have a time and order in the example above, but depending on the order, 0 to all...