Hi Claus
Both the for/next and the foreach loops work at the moment and provide what I need. They will not be called thousands of times so I feel that I am losing a lot of time without gain.
Thank you very much for your help and input it was a shame I was such a poor student, however, when time is on my side I will return and have another go at these arrays.
Kind regards.
john garvey
Last Activity: Aug 7 '12, 10:26 AM
Joined: Jan 14 '11
Location:
-
Hi
When you state 'I tried to make a module', where have you tried to make the module is it a class module as attached to a form or is it a 'named module' in the visual basic editor ?
Where and how have you inserted your sub routine ?
Kind regardsLeave a comment:
-
Hi
When I tried the code
...Code:$tempcat $row['ProductID'] => array( 'Name' => $row['Name'], 'DepartmentID' => $row['DepartmentID'], 'Price' => $row['Price'], 'Location' => $row['Location'], 'DepartmentName' => $row['DepartmentName'], 'Discount' => $row['Discount'], 'InBasket' => $row['InBasket']); Return
Leave a comment:
-
Hi
If the developers extensions are installed you will get a further option on the access button titled ->Developer.
When clicked it provides the following extra functions
1. Package Solution
2. Save as template
3. Create from sourceSafe
The package solution wizard will guide you through the processLeave a comment:
-
Hi Prasad
define your Variable
Open a recordset based on your query
assign the value of voltage to your variable
close and destroy the recordsetLeave a comment:
-
Hi Malathi
I think what you need is this 'Access package and deployment wizard' If that is so then search Microft web site for the developers extensionsLeave a comment:
-
Hi Claus
I'm still confused by these associative arrays, these are the two functions I use to extract the data into the 'Cart' and 'Catalog' arrays
...Code:Function GetBasketItems() { //Used to get all the items in the customers basket require '../includes/cxwdb.inc.php'; session_start(); unset($_SESSION['CartItems']); $BasID = $_SESSION['custDetails']['CustomerID']; $sql = "callLeave a comment:
-
Hi Claus
Hope you had a good break and are now back in full harness ?
While you were away I have been digging into the font of knowledge and have come up with the following code in a foreach loop which gives me the correct answer
...Code:$catalog = array( array('ProductID'=>2,'Name'=>'Alpha','DepID' =>2,'InBasket'=>'0'), array('ProductID'=>6,'Name'=>'Alpha','DepID' =>2,'InBasket'=>'0'),Last edited by Dormilich; Aug 6 '12, 05:26 AM.Leave a comment:
-
Hi Claus
I have found a few mistakes in my code down to human error, however, all is now well and I now give a full report below.
...Code:$catalog = array( array('ProdID'=>2,'Name'=>'Alpha','DepID' =>2,'InBasket'=>'0'), array('ProdID'=>6,'Name'=>'Alpha','DepID' =>2,'InBasket'=>'0'), array('ProdID'=>7,'Name'=>'Alpha','DepID' =>2,'InBasket'=>'0'), array('ProdID'=>8,'Name'=>'Alpha','DepID'Last edited by Dormilich; Aug 6 '12, 05:25 AM.Leave a comment:
-
Hi Colinod
Watch this video the guy unfortunately is too close to the microphone but it works.
http://www.youtube.com/watch?v=b1LIk...eature=related
Kind regards...Leave a comment:
-
As another old codger I say - Long live breakpoints
Kind regardsLeave a comment:
-
XP Pro is the only XP version that can act as server. Have you tried connecting the other way round, however, you will still need professional or above for the Win7 part.
Kind regardsLeave a comment:
-
Hi Colinid
Are you using XP Professional ?
Check out this Microsoft help page
http://support.microsoft.com/kb/315328
Kind regards...Leave a comment:
-
The only way is to try it.
Kind regardsLeave a comment:
-
Hi Yasirzafar
When I looked at your code again the line
string empl_vote_true = ",12,13,14,15,1 6"
You should not have an opening comma without data it will throw an error.
Kind regardsLeave a comment:
-
I only have 2007 (being a poor person) If there was a difference the saveAs would have been available. I think the upgrade is more functionality than format....Leave a comment:
-
Hi Denise
Open your 2007 database in Access 2010, after it has loaded click the 'Office Button' (The circle, Extreme Top Lefthand Corner of screen) in the dropdown menu that appears choose 'Save As' then click the 'Access 2010' option under the 'Save the database in another format' and give it a name and location and that is it.
Kind regardsLeave a comment:
-
Hi Claus
I've been kept busy for the last couple of days, however, I shall try all of this over the weekend and report back.
What does the 'PI'. do?
Can I still loop through each record ?
Kind regardsLeave a comment:
-
Hi Anna
Unzip the attached files and try again, they are access 2007.
Kind regards...Leave a comment:
-
Hi Anna
Please try this;
In MS Access (whatever version you have) Create a table called 'tblPeople', within that table create two columns(fields) the first data type 'text'; field size '50'; name 'person' make this the primary Key
the second data type 'Number' size 'long'; name 'StatusLevel'
Save the table as tblPeople
Open the table and type in about 10 to 15 names in the person field and scores...Leave a comment:
No activity results to display
Leave a comment: