Recent content by wendyp

I'm having hair-pulling-out trouble with a query: SELECT mwr.item_id, mwr.category_id FROM ( SELECT mwi.item_id, mwc.category_id FROM ( ( SELECT i.item_id FROM ( ( ( tbl_items i INNER JOIN tbl_items_categories ic ON i.item_id = ic.item_id ) INNER JOIN tbl_categories c ON c.category_id =...

Beautiful! Thanks a million - I would have never thought of that. And I knew it had to be simple.

I have a table like this: id cat_id 1 3 2 3 3 3 1 4 2 5 So an ID can have more than one category. I want to select records that are in both category 3 and 4. If I make an SQL statement with OR, I'll get all the items for category 3 and category 4. But...

Hi - *very* new to AJAX. I'm using Joomla (which I'm new to, too), with Docman. I created a Joomla module to pick up a list of categories and sub-categories using AJAX. This worked perfectly until I turned Joomla's friendly URL's on. Now the entire page loads in my little search box. Not...

Yes - the problem is solved. Thanks to your hint about the Javascript code needing help, I found a different calendar script that works much better. http://www.electricprism.com/aeron/calendar/ It is a little harder to setup - uses external mootools library, but it seems to be very stable in...

Hi - so frustrated with IE! I have a form: http://www.idleinc.com/dev/index.php (it's not live, so go ahead and fill it in with gibberish if you want to see what it's doing) I am using IE 7.0.6000.1575 and it works perfectly. My customer however is using a LATER version (7.0.6000.166xx) and...

Hi - I'm fairly new to Javascript and this is working great in FF, but not in IE. http://www.idleinc.com/dev/testform.php If someone picks an airport, the address box is supposed to go away and the boxes for flight info are supposed to appear. I've tried several different things, but here's...

I have a large and complicated system and am adding an archival system to keep the .mdb file small. I archive all the customers, their orders, invoices, products, transactions and service calls if they have been inactive for 2 years. I have the archival system working just fine. Now, one of...

I ended up have to delete the master / child links from the form properties. Then I reassign them with code. Here's the code that worked: 'Find the right form for this product Dim frmName As Variant frmName = DLookup("product_form", "tListProds", "id = " & Me.product_id)...

My solution was the the relationship was defined in my version and there was no relationship in the customers version. Added the relationship and then things worked fine.

That worked like a charm. Thanks a million! A star for you. /Wendy

Sorry it took so long to get back to you. UNION was exactly what I needed. Took 5 product tables and combined them into one great (but very, very long) query. I knew it couldn't be that hard. Thanks, a star to you. /Wendy

Hi all - I have a fairly complicated table setup: 5 different product tables tProdDoors (PK: id, field to link: order_item_id) tProdGlass (PK: id, field to link: order_item_id) tProdScreens (PK: id, field to link: order_item_id) tProdOptions (PK: id, field to link...

Thanks! I had been told to use currency, but I went and checked after your post and it is accurate to 15 decimal places, but on the left side of the decimal! Not what I need for percentage calculations. I've converted all my percentages to decimal with a scale of 15 (numbers on the right of...

Hello - another problem with decimals.. In the tax table, I have the following pertinent fields: numStateTaxRate numCountyTaxRate numCityTaxRate numDiscountRate They all have a data type of currency, format of percent and I've tried with decimal places being "auto" and set to 6. I have a...