Search results

Are you using VBA in your report to build this SQL? Say, using the QueryDefs object and/or a Recordset object?

Were I looking to do this, I think I would want to break things down and probably add a few more items. By a few more items I'm thinking of things like Vendor (who is providing the training), it's location (where it is), and perhaps a categorisation of courses. Would also introduce a table for...

On a Wordpress based site I maintain, I implemented a Cookie notice via a plugin. This one pops up on the site, and then vanishes after about 5 seconds. Less intrusive.

I don't see it working. With Excel you are effectively creating a Range object by selecting/dragging. In Access, the Range object doesn't exist.

You mean like this? Move the cursor over the edge of a cell until you get th white cross cursor, then drag along. Not that it does much.

No need for a DLookup. Put the contact number in the query of your main contact combo. Set the column count to include this, and then hide the column with the contact number. In your textbox, set it's ControlSource to the hidden column of the combo ie. =[MyTextbox].[Column](2)

No, but if they are punished with a fine then the business may suffer, especially if it's a substantial amount and they can't afford it. Negative coverage may also affect sales. But that's how the capitalist cookie crumbles.

Who is the I when it comes to selling goods? Is it a person who works within a business enforcing their own beliefs or is it, under laws of corporate personhood, the business itself with its terms and conditions made clear? As the primary driver for a business is making money for its...

It would be. But when you obfuscate your problem behind unhelpful object names, it's hard to grasp a) what you're doing overall; and b) if the reason you have to do it is down to a fundamental design flaw that you perhaps don't realise you've done. (i.e. Item1, Item2, Item3, etc.)

I actually find it hard to follow your example when you don't just use your real world examples.

Half right. We do the calculation in the query. Always in the query. We do not store the answer in the table at all. Consider this. You have two fields called Date Start and Date End. In Date Start is 01-Feb-2015 and in Date End is 28-Feb-2015. In a query, you can do a quick formula like...

Don't make the mistake of thinking an Access table is in any way like an Excel spreadsheet. If it did such things, we would just use Excel. Tables are purely used to store relevant data. They should, in 99.9% of situations, not be used to store the results of calculations, either. Where you...

'Next' button? I don't recall putting one in my example. Is this a button that you've added, or have you switched on Navigation Buttons to your form?

I was just writing reply here on tables for Costs, CostCategories, and CostsToEvents, however I accidentally pressed something and the web page changed, losing what I'd written. Damn. I'll need to write it again. The gist was that the costs seems that they can be split into income and...

Oh, dear. White Meat, not Meet! :o

I don't mind. Still, we need to get those tables defined properly. So, I suppose we need to understand what all the monetary fields are about, etc.

I don't know how others go about the adminstration of their databases with regards to adding/editing/deleting items from combos, etc. but I though I'd share what I do. Basically, I have a form called frmAdministration whereby all the lists in the database can be handled by the users (that way...

=IF(Sheet3!B2="",MyListBox,Sheet3!B2) * 3

If there's only two columns and one's a primary key that I want hidden, I only enter a zero for the first column, which will be its width. Beyond that Access autos everything else. Since it's only visible column, I'm not interested in defining its width as it will adjust to the whole of the...

Surely just create another cell (perhaps on a hidden sheet) that says =IF(Sheet3!C3="",Sheet1!C3,Sheet3!C3) And then, rather than refer to Sheet1!C3, get your formulae to refer to the hidden cell.