Search results

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

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

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

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.

Hey guys, Do any of you know to a free barcode generator for form/reports that I could use in Access 2007? Like this sort of thing: http://www.idautomation.com/access/native/ However, it does seem fairly pricey. Thanks.

Hey guys, I keep getting a "A.order_date" unknown error with the following query: SELECT tblOrder_Item.orderitem_id, tblOrder_Item.item_id, tblOrder_Item.order_id, qryAllocatedStock.allocated_stock, tblOrder_Item.item_qty, tblItem.item_shelfStock, tblOrder_Item.item_name...

Hey guys, I've currently got a split form setup, with the datasheet on the left and a detail form on the right. The datasheet doesn't really offer enough functionality.... so I've made a continuous form which I'd like displayed on the left hand side. But I'm having throuble piecing these...

[Solved] Allow editing of a form based on a query I've got a form setup running from a SELECT query, as I need more information than is in one table. I'd like to be able to edit the items. I understand that Access locks the form fields as it doesn't really know how to update them seeing as...

Okay, so I belive I've done the right thing and setup some relational tables as follows (feel free to correct me anywhere along the way). As a snippet, I've got: tblSupplier - with a supplier_id, supplier_name, etc. tblManufacturer -with a manufacturer_id, manufacturer_name, etc. Then I...

Hey, I have 6 drop down combo boxes, all with their row source set to the same query. The query takes approximately 1 second to run, and so the form now takes a while to load. Can I run the query once for the first drop down, and then somehow cache it so that the other 5 dropdowns...

Hey guys, first time post here but looks like a decent forum! I'm moving a lot of our web based admin stuff over from a PHP based online system to Access, using ODBC link tables. In PHP I had a neat enough little script to run through and generate a list of categories like this: Main Category...