Search results

so, I have created a working SQL statement that summarises data from a bunch of different tables (it's a stock monitoring application so it all has to do with levels of stock, numbers of parts processed etc...): SELECT tblPPIn.BatchID, tblPartDescriptions.DrawingNumber AS [Drawing Number]...

So I'm using a fairly complex query with a couple of sub-queries as expressions: SELECT tblPPIn.BatchID, tblPPIn.Qty AS [Qty In], IIf(IsNull((SELECT Sum(tblPPProcessed.QtyProcessed) AS SumOfQty1 FROM tblPPProcessed WHERE (((tblPPProcessed.BatchID)=(tblPPIn.BatchID)));)),'0',(SELECT...

extract values from text boxes (Solved) EDIT: I figured out a way to do this, scroll down to the last post if interested... so I have some text boxes on a worksheet, and I want to loop through and extract the data from each of them.. I could get it by string = string &...

So I have an access application to keep track of the status of small programmable PCBs that we use.. every time one of these pcbs is relocated or reprogrammed, an entry is made into a table in my db (tblLocation) with a unique ID for that action, the ID of the PCB (SD), the location it is going...

So my problem is, I'm writing a quick 'menu' page for easily accessing certain documents, some of which are in .dxf format (it's a portable CAD drawing format that stores all the drawing info in the form of text) my problem is that when clicking a link to such a document, firefox automatically...

Hi all, having a head scratcher as to how I can set up cells in excel to only allow certain values to be entered... basically what I want is to only allow either a '1' or a '0' to be entered into certain cells (preferably without going into vba coding, but I can use it if necessary). I have...

So I am using an excel sheet to transfer small amounts of data to a backend access database using ADODB - and to do this we need to set a reference to 'Microsoft ActiveX Data Objects x.x Library'. I typically try and use the most recent version but some of the machines here are somewhat older...

So the below code is supposed to open an html file and pass some extra info to it which is then used by JavaScript to display the correct photos (pictures of cameras before or after 'drop test') Using Firefox the page opens OK, but the extra info is not passed (I know it is in the correct...

Yep, I know access has the capability to export XML files, but they use the parser in IE and so cannot be viewed by Firefox.. so I wrote some code to create (basic) xml and xsl files to display data in a table... It is probably in need of some refinement, as I do not yet know a great deal about...

Basically, we have different camera modules on which we perform a given test a number of times, giving rise to 2 tables, tblCamera which will store basic info about the module and tblTest which will hold info for each test perfomed. The camera module has a unique ID (CameraID, the Primary key...

So I have a list box on a form from which users can select which fields to display in a query... There is a default set of fields to display, which at the moment is hardcoded in the associated VBA (far from ideal). I was wandering if there is a specific way to open a list box with a number of...

Just a quick question, it appears that I can't Enforce RI for relationships where one of the tables is linked from another *.mdb (the checkbox is greyed out)... is this a general thing with linked tables? Thanks, Bogzla

My problem is, I'm using a form to build up a query using VBA / SQL, and part of the WHERE portion of my SQL statement includes start / end dates. If I then enter dates in the UK format (dd/mm/yyyy), access will, on saving the query, reverse dd and mm if both are 12 or below. I've managed a...

So, basically my database has quite a number of lookup fields in tables as there is much repeated data, each one references to a seperate table with an autonumber field (ID) and a text field (Value) Currently I have column one (ID) as the bound column in such cases, as this is what the guy who...

OK, usually I can figure these things out for myself, but I'm realy stuck on this one and any help would be appreciated background: I work in a small scale pilot production line, and we take a series of measurements for every part that we make, each of which has a unique ID. Sometimes we need...