Search results

Thanks! With a bit of modificaton, that was exactly what I needed!

Ahhh all I was missing was the public keyword! Many thanks.

The module already shows up within my project... as per this screenshot: http://img516.imageshack.us/img516/1913/shotpq5.jpg I just right clicked my database and went to "insert module" - that's what Functions is in the screen shot. But how can I use the functions within that module in...

No wonder google wasn't bringing up much! Hmm okay. Well I'm expecting strings in the format "1234-A" or "1234", where -A might be replaced with -B or -C, etc, so I just need the first X numerical digits. Any idea where I might find such a function?

Is there a quick and easy way to extract an integer from a string in VBA?

The module I want is inside the database I'm using... I did the above and I got: "Name conflicts with existing module, project or object library" Is that method meant for referencing modules from other databases?

Well, item_shelfstock and pre_allocated_stock are in different tables/queries to tblOrder_Item, and qryOrder_Item isn't updatable because it uses SUM(). So I've changed it to the following: PARAMETERS orderno Text ( 255 ); UPDATE ((tblOrder_Item INNER JOIN tblItem ON tblItem.item_id =...

Hey guys, I've got the following SQL: PARAMETERS orderno Text ( 255 ); UPDATE tblOrder_Item SET item_qty = I.item_shelfstock - Q.pre_allocated_stock WHERE orderitem_id IN ( SELECT Q.orderitem_id FROM qryOrder_Item AS Q INNER JOIN tblItem AS I ON Q.item_id=I.item_id WHERE...

Hey guys, Either I'm missing something really basic or it doesn't exist... In Java for example, I could call import *** package name *** I've written a VBA module with some standard library functions I'll want to use, how can I import that into the VBA code for a form? Google is proving...

Hmmm, well I've had a quick scout, and none of my big queries are using OR's. I've also looked again, and the query I've got above isn't actually slow at all when you load it in datasheet view. But its within a subform with conditional formatting setup to see whether shelf stock > allocated...

Ah, apologies - got it sorted - just deleted the foreign keys, changed the type and set the keys back up!

Hey, I'd like to change my key column in a table from an auto increment Integer to a VarChar, but MySQL wont let me do this. Whenever I try to change the type, I get MySQL error 1025 - error renaming table. I think it's probably because the key is referenced in other tables as a foreign...

Well, almost perfect....! The final code is shown here, it sets orders to "processing" if all items are in stock: UPDATE tblOrder SET order_status = 'processing' WHERE order_id IN ( SELECT DISTINCT tblOrder_item.Order_ID FROM tblOrder_item WHERE (((tblOrder_item.Order_ID) Not In...

Brilliant - works a charm :-D Once again, many thanks for your help!

Wow, never even knew barcode fonts existed. I'll give that a shot - thanks!

Okay, I made a few alterations: SELECT order_id FROM tblOrder_Item WHERE orderitem_Id NOT IN (SELECT orderitem_id FROM (qryOrder_Item INNER JOIN tblItem ON tblItem.item_id=qryOrder_Item.item_id) WHERE...

Any further thoughts perhaps?

Hmmmm okay, so now I've got a different problem... I want to SELECT all orders where ALL items are in stock. I've written the following SQL: SELECT orderitem_id FROM (qryOrder_Item INNER JOIN tblItem ON tblItem.item_id=qryOrder_Item.item_id) WHERE...

Thanks. I also found the NZ() function, which is a little bit easier Thanks.

Hey guys, Is there a quick and easy way within SQL to make SUM() return zero instead of null when no rows are selected? Or can it only be done via code, checking if the value is null? Thanks.