Search results for query: *

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

Beautiful! That seems to be exactly what I needed. You get a star - especially for first thing Monday morning! Thanks, /Wendy

That looks like it might do the trick. What library is it in? I just tried Microsoft Scripting Library, but although it can find "Scripting" as an object type - it can't find "Dictionary" as a method or member. /Wendy

I can't figure out if this is possible in Access. I am getting Run-time error 2482 can't find the name "test1" you entered in the expression. I am sending 2 arrays to a function that executes an SQL INSERT procedure. One array contains the table field names and the other the data. If I could...

Hello - I am an Access programmer and a customer came to me wanting to put a spreadsheet into Access. It really should be a spreadsheet, they just want to use Access to supply pull down lists in Excel so they don't have to type so much. I use Excel for pretty basic things, but I figured out...

Thanks for the idea. I changed the CSS to have margin 0 0 0 0; and padding 0 0 0 0; for the top and footer sections. Then I went so far as to take out all the text from the header and footer, except: <div id="topmenu" align="left">top menu </div> <div id="footermenu" align="center">footer...