Search results

Wonderful :-) (not the most obvious property to defeat this from happening!)

Actually, I have a small issue-ette , the new text box field that's now on the form (i.e. =DCount("*", "QueryName") to show the query record count)....when a user enters data in the usual box on the form, access is moving focus to the informational text box (showing the query count) ...

Thanks...that was exactly the information I needed - it works a treat. thanks to all!

Thanks for the replies & apologies for the delay (& the confusion) My form inputs data to a single table. But I have a query of interest which pulls in data from several tables (one of these being the table my form inputs data to mentioned above)...this query has multiple criteria set...

So I'm using a form to update a table....in turn there's a query that references this table.....what I need to be able to do, is - as the user is entering a new record to the table via the form - that the record count from the follow query is presented back to him Here's the flow... Form ->...

Sorry if this is a lame question... I want to manually add a customer sale to me database (it's all being done via an API presently), but having a mental block how I would add two twos (to reflect two items purchased) to a table from one form? For example Mr Smith buys widget A & widget B, his...

My UI will see all orders that need to be processed (packed & dispatched) onscreen. Part of this order handling process is printing out an invoice (to go in the package), so I seek a way of highlighting all onscreen orders (or whichever orders I wish) & then printing out the invoice for these...

So I'm slowly but surely building up a useful database for my one man business (actually 1.5 man business - my wife help in the business too!) Having now got all my incoming Ebay & Amazon sales order data into normalised tables ...I've just created reports created that I need (shipping label...

Ok, I think I now understand the workings of this a little more (or at least have it working the way I seek) Firstly the format 'lines' that I seek (report -> properties ->format -> Gridline Style Top)are only possible if you select your particular 'box of interest' (for want of a better term)...

To which bit...drawing in a line manually or using the gridline properties for the field?

When you draw a line...I think that if the field shrinks the line stays static so will be in the wrong place? (I'm not 100% on this) ...whereas using the particular property that I want to press into play...the subtotal/total line is dynamic & moves with the data. Once I've had a bit more...

Ok, bingo...I've made some progress (& a discovery, thanks to the final post at the bottom of this thread/page by a the user with the name armsys .... http://windowssecrets.com/forums/showthread.php/120251-Border-vs-gridline). the report properties I'm trying to press into play is 'gridlines...

Please note that I'm still very much finding my feet with respect to reports. But coming back to to what I'm trying to get at. Looking back at my original jpg....the top group of data has a row & column structure (you can just make out the faint gridlines behid)....as you say probably created...

I'm aware of the limitation & have made sure all my boxes are bound (apologies for the confusion arising from the jpg...this was uploaded just to show the grid (row/column) structure of the data that won't shrink...but I confused everyone - sorry.

Thanks ...that certainly removes them, but are you saying the only way to get them in the first place (because I actually need them... but want to start small with one row & build from there) is to use the report wizard? In other words, there's no option to just 'insert a row' on a blank report?

Thanks. RE grids, rows & columns...the bit I've still not got to grips with in Access reports is how is it (in the jpg posted in my opening post) that some of the data is 'free form' wrt layout, whereas in the top group, they are aligned to rows & columns...what setting is it in access that...

Thanks for the reply. Actually, the jpg I posted has confused matters (it was just to show the gridlines). If I remove all labels on those rows, there's still no 'shrink' going on (yet the data below shrinks & it's the same report footer...so it looks to be something to do with the data when...

I've a report footer where I want fields to disappear when there's no data...I have it working (shrinking) but only if my report data is not arranged/placed on design gridlines. Difficult to put into words, but take a look at a screenshot... https://s16.postimg.org/3ninvu1bp/temp.jpg the top...

Many thanks....plenty there for me to get my teeth into!

I would like to set up a timer to 'go fetch' ebay/amazon orders every 15 mins or so ...I think the thing to press into play here is a form with an interval timer? (the 'go fetch' aspect I've already coded - it's just triggering it now that I need) here's the thing I only want Access to 'go...