Hi,
I have code which is working fine, it's picking up data from the following path:-
path="/category/event[@name='Man U v Arsenal']/type[@name='Match']/@points";
However i need it to pick up all events where 'Arsenal' are involved, not just 'Man U v Arsenal'. So i need a 'like' statement or...
Hi,
I have the following code from w3schools.
-----------------------------------------------
<html>
<body>
<script type="text/javascript">
function loadXMLDoc(fname)
{
var xmlDoc;
// code for IE
if (window.ActiveXObject)
{
xmlDoc=new ActiveXObject("Microsoft.XMLDOM");
}
// code for...
Hi, i'm tearing my hair out at this, i've got a submission form which is created from a mysql database. This works fine, it retrieves the data and creates fields for user input.
i've got a table called 'games' where the game is either open or closed (open = yes/no). The form picks up which...
Hi there, sorry if this seems like a stupid question and one that can't really be answered (because there's pros and cons for all mainstream languages and everyone has their own preferences).
My experience is mainly with VB. I have VB 2005 express and wanted to create a small system for...
It's ok, i've finally figured it out. I made a few amendments, but this works perfectly. Thanks for your help.
Dim varItem As Variant
Dim strSQL As String
If Lst1.ItemsSelected.Count <> 0 Then
strSQL = "SELECT Data.Surname,Data.Forename from Data WHERE "
For Each varItem In...
I'm trying to incorporate this but it's not having it! It probably sounds dumb but what do i put in the SET statement?
I've tried different things but in the end removed it
And therefore it's not picking up the selected item from lst1.
I tried strSql = strSql & "Competency = 'Tsk1'" just to...
Many thanks for your reply.
The data i've got is already in place from a spreadsheet which i'm trying to incorporate. The 'Tsk' field names were just generic ones i gave for the purposes of making my question a bit easier to understand. The real field names are a bit more complex.
Regardless...
I'm Currently building a database to track employees competencies. So certain people will be qualified to do certain tasks.
E.g in a table called Data ive got
Name Tsk1 Tsk2 Tsk3 Tsk4
Bob True True False False
Billy False True True True
Bryan True False...
Hi, cheers for your reply i will have a look.
However i've thought of another possibility, how about determining the DoCmd.movesize option of my forms depending on what resolution the screen is on start-up?
Thanks for your quick reply, but i haven't explained what i want properly.
I want to specify the size of the actual MS Access window (not the database window where the objects are), so i can fit the whole database into a 800 x 600 screen. Then if the user has a 1024 x 768 screen the actual...
Is there anyway of specifying the actual database window (program window) on start-up?
I want to acheive this to avoid problems with screen resolution and want to disable the maximize option so the user can either keep it at the pre-determined size or minimize it.
If anyone can help i'd be...
If i have several fields on a form named, for example, Text1, Text2, Text3 and Text4, how can i multi-edit the backcolor of those fields?
I don't want to go through each individually like follows:-
If IsNull(Text1)= false then
Text1.backcolour = 255
End if
If IsNull(Text2)= false then...
Thank u very much, it worked a treat. Thanks for your quick response too.
My only problem now is how to present this data as a chart, ideally on a form where the types of absence are colour coded. Or am i just over-complicating this! any ideas are most welcome!
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.