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'm actually finishing off a play-by-mail or a play by e-mail as it is now until 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...

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

Hi M, Thanks for that. I had seen that problem and it is one of the reasons that we have suggested to our client they update to SP4. I have worked on this system for 6 months and have never seen this problem until recently. The week before last it was failing multiple times a day, no problems...

Hi, I have a job that processes a file of SQL statements. The latest file was about 16M in size and contained 60K SQL statements. Recently, this job has been failing, seemingly at random (we had zero failures last week) then three this Tuesday, issuing the following message...

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

Hello, I seem to have a problem showing some graphics on a form using my home pc, but the one I use for work seems fine. My home PC is an Athlon 64 3200, 512mb ram, dual 80gb SATA drives in a striped raid running Access 2002 in Wondows XP. My works pc is a laptop with a P3 at 1133mz with 512mb...

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